>> following through this thread and I agree it is a programming error >> causing a waste of resources. But I am confused as to why this is a >> problem for Firebird. I thought that lots of short transactions was >> actually something to be encouraged over long running transactions. Is >> there some limit to # of transactions / time period? >> > The installation was using Firebird 2.5.2 SC. There was near 800000 > transactions/day, more than a half between 8:00 AM and 15:00PM. > > The system runs fine and the performance was good except the problems of page > conversion, some minutes the System was frozen (10 minutes) at 9:30 AM, and > the crash i had deleting one attachment. > > 1. The frozen may be because a sweep was executed. I had sweep interval set > to 20000. Now is disabled and executed at night.
Ok. Just a note. In a recent 2.5.2 snapshot build, King Vlad added support for tracing the sweep process via the Trace API. Very useful! Let me know if you want a recent FB TraceManager build, which has support for that. > 2. The page conversion, i think is solved, when we corrected the overhead > generated by the transactions. During load, I would run fb_lock_print to check the lock table size and hash slots. Check out Dmitry's conference session, if you are curious: http://www.youtube.com/watch?v=iYNjwbYcjuc > 3. The crash deleting the attachment, is complicated to reproduce now, > because I think the source is the amount of transactions. I'm worried with > this one, because I don't like engine crash. > > May be this amount of transactions is not good for Firebird. 600000 transactions / day, uniformly distributed means ~ 7 transactions per second, which is nothing. I'm sure you don't have that pattern in production, thus e.g. the most busy hour in respect to transaction throughput might be interesting. I would also check out the header page regularly and its transaction counters. Combined with the monitoring table and Trace API, you have a toolset to identify the offending operations. -- With regards, Thomas Steinmaurer http://www.upscene.com/ > Regards, jesus > > [Non-text portions of this message have been removed] > > > > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Resources item > on the main (top) menu. Try Knowledgebase and FAQ links ! > > Also search the knowledgebases at http://www.ibphoenix.com > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > Yahoo! Groups Links > > >
