Hy, I’m new to TPC-C benchmarking and i would like to know how and what are the steps for testing MySQL with TPC-C benchmark. My goal is to compare VoltDB and MySQL under TPC-C benchmark. Thanks
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…: analyzing MySQL query logs. So the ability to parse memcached, Postgres, Apache, and other logs was removed. We also removed several…-summary have built-in MySQL options No more “pt-stalk — -h db1 -u me”. pt-stalk 2.2 and pt-mysql… now the command line is what you expect: pt-stalk -h dhb1 -u me. pt-stalk –no-stalk is no longer…
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 10, 2013 By 13 Comments
… MySQL. Later I may want to move to something else, Postgres perhaps, MSSQL, Oracle, whatever. I may not be able to…
Comment: 10 years of MySQL User Conferences
April 13, 2013 By 6 Comments
… that “got you!” smirky look. Anyone sitting nearby can hear “h*ly sh*t!” coming from my direction. I was ambushed…
Comment: Innodb Table Locks
April 8, 2013 By 4 Comments
It’s slightly off topic, but can you elaborate on how to see existing table locks, similar to Postgres‘ “pg_locks” command? We have an issue of locking tables, but cannot find which process is causing the lock…tnx
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… of defines #define DATA_N_SYS_COLS 3 /* data0type.h */ /* from rem0types.h */ #define REC_MAX_N_FIELDS (1024 – 1) #define REC…
Post: MySQL Optimizer team comments on TPC-H Results
April 14, 2008 By 1 Comment
… optimizer team and Timur – both of them expressed concern with TPC-H run results I posted and notes about little gains in… most of TPC-H Queries. I personally (before doing what exactly queries are part of TPC-H) was expecting to see gains in TPC-H and… ? Why TPC-H queries are not targeted ? The reason is MySQL Optimizer Team did not have the goal of optimizing TPC-H queries or…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… results which are very interesting. This is obviously not audited TPC-H run, and it can’t be because we used MyISAM… others this means we can’t really get a valid TPC-H result from MySQL,though at least we get to see… TPC-H Queries post As a Summary: We can see MySQL capabilities to run complex analytics queries, in particular those presented in TPC-H…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
Last week I played with queries from TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5…. new changes in optimizer, which should affect execution plan of TPC-H queries. In reality only two queries (from 22) have significantly…
Comment: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
May 21, 2012 By 10 Comments
mydbalife, DBT3 is a decision support system type workload benchmark that is based on TPC-H. You can get more information about TPC-H here: http://www.tpc.org/tpch/ Btw, what exactly are you looking for?
