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 key efficiency 100

MySQL key efficiency 100% This is to remember the conf for this: for 1GB RAM dedicated server:

query_cache_limit = 4MB
query_cache_size = 128MB
key_buffer_size = 128M
max_connections = 300
wait_timeout = 7200
tmp_table_size = 64MB
max_connect_errors = 1000
connect_timeout = 20
max_allowed_packet = 16M

from here: thanks man! +1 Gb RAM = 2 Gb new config:

log-slow-admin-statements
query_cache_limit = 4MB
query_cache_size = 64M
key_buffer_size = 64M
max_connections = 300
wait_timeout = 7200
tmp_table_size = 12MB
max_connect_errors = 500
connect_timeout = 60
max_allowed_packet = 8M
innodb_buffer_pool_size = 128M
performance_schema

plugin_dir = /usr/lib/plugin
default-storage-engine = InnoDB

innodb = ON

Modified: 2024 April 21 (Sun) 19:08

Alex 2014 Nov. 02 (Sun) 21:25 SQL DB