[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- To: misc_(_at_)_openbsd_(_dot_)_org
- Subject: Re: BUFCACHEPERCENT.
- From: RV Tec <rvt_(_at_)_shell2_(_dot_)_lomag_(_dot_)_net>
- Date: Wed, 9 Jun 2004 12:31:32 -0400 (EDT)
> is the performance slow now? how large is your database? does mysql use
> read/write? or mmap? does it do its own caching? how will you know if
> performance improves?
Performance is an issue, specially because we've unused memory laying
around. I've about 50 concurrent connections, which brings lots of locks.
MySQL uses index cache to some extent... I've been used 384MB of it
(suggested value for this ammount of memory). And everything is running
smoothly (although, seems like I've 1.5GB of dead memory).
Everytime I try to increase this, MySQL goes insane and leaves me
hanging with a error 127 or 134 (table errors mostly) or crashes with a
signal 11 -- (and yes, I've tested/changed the RAM).
Database is around 6GB, with 150 tables (most of them are really small --
only 5 are huge: 8.000.000 records, increasing 1.000.000 per month).
MySQL is using mmap (at least, it was compiled with it):
configure:30333: checking for working mmap
configure:30498: result: yes
I'd believe that someday I'm going to run out of resources, and I will
have to use some other platform (maybe AMD64?), but until that day, I
would like to squeeze as much power as one can get from this hardware. Any
gain in performance would at least delay my pain.
I could try raising it little by little, and see what happens, but I'm
afraid to raise that and create a new problem. That's why I would like to
hear some advice...
Thanks a lot, folks!
Visit your host, monkey.org