導讀:后端開發后端開發說明：mysql 5.6、5.7默認啟動占用內存400多M，如果是vps等小內存應用，mysql內存占用率明顯偏高,將會導致崩潰，mysql會自動停止。編輯/e如何seo優化推廣網站網站seo優化診斷工具。

說明：mysql 5.6、5.7默認啟動占用內存400多M，如果是vps等小內存應用，mysql內存占用率明顯偏高,將會導致崩潰，mysql會自動停止。 編輯/etc/my.cnf文件在[mysqld]下增加或修改如下參數

performance_schema_max_table_instances = 200 table_definition_cache = 100 table_open_cache = 100。

這個三個參企業網站建設數，調低值后內存能明顯減小，現在mysql使用內存約60MB左右，就大大降低默認使用的內存。

進一步調整參數

innodb_buffer_pool_size=2M

這個三個參數可以調小。 再進一步調整： mysql 5.6默認啟用performance_schema，占用很多內存，可以禁用。

完整配置文件如下，內存占用到22M

我的mysql配置如下，如果你使用的cent網站seo優化培訓os6 64位，并且是yum安裝的（一鍵腳本)可以自己按照如下照抄，我的是centos6 64位系統

先ssh登錄服務器或VPS，在vi /etc/my.cnf

# For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html [mysqld] # # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128M # # Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log_bin # # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock #symbolic-links=0 skip-external-locking key_buffer_size = 8M max_allowed_packet = 1M table_open_cache = 4 sort_buffer_size = 64K read_buffer_size = 256K read_rnd_buffer_size = 256K net_buffer_length = 2K thread_stack = 240K #innodb_use_native_aio = 0 innodb_buffer_pool_size=2M performance_schema_max_table_instances=50 table_definition_cache=50 table_open_cache=32 max_connections=50網站seo優化課程 max_user_connections=35 wait_timeout=10 interactive_timeout=15 long_query_time=5 # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 # Recommended in standard MySQL setup sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid

默認值如下：

performance_schema_max_table_instances 12500 table_definition_cache 1400 table_open_cache 2000相關如何seo優化推廣網站網站seo優化診斷工具。

關鍵詞標簽: mysql 優化內存 內存參數