Performance has been better since I turned on "persistent connections"... but I noticed about 25 error messages from an hour ago when the MySQL calls failed due to "maximum_connections" error.

I just went in and saw these three processes running. The first one looks odd to me -- with the comment about copying to a "temp table". Is that unusual? What do you think?

- - - - -SQL LOG - - - - - - - - - - - - - - -
35266 vccachat localhost:4598 vccachat_org_-_chat Query 39 Copying to tmp table SELECT p.POST_ID FROM ubbt_POSTS p LEFT JOIN ubbt_POSTS pp on p.POST_ID=pp.POST_ID, ubbt_TOP

35289 vccachat localhost:4636 vccachat_org_-_chat Query 0 show processlist

35291 vccachat localhost:4638 vccachat_org_-_chat Query 0 Sending data select t1.TOPIC_ID,t1.POST_ID,t2.USER_DISPLAY_NAME,t1.TOPIC_CREATED_TIME,t1.TOPIC_LAST_REPLY_TIME,t
------------------------------------------------------------



--BIll B