Announcement

Collapse
No announcement yet.

Excessive Table Locking

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

  • Excessive Table Locking

    Im having a problem with excessive table locking. I have my config set up to allow 250 connections to MySQL, problem is, VB is taking up almost all of those 250 connections. Last night is was 187 out of 250. So of course my users get the "Too many connections" VB error. Here's the processes.

    Code:
    | 76439 | turbobui_turbo | localhost | turbobui_turbo | Query | 126 | Copying to tmp table | SELECT thread.threadid, thread.postuserid, thread.title, thread.dateline, thread.forumid, post.paget |
    | 76440 | turbobui_turbo | localhost | turbobui_turbo | Query | 126 | Copying to tmp table | SELECT thread.threadid, thread.postuserid, thread.title, thread.dateline, thread.forumid, post.paget |
    | 76441 | turbobui_turbo | localhost | turbobui_turbo | Query | 126 | Copying to tmp table | SELECT thread.threadid, thread.postuserid, thread.title, thread.dateline, thread.forumid, post.paget |
    | 76443 | turbobui_turbo | localhost | turbobui_turbo | Query | 126 | Copying to tmp table | SELECT thread.threadid, thread.postuserid, thread.title, thread.dateline, thread.forumid, post.paget |
    | 76444 | turbobui_turbo | localhost | turbobui_turbo | Query | 126 | Copying to tmp table | SELECT thread.threadid, thread.postuserid, thread.title, thread.dateline, thread.forumid, post.paget |
    | 76477 | turbobui_turbo | localhost | turbobui_turbo | Query | 126 | Copying to tmp table | SELECT thread.threadid, thread.postuserid, thread.title, thread.dateline, thread.forumid, post.paget |
    | 76489 | turbobui_turbo | localhost | turbobui_turbo | Query | 126 | Copying to tmp table | SELECT thread.threadid, thread.postuserid, thread.title, thread.dateline, thread.forumid, post.paget |
    | 76492 | turbobui_turbo | localhost | turbobui_turbo | Query | 126 | Copying to tmp table | SELECT thread.threadid, thread.postuserid, thread.title, thread.dateline, thread.forumid, post.paget |
    | 76500 | turbobui_turbo | localhost | turbobui_turbo | Query | 126 | Copying to tmp table | SELECT thread.threadid, thread.postuserid, thread.title, thread.dateline, thread.forumid, post.paget |
    | 76505 | turbobui_turbo | localhost | turbobui_turbo | Query | 126 | Copying to tmp table | SELECT thread.threadid, thread.postuserid, thread.title, thread.dateline, thread.forumid, post.paget |
    | 76511 | turbobui_turbo | localhost | turbobui_turbo | Query | 126 | Copying to tmp table | SELECT thread.threadid, thread.postuserid, thread.title, thread.dateline, thread.forumid, post.paget |
    | 76513 | turbobui_turbo | localhost | turbobui_turbo | Query | 126 | Copying to tmp table | SELECT thread.threadid, thread.postuserid, thread.title, thread.dateline, thread.forumid, post.paget |
    | 76587 | turbobui_turbo | localhost | turbobui_turbo | Query | 126 | Copying to tmp table | SELECT thread.threadid, thread.postuserid, thread.title, thread.dateline, thread.forumid, post.paget |
    Anyone got any ideas or suggestions on anything I can do to improve this?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X