JF Prieur wrote:
>
> Hi,
>
> I have also been looking for suggested optimizations for MySQL under
> WinNT4/SP6a running on a dual P2/450 box with 256MB of RAM and 4*9GB Ultra
> SCSI drives but I can't seem to find anything. Any starting suggestions
> would be welcome.
First suggestion would be to replace the OS with Linux - 40% speedup according
to our benchmarks :-)
Otherwise, see http://www.mysql.com/php/manual.php3?section=Performance for
general hints.
For specifics, we need to see your tables and queries...
--
Sasha Pachev
+------------------------------------------------------------------+
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sasha Pachev |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sasha@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Provo, Utah, USA |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+------------------------------------------------------------------+