David Beroff
Well-known member
- Joined
- Jun 14, 2016
- Messages
- 1,510
- 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
-
-
-
Buy your Mobile Proxy 4G/5G for Spain, USA, Colombia, Chile- Started by Proxysolid
- Replies: 0
-
Latest Hosting OffersNew Reviews
-
Latest hosting offers
-
Hostaddon VPS/VDS | EU/US/ASIA | 25/10/2/1 Gbps | SSD NVMe | Upto 50% Off | Storage | DMCA IgnoreUnmetered 1, 10, 25 Gbps Unmetered VPS Hosting- HostAddon
- Updated:
-
30 Days Free VPS Windows or Linux with Monthly Contract backed by NVMe SSD SANVPS customisble resources- trulycloud
- Updated:
-
iWebFusion.Net/Cyber Monday Special - Buy One Month Get One Month FreeUSA dedicated server- Vanessa
- Updated:
-
