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