On 10/27/05, Elena C <ecurry007@stripped> wrote:
> Folks,
>
> I have Mysql db server (4.0.12-nt) running on Windows 2000 partition that is
First of all, upgrade to the latest stable version *be careful with
upgrades from 4 to 4.1* this can be a bug fixed long ago, or not.
> actually a VMWare - ESX Server virtual machine.
Emulated? Hmmm, can't expect much from this kind of system.
> This VMWare machine has 524Mb of Ram allocated.
> The set of the databases on this server is minimal, and my.cnf values are
> set to "my.small" file.
> Nevertheless the db server stalls a couple of times a week with the system
> running up to 99% of CPU resources for mysqld alone for more than 3 min, and
> mysql service has to be restarted.
Could be so many things, could you post the configuration of the
virtual machine running it? Its hard to debug errors with a system
like this.
> I am trying to determine the cause of this. One of my "guesses" is that the
> network connection to this machine is notoriously slow, and there are
> network delays.
I don't think so, that would be no reason for such a "hunger" for resources.
> Does anyone know of mysql system issues that relate to the network outages?
> What happens if the query is issued to mysql server and the network
> connection terminates at that point - (the result set that suppose to be
> sent back to the client does not reach the client)?
The connection is closed after wait_timeout (variable) and a warning
is issued if you have log_warnings set.
> Sincerely,
> Elena.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------
