From: http://dev.mysql.com/doc/mysql/en/Server_status_variables.html
Key_reads 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. Select_full_join The number of joins that do not use indexes. If this value is not 0, you should carefully check the indexes of your tables. This variable was added in MySQL 3.23.25. Select_full_range_join The number of joins that used a range search on a reference table. This variable was added in MySQL 3.23.25. Select_range The number of joins that used ranges on the first table. (It's normally not critical even if this is big.) This variable was added in MySQL 3.23.25. Select_range_check 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.) This variable was added in MySQL 3.23.25. Select_scan The number of joins that did a full scan of the first table. This variable was added in MySQL 3.23.25. Sort_scan The number of sorts that were done by scanning the table. This variable was added in MySQL 3.23.25. So... it's not as bad as it could be ;-) I would still check the slow query log to see if there are any common queries that could use an index or two. I would also look at changing some simple indexes into compound indexes (indices?) as another means of speeding things up. Yours, Shawn Green Database Administrator Unimin Corporation - Spruce Pine matt ryan <[EMAIL PROTECTED]> wrote on 07/22/2004 01:17:12 PM: > Hmm > > I'm guessing my stats arent too good, lots of full table scans, but this > is to be expected, my users can query any table by any column, and I > cant index all column combinations > > Variable_name > Value > > Select_full_join > 0 > > Select_full_range_join > 24 > > Select_range > 145321 > > Select_range_check > 0 > > Select_scan 29402 > Sort_Scan 15360 > Key_reads 37811885 > > > and on the other big db.. > > Variable_name > Value > > Select_full_join > 535 > > Select_full_range_join > 0 > > Select_range > 1098 > > Select_range_check > 0 > > Select_scan 10443 > Sort_Scan 2464 > Key_reads 20282002 > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >
