…file (correct table contents and binary log coordinates), no other connection should use the following statements: ALTER TABLE, CREATE TABLE, DROP TABLE, RENAME TABLE, TRUNCATE TABLE. A…them on a table to be dumped can cause the SELECT that is performed by mysqldump to retrieve the table contents to …
Post: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
… that have privileges to modify a table (any non-temporary table) can inject arbitrary SQL into… not purged after transaction commit. Fixed by truncating the temporary file, if used for a… with AUTO_INCREMENT columns where correctly detected, mysqldump prevented all such keys from optimization, even…
Post: Announcing Percona Server 5.5.28-29.3
January 8, 2013 By 2 Comments
… that have privileges to modify a table (any non-temporary table) can inject arbitrary SQL into… not purged after transaction commit. Fixed by truncating the temporary file, if used for a… with AUTO_INCREMENT columns where correctly detected, mysqldump prevented all such keys from optimization, even…
Comment: Resyncing table on MySQL Slave
June 30, 2008 By 11 Comments
James, Indeed TRUNCATE does not work with LOCKED table. Suhaib, Reloading the table is pretty much only way with logical level replication. You can also use mysqldump to reload the table. What I described here just gives you a bit more control about data visibility.
