Hi again. :-)
On Thu 2002-09-05 at 14:18:10 -0500, [EMAIL PROTECTED] wrote:
[...]
> 3) I'm somewhat at a loss for this one and perhaps the answer is more
> obvious than not. I have 257 total tables from my main DB and mysql. I
> figured this by a "ls -al var/ | grep -c MYD". How can I possibly
First of all, I forgive the rather lengthy post.
Thanks for the repl(y|ies) Benjamin. Decreasing the key_buffer should
be my first step. Back to the questions:
3) I'm somewhat at a loss for this one and perhaps the answer is more
obvious than not. I have 257 total tables from my main DB and
Benjamin Pflugmann wrote:
>OTOH, if this is a MySQL-only machine, 3GB are plenty and 100MB more
>or less used do not really matter (regarding free memory), so I would
>simply set it to use about 400MB are forget about it.
>
>
Remember to actually benchmark your differences too if possible (with
Hi.
On Thu 2002-09-05 at 09:09:07 -0500, [EMAIL PROTECTED] wrote:
> For clarity sake, assume the following:
>
> Red Hat Linux 7.1
> 2.4.8 kernel
> MySQL 3.23.42
> MyISAM databases
> 3GB RAM
> P3/700 x 4
> 15GB database spanned across ~200 tables
>
> Key_reads / Key_read_request = 0.00059875
