database:mysql:session-commands
This is an old revision of the document!
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'
database/mysql/session-commands.1685127965.txt.gz · Last modified: 2023/07/04 19:36 (external edit)