RE: Mysqld eats up RAM and CPU

2001-01-31 Thread Rune Hansen
Hi Jan, your problems may OR may not be resolved by upgrading your Linux(?) system to kernel 2.4x, glibc2.2x and MySql to 2.32.30. I haven't been able to get a confirmation from the MySQL people that this actualy solves the problem - it is however clear that it is the dual CPUs that are causing th

RE: Mysqld eats up RAM and CPU

2001-01-30 Thread Tony Shiu
: Wednesday, January 31, 2001 12:49 PM To: Tony Shiu Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject:RE: Mysqld eats up RAM and CPU on my server which runs an online game the values are all in the megabytes On Wed, 31 Jan 2001, Tony Shiu wrote: > I wonder the normalization

RE: Mysqld eats up RAM and CPU

2001-01-30 Thread Andrei Cojocaru
n without significantly slow-down in peak time. > > > -Original Message- > From: Matis, Jan [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 31, 2001 12:46 AM > To: 'Sam Wong'; [EMAIL PROTECTED] > Subject: RE: Mysqld eats up RAM and CPU > >

RE: Mysqld eats up RAM and CPU

2001-01-30 Thread Tony Shiu
, January 31, 2001 12:46 AM To: 'Sam Wong'; [EMAIL PROTECTED] Subject: RE: Mysqld eats up RAM and CPU what about this ? 2*PII 450 MHZ 1G RAM data on hardware raid port= 3306 socket = /tmp/mysql.sock user= mysql skip-locking set-variable=

RE: Mysqld eats up RAM and CPU

2001-01-30 Thread Matis, Jan
You've got 1G Ram! Guys, take a look at the my-huge.cnf in the mysql tree (I've forgot which folder) it's not for me :)) it's for customers and because I'm lamer sometimes is 1GB not enough ... huge.cnf - thanx for hint : mysql-3.23.32/support-files/my-huge.cnf.sh look at these ... Do You have

Re: Mysqld eats up RAM and CPU

2001-01-30 Thread Sam Wong
nesday, January 31, 2001 12:46 AM Subject: RE: Mysqld eats up RAM and CPU > what about this ? > > 2*PII 450 MHZ > 1G RAM > data on hardware raid > > port= 3306 > socket = /tmp/mysql.sock > user= mysql > skip-locking > set-variable

RE: Mysqld eats up RAM and CPU

2001-01-30 Thread Matis, Jan
what about this ? 2*PII 450 MHZ 1G RAM data on hardware raid port= 3306 socket = /tmp/mysql.sock user= mysql skip-locking set-variable= key_buffer=16M set-variable= max_allowed_packet=1M set-variable= thread_stack=128K set-variable= wait_timeout=

Re: Mysqld eats up RAM and CPU

2001-01-30 Thread Sam Wong
/buffering setting? - Original Message - From: "Scott Gerhardt" <[EMAIL PROTECTED]> To: "Alejandro M. Leonian" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, January 31, 2001 12:06 AM Subject: RE: Mysqld eats up RAM and CPU > What sort of ha

RE: Mysqld eats up RAM and CPU

2001-01-30 Thread Scott Gerhardt
What sort of hardware are you running? - Amount of RAM - CPU speed. > > Hi There.. > I'm running mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu > (i686) on a RedHat 6.1 Os. > The server is installed and the configuration is almost by default. > The problem is that most of the time the m

Mysqld eats up RAM and CPU

2001-01-30 Thread Alejandro M. Leonian
Hi There.. I'm running mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686) on a RedHat 6.1 Os. The server is installed and the configuration is almost by default. The problem is that most of the time the mysqld threads eat up my RAM and CPU! The server gets very slow at times and it (obvi