Context: MySQL 4.0.18 on redhat linux 2.4.20-28.8smp kernel. Usage scenario: Around 10-20 users daily (not necessarily concurrent)
I have collected some "System variables" over 2x periods. Period #1: 7 days uptime ------------------------ | Select_full_join | 1967 | | Select_full_range_join | 0 | | Select_range | 1 | | Select_range_check | 0 | | Select_scan | 47074 | | Slow_queries | 106 | | Sort_merge_passes | 0 | | Sort_range | 0 | | Sort_rows | 151760 | | Sort_scan | 7341 | Period #2: 18 hours uptime after a reboot ----------------------------------------- | Select_full_join | 182 | | Select_full_range_join | 0 | | Select_range | 0 | | Select_range_check | 0 | | Select_scan | 4216 | | Slow_queries | 18 | | Sort_merge_passes | 0 | | Sort_range | 0 | | Sort_rows | 24016 | | Sort_scan | 696 | Basically I would like to zoom into the variables: Select_full_join, Select_scan, & Sort_scan. By reading the docs @ mysql.com, I can infer that my queries/sorts are performing a lot of full table scans. I know that's bad. But I want to know from experienced people if my numbers above indicate "normal" or "excessively horrible" performance. Thank you Xanana -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
