system locking up.

[IMelavin]

Hello friends,
After installing, a database of modest size is starting to regularly "freeze", where the processlist swells to dozens of entries and the simplest SELECT query take minutes to complete. The same small set of queries seems to cause no problem elsewhere. The access might be blocked for several minutes and system response is extremely slow for a longer time period. The database is using 'localhost' and the PHP mysql database interface. Any reply would be appreciated.
thanx!! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[gilbert]

If the processlist contain selects only or there are updating statements too. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --