[原]分享一個低配VPS下啟動並執行mysql設定檔

標籤：參數   border   server   cti   top   blog   and   recover   span   

在各種記憶體CPU核心只有1/2核，記憶體只有512M/1G的vps下，記憶體、CPU、硬碟都不是太充裕。因此主要思路是，禁止吃記憶體大戶innodb引擎，預設使用MyISAM。禁止吃硬碟大戶log-bin，再調節一些參數到合適的數值。

[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

重啟後mysql的記憶體佔用大概為70M+，其中和記憶體關係較大的是key-buffer-size、tmp-table-size和thread-cache-size屬性，作用分別為緩衝MyISAM的索引、執行Group By之類語言時使用的暫存資料表記憶體空間、查詢線程。

配置的使用環境為percona server 5.6，其他版本的mysql沒有測試。

[原]分享一個低配VPS下啟動並執行mysql設定檔