MySQL Daemon failed to start - Starting mysqld: FAILED!

[SahinS]

Hi Plesk,


[root@eminkitap init.d]# service mysqld start
MySQL Daemon failed to start.
Starting mysqld: [FAILED]

What can I do?

var/log/mysqld.log
__________________________________
140314 19:03:58 mysqld started
140314 19:03:58 [Warning] option 'innodb_additional_mem_pool_size': signed value 512000 adjusted to 524288
InnoDB: Error: tried to read 16384 bytes at offset 0 49152.
InnoDB: Was only able to read -1.
140314 19:04:04 InnoDB: Operating system error number 5 in a file operation.
InnoDB: Error number 5 means 'Input/output error'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html
InnoDB: File operation call: 'read'.
InnoDB: Cannot continue operation.
140314 19:04:04 mysqld ended

140314 19:05:39 mysqld started
140314 19:05:39 [Warning] option 'innodb_additional_mem_pool_size': signed value 512000 adjusted to 524288
InnoDB: Error: tried to read 16384 bytes at offset 0 49152.
InnoDB: Was only able to read -1.
140314 19:05:42 InnoDB: Operating system error number 5 in a file operation.
InnoDB: Error number 5 means 'Input/output error'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html
InnoDB: File operation call: 'read'.
InnoDB: Cannot continue operation.
140314 19:05:42 mysqld ended

 

[SahinS]

MyPlesk.com:8880
ERROR: PleskFatalException: Unable to connect to database: mysql_connect(): No such file or directory (auth.php:142)

help..

 

[SahinS]

Now,
# service mysqld status
mysqld (pid 7264) is running...


Errors.. :8880
ERROR: PleskMainDBException: MySQL query failed: Incorrect information in file: './psa/misc.frm' (db.php:102)
Search for related Knowledge Base articles



var/log/mysqld.log

140315 04:14:41 mysqld started
140315 4:14:41 InnoDB: Error: cannot allocate 3145744384 bytes of
InnoDB: memory with malloc! Total allocated memory
InnoDB: by InnoDB 27505488 bytes. Operating system errno: 12
InnoDB: Check if you should increase the swap file or
InnoDB: ulimits of your operating system.
InnoDB: On FreeBSD check you have compiled the OS with
InnoDB: a big enough maximum process size.
InnoDB: Note that in most 32-bit computers the process
InnoDB: memory space is limited to 2 GB or 4 GB.
InnoDB: We keep retrying the allocation for 60 seconds...
InnoDB: Fatal error: cannot allocate the memory for the buffer pool
140315 4:15:41 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.95' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
140315 4:15:49 [ERROR] /usr/libexec/mysqld: Incorrect information in file: './my_db/ps_configuration.frm'
140315 4:15:49 [ERROR] /usr/libexec/mysqld: Incorrect information in file: './my_db/ps_configuration.frm'
140315 4:25:30 [ERROR] /usr/libexec/mysqld: Incorrect information in file: './my_db/ps_configuration.frm'
140315 4:25:30 [ERROR] /usr/libexec/mysqld: Incorrect information in file: './my_db/ps_configuration.frm'
140315 4:26:04 [ERROR] /usr/libexec/mysqld: Incorrect information in file: './my_db/cl_param.frm'
140315 4:26:04 [ERROR] /usr/libexec/mysqld: Incorrect information in file: './my_db/cl_param.frm'
140315 4:26:04 [ERROR] /usr/libexec/mysqld: Incorrect information in file: './my_db/misc.frm'
140315 4:26:04 [ERROR] /usr/libexec/mysqld: Incorrect information in file: './my_db/misc.frm'
140315 4:27:06 [ERROR] /usr/libexec/mysqld: Incorrect information in file: './my_db/ps_configuration.frm'
140315 4:27:06 [ERROR] /usr/libexec/mysqld: Incorrect information in file: './my_db/ps_configuration.frm'

help me pls

 

[SahinS]

Heyy,

Currently, only: There are two errors. What can I do?

Version: '5.0.95' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
and
# service psa restart Stopping sw-engine-fpm: [ OK ]
Starting sw-engine-fpm: [ OK ]
ERROR 1146 (42S02) at line 1: Table 'psa.sessions' doesn't exist
[root@ ~]#