Warning: [obfuscated]():....

same problem here for 6 days in a row...
same hour when i use a user_backup script with a cronjob.

Code: [Select]

170124 15:45:45 mysqld_safe Number of processes running now: 0
170124 15:45:46 mysqld_safe mysqld restarted
170124 15:45:47  InnoDB: Initializing buffer pool, size = 8.0M
170124 15:45:47  InnoDB: Completed initialization of buffer pool
InnoDB: Log scan progressed past the checkpoint lsn 20 332212424
170124 15:45:47  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...
InnoDB: Doing recovery: scanned up to log sequence number 20 332215443
InnoDB: 1 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 1 row operations to undo
InnoDB: Trx id counter is 0 389444352
170124 15:45:47  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
170124 15:45:47  InnoDB: Started; log sequence number 20 332215443
InnoDB: Starting in background the rollback of uncommitted transactions
170124 15:45:47  InnoDB: Rolling back trx with id 0 389443928, 1 rows to undo
170124 15:45:48 [Note] Event Scheduler: Loaded 0 events
170124 15:45:48 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution

InnoDB: Rolling back of trx id 0 389443928 completed
170124 15:45:48  InnoDB: Rollback of non-prepared transactions completed
170124 15:46:37 mysqld_safe Number of processes running now: 0
170124 15:46:37 mysqld_safe mysqld restarted
170124 15:46:41  InnoDB: Initializing buffer pool, size = 8.0M
170124 15:46:41  InnoDB: Completed initialization of buffer pool
InnoDB: Error: pthread_create returned 11
170124 15:46:42 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170124 15:59:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170124 15:59:36  InnoDB: Initializing buffer pool, size = 8.0M
170124 15:59:36  InnoDB: Completed initialization of buffer pool
InnoDB: Log scan progressed past the checkpoint lsn 20 332275616
170124 15:59:36  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...
InnoDB: Doing recovery: scanned up to log sequence number 20 332282842
170124 15:59:36  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
170124 15:59:37  InnoDB: Started; log sequence number 20 332282842
170124 15:59:37 [Note] Event Scheduler: Loaded 0 events
170124 15:59:37 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170125  3:44:02 [Note] /usr/libexec/mysqld: Normal shutdown

170125  3:44:02 [Note] Event Scheduler: Purging the queue. 0 events
170125  3:44:04  InnoDB: Starting shutdown...
170125  3:44:06  InnoDB: Shutdown completed; log sequence number 20 366796198
170125  3:44:06 [Note] /usr/libexec/mysqld: Shutdown complete

170125 03:44:06 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170125 08:53:21 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170125  8:53:21  InnoDB: Initializing buffer pool, size = 8.0M
170125  8:53:21  InnoDB: Completed initialization of buffer pool
170125  8:53:21  InnoDB: Started; log sequence number 20 366796198
170125  8:53:21 [Note] Event Scheduler: Loaded 0 events
170125  8:53:21 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170126  3:30:01 [Note] /usr/libexec/mysqld: Normal shutdown

170126  3:30:01 [Note] Event Scheduler: Purging the queue. 0 events
170126  3:30:03  InnoDB: Starting shutdown...
170126  3:30:06  InnoDB: Shutdown completed; log sequence number 20 497452229
170126  3:30:06 [Note] /usr/libexec/mysqld: Shutdown complete

170126 03:30:06 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170126 09:51:24 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170126  9:51:24  InnoDB: Initializing buffer pool, size = 8.0M
170126  9:51:24  InnoDB: Completed initialization of buffer pool
170126  9:51:24  InnoDB: Started; log sequence number 20 497452229
170126  9:51:24 [Note] Event Scheduler: Loaded 0 events
170126  9:51:24 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170127  3:14:02 [Note] /usr/libexec/mysqld: Normal shutdown

170127  3:14:02 [Note] Event Scheduler: Purging the queue. 0 events
170127  3:14:04  InnoDB: Starting shutdown...
170127  3:14:06  InnoDB: Shutdown completed; log sequence number 20 688640035
170127  3:14:06 [Note] /usr/libexec/mysqld: Shutdown complete

