… the amazing MySQL manual, especially the option and variable …Com_release_savepointblogpercona.commanual Com_rename_tableblogpercona.commanual Com_rename_userblogpercona.commanual Com_… skip_log_warningsblogpercona.commanual skip_name_resolveblogpercona.commanual skip_networkingblogpercona.commanual …
Post: Dangerous command
May 20, 2008 By 9 Comments
… old name to new one. I guess there are some related bugs – and there are: Bug#28360: RENAME DATABASE destroys routines Bug#17565: RENAME DATABASE… routines related to database. And solution of bug is: Removed the RENAME DATABASE db1 TO db2 statement. So it seems MySQL took an interesting…
Post: On Character Sets and Disappearing Tables
June 21, 2012 By 1 Comment
…database is still potentially inconsistent, and you can’t explicitly drop those temporary tables or rename them. This looks somewhat like closed bug 13378, but I think there’s something of an inconsistency present when MySQL…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… have happened in the database, instead of replaying binary …_expr(@mvid,’GROUP’,'customer_name‘,’customer_name‘); CALL flexviews.add… the old contents (using RENAME TABLE) which means that…<-- too high +------------------+ 1 row in set (0.68 sec) mysql> select sum(total_lines) from dashboard_customer…
Comment: Dangerous command
May 21, 2008 By 9 Comments
the problem that ‘RENAME DATABASE‘ ran into, of course, is that all of the things that live in a database are in rather… — in a directory named after the database, referenced from a .frm file in views, in various tables in the mysql database, etc. so implementing… to help with upgrades that involve re-encoding the database name on disk. that functionality lives on as ALTER DATABASE … UPGRADE DATA DIRECTORY NAME.
Post: Best kept MySQLDump Secret
March 23, 2012 By 13 Comments
…for their Innodb tables without making database read only. In most cases it…drop original table and rename such temporary table to original name. How does …| | B | | C | +——————–+ 3 rows in set (0.00 sec) mysql> select count(*) from A; +———-+ | count(*) | +———-+ | 2359296 | …
Post: Announcing Percona Server 5.5.24-26.0
June 1, 2012 By 9 Comments
…_STATISTICS tables in the INFORMATION_SCHEMA database. Bugs Fixed: A Server acting … introduced in MySQL 5.5.18 and Percona Server inherited it from MySQL. Bug … a temporary file first, and then rename it to the actual dump file…result, the server variable with that name had to be quoted with backticks…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…when doing commercial MySQL consulting and MySQL AB has even adopted it into the official database distribution starting … details). Then rename the binary, which can be safely done even with MySQL still running. This … AND log_slow_filter. log-slow-queries[=name] Log slow queries to this log file. …
Post: Percona Toolkit Webinar followup Q&A
December 19, 2012 By 1 Comment
… MySQL The slides are now available here, and slide 7 provides a basic introduction to Data Source Names,… obviously take more time! The tool processes the database one table at a time, and processes each… what about the transaction in the meanwhile? The rename table itself should be fast, but as it…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
….083490 | | restoring secondary keys | 17.824109 | | rename result table | 0.162041 | | end | 0.000008 ….65 sec) mysql> SHOW TABLE STATUS LIKE ‘t’\G *************************** 1. row *************************** Name: t Engine:…with –innodb-optimize-keys (the test database contained only the table I …
