firebird-support : Message: Re: [firebird-support] Select count(*) from mon$attachments

firebird-support · Support for Users of Firebird Releases

Yahoo! Groups Tips

Did you know...

Want to share photos of your group with the world? Add a group photo to Flickr.

Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

Messages Help

Advanced

Select count(*) from mon$attachments kills connections

Message List

Reply | Forward

Message #100649 of 106268 |

Re: [firebird-support] Select count(*) from mon$attachments

vince.duggan@... wrote:
>
> However, selecting from the MON$ tables is pretty slow, and basically
> everything else stops while the query executes.

This is known and already fixed in v2.1.2:
http://tracker.firebirdsql.org/browse/CORE-2209

Dmitry

Thu Mar 5, 2009 8:34 pm

Show Message Option

Dmitry Yemanov <dimitr@...>

dimitr_ex

Offline

Send Email

Forward

Message #100649 of 106268 |

Expand Messages	Author	Sort by Date
Hi all, Running FirebirdCS-2.1.1.17910-0.amd64 under Linux Fedora core 9 version 2.6.27.15-78.2.23.fc9.x86_64 When the database is under a high load(i.e. over...	vince.duggan@... vince.duggan	Mar 5, 2009 2:49 pm
Just noticed that this is linked to a 'semaphores exhausted' error in the log file. However, I can run all these attachments without any errors for as long as ...	vince.duggan@... vince.duggan	Mar 5, 2009 3:16 pm
OK, sorted the problem by upping both the kernel semaphore settings and the firebird.conf setting: respectively : kernel.sem="1024 64000 1024 512" and ...	vince.duggan@... vince.duggan	Mar 5, 2009 4:15 pm
... This is known and already fixed in v2.1.2: http://tracker.firebirdsql.org/browse/CORE-2209 Dmitry...	Dmitry Yemanov dimitr_ex	Mar 5, 2009 8:34 pm

< Prev Topic | Next Topic >

Advanced

Yahoo! My Yahoo! Mail
	Sign In New User? Sign Up
		Tech - Groups - Help

Yahoo! Groups Tips

Did you know...

Best of Y! Groups

Messages