#2505 MySql goes to 100% load on search

v4.2.0
closed
nobody
None
5
2009-02-01
2009-02-01
rick
No

When I use the general search function, MySql used 100% processor load and the site times out. I need to kill the query or restart MySql.
The functions soundex and advanced search seems to work okay.

Discussion

  • rick
    rick
    2009-02-01

    • status: open --> closed
     
  • rick
    rick
    2009-02-01

    Solved this issue by updating the database items and itself to UTF8_general_ci.
    There where some table entries with a different collation.

    Rick