June 20, 2013

Post: Introducing tpce-like workload for MySQL

… TPCE. Yasufumi made some efforts to make TPCE working with MySQL, and we are making it available for public consideration. You… you should agree with TPC-E License Agreement, which in human words is: You can’t name results as “TPC Benchmark Results” You… performance research and/or compare with available Storage Engines for MySQL. The workload in tpce is quite different from tpcc. Tpcc…

Comment: The performance effects of new patches

…, 1) We consider it is less stable comparing to standard MySQL, as it is less tested. We are going to recommend…. We are testing it on our production system, on TPC-C, TPC-E, TPC-H emulation workloads, on intensive sysbench benchmarks and we have…

Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5

…secondary key on col1 would be sorted by col1 i.e. in index order and then the lookup will be …purpose of this benchmark, I have used TPC-H Query #3 and ran it on TPC-H dataset (InnoDB tables) with …a look at the status counters. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer_size=6M & read…

Post: The performance effects of new patches

… (right graph shows CPU usage) The workload emulates TPC-C and has a same characteristic to DBT-2… (no thinking time, no keying time), it uses MySQL C API and the server side prepared statement. …_list order) If you use extremely fast device (e.g. ramfs), the bigger value may help the performance. …

Comment: MySQL 6.0 vs 5.1 in TPC-H queries

Hi Vadim, – Which scale factor are you using? – How MySQL 5.1/6.0 scales with TPC-H (e.g.: scale factors 1,3,5,10,30,100)? Thanks, Noah