Check MySQL Slow Queries In Mysql Database Server

Check MySQL Slow Queries 

You can use the command to check running slow queries in MySQL.

Sometimes we face issues in database response time one of the causes 
may be as slow queries are running in MySQL. There are many ways 
to check slow query in MySQL.

I have installed maria-db on the server and created a database called testing & create a table.

Check Out: Monit Service Failed Process Monitoring To Start On Linux 7

Create table

CREATE TABLE student (id INT, name VARCHAR(20), email VARCHAR(20));

Check MySQL Slow Queries

Check Out: How To Access Amazon Server Using the Private Key

Insert data to table Student

INSERT INTO student (id,name,email) VALUES(1,”Pankaj”,”“);

Check Out: How To Enable Slow Query In MySQL Server In Linux

Check Slow query: the below command will show you the slow query 
there is no slow query as I just created You may check at the running
database server.

show processlist;

Another way is to check slow queries is status or \s;

YouTube Link :

You’re done

Share on:

I'm the founder of Curious Viral. I hope this blog will provide you complete information about Linux Technology & I would like to share my technical knowledge with you which I have learned during this period.

Other Posts You May Like...

Leave a comment