Table of Contents

Session commands

Show all processes

show processlist

Alternatively a query can be used:

select id,user, host, db, command, time, state, info, progress
from information_schema.processlist

Kill a process

kill 100

100 is the process id listed above.

Oracle compatibility

To run queries with Oracle syntax, you can use:

SET SESSION sql_mode='ORACLE'
This is available only in MariaDB 10.3 and higher