Control Web Panel
WebPanel => CentOS 6 Problems => Topic started by: Vision on July 25, 2016, 09:20:11 AM
-
Hello,
each day when i connect on my panel have this error:
Warning: [obfuscated](): No such file or directory in /usr/local/cwpsrv/htdocs/admin/index.php on line 0
mysqld (pid 10652) is running...
Trying to start mysql server, please wait!
Try to restart CentOS Web Panel with command: service cwpsrv restart
**Check your MySQL root password in: /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf
Could not connect: No such file or directory
and when i open web page have this error: Could not connect to MySQL
Then refresh panel page and all works fine, but all nigth i have site offline.
Thanks.
-
looks like you have some issue with mysql crash, this could be memory related or your site mostly in wordpress case xmlrpc.php is under dos attack.
You should check mysql, messages and apache logs more detailed.
If you don't have experience with linux then you can contact your hosting provider system admin or our managed support to assist you with this issue.
-
Thanks for aswer,
i have new OS and Panel installation on dedicated server with 2GB RAM, and dont have wordprerss site but only little database.
Memory related?
-
the best would be to check the logs when mysql crashed and also to check the other services logs at that time to determinate the cause of the issue.
-
Same problem here
How did you solved the problem?
-
Same problem here
How did you solved the problem?
the best would be to check the logs when mysql crashed and also to check the other services logs at that time to determinate the cause of the issue.
+1
4 days broken server at night...
what a solutions for that?
i´m not alone for that problem... more users have problems
1- I reset Password CWP
2- Reinstall MariaDB
3- Rebuild all Website with Apache
4- Fix Permisions
Not work nothing...
Instalado:
MariaDB-client.x86_64 0:10.1.21-1.el6 MariaDB-common.x86_64 0:10.1.21-1.el6 MariaDB-compat.x86_64 0:10.1.21-1.el6 MariaDB-devel.x86_64 0:10.1.21-1.el6 MariaDB-server.x86_64 0:10.1.21-1.el6 galera.x86_64 0:25.3.19-1.rhel6.el6
-
Up,
Againd down and 0 solution for fix that.
-
Up,
Againd down and 0 solution for fix that.
I try cp /usr/share/mysql/my-huge.cnf /etc/my.cnf and restart for see
-
their will be many reason maybe dos attach or corrupted database, check the log file
-
their will be many reason maybe dos attach or corrupted database, check the log file
The db y thinl it ok i fix all account and i repair / optimized DB with options...
At night again down...omg 6 days down website...
-
their will be many reason maybe dos attach or corrupted database, check the log file
The db y thinl it ok i fix all account and i repair / optimized DB with options...
At night again down...omg 6 days down website...
what is in the log ?
-
their will be many reason maybe dos attach or corrupted database, check the log file
The db y thinl it ok i fix all account and i repair / optimized DB with options...
At night again down...omg 6 days down website...
what is in the log ?
The log i havnt see errors...
What logs need for see? Mysql? Apache? For paste here?
-
mysql log
-
mysql log
Code
170126 16:25:13 mysqld_safe mysqld from pid file /var/lib/mysql/ns3010965.ip-188-165-236.eu.pid ended
170126 16:25:13 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2017-01-26 16:25:13 140260204697632 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
2017-01-26 16:25:13 140260204697632 [Note] /usr/sbin/mysqld (mysqld 10.1.21-MariaDB) starting as process 3130 ...
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: The InnoDB memory heap is disabled
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: Using Linux native AIO
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: Using SSE crc32 instructions
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: Completed initialization of buffer pool
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: Highest supported file format is Barracuda.
2017-01-26 16:25:14 140260204697632 [Note] InnoDB: 128 rollback segment(s) are active.
2017-01-26 16:25:14 140260204697632 [Note] InnoDB: Waiting for purge to start
2017-01-26 16:25:14 140260204697632 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 10076517483
2017-01-26 16:25:14 140259140540160 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-01-26 16:25:14 140260204697632 [Note] Plugin 'FEEDBACK' is disabled.
2017-01-26 16:25:14 140260204697632 [Note] Server socket created on IP: '::'.
2017-01-26 16:25:14 140260204697632 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.1.21-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
2017-01-27 3:21:01 140258884406016 [Note] /usr/sbin/mysqld: Normal shutdown
[b]
2017-01-27 3:21:01 140258884406016 [Note] Event Scheduler: Purging the queue. 0 events
2017-01-27 3:21:02 140259119560448 [Note] InnoDB: FTS optimize thread exiting.
2017-01-27 3:21:02 140258884406016 [Note] InnoDB: Starting shutdown...
2017-01-27 3:21:02 140258884406016 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
170127 03:21:03 mysqld_safe A mysqld process already exists
2017-01-27 3:21:04 140258884406016 [Note] InnoDB: Shutdown completed; log sequence number 10095605593
2017-01-27 3:21:04 140258884406016 [Note] /usr/sbin/mysqld: Shutdown complete
170127 03:21:04 mysqld_safe mysqld from pid file /var/lib/mysql/ns3010965.ip-188-165-236.eu.pid ended
[/b]
170127 09:59:21 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2017-01-27 9:59:21 140316613531680 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
2017-01-27 9:59:21 140316613531680 [Note] /usr/sbin/mysqld (mysqld 10.1.21-MariaDB) starting as process 29701 ...
2017-01-27 9:59:21 140316613531680 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-01-27 9:59:21 140316613531680 [Note] InnoDB: The InnoDB memory heap is disabled
2017-01-27 9:59:21 140316613531680 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-01-27 9:59:21 140316613531680 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-01-27 9:59:21 140316613531680 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-01-27 9:59:21 140316613531680 [Note] InnoDB: Using Linux native AIO
2017-01-27 9:59:21 140316613531680 [Note] InnoDB: Using SSE crc32 instructions
2017-01-27 9:59:21 140316613531680 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-01-27 9:59:21 140316613531680 [Note] InnoDB: Completed initialization of buffer pool
2017-01-27 9:59:21 140315719612160 [Warning] InnoDB: Setting thread 29708 nice to 0 failed, current nice 10, errno 13
2017-01-27 9:59:21 140315730102016 [Warning] InnoDB: Setting thread 29707 nice to 0 failed, current nice 10, errno 13
2017-01-27 9:59:21 140315688142592 [Warning] InnoDB: Setting thread 29711 nice to 0 failed, current nice 10, errno 13
2017-01-27 9:59:21 140315740591872 [Warning] InnoDB: Setting thread 29706 nice to 0 failed, current nice 10, errno 13
2017-01-27 9:59:21 140315698632448 [Warning] InnoDB: Setting thread 29710 nice to 0 failed, current nice 10, errno 13
2017-01-27 9:59:21 140315751081728 [Warning] InnoDB: Setting thread 29705 nice to 0 failed, current nice 10, errno 13
2017-01-27 9:59:21 140315669268224 [Warning] InnoDB: Setting thread 29712 nice to 0 failed, current nice 10, errno 13
2017-01-27 9:59:21 140315709122304 [Warning] InnoDB: Setting thread 29709 nice to 0 failed, current nice 10, errno 13
2017-01-27 9:59:21 140315612673792 [Warning] InnoDB: Setting thread 29713 nice to 0 failed, current nice 10, errno 13
all night 3-4
-
mysql log
Code
170126 16:25:13 mysqld_safe mysqld from pid file /var/lib/mysql/ns3010965.ip-188-165-236.eu.pid ended
170126 16:25:13 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2017-01-26 16:25:13 140260204697632 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
2017-01-26 16:25:13 140260204697632 [Note] /usr/sbin/mysqld (mysqld 10.1.21-MariaDB) starting as process 3130 ...
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: The InnoDB memory heap is disabled
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: Using Linux native AIO
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: Using SSE crc32 instructions
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: Completed initialization of buffer pool
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: Highest supported file format is Barracuda.
2017-01-26 16:25:14 140260204697632 [Note] InnoDB: 128 rollback segment(s) are active.
2017-01-26 16:25:14 140260204697632 [Note] InnoDB: Waiting for purge to start
2017-01-26 16:25:14 140260204697632 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 10076517483
2017-01-26 16:25:14 140259140540160 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-01-26 16:25:14 140260204697632 [Note] Plugin 'FEEDBACK' is disabled.
2017-01-26 16:25:14 140260204697632 [Note] Server socket created on IP: '::'.
2017-01-26 16:25:14 140260204697632 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.1.21-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
2017-01-27 3:21:01 140258884406016 [Note] /usr/sbin/mysqld: Normal shutdown
[b]
2017-01-27 3:21:01 140258884406016 [Note] Event Scheduler: Purging the queue. 0 events
2017-01-27 3:21:02 140259119560448 [Note] InnoDB: FTS optimize thread exiting.
2017-01-27 3:21:02 140258884406016 [Note] InnoDB: Starting shutdown...
2017-01-27 3:21:02 140258884406016 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
170127 03:21:03 mysqld_safe A mysqld process already exists
2017-01-27 3:21:04 140258884406016 [Note] InnoDB: Shutdown completed; log sequence number 10095605593
2017-01-27 3:21:04 140258884406016 [Note] /usr/sbin/mysqld: Shutdown complete
170127 03:21:04 mysqld_safe mysqld from pid file /var/lib/mysql/ns3010965.ip-188-165-236.eu.pid ended
[/b]
170127 09:59:21 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2017-01-27 9:59:21 140316613531680 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
2017-01-27 9:59:21 140316613531680 [Note] /usr/sbin/mysqld (mysqld 10.1.21-MariaDB) starting as process 29701 ...
2017-01-27 9:59:21 140316613531680 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-01-27 9:59:21 140316613531680 [Note] InnoDB: The InnoDB memory heap is disabled
2017-01-27 9:59:21 140316613531680 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-01-27 9:59:21 140316613531680 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-01-27 9:59:21 140316613531680 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-01-27 9:59:21 140316613531680 [Note] InnoDB: Using Linux native AIO
2017-01-27 9:59:21 140316613531680 [Note] InnoDB: Using SSE crc32 instructions
2017-01-27 9:59:21 140316613531680 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-01-27 9:59:21 140316613531680 [Note] InnoDB: Completed initialization of buffer pool
2017-01-27 9:59:21 140315719612160 [Warning] InnoDB: Setting thread 29708 nice to 0 failed, current nice 10, errno 13
2017-01-27 9:59:21 140315730102016 [Warning] InnoDB: Setting thread 29707 nice to 0 failed, current nice 10, errno 13
2017-01-27 9:59:21 140315688142592 [Warning] InnoDB: Setting thread 29711 nice to 0 failed, current nice 10, errno 13
2017-01-27 9:59:21 140315740591872 [Warning] InnoDB: Setting thread 29706 nice to 0 failed, current nice 10, errno 13
2017-01-27 9:59:21 140315698632448 [Warning] InnoDB: Setting thread 29710 nice to 0 failed, current nice 10, errno 13
2017-01-27 9:59:21 140315751081728 [Warning] InnoDB: Setting thread 29705 nice to 0 failed, current nice 10, errno 13
2017-01-27 9:59:21 140315669268224 [Warning] InnoDB: Setting thread 29712 nice to 0 failed, current nice 10, errno 13
2017-01-27 9:59:21 140315709122304 [Warning] InnoDB: Setting thread 29709 nice to 0 failed, current nice 10, errno 13
2017-01-27 9:59:21 140315612673792 [Warning] InnoDB: Setting thread 29713 nice to 0 failed, current nice 10, errno 13
all night 3-4
Today not down, fix?
-
same problem here for 6 days in a row...
same hour when i use a user_backup script with a cronjob.
-
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
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
............
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
<?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
<?php
phpinfo();
?>
fotistikadotcom/phpinfo.php