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
-
Latest posts
-
Hello to everyone I'm newbie here from India, Zirakpur- Latest: Philippe Gaucher
-
-
-
-
New threads
-
How Do I Improve My Website's SEO Health & Online Visibility?
- Started by Rameshsharama
- Replies: 1
-
Hostaddon - EU/US/ASIA | 1Gbit/10Gbit Unmetered Servers | Start @$14.99 | Additional 10% Off [Paid]
- Started by HostAddon
- Replies: 0
-
Hostaddon.com | 50% Off | Unlimited Disk + Traffic | Litespeed, SSD | From $1.99 | US, UK, AU...
- Started by HostAddon
- Replies: 0
-
Latest Hosting OffersNew Reviews
-
Latest hosting offers
-
Hostaddon - EU/US/ASIA | 1Gbit/10Gbit Unmetered Servers | Start @$14.99 | Additional 10% OffPremium Hardware @ Affordable prices- HostAddon
- Updated:
-
Hostaddon.com | 50% Off | Unlimited Disk + Traffic | Litespeed, SSD | From $1.99 | US, UK, AU, BGUnlimited Premium Shared Litespeed Hosting- HostAddon
- Updated:
-
Hostaddon VPS/VDS | EU/US/ASIA | 25/10/2/1 Gbps | SSD NVMe | Upto 50% Off | Storage | DMCA IgnorePremium Performance VPS, Affordable Prices!- HostAddon
- Updated:
-
