[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

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?


heres my _# free_ output BTW:
             total       used       free     shared    buffers     cached
Mem:        517260     318212     199048      13084      15888     244032
-/+ buffers/cache:      58292     458968
Swap:       256968          0     256968

and this is how part of my /etc/mysql/my.cnf looks like BTW just in case you
guys have some suggestions:
set-variable = connect_timeout=40
set-variable = max_connections=300
set-variable = join_buffer=16M
set-variable = key_buffer=256M
set-variable = record_buffer=16M
set-variable = sort_buffer=16M
set-variable = max_allowed_packet=2M
set-variable = thread_stack=128K
set-variable = table_cache=900

--- Russell Coker <russell@coker.com.au> wrote:
> 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.  Get 512M of RAM so that after a few 
> minutes all the data is in cache and no data has to be read from disk.

Do You Yahoo!?
Get Yahoo! Mail - Free email you can access from anywhere!

Reply to: