+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Usage (/forum-34.html)
+--- Thread: Big problem with mysql on my server (/thread-8454.html)
Big problem with mysql on my server - Spheerys - 11-15-2009 07:35 PM
Hi,
I use ispCP for 2 years now, on 4 servers, and it's work very well.
But since few weeks, I have a lots of problem on one server : MySQL stop several times per day !
I tried to read the logs, and find issues, but it's not very easy because :
- there are a lots of littles tech fits to tune the server
- the configurations files of ispCP is sometimes differents than a standard LAMPP server
This server is a little bit different than the 3 others ones : there is only one BIG website on it with a big database (and a second very small) .
On the 3 others, there are 40 smalls websites and that's work very well.
So I need your expertise !!!
Theses lasts days, I made handmade contrab to relaunch the mysql process if there is a problem, but I did it because I didn't had the time to solve properly the problem.
Now I have stopped the crontab, and I'm ready to correcting what is wrong.
I think the host server is powerfull enought, but there are only parameters of the mysql server to fix...
I'm waiting for the next crash and in few hours I'll be able to post you fresh new error logs...
If anyone has an idea to check configuration file, feel free to ask me...
RE: Big problem with mysql on my server - Spheerys - 11-16-2009 03:23 AM
My server is now inaccessible.
Here the logs files :
/var/log/daemon.log :
Code:
Nov 15 18:08:23 lumiere mysqld_safe: Number of processes running now: 0
Nov 15 18:08:23 lumiere mysqld_safe: mysqld restarted
Nov 15 18:08:24 lumiere mysqld: 091115 18:08:24 [Note] Plugin 'FEDERATED' is disabled.
Nov 15 18:08:24 lumiere mysqld: 091115 18:08:24 InnoDB: Started; log sequence number 0 43665
Nov 15 18:08:24 lumiere mysqld: 091115 18:08:24 [Note] Event Scheduler: Loaded 0 events
Nov 15 18:08:24 lumiere mysqld: 091115 18:08:24 [Note] /usr/sbin/mysqld: ready for connections.
Nov 15 18:08:24 lumiere mysqld: Version: '5.1.40-0.dotdeb.0-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian)
Nov 15 18:08:29 lumiere mysqld: 091115 18:08:29 [ERROR] /usr/sbin/mysqld: Table './forum/ibf_cache_store' is marked as crashed and should be repaired
Nov 15 18:08:29 lumiere mysqld: 091115 18:08:29 [Warning] Checking table: './forum/ibf_cache_store'
Nov 15 18:08:29 lumiere mysqld: 091115 18:08:29 [ERROR] /usr/sbin/mysqld: Table './forum/ibf_sessions' is marked as crashed and should be repaired
Nov 15 18:08:29 lumiere mysqld: 091115 18:08:29 [Warning] Checking table: './forum/ibf_sessions'
Nov 15 18:08:29 lumiere mysqld: 091115 18:08:29 [ERROR] /usr/sbin/mysqld: Table './forum/ibf_topics' is marked as crashed and should be repaired
Nov 15 18:08:29 lumiere mysqld: 091115 18:08:29 [Warning] Checking table: './forum/ibf_topics'
Nov 15 18:08:29 lumiere mysqld: 091115 18:08:29 [ERROR] /usr/sbin/mysqld: Table './forum/ibf_forums' is marked as crashed and should be repaired
Nov 15 18:08:29 lumiere mysqld: 091115 18:08:29 [Warning] Checking table: './forum/ibf_forums'
Nov 15 18:08:32 lumiere mysqld: 091115 18:08:31 [ERROR] /usr/sbin/mysqld: Table './forum/ibf_posts' is marked as crashed and should be repaired
Nov 15 18:08:32 lumiere mysqld: 091115 18:08:31 [Warning] Checking table: './forum/ibf_posts'I had repaired theses tables yesterday
Is there specials parameters to fix when there is one big database on the server ?