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
: 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
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
>
>
, 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=
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
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
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=
/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
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