Re: random-access I/O
Posted by:
Aftab Khan
Date: February 09, 2012 01:48AM
>Are you aware on whether partitions are read simultaneously for the same query? Would you agree that KEY partitioning is something I should also examine or it is something that will definitely won't help me?
Unfortunatley this is a future request:
http://forge.mysql.com/worklog/task.php?id=2552
http://bugs.mysql.com/bug.php?id=1542: WHEN WILL MYSQL HAVE PARALLEL QUERY AND PARTITIONING
As mentioned in my previous reply, RANGE partitioning seem more suitable for your situation. Using KEY partitioning the DELETES would be be costly and perhaps reads as well because the most *popular* records might be spread across many partitions.
Aftab Khan
http://mysqlopt.blogspot.com/
Edited 1 time(s). Last edit at 02/09/2012 07:58AM by Aftab Khan.
Subject
Views
Written By
Posted
3588
January 31, 2012 03:50AM
1084
January 31, 2012 08:25PM
1023
February 01, 2012 05:19AM
987
February 03, 2012 01:41AM
1246
February 03, 2012 02:39AM
1070
February 03, 2012 11:08PM
1015
February 04, 2012 08:54AM
1536
February 05, 2012 12:56PM
1034
February 08, 2012 07:22AM
1495
February 08, 2012 11:17PM
927
February 09, 2012 05:30AM
Re: random-access I/O
1016
February 09, 2012 01:48AM
846
February 09, 2012 01:58AM
1061
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.