# Commit in slow log, please help!

**URL:** <https://forums.percona.com/t/commit-in-slow-log-please-help/3983>\
**Category:** Other MySQL® Questions\
**Created:** [January 7, 2015, 8:48pm UTC](https://forums.percona.com/t/commit-in-slow-log-please-help/3983 "2015-01-07T20:48:22Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![vietnambaby](https://avatars.discourse-cdn.com/v4/letter/v/d2c977/32.png) [@vietnambaby](https://forums.percona.com/u/vietnambaby)\
**Post date:** [January 7, 2015, 8:48pm UTC](https://forums.percona.com/t/commit-in-slow-log-please-help/3983/1 "2015-01-07T20:48:22Z")

</div>

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,

---

<div class="post-metadata">

**Author:** ![Rick\_James](https://avatars.discourse-cdn.com/v4/letter/r/22d042/32.png) [@Rick\_James](https://forums.percona.com/u/Rick_James)\
**Post date:** [February 4, 2015, 11:06pm UTC](https://forums.percona.com/t/commit-in-slow-log-please-help/3983/2 "2015-02-04T23:06:09Z")

</div>

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)?