MySQL Forums
Forum List  »  InnoDB

Re: random-access I/O
Posted by: Basilis Papadopoulos
Date: February 08, 2012 07:22AM

Thank you so much about this detailed reply.

So given that the READs are the slow part of the whole process, the only thing that I can do to speed this up is increase the buffer_pool correct?

Also it's not possible to have multiple threads, since this way I will not add the records sorted by ID.

The 50 records/sec seems extremely low still. Is there anything I can do to improve this number?

Finally in one of your previous replies you mentioned that partitioning could help me. In my case would it be better to use RANGE or KEY partitioning? With the first option most of the queries will draw data from 1st partition (since the records are sorted by popularity). On the second option the "popular" records will be stored across all partitions. Does MySQL reads multiple partitions at the same time for the same query or is this done in a serial manner?

Options: ReplyQuote


Subject
Views
Written By
Posted
3570
January 31, 2012 03:50AM
1081
January 31, 2012 08:25PM
1019
February 01, 2012 05:19AM
982
February 03, 2012 01:41AM
1240
February 03, 2012 02:39AM
1063
February 03, 2012 11:08PM
1009
February 04, 2012 08:54AM
1533
February 05, 2012 12:56PM
Re: random-access I/O
1027
February 08, 2012 07:22AM
1487
February 08, 2012 11:17PM
926
February 09, 2012 05:30AM
1011
February 09, 2012 01:48AM
845
February 09, 2012 01:58AM
1056
February 09, 2012 10:52AM


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.