David Beroff
Well-known member
- Joined
- Jun 14, 2016
- Messages
- 1,480
- Points
- 63
I changed to MariaDB ver 10.1.22 and using it on my website. I want to know on how to enable slow queries logs in MariaDB? Is it the same as Mysql slow query log?
How to enable slow queries logs in MariaDB?
- Thread starter David Beroff
- Start date
- logs mariadb
Collabora
Well-known member
- Joined
- Jan 24, 2017
- Messages
- 123
- Points
- 18
You will need this in my.conf
See also
https://mariadb.com/kb/en/mariadb/server-system-variables/#slow_query_log
Code:
slow_query_log = 1
long_query_time = 1
slow_query_log_file = /var/log/mysql/slow_query.log
log_queries_not_using_indexeshttps://mariadb.com/kb/en/mariadb/server-system-variables/#slow_query_log
Older Threads
Newer Threads
Latest Threads
Recommended Threads
- Poll
Similar Threads
Latest postsNew threads
-
Latest posts
-
Considering a Dedicated Server? What Features Really Matter.
- Latest: ShaniyaMorrison
-
New threads
-
How plans of big giants affect web hosting providers like you.- Started by DemoTiger
- Replies: 4
-
Latest Hosting OffersNew Reviews
-
Latest hosting offers
-
Jtti: Anniversary promotion, dedicated server starts at 55% off, Xeon E5 dedicated server as low asdedicated server starts at 55% off- jtti
- Updated:
-
# Anniversary promotion# JTTI unlimited traffic VPS cloud host 80%discount, annual payment of $ 24.6JTTI unlimited traffic VPS cloud host 80%discount- jtti
- Updated:
-
Hivelocity | Dedicated Server Deals | 50% off 1st Month Instant Servers - Code Inside!Leading Price-to-Performance with Hosting's #1 Rated Support on a World-Class Network.
- Hivelocity
- Updated:
-
