MySQL Forums
Forum List  »  Optimizer & Parser

Re: NOP optimises Group By? -solved
Posted by: Peter Griffioen
Date: September 13, 2010 08:15PM

Thanks Rick,

I'll make those changes.

On this beast I have 96GB of Ram so I've lazy setting efficient values for buffers. This is one of 4 big DBs on the machine. Others are Aus Global warming model prediction maps for 100 years into the future, all flora and fauna records, 100 years of fire maps as a DB similar to the spp DB.

However the DB I'm most proud of is the model controller which coordinates async mulithreaded distributed modelling software (up to 50 cores chugging data in and out). When we arc it up it runs for weeks over 10 or more machines! That uses MyIsam for a temporary map cache for the output of 900Mpixel multilayer maps (1-8gb). It shuffles BLOBs which I which I wish I could put in a RAM table. Generally these sections of the map are only in the table for a minute or two while the slowest core catches up so the map can be written in order. It generally recovers if a procesor falls over but failing that I generally wipe this table and restart the current model. If I may indugle 3 more questions:

RAM tables and BLOBS, is it going to happen?
And is it possible to switch off logging, rollback capability and all of the overhead normally associated with just that table?
And finally I have another(!) 96GB machine under my desk with Unbutu. Would that be a better MYSQL server?

Thanks again for you help. I realy appreciate it. And God am I impressed with the stability and power of MYSQL!

Options: ReplyQuote

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