设置mysql内存上限_如何在my.cnf文件中设置内存限制

关闭。 这个问题是题外话。它当前不接受答案。

想改善这个问题吗？ 更新问题，使其成为Stack Overflow

的主题。

7年前关闭。

如何在my.cnf文件中设置内存限制。我尝试了memory_limit = 64M。但是在重启MYSQL服务器时显示错误。任何人都可以帮助…

my.cnf

[mysqld]

datadir=/home/mysql/

tmpdir=/home/mysqltmp

#max_connections = 175 #was 175

max_connections = 80

#max_connect_errors = 350 #was 250

max_connect_errors = 250

safe-show-database

skip-locking

key_buffer = 1024M # was 128M

max_allowed_packet = 6M

myisam_sort_buffer_size = 64M

#old settings, for 900 ish max maxconn

#sort_buffer_size = 32M

#read_buffer_size = 32M

#read_rnd_buffer_size = 32M

sort_buffer_size = 5M

read_buffer_size = 5M

read_rnd_buffer_size = 5M

query_cache_size= 1024M

query_cache_limit= 16M

max_heap_table_size = 128M

tmp_table_size = 128M

thread_concurrency = 16

wait_timeout = 10

innodb_file_per_table

innodb_log_file_size = 10485760

open_files_limit = 8192

low_priority_updates = 1

#log_slow_queries = /var/log/mysql_slow.log

#log_queries_not_using_indexes = 1

#slow_queries_log_file = /var/log/mysql_slow.log

memory_limit = 64M

# who set these? these are NOT memory settings, but rather integer settings.

#table_cache = 1024M

#thread_cache_size = 8M

table_cache = 512

thread_cache_size = 8

[mysqldump]

quick

max_allowed_packet = 16M

[mysql]

no-auto-rehash

[isamchk]

key_buffer = 128M

sort_buffer_size = 128M

read_buffer = 2M

write_buffer = 2M

[myisamchk]

key_buffer = 128M

sort_buffer_size = 128M

read_buffer = 2M

write_buffer = 2M