…table. The times for full table scan vs range scan by index: mysql…of help for big scans. This …tables being small it would not slow things down too much. On other hand join of few large tables, which is completely disk bound can be very slow. One of the reasons elevating this problem in MySQL…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…the question is: for small tables, everything can reside within a single extent. For big tables, a secondary index reserves…serializable. PZ: Cool. This is one of little known new features in MySQL 5.1 Q15: How …performance boost and it would write at 100MBps vs 33MBps. Any plans to enable tuning of …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…. PZ: I should note MySQL 5.0 vs 4.1 has a… Flash. SSD Drives would be big win for TableSpace files but… for applications (of which Mysql is the main one with “innodb_…MySQL Master Master Manager can help you to automate it a bit. I also like to keep tables small enough, “sharding” to many tables…
