Dsawiki: Kill a Long Running SQL Statement

apachejspωiki

G’day (anonymous guest)
User Preferences

Recent Searches

Kill a Long Running SQL Statement

☰

Info
- Version : 2
- Date Modified : 24-May-2022 02:17
- Author : arcoleo
- More Info...
- Attachments
Edit
More...
- View Page Source
- Show Reader View

MySQL#

Get process ID of blocking process.

mysqladmin -uroot -pROOT_PASSWORD_HERE processlist

Kill it.

mysqladmin -uroot -pROOT_PASSWORD_HERE kill 1234

MySQL

This page (revision-2) was last changed on 24-May-2022 02:17 by arcoleo Top

Main

Login
RecentChanges
Frequent
Administrative
- Fixme!
- Delete!

All Categories

Languages
Linux / Shell
Logging
Mac / Shell
Media
Networking
- Messaging
- SSH
Performance
SCM
Shell / TmMx
Web / JS

Food
General
Geographic
Recreation

Books
- Summaries
Education
Electronics
Events
Movies
Outdoors
Powersports

Index
About

JSPWiki v2.11.0-M4