I am currently optimizing our mysql production server and I noticed the ram usage on this server only increases. It never decreases. I read on several website sites that this could be caused by to many open connections. However our server has very little connections on any given time (max 15 sleep/query). After some time queries become very slow, and i think this is because the server's swap file is used because the ram memory is full.
Is this normal behavour or is something leaking memory and how can i best identify the problem?
Just to be complete below our server configuration and the my.ini configuration file.
- Windows 2008 SBS Server
- Mysql community server 5.1
- 4 quad core processors
- 32 gb ram
- 142 GB Memory (Raid 1)
[client] port=3306 [mysql] default-character-set=utf8 [mysqld] port=3306 basedir="E:/MySQL/MySQL Server 5.1/" datadir="E:/MySQL/Data/" default-character-set=utf8 default-storage-engine=INNODB sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" max_connections=100 table_cache=256 tmp_table_size = 2G thread_cache_size=8 myisam_max_sort_file_size=100G myisam_sort_buffer_size=410M key_buffer_size=354M read_buffer_size = 64 read_rnd_buffer_size=256K sort_buffer_size = 10M innodb_additional_mem_pool_size=15M innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=7M innodb_buffer_pool_size = 7G innodb_log_file_size=343M innodb_thread_concurrency=18 max_allowed_packet=16M wait_timeout = 4800 ft_min_word_len = 2 ft_stopword_file = "" max_heap_table_size = 2G tmpdir = "E:/mysql/MySqlTmp/" log-slow-queries = "F:/log/slow.log" long_query_time = 2 init-file=E:\mysql\MySQL Server 5.1\my_OnStartup.txt