MySQL Error

محروم.كوم · #1 07-06-2010, 07:40 PM

After a server migration a few days ago I thought my vbulletin software was functioning well but then this happened. This is what is in the Mysql processes. It keeps showing queries that say it's copying to tmp table. The first one hangs up, then the second then so forth until there are 200 of these and the server crashes. Any help would be appreciated. I'm willing to hire an expert to fix this.

59 vbulletin_bob localhost vbulletin_steve Query 7 Copying to tmp table SELECT COUNT(thread.threadid) AS threads, thread.postuserid, thread.dateline, user.userid, user.user
160 vbulletin_bob localhost vbulletin_steve Query 7 Copying to tmp table SELECT COUNT(thread.threadid) AS threads, thread.postuserid, thread.dateline, user.userid, user.user
161 vbulletin_bob localhost vbulletin_steve Query 7 Copying to tmp table SELECT COUNT(thread.threadid) AS threads, thread.postuserid, thread.dateline, user.userid, user.user
162 vbulletin_bob localhost vbulletin_steve Query 7 Copying to tmp table SELECT COUNT(thread.threadid) AS threads, thread.postuserid, thread.dateline, user.userid, user.user
163 vbulletin_bob localhost vbulletin_steve Query 6 Copying to tmp table SELECT COUNT(thread.threadid) AS threads, thread.postuserid, thread.dateline, user.userid, user.user
165 vbulletin_bob localhost vbulletin_steve Query 6 Copying to tmp table SELECT COUNT(thread.threadid) AS threads, thread.postuserid, thread.dateline, user.userid, user.user
167 vbulletin_bob localhost vbulletin_steve Query 5 Copying to tmp table SELECT COUNT(thread.threadid) AS threads, thread.postuserid, thread.dateline, user.userid, user.user
168 vbulletin_bob localhost vbulletin_steve Query 5 Copying to tmp table SELECT COUNT(thread.threadid) AS threads, thread.postuserid, thread.dateline, user.userid, user.user
170 vbulletin_bob localhost vbulletin_steve Query 4 Copying to tmp table SELECT COUNT(thread.threadid) AS threads, thread.postuserid, thread.dateline, user.userid, user.user
171 vbulletin_bob localhost vbulletin_steve Query 4 Copying to tmp table SELECT COUNT(thread.threadid) AS threads, thread.postuserid, thread.dateline, user.userid, user.user
172 vbulletin_bob localhost vbulletin_steve Query 4 Copying to tmp table SELECT COUNT(thread.threadid) AS threads, thread.postuserid, thread.dateline, user.userid, user.user
173 vbulletin_bob localhost vbulletin_steve Query 4 Copying to tmp table SELECT COUNT(thread.threadid) AS threads, thread.postuserid, thread.dateline, user.userid, user.user
175 vbulletin_bob localhost vbulletin_steve Query 3 Copying to tmp table SELECT COUNT(thread.threadid) AS threads, thread.postuserid, thread.dateline, user.userid, user.user
176 vbulletin_bob localhost vbulletin_steve Query 3 Copying to tmp table SELECT COUNT(thread.threadid) AS threads, thread.postuserid, thread.dateline, user.userid, user.user
178 vbulletin_bob localhost vbulletin_steve Query 3 Copying to tmp table SELECT COUNT(thread.threadid) AS threads, thread.postuserid, thread.dateline, user.userid, user.user
177 vbulletin_bob localhost vbulletin_steve Query 2 Copying to tmp table SELECT COUNT(thread.threadid) AS threads, thread.postuserid, thread.dateline, user.userid, user.user
179 vbulletin_bob localhost vbulletin_steve Query 2 Copying to tmp table SELECT COUNT(thread.threadid) AS threads, thread.postuserid, thread.dateline, user.userid, user.user
180 vbulletin_bob localhost vbulletin_steve Query 2 Copying to tmp table SELECT COUNT(thread.threadid) AS threads, thread.postuserid, thread.dateline, user.userid, user.user
181 vbulletin_bob localhost vbulletin_steve Query 2 Copying to tmp table SELECT COUNT(thread.threadid) AS threads, thread.postuserid, thread.dateline, user.userid, user.user
182 vbulletin_bob localhost vbulletin_steve Query 2 Copying to tmp table SELECT COUNT(thread.threadid) AS threads, thread.postuserid, thread.dateline, user.userid, user.user
184 vbulletin_bob localhost vbulletin_steve Query 2 Copying to tmp table SELECT COUNT(thread.threadid) AS threads, thread.postuserid, thread.dateline, user.userid, user.user
185 vbulletin_bob localhost vbulletin_steve Query 1 Copying to tmp table SELECT COUNT(thread.threadid) AS threads, thread.postuserid, thread.dateline, user.userid, user.user
187 vbulletin_bob localhost vbulletin_steve Query 1 Copying to tmp table SELECT COUNT(thread.threadid) AS threads, thread.postuserid, thread.dateline, user.userid, user.user
186 vbulletin_bob localhost vbulletin_steve Query 1 Copying to tmp table SELECT COUNT(thread.threadid) AS threads, thread.postuserid, thread.dateline, user.userid, user.user
188 vbulletin_bob localhost vbulletin_steve Query 0 Copying to tmp table SELECT COUNT(thread.threadid) AS threads, thread.postuserid, thread.dateline, user.userid, user.user
190 vbulletin_bob localhost vbulletin_steve Query 1 Copying to tmp table SELECT COUNT(thread.threadid) AS threads, thread.postuserid, thread.dateline, user.userid, user.user
191 vbulletin_bob localhost vbulletin_steve Query 0 Copying to tmp table SELECT COUNT(thread.threadid) AS threads, thread.postuserid, thread.dateline, user.userid, user.user

193 vbulletin_bob localhost vbulletin_steve Query 0 Copying to tmp table SELECT COUNT(thread.threadid) AS threads, thread.postuserid, thread.dateline, user.userid, user.user
192 vbulletin_bob localhost vbulletin_steve Query 1 Copying to tmp table SELECT COUNT(thread.threadid) AS threads, thread.postuserid, thread.dateline, user.userid, user.user __DEFINE_LIKE_SHARE__