… 5 and CentOS 5. Bug fixed #1144777 (Ignacio Nin). When mysqldump was used with –innodb-optimize-keys option it produced invalid… fixed #1131187 (Alexey Kopytov). Removed trx_list scan in read_view_open_now() which is another problem originally reported as upstream…_flush_order_mutex acquisition. Bug fixed #1163262 (Alexey Kopytov). When mysqldump was used with –innodb-optimize-keys and –no-data options…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… 5 and CentOS 5. Bug fixed #1144777 (Ignacio Nin). When mysqldump was used with –innodb-optimize-keys option it produced invalid… fixed #1131187 (Alexey Kopytov). Removed trx_list scan in read_view_open_now() which is another problem originally reported as upstream…_flush_order_mutex acquisition. Bug fixed #1163262 (Alexey Kopytov). When mysqldump was used with –innodb-optimize-keys and –no-data options…
Comment: Unexpected problem with triggers and mysqldump
February 12, 2013 By 8 Comments
… are some funny quirks like the one you encountered in mysqldump. Views are basically treated like tables, but stored routines and triggers…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… backups Strong Points: Very fast for logical backups – compared to mysqldump Consistent backups between myisam and innodb tables. Global read lock…’s. It does not handle views/triggers/procedures etc. Run with –no-schemas, instead use mysqldump for the schemas and rely on…
Comment: How to change innodb_log_file_size safely
November 8, 2011 By 17 Comments
… test it today anymore) would be able to create a mysqldump from the datafile. But as I understand it, there is… hosting server migration I started over the weekend, cheers god, mysqldump for the Zarafa database (on 7.0.2 now) has… getting to tuning. So as a final note (my personal view on this topic): Never change innodb_log_file_size in…
Post: Can Innodb Read-Ahead reduce read performance ?
June 26, 2007 By 2 Comments
… had pretty good IO subsystem so we started number of mysqldump processes in parallel. Unlike in other case when we did… ————– 8 queries inside InnoDB, 3 queries in queue 12 read views open inside InnoDB Main thread process no. 3956, id 1157658976…
