MySQL Forums
Forum List  »  Optimizer & Parser

Re: NOP optimises Group By? -solved
Posted by: Rick James
Date: September 13, 2010 10:46PM


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.

Options: ReplyQuote

Written By
September 05, 2010 08:16PM
September 11, 2010 01:22PM
September 12, 2010 11:09PM
September 13, 2010 10:56AM
September 13, 2010 08:15PM
Re: NOP optimises Group By? -solved
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.