Show all processes
Alternatively a query can be used:
select id,user, host, db, command, time, state, info, progress from information_schema.processlist
Kill a process
100 is the process id listed above.
To run queries with Oracle syntax, you can use:
SET SESSION sql_mode='ORACLE'
This is available only in MariaDB 10.3 and higher
database/mysql/session-commands.txt · Last modified: 2023/07/04 19:36 by 127.0.0.1