Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 25th October 2007, 05:46
crypted crypted is offline
Senior Member
 
Join Date: Dec 2006
Location: Oklahoma, USA
Posts: 429
Thanks: 3
Thanked 14 Times in 6 Posts
Default mysql stops responding

After just a short time it seems that MYSQL stops responding. Any website that is database driven stops operating until MYSQL is restarted either from the ISPConfig web interface or via rc.d scripts. I've been searching around and can't find anything that would be an issue. Logs don't tell me anything. I have a file, "/etc/my.cnf" that supposedly operates MYSQL. It's contents is as follows:

-------------------------------------------
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

# begin changes #
key_buffer=48M
max_allowed_packet=1M
table_cache=400
sort_buffer=4M
record_buffer=1M
thread_cache=8
thread_concurrency=4
myisam_sort_buffer_size=32M
max_connections=250
open_files_limit=750
long_query_time=4
# end changes #

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
-------------------------------------------

If you have any ideas on how to keep this frmo happening, I'd love to know. Thanks again. Where's the donate button???
Reply With Quote
Sponsored Links
  #2  
Old 25th October 2007, 11:19
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,000
Thanks: 840
Thanked 5,650 Times in 4,460 Posts
Default

Please check with:

df -h

if you have enough space on disk. You can also try to enable logging in mysql by adding the following line to my.cnf in the [mysqld] section and restart mysql:

log = /var/log/mysql.log

In this log you will find all queries. Maybe your server dies always at the same query.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 26th October 2007, 06:23
crypted crypted is offline
Senior Member
 
Join Date: Dec 2006
Location: Oklahoma, USA
Posts: 429
Thanks: 3
Thanked 14 Times in 6 Posts
Default

I restarted mysql several times and it still isn't logging to that file. the logging of mysqld.log shows the following:

071025 23:22:01 mysqld started
^G/usr/libexec/mysqld: File '/var/log/mysql.log' not found (Errcode: 13)
071025 23:22:01 [ERROR] Could not use /var/log/mysql.log for logging (error 13). Turning logging off for the whole duration of$
071025 23:22:01 InnoDB: Started; log sequence number 0 169982574
/usr/libexec/mysqld: ready for connections.
Version: '4.1.20-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution

dingle@its:/etc/rc.d/init.d# cat /var/log/mysql.log
dingle@its:/etc/rc.d/init.d# ls -lh /var/log/mysql.log
-rw-r--r-- 1 root root 0 Oct 25 12:37 /var/log/mysql.log
dingle@its:/etc/rc.d/init.d#
Reply With Quote
  #4  
Old 26th October 2007, 12:16
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,000
Thanks: 840
Thanked 5,650 Times in 4,460 Posts
 
Default

Please run:

chown mysql /var/log/mysql.log

and then try to restart mysql again.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Server randomly stops responding Jayock Server Operation 12 16th October 2007 12:34
Messed up ISPConfig-2.2.8 Upgrade Morons Installation/Configuration 4 29th November 2006 13:17
Installation stops when checking for mysql gfts Installation/Configuration 7 13th March 2006 17:46
Inst. stops, MySQL passw not accepted Thunderbirdsei Installation/Configuration 39 29th January 2006 13:11
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 17:04


All times are GMT +2. The time now is 17:44.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.