MySQL Forums
Forum List  »  Optimizer & Parser

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
3948
September 05, 2010 08:16PM
1362
September 11, 2010 01:22PM
1587
September 12, 2010 11:09PM
1413
September 13, 2010 10:56AM
1431
September 13, 2010 08:15PM
Re: NOP optimises Group By? -solved
1357
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.