|
replication-manager have a sybench wrapper test that drop table inside test and run following command , log is reversed; last command is head
2017-02-02 13:27:53 [Cluster01] BENCHMARK : sysbench 0.4.12: multi-threaded system evaluation benchmark
No DB drivers specified, using mysql
Running the test with following options:
Number of threads: 4
Doing OLTP test.
Running mixed OLTP test
Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases)
Using "BEGIN" for starting transactions
Using auto_inc on the id column
Threads started!
Time limit exceeded, exiting...
(last message repeated 3 times)
Done.
OLTP test statistics:
queries performed:
read: 33404
write: 11925
other: 4770
total: 50099
transactions: 2384 (39.72 per sec.)
deadlocks: 2 (0.03 per sec.)
read/write requests: 45329 (755.15 per sec.)
other operations: 4770 (79.47 per sec.)
Test execution summary:
total time: 60.0261s
total number of events: 2384
total time taken by event execution: 240.0176
per-request statistics:
min: 37.33ms
avg: 100.68ms
max: 204.63ms
approx. 95 percentile: 138.46ms
Threads fairness:
events (avg/stddev): 596.0000/1.58
execution time (avg/stddev): 60.0044/0.01
2017-02-02 13:26:53 [Cluster01] BENCHMARK : /usr/local/bin/sysbench -test=oltp --oltp-table-size=10000 --mysql-db=test --mysql-user=skysql --mysql-password=skyvodka --mysql-host=127.0.0.1 --mysql-port=3301 --max-time=60-oltp-test-mode=complex --max-requests=0 --num-threads=4 run
2017-02-02 13:26:53 [Cluster01] BENCHMARK : sysbench 0.4.12: multi-threaded system evaluation benchmark
No DB drivers specified, using mysql
Creating table 'sbtest'...
Creating 10000 records in table 'sbtest'...
2017-02-02 13:26:51 [Cluster01] BENCHMARK : /usr/local/bin/sysbench --test=oltp --oltp-table-size=10000 --mysql-db=test --mysql-user=skysql --mysql-password=skyvodka --mysql-host=127.0.0.1 --mysql-port=3301 --max-time=60 --oltp-test-mode=complex --max-requests=0 --num-threads=4 prepare
2017-02-02 13:26:51 [Cluster01] BENCHMARK : sysbench 0.4.12: multi-threaded system evaluation benchmark
sysbench 0.4.12
Master Conf is:
http://pastebin.com/eYb6LuL1
Slave Conf is
http://pastebin.com/7MLDMiG0
Replication stopped on
Column 2 of table 'test.sbtest' cannot be converted from type 'char(40)' to type 'char(120)'
extract of relay log
http://pastebin.com/dDwhTyeH
both DDL are the same on master and slave
CREATE TABLE `sbtest` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`k` int(10) unsigned NOT NULL DEFAULT '0',
`c` char(120) NOT NULL DEFAULT '',
`pad` char(60) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `k` (`k`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
|