Re: NOP optimises Group By? -solved
Posted by:
Rick James
Date: September 13, 2010 10:46PM
Impressive!
RAM tables -- I assume you mean ENGINE=MEMORY. And you would like to avoid degenerating to MyISAM? Consider using a chunk of your RAM as a Ram-disk. And point tmp_dir to it. Then, MyISAM for a tmp table will (I think) be memory based.
Switching off logging -- Are you referring to InnoDB? No. If MyISAM, then I don't know what logging you are referring to.
Ubantu, etc. -- Rarely do I hear of big differences between Operating Systems or "similar" Hardware.
Consider the tradeoffs between compression (in your app, via zlib or whatever) versus network bandwidth and/or I/O speed.
Subject
Views
Written By
Posted
4098
September 05, 2010 08:16PM
1430
September 11, 2010 01:22PM
1669
September 12, 2010 11:09PM
1491
September 13, 2010 10:56AM
1502
September 13, 2010 08:15PM
Re: NOP optimises Group By? -solved
1425
September 13, 2010 10:46PM
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.