170127 03:14:06 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170127 09:36:12 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170127  9:36:12  InnoDB: Initializing buffer pool, size = 8.0M
170127  9:36:12  InnoDB: Completed initialization of buffer pool
170127  9:36:12  InnoDB: Started; log sequence number 20 688640035
170127  9:36:12 [Note] Event Scheduler: Loaded 0 events
170127  9:36:12 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170128  3:35:02 [Note] /usr/libexec/mysqld: Normal shutdown

170128  3:35:02 [Note] Event Scheduler: Purging the queue. 0 events
170128  3:35:04  InnoDB: Starting shutdown...
170128  3:35:05  InnoDB: Shutdown completed; log sequence number 20 821454141
170128  3:35:05 [Note] /usr/libexec/mysqld: Shutdown complete

170128 03:35:05 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170128 03:37:20 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170128  3:37:20  InnoDB: Initializing buffer pool, size = 8.0M
170128  3:37:20  InnoDB: Completed initialization of buffer pool
170128  3:37:20  InnoDB: Started; log sequence number 20 821454141
170128  3:37:20 [Note] Event Scheduler: Loaded 0 events
170128  3:37:20 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170129  3:49:01 [Note] /usr/libexec/mysqld: Normal shutdown

170129  3:49:01 [Note] Event Scheduler: Purging the queue. 0 events
170129  3:49:03  InnoDB: Starting shutdown...
170129  3:49:08  InnoDB: Shutdown completed; log sequence number 20 1033231499
170129  3:49:08 [Note] /usr/libexec/mysqld: Shutdown complete

170129 03:49:08 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170129 08:40:51 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170129  8:40:51  InnoDB: Initializing buffer pool, size = 8.0M
170129  8:40:51  InnoDB: Completed initialization of buffer pool
170129  8:40:51  InnoDB: Started; log sequence number 20 1033231499
170129  8:40:51 [Note] Event Scheduler: Loaded 0 events
170129  8:40:51 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170130  3:28:02 [Note] /usr/libexec/mysqld: Normal shutdown

170130  3:28:02 [Note] Event Scheduler: Purging the queue. 0 events
170130  3:28:04  InnoDB: Starting shutdown...
170130  3:28:08  InnoDB: Shutdown completed; log sequence number 20 1275828139
170130  3:28:08 [Note] /usr/libexec/mysqld: Shutdown complete

170130 03:28:08 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170130 08:32:04 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170130  8:32:04  InnoDB: Initializing buffer pool, size = 8.0M
170130  8:32:04  InnoDB: Completed initialization of buffer pool
170130  8:32:05  InnoDB: Started; log sequence number 20 1275828139
170130  8:32:05 [Note] Event Scheduler: Loaded 0 events
170130  8:32:05 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution


same Here

Code: [Select]

161220 12:54:23 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
161220 12:54:23  InnoDB: Initializing buffer pool, size = 8.0M
161220 12:54:23  InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
161220 12:54:23  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
161220 12:54:23  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
161220 12:54:23  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./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: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
161220 12:54:23  InnoDB: Started; log sequence number 0 0
161220 12:54:23 [Note] Event Scheduler: Loaded 0 events
161220 12:54:23 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
161220 12:54:24 [Note] /usr/libexec/mysqld: Normal shutdown

161220 12:54:24 [Note] Event Scheduler: Purging the queue. 0 events
161220 12:54:24  InnoDB: Starting shutdown...
161220 12:54:28  InnoDB: Shutdown completed; log sequence number 0 44233
161220 12:54:28 [Note] /usr/libexec/mysqld: Shutdown complete

161220 12:54:28 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
161220 12:54:29 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
161220 12:54:29  InnoDB: Initializing buffer pool, size = 8.0M
161220 12:54:29  InnoDB: Completed initialization of buffer pool
161220 12:54:29  InnoDB: Started; log sequence number 0 44233
161220 12:54:29 [Note] Event Scheduler: Loaded 0 events
161220 12:54:29 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
161220 13:13:22 [Note] /usr/libexec/mysqld: Normal shutdown

161220 13:13:22 [Note] Event Scheduler: Purging the queue. 0 events
161220 13:13:22  InnoDB: Starting shutdown...
161220 13:13:26  InnoDB: Shutdown completed; log sequence number 0 103628
161220 13:13:26 [Note] /usr/libexec/mysqld: Shutdown complete

