[root@localhost ~]# diff --side-by-side result_query1.txt result_query2.txt +----------------------------------------------------------+ +----------------------------------------------------------+ | 1 (0.0066 sec) | | | 1 (0.0015 sec) | +----------------------------------------------------------+ +----------------------------------------------------------+ __ Overall stats _______________________ Value _____________ __ Overall stats _______________________ Value _____________ Total elapsed time 0.007 | Total elapsed time 0.001 Questions 1 Questions 1 COMMIT 0 COMMIT 0 DELETE 0 DELETE 0 DELETE MULTI 0 DELETE MULTI 0 INSERT 0 INSERT 0 INSERT SELECT 0 INSERT SELECT 0 REPLACE 0 REPLACE 0 REPLACE SELECT 0 REPLACE SELECT 0 SELECT 1 SELECT 1 UPDATE 0 UPDATE 0 UPDATE MULTI 0 UPDATE MULTI 0 Data into server 95 | Data into server 75 Data out of server 475 Data out of server 475 Optimizer cost 127.199 Optimizer cost 127.199 __ Table and index accesses ____________ Value _____________ __ Table and index accesses ____________ Value _____________ Table locks acquired 1 Table locks acquired 1 Table scans 0 Table scans 0 Join 0 Join 0 Index range scans 0 Index range scans 0 Join without check 0 Join without check 0 Join with check 0 Join with check 0 Rows sorted 0 Rows sorted 0 Range sorts 0 Range sorts 0 Merge passes 0 Merge passes 0 Table scans 0 Table scans 0 Potential filesorts 0 Potential filesorts 0 __ Row operations ____________________ Handler ______ InnoDB __ Row operations ____________________ Handler ______ InnoDB Reads 82 0 | Reads 5 0 Fixed pos (might be sort) 0 Fixed pos (might be sort) 0 Next row (table scan) 0 Next row (table scan) 0 Bookmark lookup 1 Bookmark lookup 1 First in index (full scan?) 0 First in index (full scan?) 0 Next in index 81 | Next in index 4 Prev in index 0 Prev in index 0 Writes Writes Delete 0 0 Delete 0 0 Update 0 0 Update 0 0 Insert 0 0 Insert 0 0 Commit 0 Commit 0 InnoDB row locks InnoDB row locks Number of locks waited for 0 Number of locks waited for 0 Total ms spent acquiring locks 0 Total ms spent acquiring locks 0 __ I/O Operations _____________________ Memory ________ Disk __ I/O Operations _____________________ Memory ________ Disk Key cache Key cache Key reads 19 0 | Key reads 9 0 Key writes 0 0 Key writes 0 0 Temp tables 0 0 Temp tables 0 0 Temp files 0 Temp files 0 InnoDB buffer pool InnoDB buffer pool Reads 0 0 Reads 0 0 Random read-aheads 0 Random read-aheads 0 Sequential read-aheads 0 Sequential read-aheads 0 Write requests 0 0 Write requests 0 0 Reads/creates blocked by flushes 0 Reads/creates blocked by flushes 0 InnoDB log operations InnoDB log operations Log writes 0 0 Log writes 0 0 Log writes blocked by flushes 0 Log writes blocked by flushes 0 __ InnoDB Data Operations ____ Pages _____ Ops _______ Bytes __ InnoDB Data Operations ____ Pages _____ Ops _______ Bytes Reads 0 0 0 Reads 0 0 0 Writes 0 0 0 Writes 0 0 0 Doublewrites 0 0 Doublewrites 0 0 Creates 0 Creates 0 Fsyncs 0 Fsyncs 0 OS fsyncs 0 0 OS fsyncs 0 0