Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
2.2.9
-
None
-
CentOS7
Description
We found that, In high pressure, load is not balance between workers; Our test shows this have big impact on performance.
Test1: long session
sysbench --test=$sysbenchpath/tests/db/oltp.lua --mysql-host=$ro --mysql-port=$port --mysql-user=xxxx --mysql-password=xxxx --mysql-table-engine=innodb --oltp-table-size=25000 --oltp-tables-count=250 --db-driver=mysql --max-requests=0 --oltp_simple_ranges=0 --oltp-distinct-ranges=0 --oltp-sum-ranges=0 --oltp-order-ranges=0 --max-time=$maxtime --oltp-read-only=on --num-threads=256 --mysql-db=xxx --report-interval=1 --oltp-skip-trx=on run |
|
test2: short session
function prepare()
|
return 0 |
end
|
|
|
function cleanup()
|
end
|
|
|
function thread_init(thread_id)
|
end
|
|
|
function event(thread_id)
|
db_connect()
|
rs = db_query("select 1;") |
db_disconnect()
|
end
|
