Guys:

I'm still having a lot of trouble with 7.53 since I upgraded last week.

Normally, server load is between 0.10 and 0.50. Then, all of a sudden, load spikes to 3, 4, and this morning at 7:25-7:30 (far from peak time), to 6.20, and generation times to 300-400 seconds.

Here's what the slow query log says:

Code
ORDER BY p.POST_POSTED_TIME DESC
LIMIT 200;
# Time: 090701  7:27:20
# User@Host: XXXXXXXXXXXXXXXXXX @ XXXXXXXXXXXXXXXX []
# Query_time: 337  Lock_time: 322  Rows_sent: 1  Rows_examined: 272558
SELECT count(p.POST_ID)
		FROM ubbt_POSTS p,
				 ubbt_TOPICS t
		WHERE p.USER_ID IN ( 2, 247, 260, 289, 694, 1087, 1245, 2437, 2891, 3411, 6493, 6930, 7152, 8172, 8207, 8711, 11852, 12183, 12873, 14652, 14703, 22110, 22362 )
			AND	p.TOPIC_ID = t.TOPIC_ID
		and t.FORUM_ID not in ('42','66','69');

Here's another at the same time:

Code
# Time: 090701  7:27:05
# User@Host:XXXXXXXXXXXXXXXXXXXX @ XXXXXXXXXXXXXXXXXX []
# Query_time: 322  Lock_time: 0  Rows_sent: 200  Rows_examined: 3315585
SELECT p.POST_ID
		FROM 	ubbt_POSTS p LEFT JOIN ubbt_POSTS pp on p.POST_ID=pp.POST_ID,
					ubbt_TOPICS t
		WHERE p.POST_IS_APPROVED = '1'
			AND t.TOPIC_STATUS <> 'M'
			AND t.FORUM_ID IN ('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','43','44','45','46','47','48','49','50','51','52','53','55','56','57','58','59','61','62','63','64','65','67','68','70')
			AND p.TOPIC_ID = t.TOPIC_ID
		AND MATCH p.POST_SUBJECT AGAINST ('Columbia' IN BOOLEAN MODE)
		
		AND p.POST_POSTED_TIME > '1183386103'



I have the mysql search enabled, not internal, I have results limited to 200, and the weird thing is, a week ago when I was still on 7.1, I did not have these spikes. Something happened when I went from 7.1 to 7.53, and now, intermittently, but regularly throughout the day, the board will go from humming along with a very low load to basically being locked down for minutes at a time.

It's feast or famine!

Server is a dual Opteron, 4 GB of RAM, 4 15K RPM SCSI with RAID 10.

I'll take any help I can get. I'm willing to upgrade the server if necessary, but I can't believe that everything was humming along just fine with 7.1 and that 7.53 can't do the same with this server. Something, somewhere is not set right, I suspect, and I appreciate any help you fine folks can provide in helping me ID the problem.

Rick