The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

MariaDB configure slow logs to only log certain commands

Hello I'm new to MariaDB but am tasked to configure it already. I've scouted the internet before i went here to ask my question, i'm sorry if this has been asked before but. when i add something to my mariaDB through my laravel website.

I've SET GLOBAL long_query_time = 5; and tested it with a sleep(6);

resulting in me seeing the command.

my question however is, is it possible (and how) to make my slow log, only log every SELECT UPDATE POST and DELETE that's been executed.

I'm looking forward to working with MariaDB more and hearing from you.

Thanks in advance

Arno.

Answer Answered by Ian Gilfillan in this comment.

You don't have complete flexibility to decide what queries are logged, but can use the log_slow_disabled_statements, log_slow_admin_statements and log_slow_filter variables to get as close as you can.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.