…. Since 5 min I got totally frozen box with no free memory and giant swap. The case was worth to look deeply… here is vmstat 5 output: procs ———–memory———- —swap– —–io—- –system– —-cpu—- r b swpd free buff cache si so bi bo in… MySQL ate 5GB of memory in 85 sec. That makes things clearer. As I understand MySQL allocates memory in each call of…
Post: InnoDB memory allocation, ulimit, and OpenSUSE
August 23, 2010 By 7 Comments
… the extra 3.37 GB allocation, there was still some free memory. Or was there? Maybe some hidden monster was eating it…. Apparenly OpenSUSE defaults are set in proportion to physical memory to keep the memory-hungry applications from taking the system down. On… physical memory, 2 GB swap it decided to set the virtual memory ulimit (-v) to 77.27 GB, and the physical memory (-m…
Comment: MySQL Query Cache
October 20, 2011 By 70 Comments
… ext|awk ‘/Qcache/ && /free_blocks/ || /free_memory/ || /lowmem_prunes/’ Thu Oct 20 03:42:03 EDT 2011 | Qcache_free_blocks | 117773 | | Qcache_free_memory | 147256440 | | Qcache_lowmem_prunes | 1849687 | root@server [~]# date;mysqladmin ext|awk ‘/Qcache/ && /free_blocks/ || /free_memory/ || /lowmem_prunes…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
… can be seen as large value of Qcache_free_blocks relatively to Qcache_free_memory. FLUSH QUERY CACHE command can be used for… and watch Qcache_free_memory and Qcache_lowmem_prunes – If you’re not getting much of lowmem_prunes and free_memory stays high you… enough memory for query cache. Note however due to fragmentation lowmem_prunes can be triggered even if there is some free space…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…_streams’, ’0′ ‘Open_tables’, ’512′ ‘Opened_tables’, ’183240′ ‘Qcache_free_blocks’, ’136′ ‘Qcache_free_memory‘, ’10272736′ ‘Qcache_hits’, ’14774371′ ‘Qcache_inserts’, ’83902401′ ‘Qcache… 248 0 # vmstat 5 2 procs memory swap io system cpu r b swpd free buff cache si so bi bo in…_table_locks=0 innodb_buffer_pool_size=1800M # USE ALL MEMORY AVAILABLE #innodb_log_buffer_size=8M # Lowered from 32M according…
Comment: Using MyISAM in production
July 6, 2006 By 36 Comments
…_into_free_memory_sorted_list__11Query_cacheP17Query_cache_blockPP17Query_cache_block + 95 0x81233b1 insert_into_free_memory_list__11Query_cacheP17Query_cache_block + 53 0x81231fd free_memory_block__11Query_cacheP17Query_cache_block + 93 0x812279f free_query__11Query_cacheP17Query…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…commanual pseudo_thread_idblogpercona.commanual Qcache_free_blocksblogpercona.commanual Qcache_free_memoryblogpercona.commanual Qcache_hitsblogpercona….server_idblogpercona.commanual shared_memoryblogpercona.commanual shared_memory_base_nameblogpercona.commanual show_slave_auth_infoblogpercona…
Post: Query_cache and column level privileges
August 6, 2007 By 5 Comments
…: mysql> show global status like ‘qcache%’; +————————-+———-+ | Variable_name | Value | +————————-+———-+ | Qcache_free_memory | 67091176 | | Qcache_hits | 0 | | Qcache_inserts | 0 | | Qcache_queries_in…: mysql> show global status like ‘qcache%’; +————————-+———-+ | Variable_name | Value | +————————-+———-+ | Qcache_free_memory | 67089640 | | Qcache_hits | 0 | | Qcache_inserts | 1 | | Qcache_queries_in…
Post: How much memory Innodb locks really take ?
July 13, 2006 By 11 Comments
…_length: 100253696 Max_data_length: 0 Index_length: 128974848 Data_free: 0 Auto_increment: 1638401 Create_time: 2006-07-12 07…. On other hand it still consumes exactly same amount of memory: History list length 5 Total number of lock structs in… of locked rows should take half GB of memory, which is small fraction of memory used on serious systems. Furtermore you would…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… is allocating too much memory. A runaway server process, or poorly optimized queries, can consume too much memory and cause the server… pmp-check-unix-memory plugin checks for a single process consuming too much memory and/or for too little free memory in general. This…. In addition, please ask our sales staff to include a free monitoring setup in a new support contract. I believe they…
