{"id":1720,"date":"2021-02-14T11:01:01","date_gmt":"2021-02-14T03:01:01","guid":{"rendered":"http:\/\/blog.zengqq.com.cn\/?p=1720"},"modified":"2021-02-14T16:09:22","modified_gmt":"2021-02-14T08:09:22","slug":"%e5%9c%a8512m%e4%bb%a5%e4%b8%8b%e5%b0%8f%e5%86%85%e5%ad%98vps%e4%b8%8a%e7%9a%84%e4%bc%98%e5%8c%96%e8%ae%be%e7%bd%ae","status":"publish","type":"post","link":"https:\/\/blog.zengqq.com.cn\/?p=1720","title":{"rendered":"512M\u5c0f\u5185\u5b58VPS\u4e0aMySQL\u4f18\u5316"},"content":{"rendered":"\n

\u6587\u7ae0\u8f6c\u81eahttps:\/\/blog.kuoruan.com\/72.html<\/a><\/p>\n\n\n\n

\u505a\u7f51\u7ad9\u7684\u65f6\u5019\u9009\u6570\u636e\u5e93\uff0cMySQL\u662f\u9996\u9009\uff0c\u4f46\u662f\u670d\u52a1\u5668\u914d\u7f6e\u4e0d\u9ad8\uff0c\u5982\u679c\u4e0d\u4f18\u5316\u7684\u8bdd\uff0c\u670d\u52a1\u5668\u5185\u5b58\u5b8c\u5168\u4e0d\u591f\u3002\u4e8e\u662f\u627e\u4e86\u4e00\u4e9b\u56fd\u5916\u5927\u795e\u7684\u4f18\u5316\u5b9e\u4f8b\uff0c\u5e0c\u671b\u80fd\u7ed9\u5927\u5bb6\u4e00\u4e9b\u542f\u53d1\u3002<\/p>\n\n\n\n

\u70b9\u8fd9\u91cc\u8fdb\u5165MySQL\u4f18\u5316\u8bbe\u7f6e<\/a><\/h6>\n\n\n\n

\u4e0b\u9762\u4e00\u5f20\u8868\u683c\u662f\u6211\u4ece\u56fd\u5916\u7684\u4e00\u4e2a\u535a\u5ba2\u91cc\u8fb9\u6458\u6284\u4e0b\u6765\u7684MySQL\u7684\u4e00\u4e9b\u9ed8\u8ba4\u914d\u7f6e\u9879\u548c\u6700\u4f4e\u8bbe\u7f6e\u53c2\u6570\u3002<\/p>\n\n\n\n

\u8bbe\u7f6e\u9879<\/td>\u9ed8\u8ba4<\/td>\u6700\u4f4e<\/td><\/tr>
innodb_buffer_pool_size<\/td>128M<\/td>5M<\/td><\/tr>
innodb_log_buffer_size<\/td>1M<\/td>256K<\/td><\/tr>
query_cache_size<\/td>1M<\/td>0<\/td><\/tr>
max_connections<\/td>151<\/td>1 (\u63a8\u8350\u6700\u4f4e\u8bbe\u7f6e\u4e3a10)<\/td><\/tr>
key_buffer_size<\/td>8388608<\/td>8<\/td><\/tr>
thread_cache_size<\/td>(\u81ea\u52a8\u914d\u7f6e)<\/td>0<\/td><\/tr>
host_cache_size<\/td>(\u81ea\u52a8\u914d\u7f6e)<\/td>0<\/td><\/tr>
innodb_ft_cache_size<\/td>8000000<\/td>1600000<\/td><\/tr>
innodb_ft_total_cache_size<\/td>640000000<\/td>32000000<\/td><\/tr>
thread_stack<\/td>262144<\/td>131072<\/td><\/tr>
sort_buffer_size<\/td>262144<\/td>32K<\/td><\/tr>
read_buffer_size<\/td>131072<\/td>8200<\/td><\/tr>
read_rnd_buffer_size<\/td>262144<\/td>8200<\/td><\/tr>
max_heap_table_size<\/td>16777216<\/td>16K<\/td><\/tr>
tmp_table_size<\/td>16777216<\/td>1K<\/td><\/tr>
bulk_insert_buffer_size<\/td>8388608<\/td>0<\/td><\/tr>
join_buffer_size<\/td>262144<\/td>128<\/td><\/tr>
net_buffer_length<\/td>16384<\/td>1K<\/td><\/tr>
innodb_sort_buffer_size<\/td>1M<\/td>64K<\/td><\/tr>
binlog_cache_size<\/td>32K<\/td>4K<\/td><\/tr>
binlog_stmt_cache_size<\/td>32K<\/td>4K<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

MySQL\u4f18\u5316\u8bbe\u7f6e<\/h2>\n\n\n\n

\u4f9d\u636e\u4ee5\u4e0a\u53c2\u6570\uff0cMySQL\u7684\u6700\u5c0f\u914d\u7f6e\u4e3a\uff1a<\/p>\n\n\n\n

# \/etc\/my.cnf:\ninnodb_buffer_pool_size=5M\ninnodb_log_buffer_size=256K\nquery_cache_size=0\nmax_connections=10\nkey_buffer_size=8\nthread_cache_size=0\nhost_cache_size=0\ninnodb_ft_cache_size=1600000\ninnodb_ft_total_cache_size=32000000\n \n# per thread or per operation settings\nthread_stack=131072\nsort_buffer_size=32K\nread_buffer_size=8200\nread_rnd_buffer_size=8200\nmax_heap_table_size=16K\ntmp_table_size=1K\nbulk_insert_buffer_size=0\njoin_buffer_size=128\nnet_buffer_length=1K\ninnodb_sort_buffer_size=64K\n \n#settings that relate to the binary log (if enabled)\nbinlog_cache_size=4K\nbinlog_stmt_cache_size=4K<\/pre>\n\n\n\n
FinetunedMySQL<\/h2>\n\n\n\n
\u4f46\u662f\u5e76\u4e0d\u63a8\u8350\u4f7f\u7528\u6700\u5c0f\u914d\u7f6e\uff0c\u53ef\u4ee5\u9002\u5f53\u4fee\u6539\u4e00\u4e0b\u3002<\/p>\n\n\n\n
\u5728\u53e6\u5916\u4e00\u4e2a\u535a\u5ba2\u4e0a\u627e\u5230\u4e86\u4e00\u4e2a\u6bd4\u8f83\u9002\u5408\u4e8e512M\u5185\u5b58\u7684\u914d\u7f6e\uff1a<\/p>\n\n\n\n
# Example MySQL config file for large systems.\n#\n# This is for a large system with memory = 512M where the system runs mainly\n# MySQL.\n#\n# MySQL programs look for option files in a set of\n# locations which depend on the deployment platform.\n# You can copy this option file to one of those\n# locations. For information about these locations, see:\n# http:\/\/dev.mysql.com\/doc\/mysql\/en\/option-files.html\n#\n# In this file, you can use all long options that a program supports.\n# If you want to know which options a program supports, run the program\n# with the \"--help\" option.\n \n# The following options will be passed to all MySQL clients\n[client]\n#password = your_password\nport = 3306\nsocket = \/var\/lib\/mysql\/mysql.sock\n \n# Here follows entries for some specific programs\n \n# The MySQL server\n[mysqld]\nport = 3306\nsocket = \/var\/lib\/mysql\/mysql.sock\nskip-external-locking\nkey_buffer_size = 256M\nmax_allowed_packet = 1M\ntable_open_cache = 256\nsort_buffer_size = 1M\nread_buffer_size = 1M\nread_rnd_buffer_size = 4M\nmyisam_sort_buffer_size = 64M\nthread_cache_size = 8\nquery_cache_size= 16M\n# Try number of CPU's*2 for thread_concurrency\nthread_concurrency = 8\n \n# Don't listen on a TCP\/IP port at all. This can be a security enhancement,\n# if all processes that need to connect to mysqld run on the same host.\n# All interaction with mysqld must be made via Unix sockets or named pipes.\n# Note that using this option without enabling named pipes on Windows\n# (via the \"enable-named-pipe\" option) will render mysqld useless!\n# \n#skip-networking\n \n# Replication Master Server (default)\n# binary logging is required for replication\nlog-bin=mysql-bin\n \n# binary logging format - mixed recommended\nbinlog_format=mixed\n \n# required unique id between 1 and 2^32 - 1\n# defaults to 1 if master-host is not set\n# but will not function as a master if omitted\nserver-id = 1\n \n# Replication Slave (comment out master section to use this)\n#\n# To configure this host as a replication slave, you can choose between\n# two methods :\n#\n# 1) Use the CHANGE MASTER TO command (fully described in our manual) -\n#    the syntax is:\n#\n#    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,\n#    MASTER_USER=<user>, MASTER_PASSWORD=<password> ;\n#\n#    where you replace <host>, <user>, <password> by quoted strings and\n#    <port> by the master's port number (3306 by default).\n#\n#    Example:\n#\n#    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,\n#    MASTER_USER='joe', MASTER_PASSWORD='secret';\n#\n# OR\n#\n# 2) Set the variables below. However, in case you choose this method, then\n#    start replication for the first time (even unsuccessfully, for example\n#    if you mistyped the password in master-password and the slave fails to\n#    connect), the slave will create a master.info file, and any later\n#    change in this file to the variables' values below will be ignored and\n#    overridden by the content of the master.info file, unless you shutdown\n#    the slave server, delete master.info and restart the slaver server.\n#    For that reason, you may want to leave the lines below untouched\n#    (commented) and instead use CHANGE MASTER TO (see above)\n#\n# required unique id between 2 and 2^32 - 1\n# (and different from the master)\n# defaults to 2 if master-host is set\n# but will not function as a slave if omitted\n#server-id       = 2\n#\n# The replication master for this slave - required\n#master-host     =   <hostname>\n#\n# The username the slave will use for authentication when connecting\n# to the master - required\n#master-user     =   <username>\n#\n# The password the slave will authenticate with when connecting to\n# the master - required\n#master-password =   <password>\n#\n# The port the master is listening on.\n# optional - defaults to 3306\n#master-port     =  <port>\n#\n# binary logging - not required for slaves, but recommended\n#log-bin=mysql-bin\n \n# Uncomment the following if you are using InnoDB tables\n#innodb_data_home_dir = \/var\/lib\/mysql\n#innodb_data_file_path = ibdata1:10M:autoextend\n#innodb_log_group_home_dir = \/var\/lib\/mysql\n# You can set .._buffer_pool_size up to 50 - 80 %\n# of RAM but beware of setting memory usage too high\n#innodb_buffer_pool_size = 256M\n#innodb_additional_mem_pool_size = 20M\n# Set .._log_file_size to 25 % of buffer pool size\n#innodb_log_file_size = 64M\n#innodb_log_buffer_size = 8M\n#innodb_flush_log_at_trx_commit = 1\n#innodb_lock_wait_timeout = 50\n \n[mysqldump]\nquick\nmax_allowed_packet = 16M\n \n[mysql]\nno-auto-rehash\n# Remove the next comment character if you are not familiar with SQL\n#safe-updates\n \n[myisamchk]\nkey_buffer_size = 128M\nsort_buffer_size = 128M\nread_buffer = 2M\nwrite_buffer = 2M\n \n[mysqlhotcopy]\ninteractive-timeout<\/pre>\n\n\n\n
\u94fe\u63a5\uff1a<\/p>\n\n\n\n
1.Configuring MySQL to use minimal memory<\/a><\/p>\n\n\n\n
2.Mysql sample configuration with 512M ram<\/a><\/p>\n\n\n\n