Definitely switch to classic and make sure to update the CPS setting for xinetd and the max number of instances allowed (/etc/xinetd.conf) if you will have a lot of connections being made. I think we also up the semaphore setting as well (both in /etc/sysctl.conf and firebird.conf).
I also like to move the OS stuff to a separate drive container (usually running RAID 1) with the DB partition running on a RAID 5 setup like you described. -steve -- Steve Wiser President Specialized Business Software 6325 Cochran Road, Unit 1 Solon, OH 44139 www.specializedbusinesssoftware.com www.docunym.com (440) 542-9145 - fax (440) 542-9143 Toll Free: (866) 328-4936 On Mon, Aug 22, 2011 at 1:43 PM, Alexey Kovyazin <a...@ib-aid.com> wrote: > ** > > > Hello Myles, > > Switch to 1.5.6 Classic, set in firebird.conf > DefaultDbCachePages = 512 and you'll see the difference which should be > enough. > > Regarding migration - look at Profitmed migration case study > > http://www.slideshare.net/ibsurgeon/firebird-migration-from-firebird-15-to-firebird-25 > > Regards, > Alexey Kovyazin > IBsurgeon > > > > I have a new FB 1.5.6 Linux Super Server installation going online. > > This will eventually be upgraded to 2.1 or 2.5 but we have legacy code > > that keeps us in 1.5.6 for now. > > > > I have installed a 'default' build of FB 1.5.6 on CentOS 64 bit server, > > and its running as a virtual machine on OpenVZ/Proxmox. The > > configuration of the server is like this: > > > > Dell PowerEdge 2950, Dual Xeon 2.6Ghz CPUs (2 core per CPU I believe) > > RAID 5, with 3 x 1TB drives, 1 x 1TB Parity, and 1 Hot spare > > 16GB of RAM total for server, with 6GB allocated to CentOS for FB Server > > 1GB NICs > > > > The database feeds a web application running on a separate box. > > > > I have not applied any changes to the default firebird.conf setting. > > > > The server, under light load (about 8 users), is reporting a higher than > > normal CPU load, but almost no RAM load. > > > > The most intensive queries involve a lot of row retrieval, sorting and > > display, and I do not believe I have optimized this for sorting at all. > > Nor have I optimized for CPU affinity (which I'm not even sure I can > > do with SS 1.5.6 on Linux). I have also not optimized Cache size, and > > the DB is reporting page size at 16384. > > > > So can anyone give me a suggestion as to where to start to get more > > performance out of this beast? I know that FB upgrade would help a lot, > > but I can't address that in the next few months at least so I have to > > work with what I have got right now. I'm seeing that simple queries > > appear to be pretty fast, but the more complex ones that are already > > highly optimized are loading the server. > > > > Any thoughts? > > > > Myles > > -- > > ----------------------------- > > Myles Wakeham > > Director of Engineering > > Tech Solutions USA LLC > > www.techsolusa.com > > Phone +1-480-451-7440 > > > > > > [Non-text portions of this message have been removed] > > > > > This message and any files transmitted with it may contain information that > is privileged, confidential, and exempt from disclosure under applicable > law. They are intended solely for the use of the intended recipient. If > you are not the intended recipient, distributing, copying, disclosing, or > reliance on the contents of this communication is strictly prohibited. If > this has reached you in error, kindly destroy this message and notify the > sender immediately. Thank you for your assistance. > > We attempt to sweep harmful content (e.g. viruses) from e-mail and > attachments, however we cannot guarantee their safety and can accept no > liability for any resulting damage. The recipient is responsible to verify > the safety of this message and any attachments before accepting them. > [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 <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
