解决强制重启系统导致mysql无法启动

  • 时间:
  • 浏览:10
170108 03:53:1000 mysqld_safe Starting mysqld daemon with databases from /www/server/data

170108  3:53:1000 [Note] /www/server/mysql/bin/mysqld (mysqld 5.5.47-log) starting as process 25182 ...

170108  3:53:1000 InnoDB: The InnoDB memory heap is disabled

170108  3:53:1000 InnoDB: Mutexes and rw_locks use GCC atomic builtins

170108  3:53:1000 InnoDB: Compressed tables use zlib 1.2.3

170108  3:53:1000 InnoDB: Using Linux native AIO

170108  3:53:1000 InnoDB: Initializing buffer pool, size = 16.0M

170108  3:53:1000 InnoDB: Completed initialization of buffer pool

InnoDB: The first specified data file /www/server/data/ibdata1 did not exist:

InnoDB: a new database to be created!

170108  3:53:1000  InnoDB: Setting file /www/server/data/ibdata1 size to 10 MB

InnoDB: Database physically writes the file full: wait...

170108  3:53:1000  InnoDB: Log file /www/server/data/ib_logfile0 did not exist: new to be created

InnoDB: Setting log file /www/server/data/ib_logfile0 size to 5 MB

InnoDB: Database physically writes the file full: wait...

170108  3:53:1000  InnoDB: Log file /www/server/data/ib_logfile1 did not exist: new to be created

InnoDB: Setting log file /www/server/data/ib_logfile1 size to 5 MB

InnoDB: Database physically writes the file full: wait...

InnoDB: Doublewrite buffer not found: creating new

InnoDB: Doublewrite buffer created

InnoDB: 127 rollback segment(s) active.

InnoDB: Creating foreign key constraint system tables

InnoDB: Foreign key constraint system tables created

170108  3:53:1000  InnoDB: Waiting for the background threads to start

170108  3:53:31 InnoDB: 5.5.47 started; log sequence number 0

170108  3:53:31 [Note] Server hostname (bind-address): '0.0.0.0'; port: 310006

170108  3:53:31 [Note]   - '0.0.0.0' resolves to '0.0.0.0';

170108  3:53:31 [Note] Server socket created on IP: '0.0.0.0'.

170108  3:53:31 [Note] Event Scheduler: Loaded 0 events

170108  3:53:31 [Note] /www/server/mysql/bin/mysqld: ready for connections.

Version: '5.5.47-log'  socket: '/tmp/mysql.sock'  port: 310006  Source distribution

170108  3:53:33 [Note] /www/server/mysql/bin/mysqld: Normal shutdown

170108  3:53:33 [Note] Event Scheduler: Purging the queue. 0 events



170108  3:53:33  InnoDB: Starting shutdown...

170108  3:53:34  InnoDB: Shutdown completed; log sequence number 1595675

170108  3:53:34 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

170108 03:53:34 mysqld_safe mysqld from pid file /www/server/data/loca.pid ended



170108 03:53:34 mysqld_safe Starting mysqld daemon with databases from /www/server/data

170108  3:53:34 [Note] /www/server/mysql/bin/mysqld (mysqld 5.5.47-log) starting as process 25685 ...

170108  3:53:34 [Note] Plugin 'InnoDB' is disabled.

170108  3:53:34 [Note] Server hostname (bind-address): '0.0.0.0'; port: 310006

170108  3:53:34 [Note]   - '0.0.0.0' resolves to '0.0.0.0';

170108  3:53:34 [Note] Server socket created on IP: '0.0.0.0'.

170108  3:53:34 [Note] Event Scheduler: Loaded 0 events

170108  3:53:34 [Note] /www/server/mysql/bin/mysqld: ready for connections.

Version: '5.5.47-log'  socket: '/tmp/mysql.sock'  port: 310006  Source distribution

170108  4:03:15 [Note] /www/server/mysql/bin/mysqld: Normal shutdown

170108  4:03:15 [Note] Event Scheduler: Purging the queue. 0 events



170108  4:03:15 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

170108 04:03:15 mysqld_safe mysqld from pid file /www/server/data/loca.pid ended



170108 04:03:16 mysqld_safe Starting mysqld daemon with databases from /www/server/data

170108  4:03:16 [Note] /www/server/mysql/bin/mysqld (mysqld 5.5.47-log) starting as process 100077 ...

170108  4:03:16 [Note] Plugin 'InnoDB' is disabled.

170108  4:03:16 [Note] Server hostname (bind-address): '0.0.0.0'; port: 310006

170108  4:03:16 [Note]   - '0.0.0.0' resolves to '0.0.0.0';

170108  4:03:16 [Note] Server socket created on IP: '0.0.0.0'.

170108  4:03:16 [Note] Event Scheduler: Loaded 0 events

170108  4:03:16 [Note] /www/server/mysql/bin/mysqld: ready for connections.

Version: '5.5.47-log'  socket: '/tmp/mysql.sock'  port: 310006  Source distribution

