Domain hosted stop working without notice

[PonzioP]

Introduction: I'm italian, sorry if I write like a monkey

Hi, I got Plesk 10.0.9 with three different domains on it, but one of them stops working twice a day, only for some random users. Plesk doesn't seem to detect any problem, and the same happens with the host (OVH, I've a dedicated server with CentOS 6.4), who says there's no hardware problem to notice.

During the malfunctionings, at first I received an email in which Plesk warned me that the status of the detection of the CPU usage by MySQL was shifting from "green" to "yellow", but I solved the problem of the non warranted mails by increasing the limit value. Nevertheless, the server is still not working.

The mentioned domain, hosts a phBB forum but I don't think the traffic is part of the problem, since the webpages who are totally separated from the forum stop working too. Is it possible that Plesk detect some kind of anomaly and kills the process?

Thanks for the support.

 

[IgorG]

I can suggest you only try to troubleshoot this issue more deeply with help of article http://kb.parallels.com/it/111283

 

[PonzioP]

Thanks for your help. This is my mysql log... is strange, I haven't any problem like this before i switch my site on a dedicated server. More power = more problems?!?

[root@ks36790 ~]# more /var/log/mysqld.log
130521 16:07:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130521 16:07:52 InnoDB: Initializing buffer pool, size = 8.0M
130521 16:07:52 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
130521 16:07:52 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
130521 16:07:52 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...
130521 16:07:52 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
130521 16:07:53 InnoDB: Started; log sequence number 0 0
130521 16:07:53 [Note] Event Scheduler: Loaded 0 events
130521 16:07:53 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
130521 16:09:03 [Note] /usr/libexec/mysqld: Normal shutdown

130521 16:09:03 [Note] Event Scheduler: Purging the queue. 0 events
130521 16:09:03 InnoDB: Starting shutdown...
130521 16:09:08 InnoDB: Shutdown completed; log sequence number 0 721938
130521 16:09:08 [Note] /usr/libexec/mysqld: Shutdown complete

130521 16:09:08 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
130521 16:09:09 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130521 16:09:09 InnoDB: Initializing buffer pool, size = 8.0M
130521 16:09:09 InnoDB: Completed initialization of buffer pool
130521 16:09:09 InnoDB: Started; log sequence number 0 721938
130521 16:09:09 [Note] Event Scheduler: Loaded 0 events
130521 16:09:09 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution

Status information:

Current dir: /var/lib/mysql/
Running threads: 0 Stack size: 262144
Current locks:
lock: 0x7f52b000e258:

lock: 0x7f52b000ac08:

lock: 0x7f52b00464a0:

lock: 0x7f52c405a280:

lock: 0x7f52b84e9980:

lock: 0x7f52b84eec20:

lock: 0x7f52c4029ec0:

lock: 0x7f52c4069330:

lock: 0x7f52b84ea2c0:

lock: 0x12db010:

lock: 0x7f52b402be40:

lock: 0x7f52b002aa48:

lock: 0x7f52b00493a8:

lock: 0x7f52c403ced0:

lock: 0x7f52b84e6ed0:

lock: 0x7f52b84e53a0:

lock: 0x7f52b84e3160:

lock: 0x7f52b84e12d0:

lock: 0x7f52b8440230:

lock: 0x7f52b843ccc0:

lock: 0x7f52b848e6a0:

lock: 0x7f52b8478740:

lock: 0x7f52b8363b40:

lock: 0x7f52c4017db0:

lock: 0x7f52b8381cb0:

lock: 0x7f52b83cc220:

lock: 0x7f52b83ac090:

lock: 0x7f52b8454330:

lock: 0x7f52b8437a80:

lock: 0x7f52b83a24d0:

lock: 0x7f52c4054ce0:

lock: 0x7f52b842ed80:

lock: 0x7f52b8471d00:

lock: 0x7f52b84d17f0:

lock: 0x7f52b837a1e0:

lock: 0x7f52b84c1f20:

lock: 0x7f52b840ba30:

lock: 0x7f52b83e8a60:

lock: 0x7f52b8429580:

lock: 0x7f52b8429460:

lock: 0x7f52b84248d0:

lock: 0x7f52b84d6870:

lock: 0x7f52b835f980:

lock: 0x7f52c40502b0:

lock: 0x7f52b8360450:

lock: 0x7f52b8371070:

lock: 0x7f52c40136d0:

lock: 0x7f52b84a78b0:

lock: 0x7f52b840f8e0:

lock: 0x7f52b00466f0:

lock: 0x7f52b8384770:

lock: 0x7f52b00161c0:

lock: 0x7f52b00131e0:

lock: 0x7f52b801cfe0:

lock: 0x7f52b8016620:

lock: 0x7f52b83777e0:

lock: 0x7f52b8026ba0:

lock: 0x7f52b001de18:

lock: 0x7f52b0017458:

lock: 0x7f52c40388f0:

lock: 0x7f52c40233a0:

lock: 0x7f52c000cdf0:


Key caches:
default
Buffer_size: 8384512
Block_size: 1024
Division_limit: 100
Age_limit: 300
blocks used: 126
not flushed: 0
w_requests: 8309
writes: 8308
r_requests: 20675
reads: 16


