… snapshot to reflect the changes that have happened in the database, instead of replaying binary logs directly. Selecting a refresh method… the SELECT part of the query. convert.php This script takes as one argument the default database. Notice in the following example… view with the old contents (using RENAME TABLE) which means that the view remains available for querying, even during refresh. A complete…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
Post: On Character Sets and Disappearing Tables
June 21, 2012 By 1 Comment
…? Not exactly…. (root@localhost) [oops4]> set foreign_key_checks=0; Query OK, 0 rows affected (0.00 sec) (root@localhost) [oops4... them as well. (root@localhost) [oops4]> drop database oops4; ERROR 1010 (HY000): Error dropping database (can’t rmdir ‘./oops4′, errno: 39) (root…-14`; But your database is still potentially inconsistent, and you can’t explicitly drop those temporary tables or rename them. This looks…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
….commanual Com_rename_tableblogpercona.commanual Com_rename_userblogpercona….query_cache_limitblogpercona.commanual query_cache_min_res_unitblogpercona.commanual query_cache_sizeblogpercona.commanual query_cache_typeblogpercona.commanual query_cache_wlock_invalidateblogpercona.commanual query…
Post: Percona Toolkit 2.1.8 released today with beta support for MySQL 5.6
January 9, 2013 By Leave a Comment
…-query-digest fails to parse timestamp with no query. Slow logs which include timestamps but no query–which can happen if using slow_query… reported as the database; pt-query-digest now handles this correctly. Fixed bug 1015590: pt-mysql-summary doesn’t handle renamed variables in…-check-only. When using –replicate-check-only, filter options like –databases and –tables were not applied. Fixed bug 886059: pt-heartbeat…
Post: Percona Toolkit Webinar followup Q&A
December 19, 2012 By 1 Comment
… to the master. Q: How about pt-table-checksum with databases greater than 1TB? It will work just fine, though it… database one table at a time, and processes each table one chunk at a time, checksumming each chunk with a single query… time, and what about the transaction in the meanwhile? The rename table itself should be fast, but as it needs to…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… to allow more precise logging of query execution times into the slow log. Originally MySQL database offered a second time resolution and… changes to the database configuration, specifically you need to enable slow logging (see Configuration section for details). Then rename the binary, which…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… | 61.816063 | | rename result table | 0.161528 | | end | 0.000007 | | Waiting for query cache lock | 0.000002 | | end | 0.000007 | | query end | 0… | 17.824109 | | rename result table | 0.162041 | | end | 0.000008 | | Waiting for query cache lock | 0.000002 | | end | 0.000007 | | query end | 0… with a dump created with –innodb-optimize-keys (the test database contained only the table I used in my previous examples…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
…Innodb recovery should be automatic and bring your database to consistent state. Depending on innodb_… such potentially multiple operation DDL statements as RENAME TABLE – these are most vulnerable. master.info …done by issuing large index scan queries. Full table scan queries allow to preload table …
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
…, check them by myisamchk prioritizing more important databases first an then rename them back to MySQL database directory. This way accesses to non… storage engine. This hidden corruption may later cause crashes wrong query results and further data corruption. Partial updates. MyISAM is does…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… typically print something like this: InnoDB: Database page corruption on disk or a failed…(HY000): Lost connection to MySQL server during query mysql> check table test; +———–+——-+———-+———-+ | Table | Op | Msg…_force_recovery option. You can also rename the old table in case you…
