MySQL Forums
Forum List  »  Performance

Re: very poor performance of opening tables
Posted by: Jay Pipes
Date: September 25, 2005 10:34AM

To the best of my knowledge, SIGUSR2 is used to resume a suspended thread. Therefore, I would suspect that what's happening here is that due to the operating system having to handle tens of thousands of open file descriptors, a race condition is occurring where MySQL is asking for an available file descriptor from the operating system and is having to wait until one is available? Again, this is because of the *very* high number of tables needed in your server setup. That said, however, I am no expert on this type of stuff, and if one of the MySQL developers could weigh in here, that would be helpful. My best advice, other than getting an expert dev's opinion on this, would be to consider moving to a multiple db-server setup which can more effectively handle hundreds of thousands of file descriptors.

Let us know how things work out, and I'll keep my fingers crossed that one of the developer's is watching this thread. If you get no replies, perhaps consider posting this discussion (or the meat of it) to the internals mailing list and getting some opinions there.

cheers,

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com

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
4236
J G
September 23, 2005 10:51AM
4507
J G
September 25, 2005 09:45AM
Re: very poor performance of opening tables
3967
September 25, 2005 10:34AM
5386
J G
September 25, 2005 11:16AM
3812
September 26, 2005 06:02AM
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.