I just upgraded to 7-4-1, a few days later my hosting company suspended my site. I was informed by my host that the site has a mysql slow queries problem. I have to admit, I have no idea what this means?

My host says it's a problem with the ubb software--says my account will remain frozen until I have it optimized. ?? Below is just a sample of what in my mysql_slow_queries folder.

Help!

# Mon Dec 15 18:00:04 2008
# Query_time: 491 Lock_time: 240 Rows_sent: 1 Rows_examined: 1
use ascensio_gravsportsice07;
SELECT t2.USER_TIME_OFFSET,t2.USER_TOPIC_VIEW_TYPE,t2.USER_TIME_FORMAT, t1.USER_ID, t1.USER_DISPLAY_NAME, t1.USER_PASSWORD, t1.USER_SESSION_ID, t1.USER_MEMBERSHIP_LEVEL, t1.USER_IS_BANNED,t1.USER_RULES_ACCEPTED, t1.USER_IS_UNDERAGE, t2.USER_TOTAL_PM, t2.USER_STYLE, t2.USER_HIDE_LEFT_COLUMN,t2.USER_HIDE_RIGHT_COLUMN, t2.USER_LANGUAGE, t2.USER_MOOD, t2.USER_RELATIVE_TIME, t2.USER_TIME_OFFSET,t2.USER_SHOW_ALL_GRAEMLINS, t2.USER_AVATAR, t2.USER_TITLE, t2.USER_CUSTOM_TITLE, t2.USER_NAME_COLOR, t2.USER_SHOW_LEFT_MYSTUFF
FROM ubbt_USERS as t1,
ubbt_USER_PROFILE as t2
WHERE t1.USER_ID = 341
AND t1.USER_ID = t2.USER_ID

# Mon Dec 15 18:00:05 2008
# Query_time: 838 Lock_time: 582 Rows_sent: 0 Rows_examined: 0
use ascensio_gravsportsice07;
SELECT t2.USER_TOPIC_VIEW_TYPE, t2.USER_TIME_FORMAT, t2.USER_TOPICS_PER_PAGE, t1.USER_ID, t1.USER_DISPLAY_NAME, t1.USER_PASSWORD, t1.USER_SESSION_ID, t1.USER_MEMBERSHIP_LEVEL, t1.USER_IS_BANNED,t1.USER_RULES_ACCEPTED, t1.USER_IS_UNDERAGE, t2.USER_TOTAL_PM, t2.USER_STYLE, t2.USER_HIDE_LEFT_COLUMN,t2.USER_HIDE_RIGHT_COLUMN, t2.USER_LANGUAGE, t2.USER_MOOD, t2.USER_RELATIVE_TIME, t2.USER_TIME_OFFSET,t2.USER_SHOW_ALL_GRAEMLINS, t2.USER_AVATAR, t2.USER_TITLE, t2.USER_CUSTOM_TITLE, t2.USER_NAME_COLOR, t2.USER_SHOW_LEFT_MYSTUFF
FROM ubbt_USERS as t1,
ubbt_USER_PROFILE as t2
WHERE t1.USER_ID = 0
AND t1.USER_ID = t2.USER_ID

# Mon Dec 15 18:00:05 2008
# Query_time: 238 Lock_time: 218 Rows_sent: 0 Rows_examined: 0
use ascensio_gravsportsice07;
update ubbt_USERS
set USER_SESSION_ID = '381a4c3e139cd966cef9407ab2419a9a'
where USER_ID = 341

Last edited by EJH; 12/17/2008 10:50 PM.