sslug-teknik team mailing list archive

Thread
Date

Re: MySQL 4.1 optimeringstips?

To: sslug-teknik@xxxxxxxx
From: Mogens Kjaer <mk@xxxxxx>
Date: Wed, 25 Oct 2006 11:02:44 +0200
Delivered-to: mailing list sslug-teknik@xxxxxxxx
In-reply-to: <ehn5ij$j67$2@shrek.krogh.cc>
Mailing-list: contact sslug-teknik-help@xxxxxxxx; run by ezmlm
Newsgroups: sslug.teknik
Organization: Carlsberg Laboratory
User-agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.13) Gecko/20060501 Fedora/1.7.13-1.1.fc5

Jesper Krogh wrote:

Jeg har en mysql 4.1 installation der generelt er "sløv"..


Er der ikke nogle eksempler på my.cnf filer i din
distribution?

På en FC5 ligger der:

/usr/share/doc/mysql-server-5.0.22/my-huge.cnf
/usr/share/doc/mysql-server-5.0.22/my-innodb-heavy-4G.cnf
/usr/share/doc/mysql-server-5.0.22/my-large.cnf
/usr/share/doc/mysql-server-5.0.22/my-medium.cnf
/usr/share/doc/mysql-server-5.0.22/my-small.cnf

Måske er der inspiration at hente dér.

Hvis du har top kørende imens du laver queries,
kan du så se om den har meget IO eller bruger
meget CPU tid?

Mogens

--
Mogens Kjaer, Carlsberg A/S, Computer Department
Gamle Carlsberg Vej 10, DK-2500 Valby, Denmark
Phone: +45 33 27 53 25, Fax: +45 33 27 47 08
Email: mk@xxxxxx Homepage: http://www.crc.dk

References

MySQL 4.1 optimeringstips?
From: Jesper Krogh, 2006-10-25