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.
Anyone got any ideas or suggestions on anything I can do to improve this?
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 |