D
D
Denis Denisov2015-11-11 00:26:49
CentOS
Denis Denisov, 2015-11-11 00:26:49

Centos 6.5 falls periodically msql where to dig?

Centos 6.5 falls periodically msql where to dig?
5.5.44 ver
151108 12:03:45 [ERROR] /usr/libexec/mysqld: Sort aborted: Error writing file '/tmp/MY01kSIv' (Errcode: 28)
151108 16:02:13 [Warning] IP address '218.30 .67.89' could not be resolved: Name or service not known
151108 19:58:46 [Warning] IP address '58.215.79.221' could not be resolved: Name or service not known
151109 2:42:46 [Warning] IP address '202.207.7.68' could not be resolved: Name or service not known
151109 2:54:33 [Warning] IP address '42.193.1.36' could not be resolved: Name or service not known
151109 23:05:50 mysqld_safe Number of processes running now: 0
151109 23:05:50 mysqld_safe mysqld restarted
151109 23:05:54 [Note] /usr/libexec/mysqld (mysqld 5.5.44) starting as process 14379 ...
151109 23:05:54 [Note] Plugin 'FEDERATED' is disabled.
151109 23:05:54 InnoDB: The InnoDB memory heap is disabled 151109 23:05:54
InnoDB: Mutexes and rw_locks use GCC atomic builtins InnoDB: Using Linux native AIO 151109 23:05:54 InnoDB: Initializing buffer pool, size = 128.0M 151109 23:05:55 InnoDB: Completed initialization of buffer pool 151109 23:05:55 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles!
151109 23:05:55 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
151109 23:05:57 InnoDB: Waiting for the background threads to start
151109 23:05 :58 InnoDB: 5.5.44 started; log sequence number 27720663237
151109 23:05:59 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
151109 23:05:59 [Note] - '0.0.0.0' resolves to '0.0.0.0';
151109 23:05:59 [Note] Server socket created on IP: '0.0.0.0'.
151109 23:05:59 [Note] Event Scheduler: Loaded 0 events
151109 23:05:59 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.44' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) by Remi
151110 11:18:11 [Warning] IP address '202.207.7.68' could not be resolved: Name or service not known
151110 21:34:07 [Warning] IP address '222.186.3.96' could not be resolved: Name or service not known
151110 23:06:31 mysqld_safe Number of processes running now: 0
151110 23 :06:31 mysqld_safe mysqld restarted
151110 23:06:31 [Note] /usr/libexec/mysqld (mysqld 5.5.44) starting as process 24343 ...
151110 23:06:32 [Note] Plugin 'FEDERATED' is disabled .
151110 23:06:32 InnoDB: The InnoDB memory heap is disabled
151110 23:06:32 InnoDB: Mutexes and rw_locks use GCC atomic builtins 151110 23:06:32
InnoDB: Compressed tables use zlib 1.2.3 Initializing buffer pool, size = 128.0M InnoDB: mmap(137363456 bytes) failed; errno 12 151110 23:06:32 InnoDB: Completed initialization of buffer pool 151110 23:06:32 InnoDB: Fatal error: cannot allocate memory for the buffer pool 151110 23:06:32 [ERROR] Plugin 'InnoDB' init function returned error . 151110 23:06:32 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 151110 23:06:32 [ERROR] Unknown/unsupported storage engine: InnoDB 151110 23:06:32 [ERROR] Aborting
151110 23:06:32 [Note] /usr/libexec/mysqld: Shutdown complete
151110 23:06:33 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid
ended with databases from /var/lib/mysql
151111 0:05:33 [Note] /usr/libexec/mysqld (mysqld 5.5.44) starting as process 27231 ...
151111 0:05:33 [Note] Plugin 'FEDERATED' is disabled.
151111 0:05:33 InnoDB: The InnoDB memory heap is disabled 151111 0:05:33
InnoDB: Mutexes and rw_locks use GCC atomic builtins InnoDB: Using Linux native AIO 151111 0:05:33 InnoDB: Initializing buffer pool, size = 128.0M
151111 0:05:33 InnoDB: Completed initialization of buffer pool
151111 0:05:33 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
151111 0:05:33 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
151111 0:05:34 InnoDB: Waiting for the background threads to start
151111 0:05 :35 InnoDB: 5.5.44 started; log sequence number 28663550439
151111 0:05:35 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
151111 0:05:35 [Note] - '0.0.0.0' resolves to '0.0.0.0';
151111 0:05:35 [Note] Server socket created on IP: '0.0.0.0'.
151111 0:05:35 [Note] Event Scheduler: Loaded 0 events

Answer the question

In order to leave comments, you need to log in

3 answer(s)
A
Andrew, 2015-11-11
@drevil

/usr/libexec/mysqld: Sort aborted: Error writing file '/tmp/MY01kSIv' (Errcode: 28)
ran out of space.

D
Denis Denisov, 2015-11-11
@karlson1980

[[email protected] log]# ps -eo pid,user,pcpu,pmem,comm --sort vsize | tail -5 | tac
27231 mysql 154 0.7 mysqld
3001 named 0.0 0.0 named
23834 apache 1.2 0.2 httpd
23813 apache 0.6 0.2 httpd
23702 apache 1.0 0.2 httpd

A
Anton Chernousov, 2015-11-11
@tech22

You have a base there thoroughly gone.
1. MANDATORY! Stop the database and make a file backup, what the hell is not joking, so that you can analyze the situation in the future.
2. Now start in safe mode and dump the database and upload it to an empty one.
3. If it does not start in safe mode, then this is Achtung and you need to look in more detail.
P.S.
Or there is not enough memory (Fatal error: cannot allocate memory for the buffer pool)... But it still tries to recover itself from an incorrect shutdown

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question