How to enable slow queries logs in MariaDB?

Thread starter David Beroff
Start date Apr 12, 2017
logs mariadb

David Beroff

Well-known member

Registered

Apr 12, 2017

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?

Collabora

Well-known member

Registered

Apr 21, 2017

You will need this in my.conf

Code:

slow_query_log = 1
long_query_time = 1
slow_query_log_file = /var/log/mysql/slow_query.log
log_queries_not_using_indexes

You must log in or register to reply here.

Facebook Twitter Reddit Pinterest Tumblr WhatsApp Email Link

Older Threads

What is the best Plugin that we can use from WHMCS ?

Replies: 9

Views: 6,647

Apr 26, 2017

BlimpHosting

How to create my own affiliate hosting blog?

Replies: 9

Views: 8,312

May 29, 2017

TwoPalmsHost

How to restart WHM/cPanel in SSH?

Replies: 9

Views: 14,139

Jun 13, 2018

Nixtree

How to move SSL certificate to a new hosting?

Replies: 20

Views: 16,514

Oct 26, 2017

24x7serverman

Managed vs Unmanaged Dedicated Servers?

Replies: 14

Views: 8,649

May 18, 2017

racksandcloud

Newer Threads

What do you expect from future versions of WordPress?

jamilaliahmed
Apr 12, 2017
Web Hosting

Replies: 14

Views: 7,298

May 9, 2017

Sonwebhost

OFFER Hostens | Hosting from $1.05/mo. | Let's Encrypt | Instant setup | SSD

Replies: 0

Views: 2,698

Apr 12, 2017

hostens

Easter discount - LiteSpeed hosting from 0.5$ per month

Replies: 2

Views: 3,944

May 20, 2017

manoaratefy

OFFER Free Double Disk Space Offer on WHUK Linux and Windows VPS Hosting

Replies: 0

Views: 2,463

Apr 12, 2017

KelvinSmith

What is Extended Validation SSL Certificate?

Replies: 17

Views: 11,235

Jan 27, 2023

Elliot Martin

Latest Threads

Berikut Cara Buka Blokir Wondr by BNI

Replies: 2

Views: 35

Today at 6:18 PM

lokeshjoshi

Buka Blokir Wondr by BNI Lupa/PIn Password

lokeshjoshi
Today at 6:15 PM
The Lounge

Replies: 2

Views: 37

Today at 6:16 PM

lokeshjoshi

Cara Buka Blokir Bank Bni Lupa PIn

Replies: 0

Views: 24

Today at 6:14 PM

lokeshjoshi

Cara Buka blokir Wondr by BNI

lokeshjoshi
Today at 6:12 PM
Cloud Hosting

Replies: 0

Views: 31

Today at 6:12 PM

lokeshjoshi

Panduan Lengkap Buka Blokir Akun Wondr by BNI

lokeshjoshi
Monday at 12:55 PM
General Discussion

Replies: 0

Views: 187

Monday at 12:55 PM

lokeshjoshi

Recommended Threads

Hosting for Free Photo Sharing Sites

Replies: 6

Views: 3,586

Dec 29, 2016

Philippe Gaucher

Please review my blog.

Replies: 26

Views: 15,855

May 29, 2018

superman2727

What domain registrars are better alternatives to GoDaddy?

Replies: 29

Views: 17,733

Jun 27, 2017

Maria_C

Importance of unique contents to the search engines?

Replies: 10

Views: 5,322

Mar 1, 2016

w3master

Is 101domain a reliable service?

Replies: 19

Views: 13,373

Mar 7, 2017

norled

Similar Threads

How to Enable TLS 1.3 on Windows, Limux, Mac, Apache & NGINX

Replies: 8

Views: 6,511

Jun 21, 2024

sarahalexa010

How to enable HTTPS in Drupal?

Replies: 2

Views: 2,925

Feb 23, 2023

BlueLeaf

Do I need to enable Proxy DNS in Cloudflare to use Cloudflare SSL?

Replies: 6

Views: 4,202

Apr 16, 2022

myresellerhome

Enable Nginx on DirectAdmin?

Replies: 2

Views: 3,374

Sep 16, 2021

Napster.

How to remove Cloudflare hcapcha when enable Cloudflare ddos protection?

Replies: 3

Views: 6,137

Sep 21, 2020

Fusion Arc Hosting

Latest posts
- L
  
  Berikut Cara Buka Blokir Wondr by BNI
  
  Latest: lokeshjoshi
  
  Today at 6:18 PM
  
  Web Hosting Tutorials
- L
  
  Buka Blokir Wondr by BNI Lupa/PIn Password
  
  Latest: lokeshjoshi
  
  Today at 6:16 PM
  
  The Lounge
- L
  
  Cara Buka blokir Wondr by BNI
  
  Latest: lokeshjoshi
  
  Today at 6:12 PM
  
  Cloud Hosting
New threads
- L
  
  Berikut Cara Buka Blokir Wondr by BNI
  
  Started by lokeshjoshi
  
  Today at 6:17 PM
  
  Replies: 2
  
  Web Hosting Tutorials
- L
  
  Buka Blokir Wondr by BNI Lupa/PIn Password
  
  Started by lokeshjoshi
  
  Today at 6:15 PM
  
  Replies: 2
  
  The Lounge
- L
  
  Cara Buka blokir Wondr by BNI
  
  Started by lokeshjoshi
  
  Today at 6:12 PM
  
  Replies: 0
  
  Cloud Hosting

Latest hosting offers
- Anonymous & Offshore VPS Hosting
  Bulletproof, Anonymous & Offshore VPS Hosting Provider
  
  darkvpspro
  
  Updated: Dec 16, 2025
- Hostaddon VPS/VDS | EU/US/ASIA | 25/10/2/1 Gbps | SSD NVMe | Upto 50% Off | Storage | DMCA Ignore
  Unmetered 1, 10, 25 Gbps Unmetered VPS Hosting
  
  HostAddon
  
  Updated: Oct 1, 2025
- 30 Days Free VPS Windows or Linux with Monthly Contract backed by NVMe SSD SAN
  VPS customisble resources
  
  trulycloud
  
  Updated: Sep 29, 2025

Popular Contributors - Past 30 Days

L
87
F
31
P
18
C
17
H
16
16
S
10
8
N
8
B
7
R
7
S
7
7
6
B
6

How to enable slow queries logs in MariaDB?

David Beroff

Well-known member

Collabora

Well-known member

David Beroff

Well-known member

Latest posts New threads

Latest posts

New threads

Latest Hosting Offers New Reviews

Latest hosting offers

Popular Contributors - Past 30 Days

Sponsors

Tag Cloud