Ready to be published? LXer is read by around 350,000 individuals each month, and is an excellent place for you to publish your ideas, thoughts, reviews, complaints, etc. Do you have something to say to the Linux community?
Sometimes the complexity of a relational database system can be overwhelming. Fortunately, sometimes that complexity is an advantage, as with MySQL's tools for managing queries. To view the currently-running queries, log in to the MySQL console and run the 'show processlist' command: mysql> show processlist; The first column you should look at is 'Time', which […]Continue reading...
The post How to find and kill misbehaving MySQL queries appeared first on Xmodulo.
Related FAQs:
How to view a list of MySQL users and their privileges
How to log in to MySQL server without password
How to install MySQL server and client on Linux
How to upgrade MySQL server on Debian or Ubuntu
How to set up a lightweight web server on Raspberry Pi
A free account is needed to post. Write your comment here first: your text is kept in this browser while you sign up or log in, and is waiting for you when you come back.
Your message:
|||||
10
Markdown: **bold**, *italic*, [text](https://link), - lists, > quotes, $x^2$ for math. Formatting help
