INFORMATION_SCHEMA, in particular by favorite TABLES table is not only helpful to understand tables…mysql> select concat(“mysqldump “,table_schema,” “,table_name, ” >> “,table_schema,”.sql”) from tables where engine=’innodb’ into outfile ‘/tmp/dump.sh’; Query OK, 328 rows…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… you’re going to scan the whole table to query for information about yesterday. If you put…’t get fooled into calculating the wrong thing. Be Creative With Table Structures Suppose you have some yes… lot of rows — MySQL can’t handle too many of those at once. Aside from star schemas, another tactic…
Post: Recovering CREATE TABLE statement from .frm file
December 17, 2008 By 5 Comments
…schema changes in between. So how to recover CREATE TABLE from .frm file ? Recovering from .frm for Innodb Table…mysql test; Reading table information for completion of table…wrong…
Post: Knowing what pt-online-schema-change will do
November 1, 2012 By 1 Comment
…schema-change changes nothing but prints a lot of information…table, the number of rows, chunking-related options, etc., but in general you can see how pt-online-schema-change will copy the table…wrong. If something seems suboptimal, illogical, or just plain wrong… with the MySQL server (privileges, …
