… CREATE TABLE `parent` ( `parent_id` int(10) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE… any significant errors or items requiring review. Columns – a listing of all columns in the schema, really handy to sort by name…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 2 Comments
…milestone at Launchpad. This release contains all the bug fixes from latest … implementation is considered ALPHA quality. Complete list of the ported features can …INNODB_CHANGED_PAGES query started returning data to indicate an incomplete result set. Bug fixed #1185040. The INNODB_CHANGED_PAGES table…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… SYS_INDEXES This table lists all indexes the table has, secondary as well as the primary. CREATE TABLE `SYS_INDEXES` ( `TABLE_…all fields. It must exist for any InnoDB table. If explicitely defined its `NAME` is PRIMARY. If the primary key is not defined InnoDB…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… to the database, all SELECT queries, even those participating in read-only transactions, start suffering from the trx_list overhead created by… innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_file_per_table = true innodb…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb_file_per_table = true innodb_data_file_path = ibdata1:100M innodb_flush_method = O_DIRECT innodb…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…) Drop table performance feature has been removed and its controlling variable innodb_lazy_drop_table has been…Bug fixed #1131187 (Alexey Kopytov). Removed trx_list scan in read_view_open_now() … mysqldump was used with –innodb-optimize-keys and –no-data options, all secondary key definitions would…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…) Drop table performance feature has been removed and its controlling variable innodb_lazy_drop_table has been…Bug fixed #1131187 (Alexey Kopytov). Removed trx_list scan in read_view_open_now() … mysqldump was used with –innodb-optimize-keys and –no-data options, all secondary key definitions would…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…and how. There’s still one noticeable omission: pt-table-sync. It’s still unclear if or how …time between tries for all operations are configurable. Also, we removed –lock-wait-timeout which set innodb_lock_wait_…percona-toolkit/+milestone/2.2.1 for the full list. If you upgrade from 2.1 to 2.2…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… to the database at all (use mysql -A in this case, to prevent it from getting field list from all tables) Reads though would not be blocked, ie there is no MYISAM like table lock priority problem…’re just using Innodb tables and you’re not actively changing users, stored procedures etc (which are stored in MyISAM tables anyway) you…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
… on the flush list, “Lazy Drop Table” implementation relies on taking a mutex on the LRU list (which is a list of pages ordered….24 (innodb_lazy_drop_table=1) Now so much for the details of the benchmark, lets see the graphs. First of all comes… the LRU list at all during the DROP TABLE, and I think this is something that could be implemented in “Lazy Drop Table” to…
