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.