MySQL Forums
Forum List  »  Performance

Re: very poor performance of opening tables
Posted by: J G
Date: September 23, 2005 10:40AM

> 2 GB of ram?? That seems really really small.

Seems to be good for me. Increasing my buffors don't gives me a performance increase, now I've query_cache at 128MB, key_buffer at 512MB, others are quiet small. My apache&PHP is good optimized I've very small Apache processess.

> I'm
> always complaining that I only have 4 GB of ram.
> Since you have so many databases why not spread
> them out over different servers (machines)??

It's because fistly I had one big database with milions of tables. I has divided this to many databases a few weeks ago. No it's possible to share it to different servers, earlier it wasn't.
Any way It's much easier to manage one machine... and this takes less time. Also it's cheaper [for me] to buy one very fast server rather than lots of low-ends.

Options: ReplyQuote


Subject
Views
Written By
Posted
19810
J G
September 23, 2005 06:11AM
7950
September 23, 2005 08:59AM
Re: very poor performance of opening tables
4851
J G
September 23, 2005 10:40AM
4237
J G
September 23, 2005 10:51AM
4508
J G
September 25, 2005 09:45AM
3968
September 25, 2005 10:34AM
5386
J G
September 25, 2005 11:16AM
3812
September 26, 2005 06:02AM
3587
J G
October 16, 2005 11:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.