barseghyanartur

grep -P "[\x80-\xFF]" filename

barseghyanartur

from datetime import datetime
from elasticsearch_dsl import (
    DocType,
    String,
    Integer,
    Float
)


def _suffix():

barseghyanartur

Memory hints

Show free memory using vmstat

vmstat -s -S M | head -n 5 | tail -n 1

Show top 1 memory consumers using smem

barseghyanartur

List All Table Sizes From ALL Databases

In Mb

SELECT
  TABLE_SCHEMA AS `Database`,
  TABLE_NAME AS `Table`,
  ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS `Size (MB)`
FROM

barseghyanartur

Dash to Panel

barseghyanartur

Command:

cat /path/to/certs/my_cert.crt | openssl x509 -noout -enddate

Sample output:

notAfter=Apr  6 14:23:50 2024 GMT

barseghyanartur

Set logging to verbose:

import logging
logging.basicConfig()
logging.getLogger().setLevel(logging.DEBUG)
req_log = logging.getLogger('urllib3')
req_log.setLevel(logging.DEBUG)
req_log.propagate = True

barseghyanartur

podman run --ulimit=host -p "9200:9200" elasticsearch:7.5.1

barseghyanartur

Open the nanorc file:

nano ~/.nanorc

Turn on line-numbers feature by pasting the following into the nanorc:

set linenumbers

barseghyanartur

In SQL terminal:

RESET QUERY CACHE;
FLUSH QUERY CACHE;

In Python/Django: