I've included warnings from the Runtime Information generated by phpMySQL, any comments/suggestions would be greatly appreciated:
Code: Select all
Slow_queries
499
The number of queries that have taken more than long_query_time seconds. MySQL - Documentation
Handler_read_rnd
62 M
The number of requests to read a row based on a fixed position. This is high if you are doing a lot of queries that require sorting of the result. You probably have a lot of queries that require MySQL to scan whole tables or you have joins that don't use keys properly.
Handler_read_rnd_next
3,035.69 M
The number of requests to read the next row in the data file. This is high if you are doing a lot of table scans. Generally this suggests that your tables are not properly indexed or that your queries are not written to take advantage of the indexes you have.
Created_tmp_disk_tables
493 k
The number of temporary tables on disk created automatically by the server while executing statements. If Created_tmp_disk_tables is big, you may want to increase the tmp_table_size value to cause temporary tables to be memory-based instead of disk-based.
[ tmp table size is 33,554,432 ]
Key_reads
32 M
The number of physical reads of a key block from disk. If Key_reads is big, then your key_buffer_size value is probably too small. The cache miss rate can be calculated as Key_reads/Key_read_requests.
[ key buffer size is 536,870,912 ]
Select_full_join
112 k
The number of joins that do not use indexes. If this value is not 0, you should carefully check the indexes of your tables.
Select_range_check
46
The number of joins without keys that check for key usage after each row. (If this is not 0, you should carefully check the indexes of your tables.)
Opened_tables
1,782 k
The number of tables that have been opened. If opened tables is big, your table cache value is probably too small.
[The table cache value is 256 - is that bad?]
( for reference - no warning: Table_locks_immediate 39 M
The number of times that a table lock was acquired immediately. )
Table_locks_waited
57 k
The number of times that a table lock could not be acquired immediately and a wait was needed. If this is high, and you have performance problems, you should first optimize your queries, and then either split your table or tables or use replication.
Joel