… great tools for MySQL Performance analyses. Too many people end tuning on plans and indexes while there well…it can get much slower than Monty results show. Mmap allocation process can be split to two … which can get expensive if virtual memory gets fragmented. A while ago I measured over 10 times…
Post: INFORMATION_SCHEMA tables in the InnoDB pluggable storage engine
May 24, 2008 By Leave a Comment
…MySQL conference last month. We’ve written posts ourselves about its fast index… show some status information about InnoDB. Here are the tables: mysql> SHOW…show statistics about compression; they contain a lot of useful information about compression, decompression, memory management, fragmentation…
Post: MySQL 5.6: Improvements in the Nutshell
January 27, 2013 By 16 Comments
…of improvements available in MySQL 5.6 which …Sharing issues – Reduced Innodb Memory Fragmentation – Reduced Locking for Partitioned … by User, Host etc – - Network IO Instrumentation – - Show Host Cache Contents – - Improved …in queries – Full Text Search index for Innodb – Microsecond TIME …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… to create physically sorted indexes with Innodb (with index built by sort) …of a segment are allocated from ‘fragment extents’ where any individual page …_innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_…lots of threads waiting for semaphores in SHOW INNODB STATUS), you can try…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
…or CPU bound, while to understand if MySQL goes through more rows than it …page containing old row version (and possibly index pages you’re to modify) – even …all tracks, if you use 100GB non fragmented block on 1TB hard drive you …high amount of threads which do not show this effect well. So as you …
Post: Percona build7 with latest patches
November 14, 2008 By 26 Comments
We made new binaries for MySQL 5.0.67 build 7 which include patches we recently … check fragmentation of the last InnoDB scan | 1.0 | Percona | GPL | The names are Innodb_scan_* | | userstatsv2.patch | SHOW USER/TABLE/INDEX statistics | V2 | Google | GPL | Added INFORMATION_SCHEMA.*_STATISTICS | | show_patches.patch | SHOW PATCHES | 1.0 | Jeremy…
Post: Long PRIMARY KEY for Innodb tables
October 3, 2006 By 8 Comments
…number of benefits – caching data and index in memory -so cached lookups are… other benefit – it is typical to show multiple thumbnails from the same album…repairing large MyISAM tables in case of MySQL/System crash is painful and great…be slow as it is quite fragmented. Table however is not getting …
Post: Moving from MyISAM to Innodb or XtraDB. Basics
November 22, 2010 By 2 Comments
…. Again converting schema will show you some of this….fragmentation. Usage Differences What works well for MyISAM may not work for Innodb and vice versa. You may benefit from different index…index scan for Innodb. Defaults You need to know two things about defaults for Innodb. First Depending on MySQL…
