… 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 7 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 12 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 18 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: Innodb row size limitation
April 7, 2011 By 11 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 19 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…
Comment: Fixing column encoding mess in MySQL
January 26, 2011 By 32 Comments
… munged that I don’t even know what to do with it. The table is InnoDB, utf8, the column is utf8, the original… utf-8, the tables were MyISAM – it came out of Sql Server into MySQL, and may have been converted to utf-8 during that… ISO-8859-1), though if I display it converted to utf-8, it’s back to upside-down exclamation marks and “section” glyphs…
Comment: A common problem when optimizing COUNT()
September 22, 2008 By 18 Comments
…table test( pk char(100) not null, col1 tinyint not null, primary key(pk), key(col1) ) engine = innodb… table, then using EXPLAIN with COUNT(*), COUNT(pk) and COUNT(col1). You might be surprised. Convert to… question still remains, what does the SQL mean? To return to your statement “just as good as …
