… the most, and which are candidates for dropping (why keep old data if you don… if specific for MySQL, but note that SchemaSpy works for pretty much all the popular RDBMS out…without indexes, columns flagged ‘nullable’ and ‘must be unique’ (woops!), single column tables, incrementing column names in …
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…in MySQL 5.6 that can make our lives easier and have passed almost unnoticed by most (not all) DBAs. Duplicate Index…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 4 Comments
…drop in replacement for MySQL, downloads are available here and from the Percona Software Repositories. Based on MySQL 5.1.69, this release will include all the bug fixes in it. All of Percona’s software is open-source and free, all… in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS,…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…the Star Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, … is restarted after the hot test. All OS caches are dropped at this time as well. These set … The buffer pool and adaptive hash index are cold for the cold test. All tests were done with no concurrency…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…). Based on MySQL 5.5.30, including all the bug fixes in it, Percona Server …in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop…key constraint which implied an implicit secondary index with the same name. Fixed by …
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
…dropped and innodb_file_per_table is ON Frm file corrupt, zeroed out, lost or SHOW CREATE TABLE crashes MySQL…INDEXES This table lists all indexes the table has, secondary as well as the primary. CREATE TABLE `SYS_INDEXES…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop…constraint which implied an implicit secondary index with the same name. Fixed by…-optimize-keys and –no-data options, all secondary key definitions would be lost. …
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… rebuilding secondary indexes on innobackupex –apply-log –rebuild-indexes. This …in order to add another layer of protection to the backups. innobackupex now uses Perl’s DBD::MySQL… assume the table has been dropped if the tablespace was …all the bugfixes for Percona XtraBackup 2.1.1 are available in…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…CHAR(60) DEFAULT ” NOT NULL, PRIMARY KEY (id) ) CREATE INDEX k on sbtest$I(k) and tables sbtest$…. Let’s zoom in to 10 min intervals and see throughput: We can see periodical drops, which I … socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-related options are all defaults, as I …
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… a single connection) anywhere in any ‘free’ variant of MySQL. PARTITIONs are scanned one…in all partitions. * A ‘range’ delete would mostly follow above two points. * Secondary indexes…DROPping an ‘old’ partition is very efficient, much more efficient than DELETEing the equivalent rows. This is, in…
