+----------------------------------------------------------+ | QUERY 1 (0.5632 sec) | +----------------------------------------------------------+ select day, ad, sum(clicks), sum(impressions) from tracki... __ Overall stats ___________________________________________ Elapsed time 0.563 Optimizer cost 21257.999 __ Table and index accesses ________________________________ Table locks acquired 1 Table scans 0 Join 0 Index range scans 0 Join without check 0 Join with check 0 Rows sorted 31 Range sorts 0 Merge passes 0 Table scans 1 __ Row operations ____________________ Handler ______ InnoDB Reads 51466 49881 Fixed pos (might be sort) 31 Next row (table scan) 32 Bookmark lookup 1522 First in index (full scan?) 0 Next in index 49881 Prev in index 0 Writes Delete 0 0 Update 1488 0 Insert 31 0 Commit 0 InnoDB row locks Number of locks waited for 0 Total ms spent acquiring locks 0 __ I/O Operations _____________________ Memory ________ Disk Key cache Key reads 0 0 Key writes 0 0 Temp tables 1 0 Temp files 0 InnoDB buffer pool Reads 204735 93 Random read-aheads 1 Sequential read-aheads 168 Write requests 0 0 Reads/creates blocked by flushes 0 InnoDB log operations Log writes 0 0 Log writes blocked by flushes 0 __ InnoDB Data Operations ____ Pages _____ Ops _______ Bytes Reads 2790 262 45711360 Writes 0 0 0 Doublewrites 0 0 Creates 0 Fsyncs 0 OS fsyncs 0 0 +----------------------------------------------------------+ | QUERY 2 (0.5128 sec) | +----------------------------------------------------------+ select day, ad, sum(clicks), sum(impressions) from tracki... __ Overall stats ___________________________________________ Elapsed time 0.513 Optimizer cost 10537.399 __ Table and index accesses ________________________________ Table locks acquired 1 Table scans 0 Join 0 Index range scans 0 Join without check 0 Join with check 0 Rows sorted 31 Range sorts 0 Merge passes 0 Table scans 1 __ Row operations ____________________ Handler ______ InnoDB Reads 51466 49881 Fixed pos (might be sort) 31 Next row (table scan) 32 Bookmark lookup 1522 First in index (full scan?) 0 Next in index 49881 Prev in index 0 Writes Delete 0 0 Update 1488 0 Insert 31 0 Commit 0 InnoDB row locks Number of locks waited for 0 Total ms spent acquiring locks 0 __ I/O Operations _____________________ Memory ________ Disk Key cache Key reads 0 0 Key writes 0 0 Temp tables 1 0 Temp files 0 InnoDB buffer pool Reads 204367 93 Random read-aheads 1 Sequential read-aheads 152 Write requests 0 0 Reads/creates blocked by flushes 0 InnoDB log operations Log writes 0 0 Log writes blocked by flushes 0 __ InnoDB Data Operations ____ Pages _____ Ops _______ Bytes Reads 2534 248 41517056 Writes 0 0 0 Doublewrites 0 0 Creates 0 Fsyncs 0 OS fsyncs 0 0 +----------------------------------------------------------+ | QUERY 3 (0.0255 sec) | +----------------------------------------------------------+ select day, ad, sum(clicks), sum(impressions) from tracki... __ Overall stats ___________________________________________ Elapsed time 0.026 Optimizer cost 86467.633 __ Table and index accesses ________________________________ Table locks acquired 1 Table scans 0 Join 0 Index range scans 1 Join without check 0 Join with check 0 Rows sorted 0 Range sorts 0 Merge passes 0 Table scans 0 __ Row operations ____________________ Handler ______ InnoDB Reads 31002 31001 Fixed pos (might be sort) 0 Next row (table scan) 0 Bookmark lookup 2 First in index (full scan?) 0 Next in index 31000 Prev in index 0 Writes Delete 0 0 Update 0 0 Insert 0 0 Commit 0 InnoDB row locks Number of locks waited for 0 Total ms spent acquiring locks 0 __ I/O Operations _____________________ Memory ________ Disk Key cache Key reads 0 0 Key writes 0 0 Temp tables 0 0 Temp files 0 InnoDB buffer pool Reads 4116 9 Random read-aheads 1 Sequential read-aheads 4 Write requests 0 0 Reads/creates blocked by flushes 0 InnoDB log operations Log writes 0 0 Log writes blocked by flushes 0 __ InnoDB Data Operations ____ Pages _____ Ops _______ Bytes Reads 81 15 1327104 Writes 0 0 0 Doublewrites 0 0 Creates 0 Fsyncs 0 OS fsyncs 0 0 +----------------------------------------------------------+ | SUMMARY | +----------------------------------------------------------+ __ Overall stats ___________________________________________ Total elapsed time 1.102 Questions 3 COMMIT 0 DELETE 0 DELETE MULTI 0 INSERT 0 INSERT SELECT 0 REPLACE 0 REPLACE SELECT 0 SELECT 3 UPDATE 0 UPDATE MULTI 0 Optimizer cost 118263.031 __ Table and index accesses ________________________________ Table locks acquired 3 Table scans 0 Join 0 Index range scans 1 Join without check 0 Join with check 0 Rows sorted 62 Range sorts 0 Merge passes 0 Table scans 2 __ Row operations ____________________ Handler ______ InnoDB Reads 133934 130763 Fixed pos (might be sort) 62 Next row (table scan) 64 Bookmark lookup 3046 First in index (full scan?) 0 Next in index 130762 Prev in index 0 Writes Delete 0 0 Update 2976 0 Insert 62 0 Commit 0 InnoDB row locks Number of locks waited for 0 Total ms spent acquiring locks 0 __ I/O Operations _____________________ Memory ________ Disk Key cache Key reads 0 0 Key writes 0 0 Temp tables 2 0 Temp files 0 InnoDB buffer pool Reads 413218 195 Random read-aheads 3 Sequential read-aheads 324 Write requests 0 0 Reads/creates blocked by flushes 0 InnoDB log operations Log writes 0 0 Log writes blocked by flushes 0 __ InnoDB Data Operations ____ Pages _____ Ops _______ Bytes Reads 5405 525 88555520 Writes 0 0 0 Doublewrites 0 0 Creates 0 Fsyncs 0 OS fsyncs 0 0