Announcement

Announcement Module
Collapse
No announcement yet.

slow_query_log_microseconds_timestamp=ON invalid?

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • slow_query_log_microseconds_timestamp=ON invalid?

    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?

  • #2
    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

    Comment


    • #3
      Thanks.

      Comment

      Working...
      X