MySQL Forums
Forum List  »  Partitioning

Re: Partitioning help
Posted by: Rick James
Date: October 13, 2010 06:03PM

1000 inserts/minute = 17/second -- not a problem in either engine.

When using both InnoDB and MyISAM, these are a good starting point:
innodb_buffer_pool_size = 30% of RAM
key_buffer_size = 10% of RAM

Options: ReplyQuote


Subject
Views
Written By
Posted
3329
September 24, 2010 02:16AM
1791
September 25, 2010 01:09PM
1755
September 27, 2010 03:43AM
1732
September 27, 2010 07:55PM
1700
October 12, 2010 01:55AM
1680
October 12, 2010 08:03AM
1593
October 13, 2010 03:27AM
Re: Partitioning help
1627
October 13, 2010 06:03PM


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.