UBB.threads PHP Forum Software Community Forums UBB.threads 7 Version 7 Support Could table type be an issue?

Rick, et al,

I posted in another thread about my forum on occasion becoming extremely slow and sometimes just plain locking up. I ran the script Dave D pointed me to and made some suggested fixes, but the problem persists. I've turned on slow query logging and and have been slogging through that log to see if I can find any common problem queries. In the meantime, I have noticed that on those occassions when the forum gets extremely slow or just locks up, I go and look at "SQL Processes" and see a bunch of queries with a "locked" status.

Based on that I did some research and learned that there can be a problem with locked tables when a very long query is being done. It seems this is more of a problem when the table type is MyISAM versus InnoDB. I am just wondering if, due to my forum now being rather large after 8 years, that the Table type for some of my larger tables "might" be a problem? Just wondering if anyone has any experience with the two different table types and whether you think this "might" be part of my problem?

Basil

the only table to worry about is ubbt_POSTS -- i have a site where that table is 1.6gig and runs fine..

i've always wanted to split the posts table up and syphon off the POST_BODY or DEFAULT_POST_BODY as its own parallel table.. that would divide table size by roughly half

MyISAM shouldn't be a prob..

Also, once you are 'up / running smooth' -- turn off the slow query dealio.. that should only be there as a temp. tool