June 19, 2013

Post: Percona Server for MySQL 5.5.31-30.3 now available

May 24, 2013 By Leave a Comment

…innodb_read_views_memory and innodb_descriptors_memory status variables in the Extended Show Engine InnoDB Status to improve InnoDB…mysql-perl package. Fixed by adding the package dependency. Bug fixed #1003776. Rebuilding…

Filed Under: MySQL, Percona Server, Percona Software Tagged With:

Post: Announcing Percona XtraBackup 2.1.1 GA

May 15, 2013 By Leave a Comment

…XtraBackup when rebuilding secondary indexes on innobackupex –apply-log –rebuild-indexes. This allows parallel processing of individual tables when rebuilding the index….DBD::MySQL package for server communication instead of spawning the MySQL command line client. Support for InnoDB 5.0 and InnoDB …

Filed Under: MySQL, Percona XtraBackup Tagged With:

Post: Hijacking Innodb Foreign Keys

January 2, 2012 By 2 Comments

… keys requires table rebuild. Yes you get it right even though Innodb is able to drop indexes without rebuilding table since MySQL 5.1 (Innodb Plugin) dropping foreign keys which should only require meta data change needs a table rebuild. In some…

Filed Under: Insight for DBAs, MySQL

Post: Hacking to make ALTER TABLE online for certain changes

October 29, 2007 By 26 Comments

…mysql data file structure, so be really careful with that one. Default values. MySQL rebuilds table…

Filed Under: Insight for DBAs Tagged With: , ,

Post: Innodb vs MySQL index counts

November 29, 2011 By 6 Comments

… Table database_name/table_name contains 8 indexes inside InnoDB, which is different from the number of indexes 7 defined in the MySQL … ALTER TABLE table_name ENGINE=Innodb; This, of course, rebuilds the whole table based on the .frm table definition and removes the existing index in Innodb, which…

Filed Under: MySQL

Post: InnoDB: look after fragmentation

November 5, 2009 By 12 Comments

…`), KEY `block_id` (`block_id`) ) ENGINE=InnoDB Table has 11864696 rows and takes Data_…) mysql> SHOW STATUS LIKE ‘Innodb_scan_pages%’; +——————————+——-+ | Variable_name | Value | +——————————+——-+ | Innodb_scan_pages_contiguous | 45 | | Innodb_scan_…

Filed Under: Insight for DBAs, MySQL Tagged With:

Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size

June 27, 2012 By 4 Comments

… data and index size: mysql> show table status like “sbtest” \G *************************** 1. row *************************** Name: sbtest Engine: InnoDB Version: 10 Row_format:… you’re having large tables and need to run ALTER TABLE which rebuilds the table or OPTIMIZE TABLE do not forget to enable…

Filed Under: Insight for DBAs, MySQL

Post: Improved InnoDB fast index creation

November 6, 2011 By 4 Comments

…table rebuilds without affecting the table size. mysql> SET expand_fast_index_creation=ON; Query OK, 0 rows affected (0.00 sec) mysql> ALTER TABLE…

Filed Under: Benchmarks, Insight for DBAs, MySQL

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

… sec) Records: 0 Duplicates: 0 Warnings: 1 mysql> show warnings; +———+——+————————————————–+ | Level | Code | Message | +———+——+————————————————–+ | Warning | 124 | InnoDB rebuilding table to add column FTS_DOC_ID…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

…mysql: SHOW CREATE TABLE innodb_myisam_stopword\G *************************** 1. row *************************** Table: innodb_myisam_stopword Create Table: CREATE TABLE `innodb_myisam_stopword` ( `value` varchar(18) NOT NULL DEFAULT ” ) ENGINE=InnoDB… InnoDB table, be prepared for a table rebuild. …

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,
« Older Posts