Anish Sheela asked:
My MySQL service is not starting. I am using debian wheezy as operating system in my VPS. I use MyISAM for storing tables.
Response when starting service
[email protected]:~# service mysql start [FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
The following error is showing up when I used mysqld command.
[email protected]:~# mysqld 120811 22:06:39 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072 120811 22:06:39 [Warning] ignore-builtin-innodb is deprecated and will be removed in future releases. 120811 22:06:39 [Note] Plugin 'FEDERATED' is disabled. 120811 22:06:39 [Note] Server hostname (bind-address): '(null)'; port: 3306 120811 22:06:39 [Note] - '(null)' resolves to '0.0.0.0'; 120811 22:06:39 [Note] - '(null)' resolves to '::'; 120811 22:06:39 [Note] Server socket created on IP: '0.0.0.0'. 120811 22:06:40 [ERROR] Fatal error: Can't open and lock privilege tables: Got error 5 from storage engine
I am running a load balanced server, using glusterfs for replication. /var/lib/mysql directory is replicated across 2 servers. The MySQL starts perfectly fine on second server. It was working fine on first server. One fine morning, without my intervention, it happened.
$ perror 5 OS error code 5: Input/output error
Time to check your disks….
Since it’s a (most likely leased) VPS, you can’t really check the server’s disks, though. You may have to ask the hosting provider to look into it.
This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License.