Re: what'll make a good mysql server

On 2000-10-12 19:09, t s a d i wrote: > what hardware can you recommend? single processor? dual? SCSI's? > i need all the speed i can get (my mysql db is about 300MB big) ... If you have a small database then the solution to most performance problems is to make RAM larger than the database.

Re: what'll make a good mysql server

i actually have 512M of RAM and havent maximized it yet. is it possible to "force" mysql to load all data in RAM just like what you mentioned below? TIA, chad heres my _# free_ output BTW: total used free sharedbuffers cached Mem:517260 318212

Re: what'll make a good mysql server

On 2000-10-13 12:53, t s a d i wrote: >i actually have 512M of RAM and havent maximized it yet. is it possible to >"force" mysql to load all data in RAM just like what you mentioned below? AFAIK it's not directly possible and probably not desirable. I think it's probably better to have things