[firebird-support] Help: firebird and apache Processes doesn't die
Hi, I'm using Firebird 2.5 Super server, PHP 5.5 and Apache2 on Ubuntu 14.04 As I start apache server, and the web site gets visits, apache processes start to grow as well as firebird processes ( one per second ), nearly without limit. The memory consumption also increases. After a few seconds my site is unresponsive. If I stop apache, firebird processes don't decrease immediately as expected, but only after a minute they jump from the high quantity (for example 150) to 2 processes. Nevertheless, firebird doesn't release the memory. In my php scripts every ibase_pconnect sentence has it corresponding ibase_close sentence, inside a try statement. Any idea about why apache processes keep alive and also why they don't free firebird processes ? ( I'm in a hurry, because my site is not working ) Thanks in advance for any help. Aldo
Re: [firebird-support] Help: firebird and apache Processes doesn't die
Hi again, I tested it many times: after stopping Apache server, the quantity of Firebird processes decrease to 2, but the memory isn't released. Running "top -u firebird" command displays a lot of memory ( nearly 2 GBytes ) consumed by Firebird. Is this a bug in Firebird Super Server or it was designed this way ? Thanks, Aldo Caruso El 08/01/17 a las 17:12, Aldo Caruso aldo.car...@argencasas.com [firebird-support] escribió: Hi, I'm using Firebird 2.5 Super server, PHP 5.5 and Apache2 on Ubuntu 14.04 As I start apache server, and the web site gets visits, apache processes start to grow as well as firebird processes ( one per second ), nearly without limit. The memory consumption also increases. After a few seconds my site is unresponsive. If I stop apache, firebird processes don't decrease immediately as expected, but only after a minute they jump from the high quantity (for example 150) to 2 processes. Nevertheless, firebird doesn't release the memory. In my php scripts every ibase_pconnect sentence has it corresponding ibase_close sentence, inside a try statement. Any idea about why apache processes keep alive and also why they don't free firebird processes ? ( I'm in a hurry, because my site is not working ) Thanks in advance for any help. Aldo
Re: [firebird-support] Help: firebird and apache Processes doesn't die
10.01.2017 14:03, Aldo Caruso aldo.car...@argencasas.com [firebird-support] wrote: > Is this a bug in Firebird Super Server or it was designed this way ? It depends on which exactly consumed memory. If it is page cache and other internal Firebird structures, then it is by design. If it is memory leak from Firebird or UDF, it is a bug. Use monitoring tables to find out how much memory is consumed by Firebird itself. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ 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: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Help: firebird and apache Processes doesn't die
<> SuperServer wil hold cached data as long as any connections exist. Only when the last "real" user disconnects from the database will the cache be cleared. Which two users are still connected to the database? CACHE WRITER and GARBAGE COLLECTOR? If so then these should also finish with the last user connection. Paul
Re: [firebird-support] Help: firebird and apache Processes doesn't die
Dimitry, thanks for your answer. I'll follow your advice. Nevertheless, its still a bit strange that, when more connections are established, memory keeps increasing up to nearly all the RAM available ( 4 GBytes ). My database size is only 150 MBytes. Shouldn't page cache and firebird structures size kept in RAM be of the same order of magnitude as databse size in the worst case ? Aldo El 10/01/17 a las 11:32, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] escribió: > 10.01.2017 14:03, Aldo Caruso aldo.car...@argencasas.com [firebird-support] > wrote: >>Is this a bug in Firebird Super Server or it was designed this way ? > It depends on which exactly consumed memory. If it is page cache and > other internal > Firebird structures, then it is by design. If it is memory leak from Firebird > or UDF, it > is a bug. > Use monitoring tables to find out how much memory is consumed by Firebird > itself. > >
Re: [firebird-support] Help: firebird and apache Processes doesn't die
10.01.2017 16:09, Aldo Caruso aldo.car...@argencasas.com [firebird-support] wrote: > Shouldn't page cache and firebird structures size kept in RAM be of > the same order of magnitude as databse size in the worst case ? No. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ 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: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Help: firebird and apache Processes doesn't die
Paul, thanks for your answer. I see two firebird processes, and I'm sure there is no real user connected, as apache server is down. How could I find out whether CACHE_WRITER and GARBAGE_COLLECTOR processes are active ? Thanks Aldo El 10/01/17 a las 11:50, 'Paul Beach' pabe...@waitrose.com [firebird-support] escribió:> SuperServer wil hold cached data as long as any connections exist. Only when the last "real" user disconnects from the database will the cache be cleared. Which two users are still connected to the database? CACHE WRITER and GARBAGE COLLECTOR? If so then these should also finish with the last user connection. Paul
Re: [firebird-support] Help: firebird and apache Processes doesn't die
<> The pseudo table MON$ATTACHMENTS will tell you. Regards Paul
