How to find and kill misbehaving MySQL queries
|
|
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 |
This topic does not have any threads posted yet!
You cannot post until you login.
