(Ryan Thiessen) I have found that MySQL RANGE partitions on the primary key are a great way to achieve scale for insert-heavy InnoDB tables. I have used this to maintain an excellent and predictable insert rate, to avoid some of the well documented problems with insert performance as table sizes gr
Read More - Register for Free Membership
