… buffer pool dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced and loaded for… in MySQL 5.6. This option can be used to produce 5.6-style metadata files, that can be imported by ALTER TABLE…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… buffer pool dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced and loaded for… in MySQL 5.6. This option can be used to produce 5.6-style metadata files, that can be imported by ALTER TABLE…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
…. `ID` is a table identifier. We will need the table id to find indexes of the table. mysql> select * from SYS_TABLES WHERE NAME=’sakila… what position primary key fields are defined in CREATE TABLE statement internally they always go first in a record. The second issue we…_id> 4. Load dumps of the dictionary tables into some MySQL server. Use LOAD DATA INFILE constraints_parser generates mysql>LOAD DATA INFILE ‘/path…
Post: Analyzing Slow Query Table in MySQL 5.6
February 18, 2013 By 1 Comment
… use table logs, since they can’t access the file-based logs on the server. I read the logging code in MySQL 5.6.10 source, in file sql/log.cc. I discovered that they…,Connect,Kill,Debug,Ping,Time,Delayed insert,Change user,Binlog Dump,Table Dump,Connect Out,Register Slave,Prepare,Execute,Long Data,Close stmt…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
… internally because there are many documents about that: http://dev.mysql.com/doc/refman/5.6/en/replication-gtids-concepts.html… we need to know in which GTID is the master and set it on the slave. MySQL keeps two global variables with…-table-sync. How to restore a slave in a good and slow way The good way is mysqldump again. We take a dump…
Post: Unexpected problem with triggers and mysqldump
February 11, 2013 By 8 Comments
… the data in a new database: mysql> CREATE DATABASE sakila2; Query OK, 1 row affected (0.00 sec) $ mysql sakila2 < schema.sql $ mysql sakila2… mysqldump documentation, you will see: –triggers Include triggers for each dumped table in the output. This option is enabled by default; disable it…
Post: How to obtain the "LES" (Last Executed Statement) from an Optimized Core Dump?
September 9, 2012 By 9 Comments
… inspect the mysql_execute_command frame: (gdb) frame 21 #21 0x00000000005a30af in mysql_execute_command …sel_result, OPTION_SETUP_TABLES_DONE); 3139 /* 3140 Invalidate the table in the query cache if …in an optimized core dump by checking the contents of the thd array in the mysql_…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… plain ALTER TABLE statements? Yes. This is exactly how it is done in many cases. There is really no gain in dumping table via mysqldump… as MyISAM tables are on track to be depreciated in future MySQL versions also MyISAM tables are essentially at the state they were in MySQL 4… to Innodb in MySQL 5.5, meaning you might need to set storage_engine=MYISAM if you’re relaying on tables to be…
Post: Resyncing table on MySQL Slave
June 29, 2008 By 11 Comments
….txt’ INTO TABLE tbl; UNLOCK TABLES; This will dump master’s table content to the file clean the table on master…: 0 Deleted: 0 Skipped: 0 Warnings: 0 mysql> rename table rep_maint to rep_old, rep_new to … same data loaded to “rep” table you will get the copy of old table in “rep_old” – this can…
Post: Beware the Innodb Table Monitor
November 29, 2011 By 2 Comments
…. To use it, you create a table (in any database you choose), like this: CREATE TABLE innodb_table_monitor (a INT) ENGINE=INNODB; This… it should start the Table monitor. The monitor itself dumps the contents of the Data dictionary to the mysql error log, which looks… in ‘Opening Tables‘ were waiting for the dict_sys->mutex, which is required for opening tables in Innodb. It would be better for the Table…
