LinuxQuestions.org - MySQL performance seems spite awful

- Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)

- - MySQL performance seems spite awful (https://www.linuxquestions.org/questions/linux-server-73/mysql-performance-seems-spite-awful-711569/)

MySQL performance seems spite awful

I used to see a lot of these lines in my logs.

Code:

InnoDB: Unable to lock ./ibdata1, error: 11

InnoDB: Check that you do not already have another mysqld process

InnoDB: using the same InnoDB data or log files.

InnoDB: Unable to lock ./ibdata1, error: 11

InnoDB: Check that you do not already have another mysqld process

InnoDB: using the same InnoDB data or log files.

InnoDB: Unable to lock ./ibdata1, error: 11

I have made these changes this morning:

Copied MySQL Configuration File /etc/my.cnf from a well-performing server
Cleared 25GB of MySQL Binary Logs
Ran mysqlcheck on all databases for both repair and optimize.

I am looking for suggestions. MySQL performance has been spite awful lately and I want to see a 99,99% uptime for the next 3 months.

Quote:

Originally Posted by Ujjain (Post 3475255)

I used to see a lot of these lines in my logs.

Code:

InnoDB: Unable to lock ./ibdata1, error: 11

InnoDB: Check that you do not already have another mysqld process

InnoDB: using the same InnoDB data or log files.

InnoDB: Unable to lock ./ibdata1, error: 11

InnoDB: Check that you do not already have another mysqld process

InnoDB: using the same InnoDB data or log files.

InnoDB: Unable to lock ./ibdata1, error: 11

I have made these changes this morning:

Copied MySQL Configuration File /etc/my.cnf from a well-performing server
Cleared 25GB of MySQL Binary Logs
Ran mysqlcheck on all databases for both repair and optimize.

I am looking for suggestions. MySQL performance has been spite awful lately and I want to see a 99,99% uptime for the next 3 months.

That's one piece of the puzzle. What application is accessing the database? How many users? How big is the database(s) in question?

Alot of database messages will depend on how things are getting into and out of the database...if you have record contention, or if the process is IO bound on one spindle, and you have a large database, that'll do it as well.

Try to use mysqltuner.pl to improve performance also check the file system for any errors.

To download mysqltuner.pl go to: http://wiki.mysqltuner.com/MySQLTuner

Good luck!