Database keep crushing after few hours.

SharkServers said:
With regards to MySQL running out of memory, a couple of adjustments to my.cnf could help. Depending on how much RAM your VPS has, try replacing your /etc/my.cnf with one from /usr/share/mysql - there should be multiple template files (such as my-medium.cnf, my-huge.cnf, etc) with each pre-configured for servers with different amount of resources.
Click to expand...
With what configuration?
 
Advertise on BHW
So do you all think he's running out of memory do to the virtual memory assigned to him or is he limited due to his mysql settings? Hope I worded that right.
 
headspace said:
So do you all think he's running out of memory do to the virtual memory assigned to him or is he limited due to his mysql settings? Hope I worded that right.
Click to expand...
That would be my guess, i mean running out of ram..
 
I had 150-250mb free only (which wasn't enough to operate) ... Disabling my antivirus freed an additional ~500mb

Now the site is running 10+ hours and I will wait for 24+ hours run and then will take care of all the database recommendations

If you want I will report back.

After that I will upgrade to 4gb with 2 cores
 
roki4ka said:
I had 150-250mb free only (which wasn't enough to operate) ... Disabling my antivirus freed an additional ~500mb

Now the site is running 10+ hours and I will wait for 24+ hours run and then will take care of all the database recommendations

If you want I will report back.
Click to expand...
Haha knew it.. make a swapfile n u will be good to go..
 
The site is still up, without crashes almost 24 hours.

Today I will take care of the settings and will learn more how to create such swap file.
 
So... I want to cry and to kill something or eat it alive in the same time

Two days ago the server started crashing again, after 3+ weeks uptime.

Any tips are welcome.

Could be a memory leak? Or maybe the database doesn't close the processes?

Here is some info

ua2sMUwwQ0WO3tMSlnuf_A.jpeg


n2kAIWuDSEGGMxeQYQz_XA.jpeg


Here is the error log of the mysql and httpd

Code: 
InnoDB: buffer...
170720  1:51:44  InnoDB: Waiting for the background threads to start
170720  1:51:46 Percona XtraDB (http://www.percona.com) 5.5.49-MariaDB-38.0 started; log sequence number 7315175
170720  1:51:52 [Note] Plugin 'FEEDBACK' is disabled.
170720  1:52:23 [Note] Server socket created on IP: '::1'.
170720  1:53:19 [Note] Event Scheduler: Loaded 0 events
170720  1:53:20 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.52-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
170720  2:06:16 [ERROR] mysqld: Table './admin_wp865/wphj_loginizer_logs' is marked as crashed and should be repaired
170720  2:06:17 [Warning] Checking table:   './admin_wp865/wphj_loginizer_logs'
170720  2:08:10 [ERROR] mysqld: Table './admin_wp865/wphj_postmeta' is marked as crashed and should be repaired
170720  2:08:12 [Warning] Checking table:   './admin_wp865/wphj_postmeta'
170720 02:15:52 mysqld_safe Number of processes running now: 0
170720 02:15:54 mysqld_safe mysqld restarted
170720  2:17:21 [Note] /usr/libexec/mysqld (mysqld 5.5.52-MariaDB) starting as process 30091 ...
170720  2:17:24 [Warning] Could not increase number of max_open_files to more than 1024 (request: 10261)
170720  2:18:10 InnoDB: The InnoDB memory heap is disabled
170720  2:18:23 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170720  2:18:23 InnoDB: Compressed tables use zlib 1.2.7
170720  2:18:23 InnoDB: Using Linux native AIO
170720  2:18:34 InnoDB: Initializing buffer pool, size = 128.0M
170720  2:18:39 InnoDB: Completed initialization of buffer pool
170720  2:19:03 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!
170720  2:19:05  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...
170720  2:24:58 Percona XtraDB (http://www.percona.com) 5.5.49-MariaDB-38.0 started; log sequence number 7315175
170720  2:25:16 [Note] Plugin 'FEEDBACK' is disabled.
170720  2:28:15 [Note] Server socket created on IP: '::1'.
170720  2:29:27 [Note] Event Scheduler: Loaded 0 events
170720  2:29:28 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.52-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
170720  2:30:45 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170720  2:30:46 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170720  2:30:46 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170720  2:30:46 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170720  2:30:46 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170720  2:30:46 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170720  2:30:46 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170720  2:30:46 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170720  2:30:46 [Warning] Checking table:   './admin_wp865/wphj_options'
170720 02:39:03 mysqld_safe Number of processes running now: 0
170720 02:39:05 mysqld_safe mysqld restarted
170720  2:39:17 [Note] /usr/libexec/mysqld (mysqld 5.5.52-MariaDB) starting as process 30532 ...
170720  2:39:17 [Warning] Could not increase number of max_open_files to more than 1024 (request: 10261)
170720  2:39:20 InnoDB: The InnoDB memory heap is disabled
170720  2:39:20 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170720  2:39:20 InnoDB: Compressed tables use zlib 1.2.7
170720  2:39:20 InnoDB: Using Linux native AIO
170720  2:39:21 InnoDB: Initializing buffer pool, size = 128.0M
170720  2:39:21 InnoDB: Completed initialization of buffer pool
170720  2:39:22 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!
170720  2:39:22  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...
170720  2:41:25  InnoDB: Waiting for the background threads to start
170720  2:41:28 Percona XtraDB (http://www.percona.com) 5.5.49-MariaDB-38.0 started; log sequence number 7315175
170720  2:45:23 [Note] Plugin 'FEEDBACK' is disabled.
170720  2:45:36 [Note] Server socket created on IP: '::1'.
170720  2:46:28 [Note] Event Scheduler: Loaded 0 events
170720  2:46:29 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.52-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
170720 03:09:08 mysqld_safe Number of processes running now: 0
170720 03:09:24 mysqld_safe mysqld restarted
170720  3:10:44 [Note] /usr/libexec/mysqld (mysqld 5.5.52-MariaDB) starting as process 31031 ...
170720  3:10:48 [Warning] Could not increase number of max_open_files to more than 1024 (request: 10261)
170720  3:11:17 InnoDB: The InnoDB memory heap is disabled
170720  3:11:18 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170720  3:11:18 InnoDB: Compressed tables use zlib 1.2.7
170720  3:11:18 InnoDB: Using Linux native AIO
170720  3:11:19 InnoDB: Initializing buffer pool, size = 128.0M
170720  3:11:19 InnoDB: Completed initialization of buffer pool
170720  3:11:32 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!
170720  3:11: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...
170720  3:16:27  InnoDB: Waiting for the background threads to start
170720  3:16:29 Percona XtraDB (http://www.percona.com) 5.5.49-MariaDB-38.0 started; log sequence number 7315175
170720  3:16:30 [Note] Plugin 'FEEDBACK' is disabled.
170720  3:16:34 [Note] Server socket created on IP: '::1'.
170720  3:17:53 [Note] Event Scheduler: Loaded 0 events
170720  3:17:54 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.52-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
170720  3:19:42 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170720  3:19:46 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170720  3:19:46 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170720  3:19:46 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170720  3:19:46 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170720  3:19:46 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170720  3:19:46 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170720  3:19:46 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170720  3:19:46 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170720  3:20:01 [Warning] Checking table:   './admin_wp865/wphj_options'
170720 03:37:02 mysqld_safe Number of processes running now: 0
170720 03:37:04 mysqld_safe mysqld restarted
170720  3:37:13 [Note] /usr/libexec/mysqld (mysqld 5.5.52-MariaDB) starting as process 31362 ...
170720  3:37:13 [Warning] Could not increase number of max_open_files to more than 1024 (request: 10261)
170720  3:37:30 InnoDB: The InnoDB memory heap is disabled
170720  3:37:41 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170720  3:37:41 InnoDB: Compressed tables use zlib 1.2.7
170720  3:37:41 InnoDB: Using Linux native AIO
170720  3:37:42 InnoDB: Initializing buffer pool, size = 128.0M
170720  3:38:02 InnoDB: Completed initialization of buffer pool
170720  3:38:40 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!
170720  3:38: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...
170720  3:48:06  InnoDB: Waiting for the background threads to start
170720  3:48:08 Percona XtraDB (http://www.percona.com) 5.5.49-MariaDB-38.0 started; log sequence number 7315175
170720  3:48:09 [Note] Plugin 'FEEDBACK' is disabled.
170720  3:48:13 [Note] Server socket created on IP: '::1'.
170720  3:52:16 [Note] Event Scheduler: Loaded 0 events
170720  3:52:23 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.52-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
170720 04:06:34 mysqld_safe Number of processes running now: 0
170720 04:06:36 mysqld_safe mysqld restarted
170720  4:08:06 [Note] /usr/libexec/mysqld (mysqld 5.5.52-MariaDB) starting as process 31669 ...
170720  4:08:10 [Warning] Could not increase number of max_open_files to more than 1024 (request: 10261)
170720  4:08:52 InnoDB: The InnoDB memory heap is disabled
170720  4:09:02 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170720  4:09:02 InnoDB: Compressed tables use zlib 1.2.7
170720  4:09:03 InnoDB: Using Linux native AIO
170720  4:09:29 InnoDB: Initializing buffer pool, size = 128.0M
170720  4:09:46 InnoDB: Completed initialization of buffer pool
170720  4:10:06 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!
170720  4:10:09  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...
170720  4:14:56  InnoDB: Waiting for the background threads to start
170720  4:14:58 Percona XtraDB (http://www.percona.com) 5.5.49-MariaDB-38.0 started; log sequence number 7315175
170720  4:15:10 [Note] Plugin 'FEEDBACK' is disabled.
170720  4:16:01 [Note] Server socket created on IP: '::1'.
170720  4:18:42 [Note] Event Scheduler: Loaded 0 events
170720  4:18:43 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.52-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
170720 04:51:30 mysqld_safe Number of processes running now: 0
170720 04:53:34 mysqld_safe mysqld restarted
170720  4:54:04 [Note] /usr/libexec/mysqld (mysqld 5.5.52-MariaDB) starting as process 31973 ...
170720  4:54:04 [Warning] Could not increase number of max_open_files to more than 1024 (request: 10261)
170720  4:54:08 InnoDB: The InnoDB memory heap is disabled
170720  4:54:08 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170720  4:54:08 InnoDB: Compressed tables use zlib 1.2.7
170720  4:54:08 InnoDB: Using Linux native AIO
170720  4:54:08 InnoDB: Initializing buffer pool, size = 128.0M
170720  4:54:09 InnoDB: Completed initialization of buffer pool
170720  4:54:10 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!
170720  4:54:12  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...
170720  5:00:37  InnoDB: Waiting for the background threads to start
170720  5:00:39 Percona XtraDB (http://www.percona.com) 5.5.49-MariaDB-38.0 started; log sequence number 7315175
170720  5:03:19 [Note] Plugin 'FEEDBACK' is disabled.
170720  5:03:28 [Note] Server socket created on IP: '::1'.
170720  5:04:02 [Note] Event Scheduler: Loaded 0 events
170720  5:04:02 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.52-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
170720 05:25:50 mysqld_safe Number of processes running now: 0
170720 05:27:11 mysqld_safe mysqld restarted
170720  5:30:05 [Note] /usr/libexec/mysqld (mysqld 5.5.52-MariaDB) starting as process 32312 ...
170720  5:30:06 [Warning] Could not increase number of max_open_files to more than 1024 (request: 10261)
170720  5:30:29 InnoDB: The InnoDB memory heap is disabled
170720  5:30:29 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170720  5:30:29 InnoDB: Compressed tables use zlib 1.2.7
170720  5:30:29 InnoDB: Using Linux native AIO
170720  5:30:30 InnoDB: Initializing buffer pool, size = 128.0M
170720  5:30:30 InnoDB: Completed initialization of buffer pool
170720  5:30:35 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!
170720  5:30: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...
170720  5:42:21  InnoDB: Waiting for the background threads to start
170720  5:42:26 Percona XtraDB (http://www.percona.com) 5.5.49-MariaDB-38.0 started; log sequence number 7315175
170720  5:43:07 [Note] Plugin 'FEEDBACK' is disabled.
170720  5:43:26 [Note] Server socket created on IP: '::1'.
170720  5:44:10 [Note] Event Scheduler: Loaded 0 events
170720  5:44:10 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.52-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
170720  5:45:24 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170720  5:45:25 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170720  5:45:25 [Warning] Checking table:   './admin_wp865/wphj_options'
170720  5:59:21 [ERROR] mysqld: Table './admin_wp865/wphj_postmeta' is marked as crashed and should be repaired
170720  5:59:22 [ERROR] mysqld: Table './admin_wp865/wphj_postmeta' is marked as crashed and should be repaired
170720  5:59:22 [ERROR] mysqld: Table './admin_wp865/wphj_postmeta' is marked as crashed and should be repaired
170720  5:59:22 [ERROR] mysqld: Table './admin_wp865/wphj_postmeta' is marked as crashed and should be repaired
170720  5:59:22 [Warning] Checking table:   './admin_wp865/wphj_postmeta'
170720 06:14:02 mysqld_safe Number of processes running now: 0
170720 06:14:03 mysqld_safe mysqld restarted
170720  6:16:52 [Note] /usr/libexec/mysqld (mysqld 5.5.52-MariaDB) starting as process 32766 ...
170720  6:16:54 [Warning] Could not increase number of max_open_files to more than 1024 (request: 10261)
170720  6:17:50 InnoDB: The InnoDB memory heap is disabled
170720  6:17:52 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170720  6:17:52 InnoDB: Compressed tables use zlib 1.2.7
170720  6:17:52 InnoDB: Using Linux native AIO
170720  6:18:10 InnoDB: Initializing buffer pool, size = 128.0M
170720  6:18:11 InnoDB: Completed initialization of buffer pool
170720  6:18:14 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!
170720  6:18:15  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...
170720  6:22:58  InnoDB: Waiting for the background threads to start
170720  6:22:59 Percona XtraDB (http://www.percona.com) 5.5.49-MariaDB-38.0 started; log sequence number 7315175
170720  6:23:02 [Note] Plugin 'FEEDBACK' is disabled.
170720  6:25:29 [Note] Server socket created on IP: '::1'.
170720  6:27:58 [Note] Event Scheduler: Loaded 0 events
170720  6:28:06 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.52-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
170720  6:28:20 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170720  6:28:20 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170720  6:28:20 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170720  6:28:20 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170720  6:28:20 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170720  6:28:20 [Warning] Checking table:   './admin_wp865/wphj_options'
170720 06:43:17 mysqld_safe Number of processes running now: 0
170720 06:43:42 mysqld_safe mysqld restarted
170720  6:46:39 [Note] /usr/libexec/mysqld (mysqld 5.5.52-MariaDB) starting as process 635 ...
170720  6:46:40 [Warning] Could not increase number of max_open_files to more than 1024 (request: 10261)
170720  6:46:44 InnoDB: The InnoDB memory heap is disabled
170720  6:46:44 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170720  6:46:44 InnoDB: Compressed tables use zlib 1.2.7
170720  6:46:44 InnoDB: Using Linux native AIO
170720  6:46:44 InnoDB: Initializing buffer pool, size = 128.0M
170720  6:46:44 InnoDB: Completed initialization of buffer pool
170720  6:46:45 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!
170720  6:46:46  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...
170720  6:50:50  InnoDB: Waiting for the background threads to start
170720  6:50:52 Percona XtraDB (http://www.percona.com) 5.5.49-MariaDB-38.0 started; log sequence number 7315175
170720  6:50:57 [Note] Plugin 'FEEDBACK' is disabled.
170720  6:52:13 [Note] Server socket created on IP: '::1'.
170720  6:55:07 [Note] Event Scheduler: Loaded 0 events
170720  6:55:09 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.52-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
170720  6:55:24 [Note] /usr/libexec/mysqld: Normal shutdown

170720  6:55:27 [Note] Event Scheduler: Purging the queue. 0 events
170720  6:55:42  InnoDB: Starting shutdown...
170720  6:55:45  InnoDB: Shutdown completed; log sequence number 7315175
170720  6:55:46 [Note] /usr/libexec/mysqld: Shutdown complete

170720 06:56:05 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
170720 06:57:07 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170720  6:57:09 [Note] /usr/libexec/mysqld (mysqld 5.5.52-MariaDB) starting as process 3254 ...
170720  6:57:09 [Warning] Could not increase number of max_open_files to more than 1024 (request: 10261)
170720  6:57:10 InnoDB: The InnoDB memory heap is disabled
170720  6:57:10 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170720  6:57:10 InnoDB: Compressed tables use zlib 1.2.7
170720  6:57:10 InnoDB: Using Linux native AIO
170720  6:57:10 InnoDB: Initializing buffer pool, size = 128.0M
170720  6:57:10 InnoDB: Completed initialization of buffer pool
170720  6:57:10 InnoDB: highest supported file format is Barracuda.
170720  6:57:13  InnoDB: Waiting for the background threads to start
170720  6:57:14 Percona XtraDB (http://www.percona.com) 5.5.49-MariaDB-38.0 started; log sequence number 7315175
170720  6:57:14 [Note] Plugin 'FEEDBACK' is disabled.
170720  6:57:14 [Note] Server socket created on IP: '::1'.
170720  6:57:14 [Note] Event Scheduler: Loaded 0 events
170720  6:57:14 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.52-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
170720  6:57:46 [ERROR] mysqld: Table './admin_wp865/wphj_postmeta' is marked as crashed and should be repaired
170720  6:57:46 [ERROR] mysqld: Table './admin_wp865/wphj_postmeta' is marked as crashed and should be repaired
170720  6:57:46 [Warning] Checking table:   './admin_wp865/wphj_postmeta'
170720  6:57:49 [ERROR] mysqld: Table './admin_wp865/wphj_usermeta' is marked as crashed and should be repaired
170720  6:57:49 [Warning] Checking table:   './admin_wp865/wphj_usermeta'
170720  6:57:56 [ERROR] mysqld: Table './admin_wp865/wphj_term_relationships' is marked as crashed and should be repaired
170720  6:57:56 [Warning] Checking table:   './admin_wp865/wphj_term_relationships'
170720  7:22:18 [ERROR] mysqld: Table './admin_wp865/wphj_loginizer_logs' is marked as crashed and should be repaired
170720  7:22:18 [Warning] Checking table:   './admin_wp865/wphj_loginizer_logs'
170720  7:32:10 [ERROR] mysqld: Table './admin_wp865/wphj_404_to_301' is marked as crashed and should be repaired
170720  7:32:10 [Warning] Checking table:   './admin_wp865/wphj_404_to_301'
170721 11:08:51 mysqld_safe Number of processes running now: 0
170721 11:08:57 mysqld_safe mysqld restarted
170721 11:10:01 [Note] /usr/libexec/mysqld (mysqld 5.5.52-MariaDB) starting as process 14677 ...
170721 11:10:02 [Warning] Could not increase number of max_open_files to more than 1024 (request: 10261)
170721 11:10:07 InnoDB: The InnoDB memory heap is disabled
170721 11:10:07 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170721 11:10:07 InnoDB: Compressed tables use zlib 1.2.7
170721 11:10:07 InnoDB: Using Linux native AIO
170721 11:10:09 InnoDB: Initializing buffer pool, size = 128.0M
170721 11:10:09 InnoDB: Completed initialization of buffer pool
170721 11:10:10 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!
170721 11:10:10  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...
170721 11:11:39  InnoDB: Waiting for the background threads to start
170721 11:11:48 Percona XtraDB (http://www.percona.com) 5.5.49-MariaDB-38.0 started; log sequence number 7495367
170721 11:12:40 [Note] Plugin 'FEEDBACK' is disabled.
170721 11:12:51 [Note] Server socket created on IP: '::1'.
170721 11:13:17 [Note] Event Scheduler: Loaded 0 events
170721 11:13:17 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.52-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
170721 11:13:23 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170721 11:13:23 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170721 11:13:23 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170721 11:13:23 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170721 11:13:23 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170721 11:13:23 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170721 11:13:23 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170721 11:13:23 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170721 11:13:23 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170721 11:13:23 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170721 11:13:23 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170721 11:13:23 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170721 11:13:23 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170721 11:13:23 [Warning] Checking table:   './admin_wp865/wphj_options'
170721 11:26:57 mysqld_safe Number of processes running now: 0
170721 11:27:02 mysqld_safe mysqld restarted
170721 11:30:11 [Note] /usr/libexec/mysqld (mysqld 5.5.52-MariaDB) starting as process 14943 ...
170721 11:30:12 [Warning] Could not increase number of max_open_files to more than 1024 (request: 10261)
170721 11:30:18 InnoDB: The InnoDB memory heap is disabled
170721 11:30:18 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170721 11:30:18 InnoDB: Compressed tables use zlib 1.2.7
170721 11:30:18 InnoDB: Using Linux native AIO
170721 11:30:19 InnoDB: Initializing buffer pool, size = 128.0M
170721 11:30:19 InnoDB: Completed initialization of buffer pool
170721 11:30:21 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!
170721 11:30:22  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...
170721 11:31:53  InnoDB: Waiting for the background threads to start
170721 11:31:55 Percona XtraDB (http://www.percona.com) 5.5.49-MariaDB-38.0 started; log sequence number 7495367
170721 11:31:59 [Note] Plugin 'FEEDBACK' is disabled.
170721 11:32:16 [Note] Server socket created on IP: '::1'.
170721 11:33:00 [Note] Event Scheduler: Loaded 0 events
170721 11:33:01 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.52-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
170721 11:33:18 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170721 11:33:19 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170721 11:33:19 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170721 11:33:20 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170721 11:33:20 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170721 11:33:20 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170721 11:33:20 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170721 11:33:20 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170721 11:33:20 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170721 11:33:20 [ERROR] mysqld: Table './admin_wp865/wphj_options' is marked as crashed and should be repaired
170721 11:33:21 [Warning] Checking table:   './admin_wp865/wphj_options'
170721 11:48:29 mysqld_safe Number of processes running now: 0
170721 11:48:31 mysqld_safe mysqld restarted
170721 11:48:42 [Note] /usr/libexec/mysqld (mysqld 5.5.52-MariaDB) starting as process 15399 ...
170721 11:48:42 [Warning] Could not increase number of max_open_files to more than 1024 (request: 10261)
170721 11:48:46 InnoDB: The InnoDB memory heap is disabled
170721 11:48:46 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170721 11:48:46 InnoDB: Compressed tables use zlib 1.2.7
170721 11:48:46 InnoDB: Using Linux native AIO
170721 11:48:46 InnoDB: Initializing buffer pool, size = 128.0M
170721 11:48:46 InnoDB: Completed initialization of buffer pool
170721 11:48:47 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!
170721 11:48:48  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...
170721 11:49:23  InnoDB: Waiting for the background threads to start
170721 11:49:24 Percona XtraDB (http://www.percona.com) 5.5.49-MariaDB-38.0 started; log sequence number 7495367
170721 11:49:26 [Note] Plugin 'FEEDBACK' is disabled.
170721 11:49:27 [Note] Server socket created on IP: '::1'.
170721 11:49:56 [Note] Event Scheduler: Loaded 0 events
170721 11:49:56 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.52-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
170721 12:07:57 mysqld_safe Number of processes running now: 0
170721 12:08:48 mysqld_safe mysqld restarted
170721 12:12:00 [Note] /usr/libexec/mysqld (mysqld 5.5.52-MariaDB) starting as process 15811 ...
170721 12:12:02 [Warning] Could not increase number of max_open_files to more than 1024 (request: 10261)
170721 12:13:08 InnoDB: The InnoDB memory heap is disabled
170721 12:13:08 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170721 12:13:08 InnoDB: Compressed tables use zlib 1.2.7
170721 12:13:08 InnoDB: Using Linux native AIO
170721 12:13:08 InnoDB: Initializing buffer pool, size = 128.0M
170721 12:13:13 InnoDB: Completed initialization of buffer pool
170721 12:13:15 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!
170721 12:13:17  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...
170721 12:16:01 Percona XtraDB (http://www.percona.com) 5.5.49-MariaDB-38.0 started; log sequence number 7495367
170721 12:16:06 [Note] Plugin 'FEEDBACK' is disabled.
170721 12:16:22 [Note] Server socket created on IP: '::1'.
170721 12:17:04 [Note] Event Scheduler: Loaded 0 events
170721 12:17:05 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.52-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
170721 12:41:09 mysqld_safe Number of processes running now: 0
170721 12:41:09 mysqld_safe mysqld restarted
170721 12:43:16 [Note] /usr/libexec/mysqld (mysqld 5.5.52-MariaDB) starting as process 16131 ...
170721 12:43:27 [Warning] Could not increase number of max_open_files to more than 1024 (request: 10261)
170721 12:43:38 InnoDB: The InnoDB memory heap is disabled
170721 12:43:38 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170721 12:43:38 InnoDB: Compressed tables use zlib 1.2.7
170721 12:43:38 InnoDB: Using Linux native AIO
170721 12:43:41 InnoDB: Initializing buffer pool, size = 128.0M
170721 12:43:42 InnoDB: Completed initialization of buffer pool
170721 12:43:44 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!
170721 12:43:46  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...
170721 12:44:47  InnoDB: Waiting for the background threads to start
170721 12:44:48 Percona XtraDB (http://www.percona.com) 5.5.49-MariaDB-38.0 started; log sequence number 7495367
170721 12:44:51 [Note] Plugin 'FEEDBACK' is disabled.
170721 12:45:18 [Note] Server socket created on IP: '::1'.
170721 12:45:56 [Note] Event Scheduler: Loaded 0 events
170721 12:45:57 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.52-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
170721 12:46:09 [Note] /usr/libexec/mysqld: Normal shutdown

170721 12:46:09 [Note] Event Scheduler: Purging the queue. 0 events
170721 12:46:12 [Warning] /usr/libexec/mysqld: Forcing close of thread 7  user: 'admin_wp865'

170721 12:46:12 [Warning] /usr/libexec/mysqld: Forcing close of thread 6  user: 'admin_wp865'

170721 12:46:25 [ERROR] mysqld: Got an error writing communication packets
170721 12:46:30  InnoDB: Starting shutdown...
170721 12:46:36  InnoDB: Shutdown completed; log sequence number 7495367
170721 12:46:36 [Note] /usr/libexec/mysqld: Shutdown complete

170721 12:46:44 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
170721 12:47:49 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170721 12:47:51 [Note] /usr/libexec/mysqld (mysqld 5.5.52-MariaDB) starting as process 2269 ...
170721 12:47:51 [Warning] Could not increase number of max_open_files to more than 1024 (request: 10261)
170721 12:47:52 InnoDB: The InnoDB memory heap is disabled
170721 12:47:52 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170721 12:47:52 InnoDB: Compressed tables use zlib 1.2.7
170721 12:47:52 InnoDB: Using Linux native AIO
170721 12:47:52 InnoDB: Initializing buffer pool, size = 128.0M
170721 12:47:52 InnoDB: Completed initialization of buffer pool
170721 12:47:52 InnoDB: highest supported file format is Barracuda.
170721 12:47:54  InnoDB: Waiting for the background threads to start
170721 12:47:55 Percona XtraDB (http://www.percona.com) 5.5.49-MariaDB-38.0 started; log sequence number 7495367
170721 12:47:55 [Note] Plugin 'FEEDBACK' is disabled.
170721 12:47:55 [Note] Server socket created on IP: '::1'.
170721 12:47:56 [Note] Event Scheduler: Loaded 0 events
170721 12:47:56 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.52-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
170721 12:48:32 [ERROR] mysqld: Table './admin_wp865/wphj_postmeta' is marked as crashed and should be repaired
170721 12:48:32 [ERROR] mysqld: Table './admin_wp865/wphj_postmeta' is marked as crashed and should be repaired
170721 12:48:32 [Warning] Checking table:   './admin_wp865/wphj_postmeta'
170721 12:48:32 [ERROR] mysqld: Table './admin_wp865/wphj_et_social_stats' is marked as crashed and should be repaired
170721 12:48:32 [Warning] Checking table:   './admin_wp865/wphj_et_social_stats'
170721 12:48:32 [ERROR] mysqld: Table './admin_wp865/wphj_posts' is marked as crashed and should be repaired
170721 12:48:32 [Warning] Checking table:   './admin_wp865/wphj_posts'
170721 12:48:46 [ERROR] mysqld: Table './admin_wp865/wphj_usermeta' is marked as crashed and should be repaired
170721 12:48:46 [Warning] Checking table:   './admin_wp865/wphj_usermeta'
170721 13:00:19 [ERROR] mysqld: Table './admin_wp865/wphj_loginizer_logs' is marked as crashed and should be repaired
170721 13:00:19 [Warning] Checking table:   './admin_wp865/wphj_loginizer_logs'
170721 13:05:12 [ERROR] mysqld: Table './admin_wp865/wphj_404_to_301' is marked as crashed and should be repaired
170721 13:05:12 [Warning] Checking table:   './admin_wp865/wphj_404_to_301'

Code: 
Sun Jul 16 03:46:05.964563 2017] [auth_digest:notice] [pid 629] AH01757: generating secret for digest authentication ...
[Sun Jul 16 03:46:05.974664 2017] [:notice] [pid 629] mod_ruid2/0.9.8 enabled
[Sun Jul 16 03:46:06.704657 2017] [mpm_prefork:notice] [pid 629] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips mod_fcgid/2.3.9 PHP/5.6.30 configured -- resuming normal operations
[Sun Jul 16 03:46:06.704707 2017] [core:notice] [pid 629] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
[Thu Jul 20 06:55:42.967772 2017] [mpm_prefork:notice] [pid 629] AH00170: caught SIGWINCH, shutting down gracefully
[Thu Jul 20 06:57:12.257559 2017] [suexec:notice] [pid 3256] AH01232: suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Thu Jul 20 06:57:12.336729 2017] [so:warn] [pid 3256] AH01574: module ruid2_module is already loaded, skipping
[Thu Jul 20 06:57:12.343076 2017] [auth_digest:notice] [pid 3256] AH01757: generating secret for digest authentication ...
[Thu Jul 20 06:57:12.348749 2017] [:notice] [pid 3256] mod_ruid2/0.9.8 enabled
[Thu Jul 20 06:57:15.223579 2017] [mpm_prefork:notice] [pid 3256] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips mod_fcgid/2.3.9 PHP/5.6.30 configured -- resuming normal operations
[Thu Jul 20 06:57:15.223645 2017] [core:notice] [pid 3256] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
[Fri Jul 21 12:46:24.817945 2017] [mpm_prefork:notice] [pid 3256] AH00170: caught SIGWINCH, shutting down gracefully
[Fri Jul 21 12:47:53.634112 2017] [suexec:notice] [pid 2239] AH01232: suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Fri Jul 21 12:47:53.765853 2017] [so:warn] [pid 2239] AH01574: module ruid2_module is already loaded, skipping
[Fri Jul 21 12:47:53.772912 2017] [auth_digest:notice] [pid 2239] AH01757: generating secret for digest authentication ...
[Fri Jul 21 12:47:53.782207 2017] [:notice] [pid 2239] mod_ruid2/0.9.8 enabled
[Fri Jul 21 12:47:56.245332 2017] [mpm_prefork:notice] [pid 2239] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips mod_fcgid/2.3.9 PHP/5.6.30 configured -- resuming normal operations
[Fri Jul 21 12:47:56.245452 2017] [core:notice] [pid 2239] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'

Server details:

2 x 2.4ghz CPU
4GB DDR4 ram
80GB SSD

Only 1 site hosted on it under 100k visits a month

eKRbRiE
 
After long investigation and few tests I found the memory leak and managed to stabilize the server by removing 2 plugins and disabling a setting from a 3rd.

Still monitoring.
 
roki4ka said:
Code: 
<Files xmlrpc.php>
order deny,allow
deny from all
allow from 123.123.123.123
</Files>

Why?
Click to expand...
to prevent attacks that sends a lot of sql requests wich take a lot of ram
 
shitty hosting co. very often happenes with freaking Digital Ocean.
solution:
leave garbage hosting
solution 2: swap file.
solution 3: manage traffic, block creeps/ script kiddies and other a$$holes to screw your MySQL
Easy!
 
You are overthinking this. The problem is most likely in your host and the way they use virtualization for the VPS.
It can be a hdd mailfunction or a bad sector that can cause your crash. It can also be that you need a little more resources to run the website.

Every host has different virtualization settings, how much cores they dedicated how much swap memory to each VPS together with many other settings. 1 website on 1 vps should run just fine no matter what kind of plugins you have installed.

I can offer you a free trial VPS so you can test out if the issue is in the VPS or in the website structure.
 
virtualpurity said:
You are overthinking this. The problem is most likely in your host and the way they use virtualization for the VPS.
It can be a hdd mailfunction or a bad sector that can cause your crash. It can also be that you need a little more resources to run the website.

Every host has different virtualization settings, how much cores they dedicated how much swap memory to each VPS together with many other settings. 1 website on 1 vps should run just fine no matter what kind of plugins you have installed.

I can offer you a free trial VPS so you can test out if the issue is in the VPS or in the website structure.
Click to expand...

I have 7 more websites on 7 different VPS with that provider. I did the optimization and the settings as the others. Never had a problem with any of them. The only difference between the sites are the plugins and the themes and few scripts.
 
roki4ka said:
I have 7 more websites on 7 different VPS with that provider. I did the optimization and the settings as the others. Never had a problem with any of them. The only difference between the sites are the plugins and the themes and few scripts.
Click to expand...

Than the issue is most likely in the resources or the VPS node if it keeps on crashing.
 
Yes, but if possible can you list the plugins that were causing you the problems?
 
Advertise on BHW
You must log in or register to reply here.
Sign up now!

Main Menu

Home Main Forum List Black Hat SEO White Hat SEO BHW Newbie Guide Blogging Black Hat Tools Social Media Downloads

Marketplace

Account Selling Content / Copywriting EBooks / Methods Hosting Misc Proxies For Sale SEO - Link building SEO - Packages Social Media Social Media - Panels Web Design More

Making Money

Affiliate Programs Hire a Freelancer IM Journeys Making Money Pay Per Click Site Flipping Want to Buy

BlackHat World

Dispute Resolution Forum Suggestions & Feedback Introductions Lounge
Back
Top