…to convert everything to ASCII. Or perhaps we have some other tables with ASCII identifiers and we’re doing JOINs against tables…InnoDB file formats. Moreover, trying to modify any of the remaining tables could cause the same thing to happen to…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
… which support large pages in general. Currently MyISAM and Innodb. Some SQL level items as Query Cache also could use this feature… be converted to on disk MyISAM table. It does not limit size of temporary table, neither it applies to tables created as TEMPORARY TABLE, even in memory tables.
Post: A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 8 Comments
…modified schema, the recovery completed. The customer was able to download the tables in MyISAM format and then he just convert them back to InnoDB.
Post: InnoDB in self-compiled MySQL 5.1
September 13, 2007 By 9 Comments
… of InnoDB from previous version: mysql testdatabase < dump.sql I bet you will not notice all your tables now is MyISAM. Why? Welcome to…=/dir/to/mysql –with-plugins=innodb make make install But what I would want to see is BIG Warning or even Error that InnoDB table can’t be created instead of calm converting to MyISAM
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… a script to convert SQL to the Flexviews API (see convert.php below) Refresh methods The incremental refresh method The incremental refresh method uses table changelogs… not useful, simply ignore this column. It is used to prevent wide innodb primary keys on the MV. mysql> select mview$pk…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
… but cannot really convert the gained knowledge to solve our …_create_index’, ’0′ ‘Com_create_table‘, ’31′ ‘Com_dealloc_sql‘, ’0′ ‘Com_delete’, ’348788…innodb_table_locks=0 innodb_buffer_pool_size=1800M # USE ALL MEMORY AVAILABLE #innodb_log_buffer_size=8M # Lowered from 32M according to MySQL innodb…
Post: Unexpected problem with triggers and mysqldump
February 11, 2013 By 8 Comments
… ago, I had to convert all tables of a database from MyISAM to InnoDB on a new server. The plan was to take a logical dump… and the data, then edit the CREATE TABLE statements to ensure all tables are created with InnoDB, and reload everything on the new server… $ mysqldump –no-data sakila > schema.sql # Export data $ mysqldump –no-create-info sakila > data.sql Just to check that everything is fine, let…
Post: Innodb row size limitation
April 7, 2011 By 12 Comments
…table structure: CREATE TABLE…converting from a native language character set to…Innodb‘s internal limitations), though you still need to change the way your application uses this data. You can limit the changes to…
Comment: How much memory Innodb Dictionary can take ?
May 19, 2010 By 3 Comments
… not convert MySQL system tables in the mysql database from MyISAM to InnoDB tables! This is an unsupported operation.” In my db when I run sql get below error: mysql> SELECT count(*) FROM INNODB_SYS_TABLES…
Post: MySQL Prepared Statements
August 2, 2006 By 21 Comments
…to be parsed fully each time, all return values had to be converted to…to use prepared statements: Save on query parsing Save on data conversion and copying Avoid SQL… them for table name. In…to IN Harder tracing. Logs were now fixed to include full statement text not only “Execute” but in SHOW INNODB…
