[drupal-support] Large taxonomy hangs server?

[Gerhard Killesreiter]

On Thu, 26 May 2005, Álvaro Ortiz wrote:

> We have a Drupal 4.5 site running on a Pentium 4 with 1GB RAM
> (shared with other sites: one Drupal 4.5, some WordPress, some MT)
> and it might be that Drupal has been responsible for hanging it
> several times. The server gets collapsed and the only solution is to
> restart it - the hard way.
>
> (Ruby On Rails was the suspect so we move it to another server, but now
> it has happened again)
>
> The site < http://www.popmadrid.com > is a music community/ecommerce
> site [1], with two vocabularies (bands and labels) with +700 (seven
> hundren) terms each (being this huge vocabs the new suspects...). And
> not much traffic: 1200 users daily and 5000 page views.
>
> We activated the MySQL logs (general and slow) since last time and this
> morning the server crashed again. So we have fresh material to look at :)

Since you are not telling us which queries get slow, I'll have to ask my
chrystal ball.

My chrystal ball says that some queries in Drupal 4.6 indeed were less
than optimal. In particular those for the access controll system. Teh
chrystal ball recommends to update to Drupal 4.6.

Cheers,
	Gerhard