3 ms·
Cancelling queries with MySQL is hard, in my pretty dated experience. There's no signal you can do from the client directly. You can do a kill thread ID from a
by toast0 5y ago
Cancelling queries with MySQL is hard, in my pretty dated experience.
There's no signal you can do from the client directly. You can do a kill thread ID from another client, but that's only checked at some points, and I wouldn't expect it to stop an update in progress.
Kill -9 the unix process should work, but pulling the cord might mean less chance of changes persisting to disk.