…sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127…., PRIMARY KEY (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE `child_A…for any significant errors or items requiring review. Columns – a … file. Donate – This is free software and John Currier …
Post: Percona Monitoring Plugins 1.0.3 for MySQL now available
April 23, 2013 By 4 Comments
…templates, plugins, and scripts. Changelog: * MySQL 5.6 compatibility for InnoDB graphs (bug 1124292) * Added … * Extended “MySQL Threads” graph with all kind of threads (bug 1157911) * Some Cacti single-item … with a Percona Support contract and free installation services are provided as part of…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…MySQL server. Let’s take a recent 5.1 bzr version (pre-5.1.61) and a single test, innodb_plugin.innodb…:221) ==9090== by 0x6B39223: fsp_fill_free_list (fsp0fsp.c:1455) ==9090== … mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*,…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…| 0.000006 | | query end | 0.000003 | | closing tables | 0.000008 | | freeing items | 0.000016 | | cleaning up | 0.000004 | +——————————+———–+ 18 rows in set…int(11) not null auto_increment primary key) ENGINE=InnoDB; When using MySQL 5.1 the second CREATE would just fail …
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…| 0.000007 | | query end | 0.000003 | | closing tables | 0.000008 | | freeing items | 0.000021 | | cleaning up | 0.000003 | +——————————+———–+ 18 rows in … TABLE … ENGINE=InnoDB for InnoDB tables and thus, is just a special case of the previous one: mysql> SET expand_fast_…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… the Innodb stats: mysql> select * from information_schema.innodb_buffer_pool_stats\G *************************** 1. row *************************** POOL_ID: 0 POOL_SIZE: 8191 FREE_BUFFERS:…| 0.000000 | 0 | 0 | 0 | 0 | 14 | 14 | | 16 | freeing items | 0.000049 | 0.000117 | 0.000000 | 0.001000 | 0 |…
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
… Block count: 3630694400 Reserved block count: 0 Free blocks: 3616208434 Free inodes: 226918374 First block: 0 Block size… inode: 11 This has a lot of interesting items and I’ll get into some of …Innodb is very sensitive to corruptions and if any of file system errors are reported back to MySQL/Innodb…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
… to run MySQL with innodb_flush_method=O_DIRECT in most cases – it makes … 20975714304 Max_data_length: 0 Index_length: 9047113728 Data_free: 6291456 Auto_increment: NULL Create_time: 2012-12-31…experiment with even in regards to such a minor item – Database Scientists will never have their job …
Comment: Solving INFORMATION_SCHEMA slowness
December 25, 2011 By 25 Comments
… (1.86 sec) mysql> set global innodb_stats_on_metadata=0; Query OK, 0 rows affected (0.00 sec) mysql> select count(*),sum….000012 | | Opening tables | 0.000013 | | removing tmp table | 0.000013 | | freeing items | 0.000014 | | Opening tables | 0.000014 | | Opening tables | 0.000014… | 0.000030 | | Opening tables | 0.000030 | | Opening tables | 0.000030 | | freeing items | 0.000031 | | Opening tables | 0.000031 | | Opening tables | 0.000031…
Post: 7 Reasons why MySQL Quality will never be the same
December 10, 2008 By 15 Comments
…long time. The good thing about this item is – it is easily fixable. Just …Innodb Development is going with Innodb Plugin which is separate from Innodb included default MySQL. Why is not this part of stock MySQL…general “quality” or “being free from bugs” to run MySQL in production. MySQL as it is now…
