max_connections : 600
max_user_connections : 600
wait_timeout : 10
interactive_timeout : 50
max_allowed_packet : 100M
ADVANCED OPTIONS:
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock symbolic-links=0 skip-external-locking key_buffer_size = 556M max_allowed_packet = 100M table_open_cache = 256 sort_buffer_size = 30M read_buffer_size = 30M read_rnd_buffer_size = 30M myisam_sort_buffer_size = 104M thread_cache_size = 8 query_cache_size= 1280M thread_concurrency = 8 #innodb_use_native_aio = 0 innodb_file_per_table max_connections=600 max_user_connections=600 wait_timeout=10 interactive_timeout=50 long_query_time=5 #slow_query_log=1 #slow_query_log_file=/var/log/mysql-slow-queries.log [mysqld_safe] log-error=/var/log/mariadb/mariadb.log pid-file=/var/run/mariadb/mariadb.pid # # include all files from the config directory # !includedir /etc/my.cnf.dSunucu özellikleri ;
8 Çekirdek
30 GB Ram
Sunucuda 1 site barınıyor sitenin istatistiği :
Anlık 250-300 Arası kullanıcı ve bu kullanıcılar her saniye database den işlem yapıyor.
