… other tables with ASCII identifiers and we’re doing JOINs against tables in this database and seeing that indexes aren’t being used in the…-3c13-14`; But your 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: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… amazing MySQL manual, especially the option and variable reference table. But …release_savepointblogpercona.commanual Com_rename_tableblogpercona.commanual Com_rename_userblogpercona.commanual Com…lock_wait_timeoutblogpercona.commanual locked_in_memoryblogpercona.commanual logblogpercona.commanual …
Post: Percona Toolkit 2.1.8 released today with beta support for MySQL 5.6
January 9, 2013 By Leave a Comment
…as the database; pt-query-digest now handles this correctly. Fixed bug 1015590: pt-mysql-summary doesn’t handle renamed variables in Percona … pt-table-checksum doesn’t ignore tables for –replicate-check-only. When using –replicate-check-only, filter options like –databases and –tables were …
Comment: Dangerous command
May 20, 2008 By 9 Comments
… need to release software on schedule. After being burned with MySQL 5.0 quality there was a swing to making solid… it is a shame MySQL does not have this feature even in 5.1 – it is extremely handy – rename current database and load new… have, if you just store tables in MySQL database you can simply use little script to create new database rename all tables and drop the old one…
Post: Logging Foreign Key errors
September 27, 2012 By Leave a Comment
…MySQL on host 127.0.0.1 and storing all the errors on the host 10.0.05, database test and table… The index in the foreign key in table is “PRIMARY” See http://dev.mysql.com/doc/refman/5.5/en/innodb-foreign-key-constraints.html for correct foreign key definition. InnoDB: Renaming table…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
…prioritizing more important databases first an then rename them back to MySQL database directory. This way accesses to non-checked tables fail with table does …). You can use multiple of cache tables to avoid concurrency issues. Temporary tables used in batch processing and other means Exported …
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… reflect the changes that have happened in the database, instead of replaying binary logs directly…tables used by the above view, as stored in the data dictionary: mysql> select * from flexviews.mview_table…the view with the old contents (using RENAME TABLE) which means that the view remains available…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… which moves out all MyISAM tables out of MySQL database directory, checks them with MyISAMchk … option in MySQL 4.1 so your Innodb log and binary log are synchronized. In MySQL …such potentially multiple operation DDL statements as RENAME TABLE – these are most vulnerable. master.info corruption …
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
…+ another mysql instance (or simply the database which is not replicated) to log updates in heap/myisam/archive table and aggregate it in the database …is standard “shadow table” trick – use two tables insert into one and process and truncate another. MySQL offers atomic RENAME TABLE call which can …
Post: Best kept MySQLDump Secret
March 23, 2012 By 13 Comments
…mysql> show tables; +——————–+ | Tables_in_dumptest | +——————–+ | A | | B | | C | +——————–+ 3 rows in set (0.00 sec) mysql> select count(*) from A; +———-+ | count(*) | +———-+ | 2359296 | +———-+ 1 row in…
