Hi Folks,

in Drupal 5.6, the Search module eliminates my MySQL server with long-running tasks. The start to appear about one hour after starting the server and then multiply every few hour, until they consume all server ressources and mysqld dies.

In "mytop", I can monitor these queries; they continue to run for hours and never go away or finish. They look like follows:

SELECT t.word AS realword, i.word FROM search_total t LEFT JOIN search_index i ON t.word = i.word WHERE i.word IS NULL

This is absolutely reproducable on my Drupal installation; it goes away completely as soon as I disable search module. If I allow the broken Search module to run, it completely crashes the server (not only mysqld!) about once a day. Thus I consider this bug as critical.

Thanks for any help!

Regards, -asbdpl

Comments

asbdpl’s picture

asbdpl commented

Sorry, the "mytop" output was swallowed:

SELECT t.word AS realword, i.word FROM search_total t LEFT JOIN search_index i ON t.word = i.word WHERE i.word IS NULL
robertdouglass’s picture

robertdouglass commented
Status: Active » Closed (works as designed)

Yup. Improved in D6. Try optimizing MySQL for its usage of temporary tables. Temp tables are removed in D6. Alternatively for D5 you can use the ApacheSolr module which performs better and has more features.