steve’s mysql report

Analyze current database variables for memory settings and compare to recommendations for engine types and resource availability.
Engine types:
mysql: 0 [InnoDB] 6 [MyISAM]
photography: 0 [InnoDB] 46 [MyISAM]
phpmyadmin: 0 [InnoDB] 7 [MyISAM]
store: 0 [InnoDB] 95 [MyISAM]
store2: 0 [InnoDB] 108 [MyISAM]
test: 0 [InnoDB] 163 [MyISAM]
tester: 0 [InnoDB] 47 [MyISAM]

Global engine stats: 0 [InnoDB] 472 [MyISAM]

Temp Space:
max_heap_table_size: 16777216
tmp_table_size (33554432) reduced to max_heap_table_size (16777216)
::created_tmp_disk_tables / created_tmp_tables: 41458 / 335127
:: if large, consider increasing tmp_table_size (current: 33554432)

Open Tables:
::opened_tables: 5345 - current 256 open
:: if large, consider increasing table_cache (current: 256)

Handler Types - suggests scan types:
::handler_read_key: 	2725388748
::handler_read_first: 	731618
::handler_read_next: 	2031102802
::handler_read_previous: 	5521706
::handler_read_rnd: 	23146095
::handler_update: 	582409460
::handler_delete: 	99025
::handler_write: 	34868369
::handler_rollback: 	0

COM_... Values:
::com_alter_table: 	0
::com_commit: 		6759
::com_create_table: 	0
::com_delete: 		400977
::com_drop_table: 	0
::com_flush: 		2832
::com_insert: 		86174
::com_insert_select: 	7012
::com_purge: 		0
::com_replace: 		31894
::com_rollback: 	0
::com_select: 		3442869
::com_truncate: 	2
::com_update: 		885649

General memory usage:
binlog_cache_size: 0
query_cache_size: 33554432
::holding 4229 queries with 26960360 free memory
::qcache hit ratio: 77.45 %
::qcache_lowmem_prunes can suggest qcache too small - 167983
TOTAL: 32 M

MyISAM fixed memory usage:
key_buffer_size: 67108864
::key_buffer usage: 100 % (high-water: 0 %)
::Read ratio to disk instead of buffer: 0.07 % (ideally less than 1%)
::Write ratio to disk instead of buffer: 39.59 % (may be high if lots of deletes/updates)
	delay_key_write isON, lowers key_disk_write ratio.
myisam_sort_buffer_size: 8388608		(for sorting MyISAM indexes)
TOTAL: 72 M

InnoDB fixed memory usage:
have_innodb?: YES
innodb_buffer_pool_size: 8388608
innodb_additional_mem_pool_size: 1048576
innodb_log_buffer_size: 1048576
TOTAL: 10 M

Per connection memory usage:
thread stack: 126976
net_buffer_length: 8192		(alloc. per client, grows to 1047552)
TOTAL: 0.13 M

Per allocation memory usage:
bulk_insert_buffer_size: 8388608	(alloc. for insert..select, load data infile, insert value exteded)
sort_buffer_size: 524280		(allocated for sorts, order by)
read_buffer_size: 1044480		(allocated for sequential scans)
read_rnd_buffer_size: 262144		(pre-alloc. for sorted reads)
join_buffer_size: 131072		(using full-table-scan, alloc. per join)
TOTAL: 9.87 M

Summary:

max_connections: 100
Potential Connection Memory: 13 M
::Current Connections - 3 (1 active)
::Max_Used_Connections - 100
::Thread Cache (0) hit ratio - 0.0100000000000051 %

Theoretical Potential Consumption: 95 M
MySQL formula: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections
	 = 67108864 + (1044480 + 524280) * 100 = 213.6 M
Physical memory available: 995.5 M
OK Physical memory within threshold for theoretical memory usage.