…one of…lot of help for big…tables or perform complex queries finding relationships between objects. Normalized structure and a lot of…tables being small it would not slow things down too much. On other hand join of few large tables…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…vs 4.1 has a lot of performance differences and not all of …ones. Also do not forget you may need to increase size of your Innodb log files to be able to use a lot of…reorganize which locks and reorganizes small portions of table online. Q38: Seems that… like? Do you have a big enough buffer pool? PZ: …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…small tables, everything can reside within a single extent. For big tables…fuzzy checkpointing one of little known aspects of Innodb operations …lot of waste of space if the fields are less that 16 kB. The ‘zip’ source code tree by Marko has removed most of… vs 33MBps. Any plans to enable tuning of the…
