…MySQL you cannot move your ibd files freely from one server to another or from one database to another. The reason is that the table definition is stored in the InnoDB…mysql> set FOREIGN_KEY_CHECKS=0; mysql> ALTER TABLE salaries DISCARD TABLESPACE; Copy the salaries.ibd files from the backup to…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
…INNODB_SYS_INDEXES Percona Server has some extra tables in INFORMATION_SCHEMA that can help us to find the different indexes and types. mysql…to a C header file there is another tool with the name create_defs.pl. This one will connect to the database in order to…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…how to read these, there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first edition). From…copy of the table, make the proposed modifications to it, and show the difference afterwards. Or we might have a test server to…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
…how to…in a metadata table: $ mysql -e ‘select * from flexviews.binlog_consumer_status\G’ -uroot *************************** 1. row *************************** server_id: 999 master_log_file…innodb; Query OK, 0 rows affected (0.00 sec) mysql…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…MySQL Server you may not have a good use for that memory anyway. Another thing you should keep into account is Innodb…one IO to fetch page data swapped out. This is very wrong thinking. First OS would have to swap even clean page from…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…to delete one of MySQL‘s log or data files from disk. The database server will continue to function, however, because the file isn’t really deleted. The MySQL server…to those discussed within InnoDB, but it can find evidence of problems in the server…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…to get the most out of Memcheck. Not everything is perfect though: the manual is only partially correct in how to properly build the server to…MySQL server. Let’s take a recent 5.1 bzr version (pre-5.1.61) and a single test, innodb_plugin.innodb…
Post: Connecting orphaned .ibd files
May 13, 2011 By 19 Comments
…copy the an .ibd file to another MySQL server. If you try to very often you’ll get an error in the log: InnoDB: Error: tablespace id is 10 in…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…to copy the data to a temporary table is constant. The reason is that when using merge sort, InnoDB has to…InnoDB picks such an index as the clustered one. References: Peter’s post MySQL bug #57583 MySQL bug #49120 Fast Index Creation page in Percona Server…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…servers? A: If you would like to switch back and forth between galera and built-in mysql…in mysql replication are independent from each other. Q: I installed Percona as cluster database working with Zabbix (innodb…