handler status:
read_key: 3834
read_next: 2590
read_rnd 7
read_first: 520
write: 7466
delete 12
update: 88

Table status:
Opened tables: 1098
Open tables: 64
Open files: 12
Open streams: 0

Alarm status:
Active alarms: 0
Max used alarms: 5
Next alarm time: 0

Begin safemalloc memory dump:

End safemalloc memory dump.

Memory status:
Non-mmapped space allocated from system: 6201344
Number of free chunks: 43
Number of fastbin blocks: 3
Number of mmapped regions: 12
Space in mmapped regions: 24649728
Maximum total allocated space: 0
Space available in freed fastbin blocks: 192
Total allocated space: 5848608
Total free space: 352736
Top-most, releasable space: 126688
Estimated memory (with thread stack): 30851072



Events status:
LLA = Last Locked At LUA = Last Unlocked At
WOC = Waiting On Condition DL = Data Locked

Event scheduler status:
State : INITIALIZED
Thread id : 0
LLA : n/a:0
LUA : n/a:0
WOC : NO
Workers : 0
Executed : 0
Data locked: NO

Event queue status:
Element count : 0
Data locked : NO
Attempting lock : NO
LLA : init_queue:132
LUA : init_queue:142
WOC : NO
Next activation : never
130521 16:29:57 [Note] /usr/libexec/mysqld: Normal shutdown

130521 16:29:57 [Note] Event Scheduler: Purging the queue. 0 events
130521 16:29:57 InnoDB: Starting shutdown...
130521 16:30:00 InnoDB: Shutdown completed; log sequence number 0 3718018
130521 16:30:00 [Note] /usr/libexec/mysqld: Shutdown complete

130521 16:30:00 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
130521 16:30:00 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130521 16:30:01 InnoDB: Initializing buffer pool, size = 8.0M
130521 16:30:01 InnoDB: Completed initialization of buffer pool
130521 16:30:01 InnoDB: Started; log sequence number 0 3718018
130521 16:30:01 [Note] Event Scheduler: Loaded 0 events
130521 16:30:01 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
130521 16:37:38 [Note] /usr/libexec/mysqld: Normal shutdown

130521 16:37:38 [Note] Event Scheduler: Purging the queue. 0 events
130521 16:37:38 InnoDB: Starting shutdown...
130521 16:37:41 InnoDB: Shutdown completed; log sequence number 0 3763387
130521 16:37:41 [Note] /usr/libexec/mysqld: Shutdown complete

130521 16:37:42 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
130521 16:39:15 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130521 16:39:16 InnoDB: Initializing buffer pool, size = 8.0M
130521 16:39:16 InnoDB: Completed initialization of buffer pool
130521 16:39:16 InnoDB: Started; log sequence number 0 3763387
130521 16:39:16 [Note] Event Scheduler: Loaded 0 events
130521 16:39:16 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
130523 11:34:26 [Note] /usr/libexec/mysqld: Normal shutdown

130523 11:34:26 [Note] Event Scheduler: Purging the queue. 0 events
130523 11:34:26 InnoDB: Starting shutdown...
130523 11:34:29 InnoDB: Shutdown completed; log sequence number 0 9111399
130523 11:34:29 [Note] /usr/libexec/mysqld: Shutdown complete

130523 11:34:29 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
130523 11:34:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130523 11:34:36 InnoDB: Initializing buffer pool, size = 8.0M
130523 11:34:36 InnoDB: Completed initialization of buffer pool
130523 11:34:36 InnoDB: Started; log sequence number 0 9111399
130523 11:34:36 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69' socket: '/var/lib/mysql/mysql.sock' port: 0 Source distribution
130523 11:34:40 [Note] /usr/libexec/mysqld: Normal shutdown

130523 11:34:40 InnoDB: Starting shutdown...
130523 11:34:43 InnoDB: Shutdown completed; log sequence number 0 9111448
130523 11:34:43 [Note] /usr/libexec/mysqld: Shutdown complete

130523 11:34:43 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
130523 11:34:45 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130523 11:34:45 InnoDB: Initializing buffer pool, size = 8.0M
130523 11:34:45 InnoDB: Completed initialization of buffer pool
130523 11:34:45 InnoDB: Started; log sequence number 0 9111448
130523 11:34:45 [Note] Event Scheduler: Loaded 0 events
130523 11:34:45 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
130527 16:26:32 [Note] /usr/libexec/mysqld: Normal shutdown

130527 16:26:32 [Note] Event Scheduler: Purging the queue. 0 events
130527 16:26:32 InnoDB: Starting shutdown...
130527 16:26:36 InnoDB: Shutdown completed; log sequence number 0 30994121
130527 16:26:36 [Note] /usr/libexec/mysqld: Shutdown complete

130527 16:26:36 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
130527 16:28:10 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130527 16:28:11 InnoDB: Initializing buffer pool, size = 8.0M
130527 16:28:11 InnoDB: Completed initialization of buffer pool
130527 16:28:11 InnoDB: Started; log sequence number 0 30994121
130527 16:28:11 [Note] Event Scheduler: Loaded 0 events
130527 16:28:11 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution