MySQL Forums :: Partitioning :: Advice on partitioning


Advanced Search

Re: Advice on partitioning
Posted by: Rick James ()
Date: June 15, 2015 07:05PM

I'm looking forward to hear how it goes. Test with 2 servers (to test sharding) and enough records on each machine to exercise the indexes, caches, etc., in a realistic way.

You might consider normalizing `sender`, `to`, and `folder` to save a little space.

`parent_id` is `INT UNSIGNED`; is that big enough?

Options: ReplyQuote


Subject Views Written By Posted
Advice on partitioning 1598 me su 04/24/2015 01:40PM
Re: Advice on partitioning 911 Rick James 04/24/2015 05:34PM
Re: Advice on partitioning 849 Mehdi Salarkia 04/27/2015 09:05AM
Re: Advice on partitioning 895 Rick James 04/27/2015 02:22PM
Re: Advice on partitioning 749 Drew Morris 04/28/2015 11:02AM
Re: Advice on partitioning 781 Rick James 04/28/2015 12:32PM
Re: Advice on partitioning 810 Mehdi Salarkia 04/28/2015 04:07PM
Re: Advice on partitioning 658 Mehdi Salarkia 06/15/2015 06:39PM
Re: Advice on partitioning 802 Rick James 06/15/2015 07:05PM
Re: Advice on partitioning 751 Mehdi Salarkia 06/16/2015 06:40PM


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.