I tried increasing innodb_buffer_pool_size
via my.cnf
from default 128m to 256m, but on restart attempt, mysql shutdown failed with:
130125 11:49:55 InnoDB: Initializing buffer pool, size = 256.0M
130125 11:49:55 InnoDB: Completed initialization of buffer pool
InnoDB: Unable to lock ./ibdata1, error: 11
MySQL is up and running but the any attempt to "mysql -u root -p" via terminal blows up with:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
I touch'd/chown'd mysql.sock and mysqld.pid in appropriate locations (as they were missing, not good), but still no luck getting into mysql.
Have a dump from last night, but would love to get a dump from today to see if ibdata1 is corrupted (read/write operations seem fine, so if it was corrupted mysql would shutdown, no?)
Needless to say, worried about trying to restart! We have a Java application that connects to MySQL via a connection pool; is the locking happening there?
At any rate, ideas for how to approach the situation appreciated. Might clone the VM MySQL runs on and import /var/lib/mysql directory to see what's going on, but if it's simply a matter of recreating the sock and pid files and making the restarting, no point in wasting an afternoon.