… GB of instance storage 64-bit platform I… to the MySQL configuration. MySQL Configuration I used…table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type…ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (transactionid) (PARTITION p0 VALUES LESS THAN (100000000) ENGINE…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… size mrr_buffer_size. Both buffer sizes default to 256K in MySQL 5.6 and MariaDB 5.5 … are performed in a single call to the storage engine and the counters Handler_read_key and Innodb_… query execution plans. a. Bad Plan id select_type table type possible_keys key key_len ref rows filtered…
Post: Recovering CREATE TABLE statement from .frm file
December 17, 2008 By 4 Comments
…MySQL to report some more reasonable error message, something like Storage Engine could not open table…
Post: Performance gotcha of MySQL memory tables
February 1, 2008 By 5 Comments
… with MEMORY tables you might know about comes from the fact it is the only MySQL storage engine which defaults to HASH index type by default, instead… test table: CREATE TABLE `test` ( `id` int(11) NOT NULL auto_increment, `c` tinyint(4) default NULL, PRIMARY KEY (`id`), KEY `c` (`c`) ) ENGINE…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…ships by default with many server installations) or a system administration mistake to delete one of MySQL‘…as the storage engine. For example, a pile-up of connections all trying to open or close tables …we will include more plugins to monitor more types of problems, but the current plugins already …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the option and variable reference table…default_storage_engineblogpercona.commanual default_time_zoneblogpercona.commanual default_week_formatblogpercona.commanual defaults_extra_fileblogpercona.commanual defaults_fileblogpercona.commanual defaults…
Post: InnoDB in self-compiled MySQL 5.1
September 13, 2007 By 9 Comments
…tables | NO | NO | NO | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO | | MyISAM | DEFAULT | Default engine as of MySQL…default InnoDB is not compiled as storage engines. Perhaps it is related to new pluginable architecture and all engines…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…default method is used: mysql> SET profiling=1; Query OK, 0 rows affected (0.00 sec) mysql> ALTER TABLE…storage…TABLE STATUS versus 265 MB index size with the optimization disabled. OPTIMIZE TABLE OPTIMIZE TABLE is mapped to ALTER TABLE … ENGINE=InnoDB for InnoDB tables…
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
…tables): mysql> optimize table test; +———–+———-+———-+———————————-+ | Table | Op | Msg_type | Msg_text | +———–+———-+———-+———————————-+ | test.test | optimize | error | Got error -1 from storage engine…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… baseline. Do not change storage engine at the same time eather… consisting of several query types. Though it is rather …tables involved and check cardinality) Different stats can often cause different plans. Run ANALYZE TABLE on both MySQL… options (might be even defaults) or some more subtle …
