MySQL Forums
Forum List  »  Partitioning

Re: Thoughts on partitioning by hour - and which partition type?
Posted by: Phil Hildebrand
Date: June 09, 2008 08:44PM

You might consider moving your rcs_probe and java processes off to another server if possible - might help keeping database load to just the database processes itself.

I would think that under heavy insert load, partitioning could have an effect on CPU (due to the calculations needed in the optimizer for calculating the partitions), but I wouldn't think it would be much (as most of the cpu should be due to index btree/hash updating, etc)

Options: ReplyQuote

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.