…, only visible in debug builds. Bug fixed #905334 (Laurynas Biveinis). Querying I_S.GLOBAL_…MySQL bug #66301. Concurrent INSERT … ON DUPLICATE KEY UPDATE statements on a table with an AUTO_INCREMENT column could result in…to a temporary file first, and then renames it to the actual dump file. Bug …
Post: Percona Server and XtraBackup weekly news, March 12th
March 13, 2011 By Leave a Comment
…and progress report. What’s new this week in Percona Server: As you might have seen, we… columns for rows examined, sent, and read. This can be useful for understanding how much progress a query… command-line options and configuration variables will be renamed. We did not always choose good names for…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
…id” and “counter” columns. Using separate table for updates already solves the problem in a lot of…in this case – the script which processes the views within last hour has to run rather complicated group by query…one and process and truncate another. MySQL offers atomic RENAME TABLE call which can be …
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…mysql> SET profiling=1; Query OK, 0 rows affected (0.00 sec) mysql> ALTER TABLE t ADD COLUMN v VARCHAR(1); Query…rename result table | 0.161528 | | end | 0.000007 | | Waiting for query cache lock | 0.000002 | | end | 0.000007 | | query…the data is loaded.” mysqldump in Percona Server supports the new …
