June 19, 2013

Post: Percona Server for MySQL 5.5.31-30.3 now available

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

Post: Announcing Percona XtraBackup 2.1.1 GA

…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

Post: Hijacking Innodb Foreign Keys

… 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…

Post: Hacking to make ALTER TABLE online for certain changes

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

Post: Innodb vs MySQL index counts

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…

Post: InnoDB: look after fragmentation

…`), 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_…

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

… 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…

Post: Improved InnoDB fast index creation

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

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

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

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

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=InnoDBInnoDB table, be prepared for a table rebuild. …