Alcuni my.cnf per MySQL per server con 2GB 4GB 8GB 16GB 32GB di RAM
32 bit system 2GB of memory Dedicated DB Box All innodb tables 32 bit system 4GB of memory Dedicated DB Box All Innodb tables [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /mysql/ datadir = /data01/data tmpdir = /tmp thread_cache_size = 64 table_cache = 64 key_buffer = 64M […]
Alcuni esempi di my.cnf per MySQL
Esempio per un server con 4-8GB di RAM # The settings provided below are ideal for a 4GB-8GB RAM server. # You can adjust values accordingly for higher or lower spec systems, but generally, # it’s an almost “one size, fits all” setup. # Use DB diagnostics tools like: # https://launchpad.net/mysql-tuning-primer or http://blog.mysqltuner.com/download/ # to […]