Open Mysql threads - server crash

Author Message

laurent le cadet

Monday 25 September 2006 12:27:02 am

Hi,

I have a problem with 1 site which keeps mysql Threads open (more than 100 threads at the same time).
It makes the server crash.

This is an old site (3.2-1) that I planned to upgrade (but no time actually).
I don't know where to look for in phpMyadmin or anywhere else to solve this problem.

The site is quiet slow and I think that if we don't wait for the end of the querie and clic on another link of the site, the thread will stay open.

Please, give me a hint.

regards.

Laurent

Per-Espen Kindblad

Monday 25 September 2006 3:48:32 am

What kind of queries? Related to the search-function?

Per-Espen

laurent le cadet

Monday 25 September 2006 5:00:44 am

Per-Epsen,

No, I don't think it's related to the search engine. It's look like much more regular querie like clicking on a link.

I tryed to optimized the cache :

[ContentSettings]
ViewCaching=enabled

[TemplateSettings]
NodeTreeCaching=enabled

But there is no real effect.

Laurent

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.