June 18, 2013

Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency

May 22, 2013 By Leave a Comment

… the hot test. All OS caches are dropped at this time as well. These set …at the filesystem level. The InnoDB indexes were built using ALTER TABLE fast index creation (merge sort). For …datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_…

Filed Under: Benchmarks, MySQL Tagged With: , , , , , , ,

Post: MySQL and Percona Server in LinkBench benchmark

May 8, 2013 By 18 Comments

…test we used a PowerEdge R720 box with a fast PCI-e flash card as storage. By default …5 outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 demonstrate notable drops in performance….to BUG#67808. For MySQL 5.6.11 top mutexes is &buf_pool->mutex,&new_index->lock. I profiled 5…

Filed Under: Benchmarks, MySQL, Percona Server Tagged With: , , , ,

Post: Benchmarking Percona Server TokuDB vs InnoDB

May 7, 2013 By 32 Comments

…DEFAULT ” NOT NULL, PRIMARY KEY (id) ) CREATE INDEX k on sbtest$I(k) … TokuDB does time-based checkpoints. These drops are quite concerning, and it …is low selectivity is not good for fast inserts, but it is suitable for…threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-…

Filed Under: Benchmarks, MySQL, Percona Server Tagged With: , , ,

Post: Ultimate MySQL variable and status reference list

January 8, 2011 By 4 Comments

…MySQL manual, …drop_eventblogpercona.commanual Com_drop_functionblogpercona.commanual Com_drop_indexblogpercona.commanual Com_drop_procedureblogpercona.commanual Com_drop_serverblogpercona.commanual Com_drop_tableblogpercona.commanual Com_drop…commanual innodb_fast_shutdownblogpercona.commanual…

Filed Under: Insight for DBAs, MySQL

Post: Improved InnoDB fast index creation

November 6, 2011 By 4 Comments

… secondary indexes were temporarily dropped and then recreated using fast index creation; dumps produced by mysqldump first create tables with all secondary indexes … picks such an index as the clustered one. References: Peter’s post MySQL bug #57583 MySQL bug #49120 Fast Index Creation page in …

Filed Under: Benchmarks, Insight for DBAs, MySQL

Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL

June 22, 2012 By 33 Comments

…shared reader-writer lock on the Adaptive Hash Index latch. The buffer pool mutex is a…life workload we will not be doing create/drop as fast as possible. Neither would I be…DROP TABLE implementation is MySQL 5.5.15, the version of MySQL used for benchmarking the new DROP TABLE implementation is MySQL…

Filed Under: Benchmarks, Insight for DBAs, MySQL

Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size

June 27, 2012 By 4 Comments

…looking at the ALTER TABLE performance with fast index creation and without it with different buffer … as following in terms of data and index size: mysql> show table status like “sbtest” \G *************************** 1….when you’re adding/dropping/changing columns as if you just add index it will be…

Filed Under: Insight for DBAs, MySQL

Post: MySQL Upgrade Webinar Questions Followup

June 28, 2012 By 7 Comments

…significant development since MySQL 4.1, so in-place upgrade of MySQL 5.0 to MySQL 5.5 should…would recommend using Percona Server with enabled expand_fast_index_creation feature, as I just wrote this option…Percona Server, so it should be good as drop in replacement with no data conversion needed. …

Filed Under: Insight for DBAs, MySQL

Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark

March 11, 2013 By 7 Comments

… than the data but underlying IO is fast (a warm FS cache reduces IO cost … the other secondary indexes have been pushed out of the buffer pool. mysql> select * from information_…LastDayInMonthFl tinyint, D_HolidayFl tinyint, D_WeekDayFl tinyint ); DROP TABLE IF EXISTS lineorder; CREATE TABLE IF …

Filed Under: MySQL Tagged With: , , , , ,

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

…’t to find out how to make InnoDB FTS blazingly-fast, but simply to get a sense of how it works… had a full-text index on it, and then I create one, the following warning is generated: mysql> alter table dir_test… mysql mysql 98304 Feb 20 18:57 FTS_0000000000000025_STOPWORDS.ibd Also, while we’re on the subject of adding and dropping FT indexes…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,
« Older Posts