…case you may need to take it much slower checking your progress along the way. There is no limit as…run SELECT queries on both new and old MySQL installations and check result set, explain plan and execution time, …made it to caught up you can use mk-table-checksum to ensure data is the same. It …
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
… final import command: alter table order_line import tablespace; now some magic happens and you can see progress of import in …finished quick check mysql> select count(*) from order_line; +———-+ | count(*) | +———-+ | 32093604 | +———-+ 1 row in set (3 min 29.32 sec) New table has…
Post: Progress with ClickAider project
October 24, 2007 By 21 Comments
… think it is about the time to write about the progress we have with this project for those who interested. The… data storage with no MySQL bugs hitting us with this project so far. We use Innodb tables now because checking and repairing MyISAM is nightmare and PBXT which could be good for this work is just not ready. MySQL…
Post: Announcing Percona Server 5.5.27-29.0
October 11, 2012 By Leave a Comment
… block server while the dump is in progress. Bug fixed #686534 (George Ormond Lorch III). …to 0 (default), flashcache checks are disabled and when set to 1 checks are enabled. Error message …a non-default maximum number of indexes per table. Upstream MySQL bugs: #54127, #61178, #61179 and #61180. Bug…
Post: Fighting MySQL Replication Lag
September 22, 2008 By 7 Comments
…LIKE “%cheap rolex%”; This query will perform full table scan in MySQL 5.0 (even if there are no spam…execution of batch job – this is when they will check slave lag every so often and pause if …around and adjusting your sleep behavior to keep the progress fast enough and at the same time keep …
Comment: Pitfalls of converting to InnoDB
March 8, 2007 By 16 Comments
…I’m using PHP 5.1.6, MySQL 5.0.24a default installs from … a basic insert into an InnoDB table. My database class starts a transaction …_progress = true; register_shutdown_function(array($this, “__shutdown_check“)); } public function __shutdown_check() { if ($this->transaction_in_progress) { $this->…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
… mysql -e “set foreign_key_checks=0; set sql_log_bin=0; set unique_checks=0; load data local infile ‘infile.txt’ into table…/my-fifo ]; do time mysql -e “set foreign_key_checks=0; set sql_log_bin=0; set unique_checks=0; load data local… disk activity and rows-per-second to see what the progress was. Here are some graphs. This one is the rows…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
…the webinar until it was 20 minutes in progress. Is it possible to get a recording …need scale-out or failover capability. For example tables used for logging less critical information. In this…tips: Check out upcoming Percona Training classes in North America and Europe. Join Percona and the MySQL …
Post: Onsite and Remote - getting best of both worlds
July 2, 2009 By 1 Comment
…and asking the question about the progress. The Single Day visits are … (writing queries), hands on setting up MySQL, Replication, Monitoring, High Availability with …) operations to complete – backup, restore, ALTER TABLE, load testing – all of these …be the benefit in onsite status-checks and team…
Comment: Add an option to Fail on Innodb Initialize failure, Please ?
October 18, 2007 By 9 Comments
… them but refusing queries to say Innodb tables with “Recovery In Progress” or staling them on table lock could be an option but… now you have either MySQL is down or it is up and fully operational which is easy to check. In your case I guess you need to check MySQL Error logs as well to see…