161220 13:13:26 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
161220 13:14:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
161220 13:14:01  InnoDB: Initializing buffer pool, size = 8.0M
161220 13:14:01  InnoDB: Completed initialization of buffer pool
161220 13:14:01  InnoDB: Started; log sequence number 0 103628
161220 13:14:01 [Note] Event Scheduler: Loaded 0 events
161220 13:14:01 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170107 23:23:19 [Note] /usr/libexec/mysqld: Normal shutdown

170107 23:23:19 [Note] Event Scheduler: Purging the queue. 0 events
170107 23:23:19  InnoDB: Starting shutdown...
170107 23:23:20  InnoDB: Shutdown completed; log sequence number 0 103648
170107 23:23:20 [Note] /usr/libexec/mysqld: Shutdown complete

170107 23:23:20 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170107 23:23:58 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170107 23:23:58  InnoDB: Initializing buffer pool, size = 8.0M
170107 23:23:58  InnoDB: Completed initialization of buffer pool
170107 23:23:59  InnoDB: Started; log sequence number 0 103648
170107 23:23:59 [Note] Event Scheduler: Loaded 0 events
170107 23:23:59 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170117 10:03:21 [Note] /usr/libexec/mysqld: Normal shutdown

170117 10:03:21 [Note] Event Scheduler: Purging the queue. 0 events
170117 10:03:21  InnoDB: Starting shutdown...
170117 10:03:26  InnoDB: Shutdown completed; log sequence number 0 429670741
170117 10:03:26 [Note] /usr/libexec/mysqld: Shutdown complete

170117 11:03:26 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170117 11:03:27 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170117 11:03:27  InnoDB: Initializing buffer pool, size = 8.0M
170117 11:03:27  InnoDB: Completed initialization of buffer pool
170117 11:03:27  InnoDB: Started; log sequence number 0 429670741
170117 11:03:27 [Note] Event Scheduler: Loaded 0 events
170117 11:03:27 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170118  3:34:06 [Note] /usr/libexec/mysqld: Normal shutdown

170118  3:34:06 [Note] Event Scheduler: Purging the queue. 0 events
170118  3:34:08  InnoDB: Starting shutdown...
170118  3:34:12  InnoDB: Shutdown completed; log sequence number 0 491226394
170118  3:34:12 [Note] /usr/libexec/mysqld: Shutdown complete

170118 03:34:12 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170118 07:31:11 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170118  7:31:11  InnoDB: Initializing buffer pool, size = 8.0M
170118  7:31:11  InnoDB: Completed initialization of buffer pool
170118  7:31:11  InnoDB: Started; log sequence number 0 491226394
170118  7:31:11 [Note] Event Scheduler: Loaded 0 events
170118  7:31:11 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170119  3:21:03 [Note] /usr/libexec/mysqld: Normal shutdown

170119  3:21:03 [Note] Event Scheduler: Purging the queue. 0 events
170119  3:21:05  InnoDB: Starting shutdown...
170119  3:21:06  InnoDB: Shutdown completed; log sequence number 0 497992165
170119  3:21:06 [Note] /usr/libexec/mysqld: Shutdown complete

170119 03:21:06 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170119 07:56:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170119  7:56:14  InnoDB: Initializing buffer pool, size = 8.0M
170119  7:56:14  InnoDB: Completed initialization of buffer pool
170119  7:56:14  InnoDB: Started; log sequence number 0 497992165
170119  7:56:14 [Note] Event Scheduler: Loaded 0 events
170119  7:56:14 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170120  3:18:05 [Note] /usr/libexec/mysqld: Normal shutdown

170120  3:18:05 [Note] Event Scheduler: Purging the queue. 0 events
170120  3:18:07  InnoDB: Starting shutdown...
170120  3:18:11  InnoDB: Shutdown completed; log sequence number 0 512001736
170120  3:18:11 [Note] /usr/libexec/mysqld: Shutdown complete

170120 03:18:11 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170120 07:12:41 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170120  7:12:41  InnoDB: Initializing buffer pool, size = 8.0M
170120  7:12:41  InnoDB: Completed initialization of buffer pool
170120  7:12:41  InnoDB: Started; log sequence number 0 512001736
170120  7:12:41 [Note] Event Scheduler: Loaded 0 events
170120  7:12:41 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170121  3:29:02 [Note] /usr/libexec/mysqld: Normal shutdown

