James have you copied over the php and apache confs from the good server to the bad?
One of those might be the cause of the problem.
Is ensim involved here at all? I doubt it as it doesnt really rely on mysql except for 
the creation of databases. This is a guess as I have zero ensim experence (but know 
what it is).

I would try first copying the apache conf over and restart it.
Then try the php conf and go from there.


Matthew

>>> James Riordon <[EMAIL PROTECTED]> 10/13/02 12:33pm >>>
On Sunday, October 6, 2002, at 01:53  AM, James Riordon wrote:

>> Have you tried monitoring server B via 'top' or something and see what
>> processes are taking up CPU time and/or swapping.
>
>
> Hello,
>
>       I have monitored top for a bit. It is definitely MySQL-Max that is 
> taking up the CPU and placing the load on the server. I have run strace > on some of 
>the pids and see nothing normal. I have attached here one of > the listings from 
>processlist just in case you see something:
>

All right, after some more testing I have done the following:


RECAP
I have two servers, server A and server B. Server A has dual 1GHz PIII 
chips with 1GB ram and 2 ide drives running Ensim 3.0.4, php 4.1.2 and 
mysql-max 3.23.49a. Server B is a single processor 1.7Ghz PIV with 1.5GB 
of RAM and 1 ide drive running Ensim 3.1.1, php 4.1.2 and mysql-max 
3.23.49a. I have one site on Server A which runs well and the server 
load is consistently under 1. When I moved that site to the new server 
it spiraled and crashed within seconds with high loads. After some 
investigation I thought it was MySQL that was the problem. Reason being 
is that I get tons of MySQL children or connections but they never close.

Then I did the following. I recreated the site on Server B. In the 
config files on Server B I pointed the MySQL connect to Server A. I then 
redirected all traffic from Server A to Server B. So now Server A is 
handling all the mysql stuff as it was before, but all the httpd stuff 
is on Server B. Now for the strange thing, Server A crashes and burns. 
Yes, the dual processor machine now dies after about 2-3 minutes with 
load averages as high as 30 or more! All from mysql-max.

So, I am thinking that it is no longer MySQL that is the problem. I 
would think from this test that it is either PHP or Apache that is 
opening connections with MySQL and then not releasing them. I am using 
connect() and not pconnect(), and I have disabled persistent connections 
in php.ini. My httpd.conf settings and my.cnf settings are below.

Sorry if this sounds confusing but it is hard to describe it all 
clearly. Can anyone give me some suggestions of things I can look at on 
the new server that might be causing MySQL to open all these 
connections. I have checked the process list and I get a lot of process 
that just sit there and do nothing for over a minute. Almost like they 
are used once and then sit there until they die.

Here are my config settings (same on both servers so I only include them 
once here):

my.cnf
---------

set-variable = max_connections=200
set-variable = interactive_timeout=100
set-variable = wait_timeout=100
set-variable = thread_cache_size=256
set-variable = connect_timeout=120
set-variable = myisam_sort_buffer_size=32M
set-variable = key_buffer=16M
set-variable = join_buffer=3M
set-variable = record_buffer=3M
set-variable = sort_buffer=5M
set-variable = table_cache=1024
skip-locking

Apache httpd.conf
-------------------------

Timeout 300
KeepAlive On
MaxKeepAliveRequests 300
KeepAliveTimeout 30
MinSpareServers 32
MaxSpareServers 64
StartServers 5
MaxClients 256
#MaxRequestsPerChild 30


Many many thanks.

James


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php 



This electronic mail message is intended only for the
addressee and may contain confidential information.
If you are not the addressee, you are notified that any 
transmission, distribution or photocopying of this email 
is strictly prohibited. The confidentiality attached to this 
email is not waived, lost or destroyed by reasons of a 
mistaken delivery and Council does not accept responsibility 
for the accuracy of the message. The information contained in this email transmission 
may 
also be subject to Freedom of Information legislation.


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to