Just my blog

Blog about everything, mostly about tech stuff I made. Here is the list of stuff I'm using at my blog. Feel free to ask me about implementations.

My Github My LinkedIn

Soft I recommend

Mobaxterm SSH RDP FTP...
Thunderbird Email client
Filezilla FTP client/server
Nirsoft Win utils
Sysinternals Win utils
Pi-Hole AD block by DNS
NUT UPS manager
Rpi MON Raspberry monitoring
Free CAD 3D modelling
Free Commander Far-like filemanager
Bitwarden Password manager

There are no referral links!

Py lib I recommend

Django web framework
celery multi-tasking
celery-beat Celery + Django
celery-results Celery + Django
Pillow Python image lib
wsgi mod Apache + Python
requests best in WEB requests
openpyxl make Excell docs
p4python Perforce + Python
paramiko SSH + Python
pyvmomi ESXi Vcenter + Python

I'm using these libraries so you can ask me about them.

There are no referral links!

MySQL default my.cnf концигурация

Далее приведена конфигурация MySQL сервера файлом: /etc/my.cnf по принятым стандартам для хоста с 1Gb оперативной памяти:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
query_cache_limit=1M
query_cache_size=23M
query_cache_type=1
max_connections=1000
max_user_connections=300
interactive_timeout=100
wait_timeout=100
connect_timeout=10
thread_cache_size=128
key_buffer=64M
join_buffer_size=1M
max_allowed_packet=32M
table_cache=1024
sort_buffer_size=1M
read_buffer_size=1M
read_rnd_buffer_size=768K
max_connect_errors=10
thread_concurrency=4

# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[client]
socket=/var/lib/mysql/mysql.sock

Modified: 2024 April 21 (Sun) 17:53

Alex 2013 Nov. 11 (Mon) 11:02 SQL DB