170121  3:29:02 [Note] Event Scheduler: Purging the queue. 0 events
170121  3:29:04  InnoDB: Starting shutdown...
170121  3:29:05  InnoDB: Shutdown completed; log sequence number 0 576508052
170121  3:29:05 [Note] /usr/libexec/mysqld: Shutdown complete

170121 03:29:05 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170121 09:22:50 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170121  9:22:50  InnoDB: Initializing buffer pool, size = 8.0M
170121  9:22:50  InnoDB: Completed initialization of buffer pool
170121  9:22:50  InnoDB: Started; log sequence number 0 576508052
170121  9:22:50 [Note] Event Scheduler: Loaded 0 events
170121  9:22:50 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170122  3:24:02 [Note] /usr/libexec/mysqld: Normal shutdown

170122  3:24:02 [Note] Event Scheduler: Purging the queue. 0 events
170122  3:24:04  InnoDB: Starting shutdown...
170122  3:24:07  InnoDB: Shutdown completed; log sequence number 0 584195826
170122  3:24:07 [Note] /usr/libexec/mysqld: Shutdown complete

170122 03:24:07 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170122 16:26:16 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170122 16:26:16  InnoDB: Initializing buffer pool, size = 8.0M
170122 16:26:16  InnoDB: Completed initialization of buffer pool
170122 16:26:16  InnoDB: Started; log sequence number 0 584195826
170122 16:26:16 [Note] Event Scheduler: Loaded 0 events
170122 16:26:16 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170123  3:49:01 [Note] /usr/libexec/mysqld: Normal shutdown

170123  3:49:01 [Note] Event Scheduler: Purging the queue. 0 events
170123  3:49:03  InnoDB: Starting shutdown...
170123  3:49:05  InnoDB: Shutdown completed; log sequence number 0 595161537
170123  3:49:05 [Note] /usr/libexec/mysqld: Shutdown complete

170123 03:49:05 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170123 09:27:47 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170123  9:27:47  InnoDB: Initializing buffer pool, size = 8.0M
170123  9:27:47  InnoDB: Completed initialization of buffer pool
170123  9:27:47  InnoDB: Started; log sequence number 0 595161537
170123  9:27:47 [Note] Event Scheduler: Loaded 0 events
170123  9:27:47 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170124  3:27:01 [Note] /usr/libexec/mysqld: Normal shutdown

170124  3:27:01 [Note] Event Scheduler: Purging the queue. 0 events
170124  3:27:03  InnoDB: Starting shutdown...
170124  3:27:05  InnoDB: Shutdown completed; log sequence number 0 598140560
170124  3:27:05 [Note] /usr/libexec/mysqld: Shutdown complete

170124 03:27:05 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170124 07:48:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170124  7:48:52  InnoDB: Initializing buffer pool, size = 8.0M
170124  7:48:52  InnoDB: Completed initialization of buffer pool
170124  7:48:52  InnoDB: Started; log sequence number 0 598140560
170124  7:48:52 [Note] Event Scheduler: Loaded 0 events
170124  7:48:52 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170124 11:47:09 [Note] /usr/libexec/mysqld: Normal shutdown

170124 11:47:09 [Note] Event Scheduler: Purging the queue. 0 events
170124 11:47:09  InnoDB: Starting shutdown...
170124 11:47:14  InnoDB: Shutdown completed; log sequence number 0 598513357
170124 11:47:14 [Note] /usr/libexec/mysqld: Shutdown complete

170124 11:47:14 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170124 11:49:18 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170124 11:49:18  InnoDB: Initializing buffer pool, size = 8.0M
170124 11:49:18  InnoDB: Completed initialization of buffer pool
170124 11:49:18  InnoDB: Started; log sequence number 0 598513357
170124 11:49:18 [Note] Event Scheduler: Loaded 0 events
170124 11:49:18 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170125  3:26:02 [Note] /usr/libexec/mysqld: Normal shutdown

170125  3:26:02 [Note] Event Scheduler: Purging the queue. 0 events
170125  3:26:04  InnoDB: Starting shutdown...
170125  3:26:07  InnoDB: Shutdown completed; log sequence number 0 600676808
170125  3:26:07 [Note] /usr/libexec/mysqld: Shutdown complete

