KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
i have an issue with my current database with mysql. i have over 100 connection waiting on a select record. when i execute: show processlist; the select query is a big query and the others are smaler queries and inserts, updates. i have one database with 100 tables and the select is using 5 joins. is there a way to temporary stop the process and let the other processes run, once all the processes are completed, then the select can continue running?
Tags (comma-separated)
Save Edits
Cancel