… new DROP Table in MySQL >= 5.5.23 work, I would like to mention quickly, that how drop table in MySQL < 5.5.23 used to work. When dropping the… completely warmed up with the dataset that sysbench will be using entirely in memory. Furthermore I filled up the bufferpool enough to make sure…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…sysbench trunk immediately, though I didn’t want to recompile sysbench on this system so I’ve used Domas’ uncache after prepare to…with respect to IO alignment yourself. In this case offset is correct, but file system is unaware how to…
Post: Dynamic row format for MEMORY tables
September 6, 2011 By 5 Comments
…MySQL 5.0. Although this patch did not add the BLOB and TEXT support, it refactored the code to make it easier to…how to request it explicitly and how to…with this patch–for the fixed-length records too. Default sysbench…
Post: MySQL performance: Impact of memory allocators (Part 2)
March 8, 2013 By 12 Comments
…to 32 vcpu. As test workload I will use the same 2 sysbench tests – OLTP_RO and POINT_SELECT that I used before. Sysbench…with decreasing performance in workloads with MySQL. # Test: POINT_SELECT:throughput, QPS # # Set 1 – 5.5.30pre-jemalloc-3.0.0 # Set 2 – 5.5…
Post: Comparing Percona XtraDB Cluster with Semi-Sync replication Cross-WAN
June 14, 2012 By 7 Comments
…wanted me to do a test comparing PXC against semi-synchronous replication to see how they…100ms. All environments used Percona Server or Percona XtraDB Cluster server 5.5.24. Innodb… work). Sysbench 32-client test For this test I used the latest sysbench with 20 tables (~…replication in stock MySQL…
Post: Impact of memory allocators on MySQL performance
July 5, 2012 By 11 Comments
… always efficiently with MySQL so i decided to include old one to comparison as well. I used glibc-2….5.5.24 2 read only scnearios: OLTP_RO and POINT_SELECT from the latest sysbench-0.5 dataset consists of 4 sysbench…test. So on charts below you will see how mysqld footprint is changed during the test…
Post: Virtualization and IO Modes = Extra Complexity
March 21, 2011 By 12 Comments
…to 1MB file using SysBench on Ubuntu, ext4 running on VirtualBox 4.0.4 running on Windows 7 on my desktop computer with… realistic with overhead. Now lest see how it looks using O_DIRECT pz@ubuntu:~/test$ sysbench –… max: 259.69ms approx. 95 percentile: 5.31ms Threads fairness: events (avg/stddev):…
Post: InnoDB compression woes
May 20, 2011 By 14 Comments
…To get some initial impression about performance I decided to run some sysbench with multi-tables benchmarks. I actually was preparing to…mysql…using compressed tables we have very strong contention in LRU_list_mutex. I should check how…
Post: Intel Nehalem vs AMD Opteron shootout in sysbench workload
April 25, 2011 By 41 Comments
…sysbench oltp ( both read-only and read-write) and MySQL 5…to 32 threads, with…MySQL 5.6. Anyway, we have PERFORMANCE_SCHEMA and in next run I will try to get more information what is most used…
Post: kernel_mutex problem. Or double throughput with single variable
December 2, 2011 By 17 Comments
…with kernel_mutex in MySQL 5.1 and MySQL 5.5 is known: Bug report. In fact in MySQL 5.6 there are some fixes that suppose to…. InnoDB uses kernel_…sysbench running only simple select PK queries against 48 tables, 5…how it does work internally, but I wanted to show one of possible ways to deal with…