170125 03:26:07 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170125 07:19:54 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170125  7:19:54  InnoDB: Initializing buffer pool, size = 8.0M
170125  7:19:54  InnoDB: Completed initialization of buffer pool
170125  7:19:54  InnoDB: Started; log sequence number 0 600676808
170125  7:19:54 [Note] Event Scheduler: Loaded 0 events
170125  7:19:54 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170126  3:39:02 [Note] /usr/libexec/mysqld: Normal shutdown

170126  3:39:02 [Note] Event Scheduler: Purging the queue. 0 events
170126  3:39:04  InnoDB: Starting shutdown...
170126  3:39:07  InnoDB: Shutdown completed; log sequence number 0 612047283
170126  3:39:07 [Note] /usr/libexec/mysqld: Shutdown complete

170126 03:39:07 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170126 07:02:07 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170126  7:02:08  InnoDB: Initializing buffer pool, size = 8.0M
170126  7:02:08  InnoDB: Completed initialization of buffer pool
170126  7:02:08  InnoDB: Started; log sequence number 0 612047283
170126  7:02:08 [Note] Event Scheduler: Loaded 0 events
170126  7:02:08 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170127  3:16:04 [Note] /usr/libexec/mysqld: Normal shutdown

170127  3:16:04 [Note] Event Scheduler: Purging the queue. 0 events
170127  3:16:06  InnoDB: Starting shutdown...
170127  3:16:09  InnoDB: Shutdown completed; log sequence number 0 627390071
170127  3:16:09 [Note] /usr/libexec/mysqld: Shutdown complete

170127 03:16:09 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170127 09:03:02 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170127  9:03:02  InnoDB: Initializing buffer pool, size = 8.0M
170127  9:03:02  InnoDB: Completed initialization of buffer pool
170127  9:03:02  InnoDB: Started; log sequence number 0 627390071
170127  9:03:02 [Note] Event Scheduler: Loaded 0 events
170127  9:03:02 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170128  3:14:02 [Note] /usr/libexec/mysqld: Normal shutdown

170128  3:14:02 [Note] Event Scheduler: Purging the queue. 0 events
170128  3:14:04  InnoDB: Starting shutdown...
170128  3:14:07  InnoDB: Shutdown completed; log sequence number 0 834239967
170128  3:14:07 [Note] /usr/libexec/mysqld: Shutdown complete

170128 03:14:07 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170128 09:03:02 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170128  9:03:02  InnoDB: Initializing buffer pool, size = 8.0M
170128  9:03:02  InnoDB: Completed initialization of buffer pool
170128  9:03:02  InnoDB: Started; log sequence number 0 834239967
170128  9:03:02 [Note] Event Scheduler: Loaded 0 events
170128  9:03:02 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170129  3:19:02 [Note] /usr/libexec/mysqld: Normal shutdown

170129  3:19:02 [Note] Event Scheduler: Purging the queue. 0 events
170129  3:19:04  InnoDB: Starting shutdown...
170129  3:19:08  InnoDB: Shutdown completed; log sequence number 0 840353381
170129  3:19:08 [Note] /usr/libexec/mysqld: Shutdown complete

170129 03:19:08 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170129 09:03:02 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170129  9:03:02  InnoDB: Initializing buffer pool, size = 8.0M
170129  9:03:02  InnoDB: Completed initialization of buffer pool
170129  9:03:02  InnoDB: Started; log sequence number 0 840353381
170129  9:03:02 [Note] Event Scheduler: Loaded 0 events
170129  9:03:02 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170129 22:01:30 [Note] /usr/libexec/mysqld: Normal shutdown

170129 22:01:30 [Note] Event Scheduler: Purging the queue. 0 events
170129 22:01:30  InnoDB: Starting shutdown...
170129 22:01:33  InnoDB: Shutdown completed; log sequence number 0 845804581
170129 22:01:33 [Note] /usr/libexec/mysqld: Shutdown complete

170129 22:01:33 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170129 22:01:34 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170129 22:01:34  InnoDB: Initializing buffer pool, size = 8.0M
170129 22:01:34  InnoDB: Completed initialization of buffer pool
170129 22:01:34  InnoDB: Started; log sequence number 0 845804581
170129 22:01:34 [Note] Event Scheduler: Loaded 0 events
170129 22:01:34 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
170129 22:01:56 [Note] /usr/libexec/mysqld: Normal shutdown

