Guest User

Untitled

a guest
Jan 12th, 2018
337
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.85 KB | None | 0 0
  1. MariaDB [(none)]> SET GLOBAL log_slow_time = 1;
  2. Query OK, 0 rows affected (0.00 sec)
  3.  
  4. MariaDB [(none)]> show variables like '%slow%';
  5. +---------------------+---------------------------------+
  6. | Variable_name | Value |
  7. +---------------------+---------------------------------+
  8. | log_slow_filter | |
  9. | log_slow_queries | ON |
  10. | log_slow_rate_limit | 1000 |
  11. | log_slow_time | 10.000000 |
  12. | log_slow_verbosity | query_plan |
  13. | slow_launch_time | 1 |
  14. | slow_query_log | ON |
  15. | slow_query_log_file | /var/log/mysql/mariadb-slow.log |
  16. +---------------------+---------------------------------+
  17. 8 rows in set (0.00 sec)
Add Comment
Please, Sign In to add comment