Page 1 of 1
Allowing MySQL to process more than 1 query at once
Posted: Wed Oct 29, 2008 8:01 am
by impulse()
We have a FreeBSD server running MySQL 4 that is used heavily but a problem I'm running into sometimes is that I can run a query that takes several minutes to complete and this is bottlenecking the server leaving hundreds of other queries in a que while my fat query get processed.
Is there any server configuration that would allow those queries in the que to get processed while my fat query continues?
Thanks,
Re: Allowing MySQL to process more than 1 query at once
Posted: Wed Oct 29, 2008 9:15 am
by playgames
are you used index key for the table?
Re: Allowing MySQL to process more than 1 query at once
Posted: Wed Oct 29, 2008 9:38 am
by impulse()
Yes.
I have 3 tables and 2 of those have over 4 million rows in, which is causing the hold up. But my query is selecting every row in the table anyway.
Re: Allowing MySQL to process more than 1 query at once
Posted: Wed Oct 29, 2008 8:59 pm
by playgames
post up table's structure and index key .
maybe you need to partition your table (but mysql4 not support it,only mysql 5)
Re: Allowing MySQL to process more than 1 query at once
Posted: Wed Oct 29, 2008 9:41 pm
by Eran
Run EXPLAIN on the query and post the results here
Re: Allowing MySQL to process more than 1 query at once
Posted: Wed Oct 29, 2008 10:18 pm
by s.dot
The table's probably being locked while waiting for your query to finish executing. I'm not sure what you can do about it, but reading about
table locks couldn't hurt.