dimanche 13 septembre 2015

MySQL Random Query Generator Output meaning

I have downloaded the MySQ Random Query Generator (RQG) that i am testing on my percona 5.6 server. However, i do not know what to make of my results when i run a test. Can somebody help me understand the meaning of my output, and maybe what results i should be expecting? I am new to RQG and i cannot find a good tutorial online that discusses how to interpret the output, or even what to expect when you run a test.

Test command for Percona server5.6:

perl gentest.pl --dsn=dbi:mysql:host=192.168.2.100:port=3306:user=root:password=skret:database=test --threads=1 --queries=100K --grammar=conf/percona_qa/5.6/5.6.yy --duration 3600

Output

# 2015-09-14T10:16:55 -------------------------------
# 2015-09-14T10:16:55 Configuration
# 2015-09-14T10:16:55   debug_server => ['']
# 2015-09-14T10:16:55   dsn => ['dbi:mysql:host=192.168.2.100:port=3306:user=root:password=skret:database=test']
# 2015-09-14T10:16:55   duration => 3600
# 2015-09-14T10:16:55   generator => FromGrammar
# 2015-09-14T10:16:55   grammar => conf/percona_qa/5.6/5.6.yy
# 2015-09-14T10:16:55   queries => 100000
# 2015-09-14T10:16:55   reporters => ['']
# 2015-09-14T10:16:55   seed => 1
# 2015-09-14T10:16:55   threads => 1
# 2015-09-14T10:16:55   transformers => ['']
# 2015-09-14T10:16:55   validators => ['']
# 2015-09-14T10:16:55   views => ['', '']
# 2015-09-14T10:16:55 Reporters: ErrorLog, Backtrace

Aucun commentaire:

Enregistrer un commentaire