David Beroff
Well-known member
- Joined
- Jun 14, 2016
- Messages
- 1,501
- 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
Similar Threads
Latest postsNew threads
-
New threads
-
How much bandwidth is enough for a growing website?
- Started by Ridoy
- Replies: 1
-
-
What are the performance differences between DNS load Balancing and reverse proxy?
- Started by jtti
- Replies: 2
-
Latest Hosting OffersNew Reviews
-
Latest hosting offers
-
Save an incredible 90% off! The Best HostPapa Deal so Far: Unlimited SSL, 50 GB NVMe, 24/7 supportEssentials Hosting provides reliable and affordable web hosting solutions!- cancan
- Updated:
-
Affordable Dedicated Servers - Raspberry Pi & Intel N95 | From €12.90/mo - Unlimited Traffic.Affordable Raspberry Pi & Intel N95 Dedicated Servers with SSD Storage and Unlimited Traffic.- Tinyservers.eu
- Updated:
-
SystemInPlace - Low cost Dual E5 384GB/512GB RAM DEDI. 30% OFF FIRST MONTH! 1gb/2.5gb/5gb/10gbAffordable enterprise grade dedicated servers at a price you can afford.- systeminplace
- Updated:
-
