June 19, 2013

Post: MySQL and Percona Server in LinkBench benchmark

May 8, 2013 By 18 Comments

… symptom is related to BUG#67808. For MySQL 5.6.11 top mutexes is &buf_pool->mutex,&new_index->lock. I profiled…=0 loose-metadata_locks_hash_instances=256 innodb_buffer_pool_instances=16 # MySQL 5.5 and 5.6 loose-innodb_io_capacity…=root -D port=3306 -D password= -D maxid1=100000001 -c config/MyConfig.properties -csvstats final-stats.csv -csvstream streaming-stats.csv…

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

Post: More on MySQL transaction descriptors optimization

April 26, 2013 By Leave a Comment

…several our boxes. You can find setup/config details at the very end of this post…DIRECT innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = … –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-…

Filed Under: Benchmarks, MySQL Tagged With: ,

Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer

March 29, 2013 By 10 Comments

… how one would start the memcached plugin: mysql> install plugin daemon_memcached soname ‘libmemcached.so…the rough code for this benchmark: // Identical config/code for memcached vs InnoDB $frontendOpts = array( ‘caching’ =>…entire data set fits into the buffer pool, so there are no reads from disk. …

Filed Under: MySQL Tagged With: , , , ,

Post: Virident vCache vs. FlashCache: Part 2

May 17, 2013 By 3 Comments

… C (shown in the graph as the blue line – SSD config) which shows the most consistent performance. The others all have…­-time=7200 ­­–max­-requests=0 ­­–percentile=95 ­­\ –mysql­-user=root –mysql­-socket=/tmp/mysql.sock ­­–mysql­-table­-engine=innodb ­­\ –oltp­-read­-only=off run The base MySQL configuration (configuration A) appears below: #####fixed innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb…

Filed Under: Benchmarks, Hardware and Storage, MySQL Tagged With: , , , , , , ,

Post: How to check MySQL Config files

February 12, 2008 By 7 Comments

Probably most of MySQL users sometime had a situation when they would do changes in MySQL config file without restarting server (may be…. Unlike Apache MySQL service control script does not have “configtest” option so there is no straight way to check MySQL config file for… check, ie it is possible to allocate 80GB to buffer pool instead of 8G you intended but at least it checks…

Filed Under: Insight for DBAs Tagged With:

Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5

March 21, 2012 By 10 Comments

…. Also note that the following changes were made in the MySQL config: optimizer_switch=’index_condition_pushdown=off’ optimizer_switch=’mrr=on… that the relevant pages were already loaded in the buffer pool. Note that as mentioned at the start of the benchmark… counters above that both MySQL 5.6 and MariaDB 5.5 are reporting high numbers for Innodb_buffer_pool_read_ahead which…

Filed Under: Benchmarks, Insight for DBAs, MySQL Tagged With: , , , , , , , , , , , , , ,

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

March 11, 2013 By 7 Comments

… tested three configurations: Config 1: Default config for MySQL 5.5 and MySQL 5.6, no tuning at all Config 2: MySQL 5.6 with all default settings except innodb_old_blocks_time=0 Config 3: MySQL 5.5 and 5.6 with a 4G buffer pool instead of the default 128M…

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

Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5

April 4, 2012 By 4 Comments

… be reading the same page multiple times into the buffer pool. So considering this drawback, Batched Key Access (BKA) optimization was…. Also note that the following changes were made on MySQL 5.6 config: optimizer_switch=’index_condition_pushdown=off’ optimizer_switch=’mrr… that the following changes were made on MariaDB 5.5 config: optimizer_switch=’index_condition_pushdown=off’ optimizer_switch=’mrr=on…

Filed Under: Benchmarks, Insight for DBAs, MySQL Tagged With: , , , , , , , , , , , , , ,

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

February 26, 2013 By 1 Comment

… important number here is to note that the InnoDB buffer pool for my 5.6 instance is 128MB – smaller than the….ibd -rw-rw—-. 1 mysql mysql 98304 Feb 20 16:09 FTS_00000000000000ad_CONFIG.ibd -rw-rw—-. 1 mysql mysql 98304 Feb 20 16:09….ibd -rw-rw—-. 1 mysql mysql 98304 Feb 20 15:55 FTS_0000000000000114_CONFIG.ibd -rw-rw—-. 1 mysql mysql 98304 Feb 20 15:54…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: MySQL 5.5.8 and Percona Server: being adaptive

December 20, 2010 By 25 Comments

… and MySQL is about 2500-2800 NOTPM (~15% difference). MySQL 5.5.8 now has features related to having several buffer pool instancesÂ… is the config file used for benchmarks on FusionIO: [client] socket=/var/lib/mysql/mysql.sock [mysqld] core basedir=/usr/local/mysql user=root socket=/var/lib/mysql/mysql.sock skip-grant-tables server_id=1 local_infile=1 datadir=/mnt/fio320 innodb_buffer_pool…

Filed Under: Benchmarks, MySQL Tagged With: , ,
« Older Posts