# salve slow log

**URL:** <https://forums.percona.com/t/salve-slow-log/3022>\
**Category:** Other MySQL® Questions\
**Created:** [October 22, 2013, 10:52am UTC](https://forums.percona.com/t/salve-slow-log/3022 "2013-10-22T10:52:25Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![baoxiao](https://avatars.discourse-cdn.com/v4/letter/b/f6c823/32.png) [@baoxiao](https://forums.percona.com/u/baoxiao)\
**Post date:** [October 22, 2013, 10:52am UTC](https://forums.percona.com/t/salve-slow-log/3022/1 "2013-10-22T10:52:25Z")

</div>

When enable slave slow log, I set the long\_query\_time = 0 but in the slow log file, I can’t get the actually query statement, all I find are things like below:

SET timestamp=1382458852;  
BEGIN;

# User@Host: [SQL\_SLAVE] @ Id: 26

# Schema: mundotrack Last\_errno: 0 Killed: 0

# Query\_time: 0.000009 Lock\_time: 0.000000 Rows\_sent: 0 Rows\_examined: 0 Rows\_affected: 0

# Bytes\_sent: 0

Any configuration missing?

Thanks,

James

---

<div class="post-metadata">

**Author:** ![niljoshi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/niljoshi/32/16889_2.png) [@niljoshi](https://forums.percona.com/u/niljoshi)\
**Post date:** [October 22, 2013, 9:37pm UTC](https://forums.percona.com/t/salve-slow-log/3022/2 "2013-10-22T21:37:37Z")

</div>

Hi,

[URL][http://dev.mysql.com/doc/refman/5.5/en/slow-query-log.html[/URL]](http://dev.mysql.com/doc/refman/5.5/en/slow-query-log.html%5B/URL%5D)

Are you using it? if not then can you try with that option? thanks.

---

<div class="post-metadata">

**Author:** ![baoxiao](https://avatars.discourse-cdn.com/v4/letter/b/f6c823/32.png) [@baoxiao](https://forums.percona.com/u/baoxiao)\
**Post date:** [October 24, 2013, 8:09am UTC](https://forums.percona.com/t/salve-slow-log/3022/3 "2013-10-24T08:09:11Z")

</div>

I already enabled it.

Thanks,

James

---

<div class="post-metadata">

**Author:** ![przemek](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/przemek/32/3_2.png) [@przemek](https://forums.percona.com/u/przemek)\
**Post date:** [October 26, 2013, 5:17am UTC](https://forums.percona.com/t/salve-slow-log/3022/4 "2013-10-26T05:17:13Z")

</div>

James, this will work only if you are using STATEMENT based replication. For ROW, there are no actual queries, hence nothing will get logged from the replication stream.

---

<div class="post-metadata">

**Author:** ![baoxiao](https://avatars.discourse-cdn.com/v4/letter/b/f6c823/32.png) [@baoxiao](https://forums.percona.com/u/baoxiao)\
**Post date:** [October 29, 2013, 10:16am UTC](https://forums.percona.com/t/salve-slow-log/3022/5 "2013-10-29T10:16:10Z")

</div>

It supposed to work this way or is a bug because with row based replication we can still get the query from slave binary log file if enable log\_slave\_update

---

<div class="post-metadata">

**Author:** ![niljoshi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/niljoshi/32/16889_2.png) [@niljoshi](https://forums.percona.com/u/niljoshi)\
**Post date:** [October 29, 2013, 11:32pm UTC](https://forums.percona.com/t/salve-slow-log/3022/6 "2013-10-29T23:32:16Z")

</div>

Hi,

Can you provide which exact MySQL/PS version you are using on Master/Slave? Need to test it before come on any conclusion. I have also found one bug related to this but don’t know if it’s same.  
[URL][https://bugs.launchpad.net/percona-server/+bug/625022[/URL]](https://bugs.launchpad.net/percona-server/+bug/625022%5B/URL%5D)

Thanks.