…MySQL 5.5, you will succeed without errors or warnings: mysql> ALTER TABLE test ADD INDEX…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…, 2013. A drop in replacement for MySQL, downloads are available here and from the Percona Software Repositories. Based on MySQL 5.1.69, this… for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER_STATISTICS) led to…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using … after the hot test. All OS caches are dropped at this time as well. These set of … the filesystem level. The InnoDB indexes were built using ALTER TABLE fast index creation (merge sort). For the …
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…, and which are candidates for dropping (why keep old data if …5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/schemaspy driverPath=/usr/share/java/mysql… based on names, tables without indexes, columns flagged ‘nullable’ and ‘must be unique…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…MySQL version 5.5.30-30.2[/caption] Percona is glad to announce the release of Percona Server for MySQL 5.5…Feature has been removed because the upstream DROP TABLE implementation has been improved. (Laurynas Biveinis)… constraint which implied an implicit secondary index with the same name. Fixed by …
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 …Hrvoje Matijakovic). Release notes for Percona Server for MySQL 5.5.30-30.2 are available in our …
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…-bound scenario. Percona Server 5.5 outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 demonstrate notable drops in performance. What can…pool_instances=16 # MySQL 5.5 and 5.6 loose-innodb_io_capacity_max = 15000 #Percona only innodb_adaptive_hash_index_partitions=8 innodb_buffer…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…XtraBackup when rebuilding secondary indexes on innobackupex –apply-log –rebuild-indexes. This allows …MySQL package for server communication instead of spawning the MySQL command line client. Support for InnoDB 5.0 and InnoDB 5… would assume the table has been dropped if the tablespace was renamed …
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…Index id in our example is 1679: mysql> SELECT * FROM SYS_FIELDS WHERE INDEX_ID = 1679; +———-+—–+———-+ | INDEX… BY ‘SYS_FIELDS\t’ (`INDEX_ID`, `POS`, `COL_NAME`); 5. Now …
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$…. With TokuDB we also see a drop, and by end of 5 hours the average throughput is 7800 tps…Percona-Server-5.5.30-rel30.2-500.Linux.x86_64/lib/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql #…
