Active
Project:
DB Tuner
Version:
6.x-1.x-dev
Component:
Documentation
Priority:
Normal
Category:
Support request
Assigned:
Unassigned
Reporter:
Created:
1 Aug 2011 at 06:40 UTC
Updated:
1 Aug 2011 at 06:40 UTC
DB Tuner reports many adavces about indexes
I already set all fields for indexing, what shall I do next? Changing something in my Views?
Sorts
Total sorts: 67430
% sorts that cause temporary tables: 0
rate of sorts that cause temporary tables: 0 per day
sort_buffer_size: 2.0 Gb
read_rnd_buffer_size: 2.0 Gb
Sort rows: 3.99632190772 per second
There are lots of rows being sorted. Consider using indexes in more queries to avoid sorting too often.
(&hr_bytime(Sort_rows/Uptime_since_flush_status) =~ /second|minute/)
(dbtuner_hr_bytime(588894/147359) dbtuner_stristr('3.99632190772 per second', array('second', 'minute')))
Joins,scans
rate of joins without indexes: 36.5454434408 per minute
There are too many joins without indexes -- this means that joins are doing full table scans.
(&hr_bytime((Select_range_check + Select_scan + Select_full_join)/Uptime_since_flush_status) =~ /second|minute/)
(dbtuner_hr_bytime((0 + 85031 + 4724)/147359) dbtuner_stristr('36.5454434408 per minute', array('second', 'minute')))
rate of reading first index entry: 38.4497723247 per minute
The rate of reading the first index entry is high; this usually indicates frequent full index scans.
(&hr_bytime(Handler_read_first/Uptime_since_flush_status) =~ /second|minute/)
(dbtuner_hr_bytime(94432/147359) dbtuner_stristr('38.4497723247 per minute', array('second', 'minute')))
rate of reading fixed position: 2.61789914427 per second
The rate of reading data from a fixed position is high; this indicates many queries need to sort results and/or do a full table scan, including join queries that do not use indexes.
(&hr_bytime(Handler_read_rnd/Uptime_since_flush_status) =~ /second|minute/)
(dbtuner_hr_bytime(385771/147359) dbtuner_stristr('2.61789914427 per second', array('second', 'minute')))
rate of reading next table row: 3283.948561 per second
The rate of reading the next table row is high; this indicates many queries are doing full table scans.
(&hr_bytime(Handler_read_rnd_next/Uptime_since_flush_status) =~ /second|minute/)
(dbtuner_hr_bytime(483919376/147359) dbtuner_stristr('3283.948561 per second', array('second', 'minute')))