How to find and kill misbehaving MySQL queries

Posted by bob on Jul 2, 2014 9:08 AM EDT
Mail this story
Print this story

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

Full Story

» Read more about: Groups: Debian, MySQL, Ubuntu, Linux, Raspberry Pi; Story Type: News Story

« Return to the newswire homepage

This topic does not have any threads posted yet!

You cannot post until you login.