170129 22:01:56 [Note] Event Scheduler: Purging the queue. 0 events
170129 22:01:56  InnoDB: Starting shutdown...
170129 22:01:59  InnoDB: Shutdown completed; log sequence number 0 845809291
170129 22:01:59 [Note] /usr/libexec/mysqld: Shutdown complete

170129 22:01:59 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170129 22:02:00 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170129 22:02:00  InnoDB: Initializing buffer pool, size = 8.0M
170129 22:02:00  InnoDB: Completed initialization of buffer pool
170129 22:02:00  InnoDB: Started; log sequence number 0 845809291
170129 22:02:00 [Note] Event Scheduler: Loaded 0 events
170129 22:02:00 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution


i think it a problem with upgrade packge. ... i dont know why

i think it a problem with upgrade packge. ... i dont know why

new
in mysqld.log

Code: [Select]

............
Modified db pages  8
Pending reads 0
Pending writes: LRU 0, flush list 8, single page 0
Pages read 20832, created 3918, written 57013
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
--------------
ROW OPERATIONS
--------------
8 queries inside InnoDB, 3 queries in queue
4 read views open inside InnoDB
Main thread process no. 14011, id 139946155288320, state: flushing buffer pool pages
Number of rows inserted 163203, updated 7829, deleted 4928, read 81771472
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================

=====================================
170202  8:37:17 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 20 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 5406, signal count 5381
Mutex spin waits 0, rounds 29197, OS waits 560
RW-shared spins 8522, OS waits 4182; RW-excl spins 681, OS waits 624
------------
TRANSACTIONS
------------
Trx id counter 0 5269057
Purge done for trx's n:o < 0 5268797 undo n:o < 0 0
History list length 6
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0 5267329, not started, process no 14011, OS thread id 139946276022016
MySQL thread id 15032, query id 2127030 localhost postfix
--------
FILE I/O
--------
I/O thread 0 state: waiting for i/o request (insert buffer thread)
I/O thread 1 state: waiting for i/o request (log thread)
I/O thread 2 state: waiting for i/o request (read thread)
I/O thread 3 state: waiting for i/o request (write thread)
Pending normal aio reads: 0, aio writes: 0,
 ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 0
11250 OS file reads, 72543 OS file writes, 39565 OS fsyncs
0.05 reads/s, 16384 avg bytes/read, 2.50 writes/s, 1.60 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 44, seg size 46,
11785 inserts, 11785 merged recs, 1084 merges
Hash table size 17393, node heap has 3 buffer(s)
223.29 hash searches/s, 385.88 non-hash searches/s
---
LOG
---
Log sequence number 0 947847981
Log flushed up to   0 947847981
Last checkpoint at  0 947726246
0 pending log writes, 0 pending chkp writes
24704 log i/o's done, 1.20 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 22154498; in additional pool allocated 986112
Dictionary memory allocated 1125944
Buffer pool size   512
Free buffers       1
Database pages     508
Modified db pages  20
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 20833, created 3921, written 57095
0.05 reads/s, 0.15 creates/s, 4.10 writes/s
Buffer pool hit rate 1000 / 1000
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Main thread process no. 14011, id 139946155288320, state: sleeping
Number of rows inserted 163214, updated 7843, deleted 5065, read 81937172
0.55 inserts/s, 0.70 updates/s, 6.85 deletes/s, 8284.59 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
InnoDB: ###### Diagnostic info printed to the standard error stream


New? Fix? Or continued problems?

no (reboot) problem from 31/2/2017 until now

today I take an other error
Fatal error: Allowed memory size of ‎134217728 bytes exhausted (tried to allocate ‎12845211 bytes) in /home/foscom/public_html/libraries/joomla/cache/storage/file.php on line 123
and increase the PHP.ini
memory_limit = 256M to fix the above error

Nice, 512mbs

Nice, 512mbs

 Fix? Or continued problems?

no, continued, not fix.

you should create file with function phpinfo() in your domain public_html folder to see which php.ini file you have loaded and what is the limit set there

example: /home/USERNAME/public_html/testphp.php

Code: [Select]

<?php
phpinfo();
?>

you should create file with function phpinfo() in your domain public_html folder to see which php.ini file you have loaded and what is the limit set there

example: /home/USERNAME/public_html/testphp.php

Code: [Select]

<?php
phpinfo();
?>

fotistikadotcom/phpinfo.php