On Wed, Jan 9, 2013 at 9:49 AM, Alex Vinnik <alvinnik(dot)g(at)gmail(dot)com> wrote:
> Guys, thanks a lot for your input. It is very valuable for us. We plan to
> fix a separate dev server similar to production one, copy all data there and
> try you suggestions as we really don't want to do it on production server. I
> also noticed that IOPS jumps to 100% when running this query. So it is a bit
> scary to make those changes in production directly. Will report back on the
> progress and findings.
nothing wrong with that, but keep in mind you can tweak
'effective_cache_size' for a single session with 'set' command;
merlin