170108  4:17:1000 [Note] /www/server/mysql/bin/mysqld: Normal shutdown

170108  4:17:31 [Note] Event Scheduler: Purging the queue. 0 events



170108  4:17:31 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

170108 04:17:31 mysqld_safe mysqld from pid file /www/server/data/loca.pid ended



170108 04:17:54 mysqld_safe Starting mysqld daemon with databases from /www/server/data

170108  4:17:54 [Note] /www/server/mysql/bin/mysqld (mysqld 5.5.47-log) starting as process 1131 ...

170108  4:17:54 [Note] Plugin 'InnoDB' is disabled.

170108  4:17:54 [Note] Server hostname (bind-address): '0.0.0.0'; port: 310006

170108  4:17:54 [Note]   - '0.0.0.0' resolves to '0.0.0.0';

170108  4:17:54 [Note] Server socket created on IP: '0.0.0.0'.

170108  4:17:54 [Note] Event Scheduler: Loaded 0 events

170108  4:17:54 [Note] /www/server/mysql/bin/mysqld: ready for connections.

Version: '5.5.47-log'  socket: '/tmp/mysql.sock'  port: 310006  Source distribution

170109 13:41:23 [Warning] IP address '118.123.116.251' could not be resolved: Name or service not known

170109 15:20:22 [Warning] IP address '139.196.40.69' could not be resolved: Name or service not known

170109 20:28:59 [Warning] IP address '104.216.4.234' could not be resolved: Name or service not known

170110  2:58:06 [Note] /www/server/mysql/bin/mysqld: Normal shutdown

170110  2:58:06 [Note] Event Scheduler: Purging the queue. 0 events



170110  2:58:08 [Warning] /www/server/mysql/bin/mysqld: Forcing close of thread 2910  user: 'tieba'

170110  2:58:08 [Warning] /www/server/mysql/bin/mysqld: Forcing close of thread 2903  user: 'tieba'

170110  2:58:08 [Warning] /www/server/mysql/bin/mysqld: Forcing close of thread 2902  user: 'tieba'

170110  2:58:08 [Warning] /www/server/mysql/bin/mysqld: Forcing close of thread 2901  user: 'tieba'

170110  2:58:08 [Warning] /www/server/mysql/bin/mysqld: Forcing close of thread 2897  user: 'tieba'

170110  2:58:08 [Warning] /www/server/mysql/bin/mysqld: Forcing close of thread 2885  user: 'tieba'

170110  2:58:08 [Warning] /www/server/mysql/bin/mysqld: Forcing close of thread 2879  user: 'tieba'

170110  2:58:08 [Warning] /www/server/mysql/bin/mysqld: Forcing close of thread 281000  user: 'tieba'

170110  2:58:08 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

170110 02:58:08 mysqld_safe mysqld from pid file /www/server/data/loca.pid ended



170110 02:58:09 mysqld_safe Starting mysqld daemon with databases from /www/server/data

170110  2:58:09 [Note] /www/server/mysql/bin/mysqld (mysqld 5.5.47-log) starting as process 17413 ...

170110  2:58:09 [Note] Plugin 'InnoDB' is disabled.

170110  2:58:09 [Note] Server hostname (bind-address): '0.0.0.0'; port: 310006

170110  2:58:09 [Note]   - '0.0.0.0' resolves to '0.0.0.0';

170110  2:58:09 [Note] Server socket created on IP: '0.0.0.0'.

170110  2:58:09 [Note] Event Scheduler: Loaded 0 events

170110  2:58:09 [Note] /www/server/mysql/bin/mysqld: ready for connections.

Version: '5.5.47-log'  socket: '/tmp/mysql.sock'  port: 310006  Source distribution

170110  2:59:41 [Note] /www/server/mysql/bin/mysqld: Normal shutdown

170110  2:59:41 [Note] Event Scheduler: Purging the queue. 0 events



170110  2:59:41 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

170110 02:59:41 mysqld_safe mysqld from pid file /www/server/data/loca.pid ended



170110 02:59:43 mysqld_safe Starting mysqld daemon with databases from /www/server/data

170110  2:59:43 [Note] /www/server/mysql/bin/mysqld (mysqld 5.5.47-log) starting as process 1100039 ...

170110  2:59:43 [Note] Plugin 'InnoDB' is disabled.

170110  2:59:43 [Note] Server hostname (bind-address): '0.0.0.0'; port: 310006

170110  2:59:43 [Note]   - '0.0.0.0' resolves to '0.0.0.0';

170110  2:59:43 [Note] Server socket created on IP: '0.0.0.0'.

170110  2:59:43 [Note] Event Scheduler: Loaded 0 events

170110  2:59:43 [Note] /www/server/mysql/bin/mysqld: ready for connections.

Version: '5.5.47-log'  socket: '/tmp/mysql.sock'  port: 310006  Source distribution

170110 03:00:20 mysqld_safe A mysqld process already exists