MySQL Forums
Forum List  »  General

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.)

Options: ReplyQuote


Subject
Written By
Posted
April 26, 2016 04:55PM
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.