Hi there
Is there anything similar to this that will run on a Windows platform?
Regards
WARREN
~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Durban, South Africa
Cell (+27-83) 262-9163
Office (+27-31) 767-0249
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
]On Behalf
Of Jeremy Zawodny
Sent: 02 May 2001 07:30
To: Bryan Coon
Cc: '[EMAIL PROTECTED]'
Subject: Re: Optimization of MySQL
On Tue, May 01, 2001 at 04:46:39PM -0700, Bryan Coon wrote:
Our database is large, and getting larger, with several tables
approaching the 1gig mark. In addition, the database will be moving
to a dedicated node on a beowulf cluster.
Cool... :-)
For our users, we are not particulary interested in squeezing every
last drop of performance out of MySQL, but I would be interested to
know if there are obvious things that I should do to optimize our
performace.
For example, compiling my own mysql with certain flags, or perhaps
startup options, etc.
I searched the usenet and mysql site, and found some information but
would like to hear some experienced advice before I jump in with
both feet.
Well, just wait a few weeks for my article in the next issue of Linux
Magazine. :-)
But before that happens, here are some ideas... There are two
approaches to optimization, and you should use both.
First is optimizing your application. This is generally just making
sure your queries are fast (well indexed), you're only retrieving the
data you need, you aren't indexing columns which will never benefit
from indexes, you're caching data in your app which can be cached,
etc.
Second is server tuning. You can look at increasing the size if the
key_buffer, record_buffer, and so on in your /etc/my.cnf (or similar)
file. Try to get an idea how efficient things are currently. I often
use mytop (http://public.yahoo.com/~jzawodn/mytop/) to gather some
info about my system before, during, and after tuning. It doesn't give
you everything you'll need (yet!), but it's a decent start. You'll
probably want to look closely at the output of SHOW VARIABLES and
SHOW STATUS and learn more about what some of them mean.
And, of course, we're glad to field specific questions on this list.
(This reminds me... I'm thinking of another patch to the MySQL manual
which explains some more of this stuff. Just need to find the time to
do it. Things are getting more, uh... interesting as the number of
table handlers expand. With ISAM, MyISAM, InnoDB, BDB, Gemini, and
HEAP, there is more room for both improvement and error.)
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951
MySQL 3.23.29: up 118 days, processed 734,376,106 queries
(71/sec. avg)
-
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
