… out as not good to be, here are a few: Innodb_buffer_pool_reads 12 Handler_read_rnd 2,448 k…,208 Select_full_join 1,074(the application is using indexes to join the tables so this puzzles me) Sort_merge_passes 2,602… the server some….maybe use InnoDB since the database is 3NF and uses alot of selects using joins? Any tips and help…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
…, while Disk_filesort means that sorting was done through temporary files. INNODB USAGE The final part are the InnoDB usage statistics. MySQL currently… Full_join: No Tmp_table: Yes Disk_tmp_table: No # Filesort: Yes Disk_filesort: No Merge_passes: 0 # InnoDB_IO_r_ops: 19 InnoDB…: No Full_join: No Tmp_table: No Disk_tmp_table: No # Filesort: No Disk_filesort: No Merge_passes: 0 # No InnoDB statistics available…
