keybuffer=0?
tablecache=0?
For complicated query, Mysql may search the harddisk for stuff again, the it
holds the query for sometimes...and then some more connection come in, as a
result, more ram and cpu is consumed
May I suggest you to lower down the max connection, and tune up the
caching/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 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 mysqld threads eat up
> > my RAM and CPU! The server gets very slow at times and it
> > (obviously) afects its performance very badly.
> > Since i'm no expert i have tried as much as i could learn from
> > Deja.com and other web resources.
> > My /etc/my.cnf looks like this:
> >
> > [mysqld]
> > port=3306
> > socket=/tmp/mysql.sock
> > set-variable = key_buffer=0
> > set-variable = record_buffer=4k
> > set-variable = net_buffer_length=4k
> > set-variable = sort_buffer=4k
> > set-variable = table_cache=4
> > set-variable = max_connections=550
> >
> >
> > Please any pointer/tip/manual/website is appreciated.
> > I'm kinda desperate :/.
> > Thanks very much in advance.
> >
> > Latigo
> >
> >
>
> ---------------------------------------------------------------------
> 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
>
>
>
---------------------------------------------------------------------
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
