Announcement

Collapse
No announcement yet.

MySQL Error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • borbole
    replied
    Are you on a dedicated server or a shared one?

    Leave a comment:


  • Lightbulbs
    started a topic MySQL Error

    MySQL Error

    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
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X