… in the InnoDB plugin is that it only works when indexes are explicitly created using ALTER TABLE… set (0.00 sec) Now let’s see how performance is affected when turning expand_fast_index… data is loaded.” mysqldump in Percona Server supports the new option –innodb-optimize-keys which does just that, …
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
… logs for the last month to see how frequently this functionality is used. Happily there … properly but does data match ? (This also would cover data improperly loaded with mysqldump if there is… performed the same checks again – happily replication worked and there were no “drift”. This allows …
Post: Percona XtraDB Cluster Feature 1: High Availability
January 17, 2012 By 20 Comments
… – 3 duplicates This basically defines how Percona XtraDB Cluster can be … continue to work, you can continue to run queries on working nodes. … available in Percona XtraDB Cluster: mysqldump, rsync and xtrabackup ( Percona XtraBackup… READ LOCK command). Xtrabackup SST does not require READ LOCK for …
Post: MySQL Workshops: Chicago & London this April
March 15, 2013 By Leave a Comment
… InnoDB data, and describe the advantages of common backup methods (mysqldump, file system snapshot, InnoDB hot backup). Setup and administer MySQL… does internally when data is written, and how features like the transaction log files and undo space work. See how key features of InnoDB work…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
… is that it works with all MySQL storage engines. This set of benchmarks evaluates how well Infobright community…the data to tab delimited flat files using mysqldump. I started by loading the raw data …parallelism. Thus, in the scale up configuration it does not perform any better than the baseline, …
Post: dbqp and Xtrabackup testing
November 16, 2011 By Leave a Comment
… at the dev meeting was showing how we can set up tests …their code. The biggest bit dbqp does is search the specified server code…restore: Populate server Take a validation snapshot (mysqldump) Take the backup (via innobackupex) Clean…up ok, then we do additional work on the master and compare master…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…that ) with some serious limitations (like using mysqldump for node propagation). The Galera team heard…with Galera we have Semi-synchronous slaves. How it works on slaves: slaves just acknowledge reception …6-Jun-2011): It was my misunderstanding: Galera does work with InnoDB-plugin also. You may try…
Post: Data Corruption, DRBD and story of bug
November 29, 2010 By 6 Comments
… innodb_force_recovery=3 and mysqldump your data. What makes problem even worse is that InnoDB does not report tablename, so you… DRBD for HA purposes ( as is in the case I worked with), you screwed, as DRBD mirroring physical data, and MySQL….1.51+ . Now another interesting point – how can you be sure that 5.1.51 works. The bug 55543 is not mentioned…
Post: Can Innodb Read-Ahead reduce read performance ?
June 26, 2007 By 2 Comments
…good IO subsystem so we started number of mysqldump processes in parallel. Unlike in other case when…thread which is unable to keep up. This does not explain the whole story to me, …work Christoffer was doing (I was adviseor in this project from MySQL AB side) – to improve how Innodb read-ahead works…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… Another alternative is to dump table with MySQLDump and load it back. It is all…taking place and as MySQL crashes it does not store all data it could …are not corrupted. So we looked at how to get your data back from simple… index is corrupted this method will not work well – in this case you may wish…
