…database one table at a time, and processes each table one chunk at a time, checksumming each chunk with a single query…query-digest. For example, with the sandbox server I used for the examples, it would be pt-query-digest –review S=/tmp/mysql… in the meanwhile? The rename table itself should 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…innodb-optimize-keys (the test database contained only the table …
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
… databases out of MySQL directory to other location, check them by myisamchk prioritizing more important databases first an then rename them back to MySQL database… engine. This hidden corruption may later cause crashes wrong query results and further data corruption. Partial updates. MyISAM is …
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…0′ ‘Com_purge_before_date’, ’0′ ‘Com_rename_table’, ’0′ ‘Com_repair’, ’0′ ‘…show_create_table’, ’2661′ ‘Com_show_databases‘, ’93′ ‘Com_show_errors’, ’0′ ‘…mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow-queries…
Comment: Derived Tables and Views Performance
December 14, 2007 By 16 Comments
… this query syntax was for programming brevity – it’s easier to rename the output columns from the big inner query using the outer query instead. Alas, though, the nasty version of this query took… the sub-query‘s grouping clauses. MySQL needs quite a bit of real-world tuning to make it a believable enterprise database. You…
