Mysql – any documentation on tpcc-thesql benchmark tool

You should enable slow-query-log and log-queries-not-using-indexes to in order to manifest what queries are skipping on the indexes.

This is just a personal preference, but I usually the --processlist option of mk-query-digest. I wrote a automation script for it long ago : MySQL general query log performance effects based on Percona's video about mk-query-digest being a replacement for the slow log.

Once the queries are made known, you will have run EXPLAIN on all selects. Any query whose EXPLAIN plan fails to choose an index is guilty of doing the table scans.

I seem to have found an answer... at least it works.

After a few hours of trial and error, i saw that the problem seemed to be my transactions in my slow log. I could not find any documentation to support this, so i am still not sure if i might just be using the tool wrong.

I commented all:

• XA START
• XA END
• XA COMMMIT
• XA PREPARE
• BEGIN;
• COMMIT;

Lines from my log, and it worked without a single lock.