here are the key memory variables i set for the my.cnf
innodb_buffer_pool_size = 2G
innodb_additional_mem_pool_size = 64M
innodb_log_file_size = 256M
innodb_log_buffer_size = 32M
innodb_file_per_table = 1
innodb_thread_concurrency = 200
read_buffer_size = 128k
sort_buffer_size = 128k
read_rnd_buffer_size = 512k
The mysql server use about 2.7g at startup and after 2 day’s of running, the memory go up to 14g.
It’s a heavy cpu load game server database, always have 40% cpu usage. there are hundreds of innodb table in the database and only 2 memory table which is writen to in 2 time per second. there are simultanous 374 long connections connection to one database.
I have read many article on percona about memory usage about mysql and haven’t figure out what’s wrong with my server.