[formerly] share a MySQL profile running under a low-provisioned VPS

In a variety of memory CPU core only 1/2 cores, memory only 512m/1g VPS, memory, CPU, hard disk are not too abundant. So the main idea is to prohibit eating large memory InnoDB engine, the default use of MyISAM. It is forbidden to eat hard disk large log-bin, and then adjust some parameters to the appropriate values.

[MySQL]# CLIENT #port= 3306Socket=/var/run/mysqld/mysqld.sock[mysqld]# General #user=Mysqldefault-storage-engine=Myisamdefault-tmp-storage-engine=Myisamsocket=/var/run/mysqld/mysqld.sockpid-file=/var/run/mysqld/mysqld.pidbind-address= 127.0.0.1Lc-messages-dir=/usr/share/mysql/skip-external-locking# MyISAM #key-buffer-size=16mmyisam-recover= Force,backup# SAFETY #max-allowed-packet=16mmax-connect-errors= 256Skip-name-resolvesysdate-is-now= 1# DATA STORAGE #datadir=/var/lib/mysql/# CACHES and LIMITS #tmp-table-size=32mmax-heap-table-size=32mquery-cache-type= 0query-cache-size= 0max-connections= 64Thread-stack=192kthread-cache-size= 4thread-concurrency= 2Open-files-limit= 1028Table-definition-cache= 256Table-open-cache= 64# INNODB #loose-skip-innodbloose-innodb-trx= 0Loose-innodb-locks= 0loose-innodb-lock-waits= 0loose-innodb-cmp= 0Loose-innodb-cmp-per-index= 0Loose-innodb-cmp-per-index-reset= 0Loose-innodb-cmp-reset= 0Loose-innodb-cmpmem= 0Loose-innodb-cmpmem-reset= 0Loose-innodb-buffer-page= 0Loose-innodb-buffer-page-lru= 0Loose-innodb-buffer-pool-stats= 0Loose-innodb-metrics= 0Loose-innodb-ft-default-stopword= 0loose-innodb-ft-inserted= 0loose-innodb-ft-deleted= 0loose-innodb-ft-being-deleted= 0Loose-innodb-ft-config= 0Loose-innodb-ft-index-cache= 0loose-innodb-ft-index-table= 0Loose-innodb-sys-tables= 0Loose-innodb-sys-tablestats= 0loose-innodb-sys-indexes= 0Loose-innodb-sys-columns= 0Loose-innodb-sys-fields= 0loose-innodb-sys-foreign= 0Loose-innodb-sys-foreign-cols= 0# LOGGING #log-error=/var/log/mysql/error.loglog-queries-not-using-indexes= 0Long-query-time= 1Slow-query-log= 1Slow-query-log-file=/var/log/mysql/slow.log

The memory consumption of MySQL after reboot is about 70m+, which is the key-buffer-size, tmp-table-size and Thread-cache-size attributes of the memory relationship, respectively, the index of cache MyISAM, the execution group Temporary table memory space, query thread used by languages such as by.

The configured usage environment for Percona Server 5.6, other versions of MySQL is not tested.

[formerly] share a MySQL profile running under a low-provisioned VPS