Re: Resources for Query
Posted by:
Rick James
Date: April 30, 2016 11:31PM
No.
Why would you want to?
Ill make a guess. You have a big analytics query, and you don't want to interfere with live traffic.
CPU: You probably have several cores. MySQL uses no more than one core per connection. So, no problem.
Memory: In general the caching mechanism are robust. Even the case where you do a table scan, the buffer_pool will not be completely flushed out.
Threads: One connection = one thread.
I/O: Linux (etc) do a good job of keeping on process from being too much of a hog. (Windows is less intelligent about I/O allocation.)
Subject
Written By
Posted
Re: Resources for Query
April 30, 2016 11:31PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.