Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
None
Description
A stand-alone server running mariadb 10.2.12.
binlog_commit_wait_count = 10 |
10,000 records insert
# time mysql sbtest < sbtest.sql
|
|
|
real 1m6.715s
|
user 0m0.280s
|
sys 0m0.694s
|
|
|
# time mysql sbtest < sbtest.sql
|
|
|
real 1m6.700s
|
user 0m0.290s
|
sys 0m0.656s
|
binlog_commit_wait_count = 0 |
# time mysql sbtest < sbtest.sql
|
|
|
real 0m2.211s
|
user 0m0.178s
|
sys 0m0.143s
|
|
|
# time mysql sbtest < sbtest.sql
|
|
|
real 0m2.280s
|
user 0m0.236s
|
sys 0m0.188s
|
According to the official manual, the system variable will only impact parallel replication, is that normal on a stand-alone server?