…to know more about how MySQL executes this query. … | Duration | +———————-+———-+ | starting | 0.000075 | | checking permissions | 0.000004 | | checking permissions | 0.000004 | | Opening tables … this could increase the fragmentation of the cache and…
Post: MySQL Storage Engines - PBXT
May 14, 2007 By 6 Comments
… which are never fragmented and handled efficiently. PBXT team even leads the project to add scalable blob streaming to MySQL which would… for many applications if implemented well. It is too bad MySQL Users Conference only allowed 45 minutes for Storage Engine presentations… lot of changes are expected to happen anyway. We also checked for CPU bound workload – with disk IO situation can be…
Post: Percona build7 with latest patches
November 14, 2008 By 26 Comments
… binaries for MySQL 5.0.67 build 7 which include patches we recently announced. The -percona release includes: | innodb_check_defrag.patch | Session status to check fragmentation of the last InnoDB scan | 1.0 | Percona…
Post: MySQL performance: Impact of memory allocators (Part 2)
March 8, 2013 By 12 Comments
… allows to generate significant load and check server behavior under very high pressure Observations: … pages, minimize impact of the memory fragmentation is so significant that becomes bottleneck … with decreasing performance in workloads with MySQL. # Test: POINT_SELECT:throughput, QPS # # Set 1 …
Comment: Statistics of InnoDB tables and indexes available in xtrabackup
September 14, 2009 By 6 Comments
… vals %lu, leaf pages %lu, size pages %lu” : http://dev.mysql.com/doc/refman/5.0/en/innodb-monitors.html#innodb…”. (contiguousness like http://www.percona.com/docs/wiki/patches:innodb_check_fragmentation ?)
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… 0 mysql> SHOW PROFILE; +——————————+———–+ | Status | Duration | +——————————+———–+ | starting | 0.000054 | | checking permissions | 0.000004 | | checking permissions | 0…. is fragmentation. Fast index creation results in much less fragmented …
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
… of MySQL directory to other location, check them by myisamchk prioritizing more important databases first an then rename them back to MySQL database directory. This way accesses to non-checked tables fail with table does not… may cause total block if there are long selects running. Fragmentation. This is common problem for pretty much all storage engines…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…_buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries,… can run to show any table / index fragmentation, without having to run the OPTIMIZE? HT: … status or bug in implementation. I’ll check with Alexander or check myself to see what it could…
Post: Innodb Double Write
August 4, 2006 By 24 Comments
… execution. Reasons for splitting could be file fragmentation – most file systems use 4K block sizes… the second time. Now on recovery Innodb checks doublewrite buffer contents and pages in their …. How much does double write buffer affect MySQL Performance ? Even though double write requires each…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
… seconds. The problem was: why would this table get so fragmented or come to its knees with the transaction record as… takes about 7 second. What gives? Integrity checks don’t work — try making a check on a column NOT NULL to include… have to do this check in the application. Just my experience. I know some big websites are using MySQL, but we had…
