Not the answer you need?
Register and ask your own question!

Commit in slow log, please help!

vietnambabyvietnambaby EntrantCurrent User Role Beginner
Hi,

I checked mysql slow log,
commit command appear in slow log:

# [email protected]: xxxxxxx @ [127.0.0.1]
# Query_time: 1.195461 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1420594562;
commit;
# [email protected]: xxxxxxx @ [127.0.0.1]
# Query_time: 1.189559 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1420594562;
commit;
# [email protected]: xxxxxxx @ [127.0.0.1]
# Query_time: 1.123265 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1420594562;
commit;
# [email protected]: xxxxxxx @ [127.0.0.1]
# Query_time: 1.034187 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1420594562;
commit;
# [email protected]: 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



[[email protected]:~]$ 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,

Comments

  • Rick JamesRick James Contributor Current User Role Novice
    Yes; this sucks. You can't tell which COMMIT it was. (Or maybe you could if you added a /*...*/ after each comment in the code?) The time is probably being taken up by all the ROLLBACK (etc) stuff that needs cleaning up.

    Were you using PXC (Galera)?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.