MySQL Forums
Forum List  »  Performance

Re: very poor performance of opening tables
Posted by: J G
Date: October 16, 2005 11:25AM

> Why 1600/s? Is this number based on previous
> performance numbers before you started
> experiencing issues?

I am able to reach about 2000q/s using the same queries but operating on limited number of tables (just flooding one of my sites).


> any specific reason why Gentoo would perform any
> better in this scenario than FreeBSD.

It supports faster filesystems (for exaple ReiserFS, XFS, JFS). Any way, IMHO, UFS+softupdates is more safe in my case.

> thing I can think of that may give you a
> performance benefit on Gentoo is doing a stage 1
> install with NPTL (Native Posix Thread Library)
> compiled into the kernel (use the USE flags: nptl
> nptlonly and remember you'll have to unmask for
> the most recent MySQL version when you emerge
> MySQL...).

Yes, I know it about it.


Best Regards
J G

Options: ReplyQuote


Subject
Views
Written By
Posted
19810
J G
September 23, 2005 06:11AM
7950
September 23, 2005 08:59AM
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
Re: very poor performance of opening tables
3586
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.