Analyze current database variables for memory settings and compare to recommendations for engine types and resource availability.
Engine types:
information_schema: 0 [InnoDB] 17 [MyISAM]
cnm_authorizations: 4 [InnoDB] 0 [MyISAM]
cnm_employees: 0 [InnoDB] 0 [MyISAM]
cnm_icms: 0 [InnoDB] 0 [MyISAM]
cnm_ldap: 2 [InnoDB] 0 [MyISAM]
cnm_persons: 27 [InnoDB] 0 [MyISAM]
cnm_proposals: 0 [InnoDB] 0 [MyISAM]
cnm_publications: 19 [InnoDB] 1 [MyISAM]
cnm_tools: 26 [InnoDB] 0 [MyISAM]
innodb: 0 [InnoDB] 0 [MyISAM]
magikspot: 9 [InnoDB] 0 [MyISAM]
mysql: 0 [InnoDB] 17 [MyISAM]
phpmyadmin: 0 [InnoDB] 7 [MyISAM]
private_info: 0 [InnoDB] 1 [MyISAM]
Other engine type: production.banned_ip_memory - MEMORY
Other engine type: production.billable_account -
Other engine type: production.chat_message - MEMORY
Other engine type: production.chat_name - MEMORY
Other engine type: production.forum_post_newest_1000 -
Other engine type: production.forum_post_public -
Other engine type: production.forum_poster_memory - MEMORY
Other engine type: production.forum_recently_posted -
Other engine type: production.forum_thread_active -
Other engine type: production.forum_thread_newest_1000 -
Other engine type: production.forum_thread_public -
Other engine type: production.forum_topic_memory - MEMORY
Other engine type: production.friend_online -
Other engine type: production.ip2location_detailed -
Other engine type: production.ip2location_english -
Other engine type: production.message_sidebar -
Other engine type: production.message_unread -
Other engine type: production.online_guest - MEMORY
Other engine type: production.online_member - MEMORY
Other engine type: production.photo_newest_1000 -
Other engine type: production.photo_newest_1000_cam -
Other engine type: production.photo_search -
Other engine type: production.site_setup_memory - MEMORY
Other engine type: production.sitemap_memory - MEMORY
Other engine type: production.user_registry_active -
Other engine type: production.user_registry_memory - MEMORY
Other engine type: production.user_registry_newest_1000 -
Other engine type: production.user_registry_online -
production: 119 [InnoDB] 0 [MyISAM]
test: 0 [InnoDB] 0 [MyISAM]
tufro_cake: 0 [InnoDB] 0 [MyISAM]
tufro_drupal: 0 [InnoDB] 0 [MyISAM]
Global engine stats: 206 [InnoDB] 43 [MyISAM]
18 [], 10 [MEMORY],
Temp Space:
max_heap_table_size: 1073741824
tmp_table_size: 1073741824
::created_tmp_disk_tables / created_tmp_tables: 119723 / 119724
:: if large, consider increasing tmp_table_size (current: 1073741824)
Open Tables:
::opened_tables: 529 - current 523 open
:: if large, consider increasing table_cache (current: 1024)
Handler Types - suggests scan types:
::handler_read_key: 333370719
::handler_read_first: 34212
::handler_read_next: 3165528654
::handler_read_previous: 572153188
::handler_read_rnd: 10387791
::handler_update: 140640057
::handler_delete: 19114
::handler_write: 74667244
::handler_rollback: 1
COM_... Values:
::com_alter_table: 0
::com_commit: 0
::com_create_table: 0
::com_delete: 94133
::com_drop_table: 0
::com_flush: 0
::com_insert: 113498
::com_insert_select: 1553
::com_purge: 0
::com_replace: 168275
::com_rollback: 0
::com_select: 769191
::com_truncate: 2
::com_update: 919655
General memory usage:
binlog_cache_size: 0
query_cache_size: 16777216
::holding 4832 queries with 10233240 free memory
::qcache hit ratio: 41.97 %
::qcache_lowmem_prunes can suggest qcache too small - 5563
TOTAL: 16 M
MyISAM fixed memory usage:
key_buffer_size: 1073741824
::key_buffer usage: 84.2520713806152 % (high-water: 0.0072479248046875 %)
::Read ratio to disk instead of buffer: 0.1 % (ideally less than 1%)
::Write ratio to disk instead of buffer: 0 % (may be high if lots of deletes/updates)
delay_key_write isOFF, lowers key_disk_write ratio.
myisam_sort_buffer_size: 8388608 (for sorting MyISAM indexes)
TOTAL: 1032 M
InnoDB fixed memory usage:
have_innodb?: YES
innodb_buffer_pool_size: 2306867200
innodb_additional_mem_pool_size: 20971520
innodb_log_buffer_size: 4194304
TOTAL: 2224 M
Per connection memory usage:
thread stack: 131072
net_buffer_length: 16384 (alloc. per client, grows to 33553408)
TOTAL: 0.15 M
Per allocation memory usage:
bulk_insert_buffer_size: 8388608 (alloc. for insert..select, load data infile, insert value exteded)
sort_buffer_size: 67108856 (allocated for sorts, order by)
read_buffer_size: 6287360 (allocated for sequential scans)
read_rnd_buffer_size: 6287360 (pre-alloc. for sorted reads)
join_buffer_size: 268431360 (using full-table-scan, alloc. per join)
TOTAL: 339.98 M
Summary:
max_connections: 50
Potential Connection Memory: 7.5 M
::Current Connections - 2 (3 active)
::Max_Used_Connections - 51
::Thread Cache (48) hit ratio - 99.94 %
Theoretical Potential Consumption: 3263.5 M
MySQL formula: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections
= 1073741824 + (6287360 + 67108856) * 50 = 4523.8 M
Physical memory available: 7848.14 M
OK Physical memory within threshold for theoretical memory usage.