…DROP INDEX `redundant`, ADD INDEX `redundant` (`col2`); # ######################################################################## # Summary of indexes # ######################################################################## # Size Duplicate Indexes 9 # Total Duplicate Indexes 1 # Total Indexes…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…-14.7 on June 10, 2013. A drop in replacement for MySQL, downloads are available … variable innodb_flush_method was set to ALL_O_DIRECT. Bug fixed #1131949. Fixed the… Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER_STATISTICS…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… database software is restarted after the hot test. All OS caches are dropped at this time as well. These set of queries… already. The buffer pool and adaptive hash index are cold for the cold test. All tests were done with no concurrency. The… data at the filesystem level. The InnoDB indexes were built using ALTER TABLE fast index creation (merge sort). For the MyISAM tests…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…referenced the most, and which are candidates for dropping (why keep old data if you don’…between columns/tables based on names, tables without indexes, columns flagged ‘nullable’ and ‘must be unique’ (woops…or items requiring review. Columns – a listing of all columns in the schema, really handy to …
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… .frm files is not an option: Table was dropped and innodb_file_per_table is ON Frm … 738 | +————–+—–+——–+——+——–+———+————–+——-+ SYS_INDEXES This table lists all indexes the table has, secondary as well as the primary. CREATE TABLE `SYS_INDEXES` ( `TABLE_ID…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 9, 2013 By 32 Comments
… some tests with concurrent load but did not see performance drops. It is reasonable that N threads doing concurrent load will… 1 for some N. Eventually you change from having all index blocks for all tables in memory to not and then disk read…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… Feature has been removed because the upstream DROP TABLE implementation has been improved. (Laurynas Biveinis)…key constraint which implied an implicit secondary index with the same name. Fixed by …–innodb-optimize-keys and –no-data options, all secondary key definitions would be lost. Bug …
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…(60) DEFAULT ” NOT NULL, PRIMARY KEY (id) ) CREATE INDEX k on sbtest$I(k) and tables sbtest…interval, as TokuDB does time-based checkpoints. These drops are quite concerning, and it might be a…root skip-grant-tables TokuDB-related options are all defaults, as I understand from documentation TokuDB …
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… Feature has been removed because the upstream DROP TABLE implementation has been improved. (Laurynas Biveinis)…key constraint which implied an implicit secondary index with the same name. Fixed by …–innodb-optimize-keys and –no-data options, all secondary key definitions would be lost. Bug …
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… would attempt the DELETE in all partitions. * A ‘range’ delete would mostly follow above two points. * Secondary indexes are also BTrees, so… when partitioned, hence slightly faster. Conclusion: Not much difference. Yes, DROPping an ‘old’ partition is very efficient, much more efficient than…
