…of different operations for different levels of concurrency, specifically around mutexes…to show any table / index fragmentation, without having to run the OPTIMIZE…operations on them. Idea for Heikki – it should be possible to…œshow innodb statusâ€. select * from table where id=5 show innodb status: …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… month since I promised Heikki Tuuri to answer Innodb Questions. Heikki is a busy man so I got… 32 pages of a segment are allocated from ‘fragment extents’ where any individual page can be …1: if you set the transaction isolation level READ COMMITTED, then InnoDB normally does not lock the ‘gaps…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…for data and for various indexes. How many “fragmented” pages do we have in the index with…was asking Heikki about probably since my first days as Innodb user when I found out ALTERing Innodb tables…target at least MySQL 5.1 with row level replication readily available. Speaking about community items …
