… meta data (it is not implemented in MySQL anyway though). Very interesting to see how this one will compare to transparent gzip… handling for example having direct blob writes to the database and probably some others. This would be very interesting to see how… is regarding handling fragmentation – what happens on row updates, are they stored in the same position or in another location ? Does row ever…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… cache so it can handle system restarts. When putting… Q36: There have been several MySQL bugs opened about multi-core …specifically around mutexes and contention? How does this fit into the development …how long will this take? Is there a facility we can run to show any table / index fragmentation…
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…by row insertions as it currently does which can be multiple orders of… this aspect separately. Improved Auto Increment handling Yet another known Innodb problem is… which may come in MySQL 5.2 or even MySQL 5.1. I surely…
Post: MySQL Storage Engines - PBXT
May 14, 2007 By 6 Comments
…PBXT because this is storage engine does not target the same general purpose…effect of it is yet unknown – how transactional system implements logging and …handling of the blobs which are never fragmented and handled efficiently. PBXT team even leads the project to add scalable blob streaming to MySQL…
Post: MySQL performance: Impact of memory allocators (Part 2)
March 8, 2013 By 12 Comments
… and how they can affect MySQL performance in general….does the number of processor cores have on different memory allocators and what difference we will see in MySQL…fragmentation is so significant that becomes bottleneck for the query processing. I believe that both allocators can be tuned to handle…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…32 pages of a segment are allocated from ‘fragment extents’ where any individual page can be… little known new features in MySQL 5.1 Q15: How frequently does Innodb fuzzy checkpointing is activated … magic number to experiment with. Q17: How InnoBD handles blobs/text fields (needs more info) According…
