Hi,
I checked mysql slow log,
commit command appear in slow log:
User@Host: xxxxxxx @ [127.0.0.1]
Query_time: 1.195461 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1420594562;
commit;
User@Host: xxxxxxx @ [127.0.0.1]
Query_time: 1.189559 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1420594562;
commit;
User@Host: xxxxxxx @ [127.0.0.1]
Query_time: 1.123265 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1420594562;
commit;
User@Host: xxxxxxx @ [127.0.0.1]
Query_time: 1.034187 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1420594562;
commit;
User@Host: xxxxxxx @ [127.0.0.1]
Query_time: 1.007584 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1420594562;
commit;
mysql version 5.5
all table engine type is InnoDB
my.cnf:
sync_binlog 0
innodb_buffer_pool_size 4294967296
innodb_commit_concurrency 0
innodb_concurrency_tickets 500
innodb_file_per_table OFF
innodb_flush_log_at_trx_commit 2
innodb_flush_method
innodb_io_capacity 500
innodb_log_file_size 1073741824
innodb_read_io_threads 32
Data file size: 5G
Centos 5.6, SSD , ext4
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 205G 37G 158G 19% /
tmpfs 3.9G 0 3.9G 0% /dev/shm
/dev/sda1 477M 46M 406M 11% /boot
[123@123:~]$ free -m
total used free shared buffers cached
Mem: 7827 7551 275 26 137 1975
-/+ buffers/cache: 5438 2388
Swap: 15999 81 15918
Can any one help me?
Thanks,