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
-
HOT FIRST MONTHS UK DIRECTADMIN HOSTING £1 - WEBSITE HOSTS UK- Latest: WebHostingUK
-
OFFER 50% OFF FIRST YEARS RESELLER HOSTING + FREE DOMAIN
- Latest: WebHostingUK
Latest Hosting OffersNew Reviews
-
Latest hosting offers
-
HostingB2B | Dedicated Dubai Servers | Limited AvailabilityGet your Dedicated Server in Dubai!
- HostingB2B
- Updated:
-
Anonymous & Offshore VPS HostingBulletproof, Anonymous & Offshore VPS Hosting Provider- darkvpspro
- Updated:
-
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:
-
