Steps to check when MySQL Performance is POOR



If your MySQL server performance is poor check the following details in your server.

1.Check the load average.

          ex: w 

Note:load average is not more than 1.


2.Check free memory.

          ex: free -m 

Check the available memory. 


3.Check the updating running process.

          ex: top 

Check CPU utilization and Memory of the server.


4.Show processlist.
This statement shows you which threads are running and to see “too many connections” error message and want to find out what is going on.


5.See log error.

 Is there any error in the server.


6.See slow query log. 
Check which query is taking more time to execute.
Then,Optimizing the query response time by query tuning, proper  index creation and parameter tuning.



7.Hard disk performance.

Comments

Post a Comment

Popular posts from this blog

PostgreSQL Database Version 13.4 To MySQL Database Version 8.0.20 Migration by using SQLines Tool

 PostgreSQL to MySQL  ------------------------ This Document will give details about PostgreSQL to MySQL Database . Environment Details :- --------------------------- Server 1 == Source Database == PostgreSQL Database Version == 13.4 Server 2 == Target Database == MySQL Database Version == 8.0.20 Server 3 == Jump host == Where you will install Sqline and connect to Source DB and Target DB. I have consider 3 EC2 Machines from AWS [ RHEL 8.x ]  postgres-source-server == 172.31.30.141 [ Private Ipaddress ] = EC2 Machine = RHEL 8.4 mysql-target-server    == 172.31.17.136 [ Private Ipaddress ] = EC2 Machine = RHEL 8.4 jump-host              == 172.31.27.241 [ Private Ipaddress ] = EC2 Machine = RHEL 8.4 Step - 1  Install PostgreSQL Database Version in Source Server  Step - 2  Install MySQL Database Verion in Target Server  Step - 3  Install / Setup sqline s/w in Jump host server  Step - 4  Loading ...
Read more

MariaDB Database Multi-instance implementation in single machine

--------------------------------------------------------------------- MariaDB Database Multi-instance implementation in single machine --------------------------------------------------------------------- Step - 1 : Install MaariaDB [ First ] instance by using YUM or Repo installation  Step - 2 : Setup for other port numbers [ 3307 , 3308 and 3309 ] Instances for MariaDB  Step - 3 : Start the MariaDB service with new DB instances [ 3307 , 3308 and 3309 ]  Step - 4 : Stop / Shutdown of MariaDB all Instances [ 3306 , 3307 ,3308 and 3309 ] Step - 5 : Connection for all MariaDB instances [ 3306 , 3307 ,3308 and 3309 ] Step - 6 : Setting the password for DB super user for all MariaDB instances [ 3306 , 3307 ,3308 and 3309 ] Step - 7 : MariaDB services creation for all instances [ 3306 , 3307 ,3308 and 3309 ] Step - 8 : Stop / Start / Status / Restart for all MariaDB instances by uising mariadb instance service files -------------------------------------------------------------...
Read more