# slow\_query\_log\_microseconds\_timestamp=ON invalid?

**URL:** <https://forums.percona.com/t/slow-query-log-microseconds-timestamp-on-invalid/1553>\
**Category:** Other MySQL® Questions\
**Created:** [November 5, 2010, 4:22am UTC](https://forums.percona.com/t/slow-query-log-microseconds-timestamp-on-invalid/1553 "2010-11-05T04:22:04Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Synchro](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/synchro/32/831_2.png) [@Synchro](https://forums.percona.com/u/Synchro)\
**Post date:** [November 5, 2010, 4:22am UTC](https://forums.percona.com/t/slow-query-log-microseconds-timestamp-on-invalid/1553/1 "2010-11-05T04:22:04Z")

</div>

I’m running 5.1.50-rel11.4 and my config file contains this line:

slow\_query\_log\_microseconds\_timestamp = ON

which I got from the docs, but but on startup the server says:

mysqld: 101105 9:19:52 [Warning] /usr/sbin/mysqld: ignoring option ‘–slow\_query\_log\_microseconds\_timestamp’ due to invalid value ‘ON’

What’s wrong with that?

---

<div class="post-metadata">

**Author:** ![gmouse](https://avatars.discourse-cdn.com/v4/letter/g/b9e5f3/32.png) [@gmouse](https://forums.percona.com/u/gmouse)\
**Post date:** [November 5, 2010, 7:41am UTC](https://forums.percona.com/t/slow-query-log-microseconds-timestamp-on-invalid/1553/2 "2010-11-05T07:41:01Z")

</div>

[http://dev.mysql.com/doc/refman/5.0/en/dynamic-system-variab](http://dev.mysql.com/doc/refman/5.0/en/dynamic-system-variab) les.html

Variables that have a type of “boolean” can be set to 0, 1, ON or OFF. (If you set them on the command line or in an option file, use the numeric values.)

So try slow\_query\_log\_microseconds\_timestamp = 1

---

<div class="post-metadata">

**Author:** ![Synchro](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/synchro/32/831_2.png) [@Synchro](https://forums.percona.com/u/Synchro)\
**Post date:** [November 5, 2010, 9:41am UTC](https://forums.percona.com/t/slow-query-log-microseconds-timestamp-on-invalid/1553/3 "2010-11-05T09:41:01Z")

</div>

Thanks.