… tables” $DBNAME); do echo “Converting table $t” mysql -u$DBUSER -p$DBPWD -e “alter table $t type=InnoDB” $DBNAME; done There is the standard script mysql_convert_table_format in the MySQL distribution…
Post: On Character Sets and Disappearing Tables
June 21, 2012 By 1 Comment
…convert everything to ASCII. Or perhaps we have some other tables with ASCII identifiers and we’re doing JOINs against tables… of InnoDB file formats. Moreover, trying to modify any of the remaining tables could cause the…’s something of an inconsistency present when MySQL won’t allow us to change an…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… should not be the problem. Innodb internal format is rather low level and it …MySQL Replication to work. You might need to inject MySQL 5.0 in between so it will convert…tables are on track to be depreciated in future MySQL versions also MyISAM tables are essentially at the state they were in MySQL…
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
…MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you … already looked at using LIKE statement. As default table format for slow_log is CSV with no indexes …. More than that. I found even if I convert table to MyISAM, disable concurrent inserts and run long …
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
…mk-query-digest to convert this into a query log, and examine the log. In MySQL 5.1 and…. There are some INFORMATION_SCHEMA tables that make this simple. Just query the tables, and if something is … sequence of queries in an easy-to-view format, rather than aggregating the worst queries together. This…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…convert SQL to the Flexviews API (see convert.php below) Refresh methods The incremental refresh method The incremental refresh method uses table…table dashboard_customer_sales AS select customer_id, customer_name, DATE_FORMAT…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
…table row format from the Information Schema: mysql (information_schema) > SELECT ROW_FORMAT from TABLES WHERE TABLE_SCHEMA=’employees’ AND TABLE_NAME=’salaries’; +————+ | ROW_FORMAT | …table_defs.h so it will be necessary to recompile the tool. To help us in the task of converting…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… | 11893 | … snip … Then I format…tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max_heap_table_size | 268435456 | | tmp_table…table will be converted to an on-disk table…
Post: A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 8 Comments
…mysql -u root test The MyISAM table recording the space ids of the tables mysql> show create table test.tablesG *************************** 1. row *************************** Table: tables Create Table: CREATE TABLE `tables… was able to download the tables in MyISAM format and then he just convert…
Post: When is MIN(DATE) != MIN(DATE) ?
September 4, 2012 By 5 Comments
…MySQL puzzle. He was running Percona Server 5.5.21 with a table structure that looks something like this: CREATE TABLE…of zero, whereas doing a CAST() or a CONVERT() on the update_time field first (so that…of all: Always, always range-check your input! Format-checking is not enough. One final aside – …
