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 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 <[EMAIL PROTECTED]> 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!
http://mail.yahoo.com/
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
