FW: Optimization

2002-01-17 Thread Ioakim Spyros
Hello all,   I'm having real trouble trying to optimize MySQL cause I can't believe that MSSQL is faster. My configurations are as follows: MSSQL 2000 on W2K server. PIII 733 - 512 MB memory. MySQL-3.23.47-1 on Redhat 7.2. Dual PIII 1000 - 1.128 GB memory   I have a PHP script that runs on a Redh

Re: FW: OPTIMIZATION

2001-05-24 Thread Tonu Samuel
On 23 May 2001 00:15:52 -0400, Randy Johnson wrote: > > Please give me advice on optimizing my server: Here are the system specs > > dual 733 Pentium > 512 megs of ram > > 9 gig scsi > > -- > > Here is the options that I use based on the documentation for a mode

FW: OPTIMIZATION

2001-05-22 Thread Randy Johnson
Please give me advice on optimizing my server: Here are the system specs dual 733 Pentium 512 megs of ram 9 gig scsi -- Here is the options that I use based on the documentation for a moderate # of users: -O max_connections=1000 -O key_buffer=64M -O table_ca