Re: [sqlite] Database locks up on AMD64/PHP
On Tue, 7 Mar 2006, Firman Wandayandi wrote: On 3/7/06, Stefan de Konink [EMAIL PROTECTED] wrote: Hello, We are running SQLite 2.8.16 together with PHP5 on Linux. And it runs our TV Newspaper System. It was running on a PIII-1GHz but due some shifts for rendering performance increase (Inkscape SVG - PNG) we moved the complete application to an AMD64. The last weeks it seems the database got locked very often, and made the apache/php system 'hang', not on query but on insert. Restarting Apache solves the problem making me wonder what I can do to visualize the problem or even fix it. As temporary fix I already tried to decrease the database size (now at 7MB). But this only increase speed (for now). What's this meant? What part isn't clear? Stefan
Re: [sqlite] Database locks up on AMD64/PHP
On 3/7/06, Stefan de Konink [EMAIL PROTECTED] wrote: On Tue, 7 Mar 2006, Firman Wandayandi wrote: On 3/7/06, Stefan de Konink [EMAIL PROTECTED] wrote: Hello, We are running SQLite 2.8.16 together with PHP5 on Linux. And it runs our TV Newspaper System. It was running on a PIII-1GHz but due some shifts for rendering performance increase (Inkscape SVG - PNG) we moved the complete application to an AMD64. The last weeks it seems the database got locked very often, and made the apache/php system 'hang', not on query but on insert. Restarting Apache solves the problem making me wonder what I can do to visualize the problem or even fix it. As temporary fix I already tried to decrease the database size (now at 7MB). But this only increase speed (for now). What's this meant? What part isn't clear? Nothing, it's just like annoucement. Well, sorry I didn't read carefully the second paragraph. I have no idea it could be happened, seems something has vacummed your databases, well not sure. -- Firman Wandayandi, Tarzilla Foundation. Never Dreamt Before: http://firman.dotgeek.org/ Wishlist: http://www.amazon.com/gp/registry/1AAN8NZBHW2W9
[sqlite] Database locks up on AMD64/PHP
Hello, We are running SQLite 2.8.16 together with PHP5 on Linux. And it runs our TV Newspaper System. It was running on a PIII-1GHz but due some shifts for rendering performance increase (Inkscape SVG - PNG) we moved the complete application to an AMD64. The last weeks it seems the database got locked very often, and made the apache/php system 'hang', not on query but on insert. Restarting Apache solves the problem making me wonder what I can do to visualize the problem or even fix it. As temporary fix I already tried to decrease the database size (now at 7MB). But this only increase speed (for now). Yours Sincerely, Stefan de Konink
Re: [sqlite] Database locks up on AMD64/PHP
On 3/7/06, Stefan de Konink [EMAIL PROTECTED] wrote: Hello, We are running SQLite 2.8.16 together with PHP5 on Linux. And it runs our TV Newspaper System. It was running on a PIII-1GHz but due some shifts for rendering performance increase (Inkscape SVG - PNG) we moved the complete application to an AMD64. The last weeks it seems the database got locked very often, and made the apache/php system 'hang', not on query but on insert. Restarting Apache solves the problem making me wonder what I can do to visualize the problem or even fix it. As temporary fix I already tried to decrease the database size (now at 7MB). But this only increase speed (for now). What's this meant? -- Firman Wandayandi Never Dreamt Before: http://firman.dotgeek.org/ Wishlist: http://www.amazon.com/gp/registry/1AAN8NZBHW2W9