InnoDB: Unable to lock ibdata1 error

If you are receiving below error it is due to an error with the restart command "service mysql restart"

[ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
[Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
[ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
[Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.

Please use /etc/init.d/mysql restart command instead:

 

 mysql# /etc/init.d/mysql restart
Shutting down MySQL. SUCCESS!
Parametr key_buffer_size set to 928M
Parametr table_open_cache set to 256
Parametr myisam_sort_buffer_size set to 1237M
Parametr innodb_buffer_pool_size set to 1856M
Starting MySQL. SUCCESS!
  • innodb, Unable to lock
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

 Client does not support authentication protocol requested by server

If you have a mysql authentication issues related to the error below you can take the following...

 Connect to mysql server under docker

You can use below command to connect to a mysql dockerized version: mysql -u root -h 127.0.0.1...

 Database with latin1 content but over a utf8 connection

It is often the case where you want to migrate to a new server.The new server may be configured...

 Host is not allowed to connect to this MariaDB server

The error "Host is not allowed to connect to this MariaDB server" usually points to a remote...

 ibdata reduce size

Step 01) MySQLDump all databases into a SQL text file (call it SQLData.sql) Step 02) Drop all...