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
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: > 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
[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
