…. If there are thousands of tables and slow IO then XtraBackup can spend a lot of time…. Due to different implementation in MySQL 5.6 error messages were not printed to stderr directly. Because of…xtrabackup_56. Bug fixed #1169971. innobackupex would still run with FLUSH TABLES WITH READ LOCK even if…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…system is being crushed by IO wait. FlashCache and vCache both show improvements, but it’s not until we get to vCache…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…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… level 14000 tps and below. I do not have enough space on this SSD to run this experiment that long. So there… line to run: sysbench –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb… options innodb_read_io_threads = 16 innodb_write_io_threads = 4 innodb_io_capacity = 4000 innodb_use_native_aio=0 #not innodb options (fixed…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… to conduct some benchmarks for the use case where the MySQL working set is significantly larger than the InnoDB buffer pool… of PIDs or simply running in a “cache everything” mode. Both of them have support for not caching sequential IO, adjusting the dirty… be retrieved by running the vgc-vcache-monitor command. Personally, I prefer “cat /proc/something” but I’m not sure that’s…
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
… was used in my previous benchmark run. A small handful of additional tests …. When we switch over to synchronous IO, we find that the card is …3ms. How well does it perform with MySQL? Exact results vary, depending upon the usual… final analysis, there may or may not be faster cards out there, but …
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
… size and OS cache which is available. I run CHECK TABLE on this table which essentially performs …_Ahead which is not available in MySQL 5.5 (different version is added back in MySQL 5.6) so …potential in MySQL IO as I think we should be getting very close numbers for buffered and unbuffered IO for …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings. Moreover, I have been running these benchmarks… with the following my.cnf configuration: [mysqld] datadir=/data/mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table = true innodb…
Post: Is your MySQL Application having Busy IO by Oracle Measures ?
January 8, 2012 By 1 Comment
… James calls “Busy” Oracle database application when it comes to IO consumption: It is applications either using Over 10.000… are not that high – many what would be considered medium scale MySQL installations would get there. With MySQL we seems to prefer to run… archive this but it is not the same thing. How many of us are running 5TB per MySQL instance ? 20TB ? Over 50TB ? I…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… surprise MySQL 5.6.10 did not get much faster during the repeat runs, compared to the initial cold run. I stopped the MySQL 5… buffer pool hit ratio during the MySQL 5.6 runs and MySQL 5.6.10 was doing more IO as a consequence. To confirm… * READ_AHEAD_EVICTED_RATE: 0 LRU_IO_TOTAL: 531 * LRU_IO_TOTAL: 431 LRU_IO_CURRENT: 0 * LRU_IO_CURRENT: 0 UNCOMPRESS_TOTAL: 0…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… use this data to estimate capacity of MySQL system ? We can look at CPU and IO consumption per Query and compare it…’re running Innodb with MySQL we can use Innodb_data_reads , Innodb_data_writes, Innodb_os_log_fsyncs for your disk IO estimation… a good clue how many queries needed no io, needed 1 IO which was not queued (less than 10 ms) or needed more…
