Re: MySQL Optimisation

2003-09-09 Thread Roger Baklund
* Jonathan Edwards > I'm running MySQL on a Linux server with 2 processors, 4 Gb memory and > SCSI disks. I am using MySQL to manage a database with 3 million reports > and various auxiliary tables which are also fairly large. > > My question is: How do I make the best use of the 4 Gb memory availa

MySQL Optimisation

2003-09-09 Thread Jonathan Edwards
Hi, I'm running MySQL on a Linux server with 2 processors, 4 Gb memory and SCSI disks. I am using MySQL to manage a database with 3 million reports and various auxiliary tables which are also fairly large. My question is: How do I make the best use of the 4 Gb memory available? I've tried increa