MySQL Forums
Forum List  »  Replication

Re: Replication Lagging
Posted by: Mahendra Singh Bisht
Date: February 02, 2016 10:35PM

slowlog is enabled but it doesn't work

mysql> show variables like 'slow_%';
+---------------------+-------------------------+
| Variable_name | Value |
+---------------------+-------------------------+
| slow_launch_time | 2 |
| slow_query_log | ON |
| slow_query_log_file | /var/lib/mysql/errorlog |
+---------------------+-------------------------+
3 rows in set (0.00 sec)

mysql> show variables like 'long_%';
+-----------------+-----------+
| Variable_name | Value |
+-----------------+-----------+
| long_query_time | 10.000000 |
+-----------------+-----------+
1 row in set (0.00 sec)

[root@server1 backup]# cd /var/lib/mysql/errorlog
[root@server1 errorlog]# ls -ltr
total 0
[root@server1 errorlog]#

Version is : 5.6.19-enterprise-commercial-advanced-log

Questions | 1539346150
Uptime | 906016

Any suggestion on why the slow logs are not generating ?

Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
1395
January 25, 2016 06:24AM
938
January 29, 2016 06:45PM
987
January 30, 2016 12:02AM
782
January 30, 2016 08:48PM
831
January 31, 2016 03:14AM
851
February 01, 2016 11:14AM
Re: Replication Lagging
857
February 02, 2016 10:35PM
803
February 04, 2016 10:42PM
843
February 04, 2016 11:13PM
763
February 06, 2016 04:20PM
842
February 08, 2016 02:15AM
777
February 13, 2016 05:45PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.