Problem with Apache or Mysql

This is a discussion on Problem with Apache or Mysql within the Apache Web Server forums, part of the Web Server and Related Forums category; I have problem with my web server, but I don't know if it is whit Apache or Mysql. Sometimes ...


Go Back   Usenet Forums > Web Server and Related Forums > Apache Web Server

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 12-13-2004
Nicola Svaizer
 
Posts: n/a
Default Problem with Apache or Mysql

I have problem with my web server, but I don't know if it is whit Apache or
Mysql.

Sometimes I have many httpd processes active and mysqld admin reject any
connections with the error "...many users ..."
In this state both services: httpd and mysqld can't accept any connections
and I can restart only apache with killall httpd and apachectl restart, but
mysqld not respond to any kill, killall or mysqld stop.
I can resolve the problem only with reboot the system !

In correspondence of this error in mysqld log file I can read that:

--------------------------------------------
041209 11:20:46 /usr/libexec/mysqld: Normal shutdown

041209 11:20:47 /usr/libexec/mysqld: Forcing close of thread 72442 user:
'nicola'
-------------------------------------
And many lines like this: 041209 11:20:47 /usr/libexec/mysqld: Forcing
close of thread 72442 user: 'nicola'

Where is the problem ? With Apache or with Mysql ?

This is my.cf file :
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-update=/var/log/mysql/queries
log-long-format
set-variable=max_connections=1000

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

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


Sorry for my bad english ! :(
Thanks
Bye
Nicola



  #2 (permalink)  
Old 12-13-2004
Davide Bianchi
 
Posts: n/a
Default Re: Problem with Apache or Mysql

On 2004-12-13, Nicola Svaizer <nicola@camonkit.it> wrote:
> Sometimes I have many httpd processes active and mysqld admin reject any
> connections with the error "...many users ..."


It sounds like a bug in your php application more than a misconfiguration
of Apache.

> but mysqld not respond to any kill, killall or mysqld stop.


It would be interesting to know what is he doing, if is stuck in some
process or not.

Davide

--
Bugs come in through open Windows.
 


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

vB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 06:18 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0