MySQL Forums
Forum List  »  Partitioning

Re: partition and subpartitioning help
Posted by: deva clementraj
Date: May 18, 2011 06:26AM

which one will preforme good
if the
show status 'handler%'
gave me this
handler_read_next=7 and handler_read_rnd_next=49,08,079
when i partitioned table to_day(cols) with index ( id & timestamp)

i also created table with a partition of month(cols) with index
and i executed the select statement
the show status 'handler%'
show like this
handler_rad_next=20,35,953 and read_rnd_next=7
which one is better?

but the time taken is less for the partition table with to_days(cols),it takes 16.72265(2.8999)to give me the result

and partiton table with month(cols) it take more then the previous like 21.7464(0.1824)to give the result
which is better

Options: ReplyQuote

Written By
Re: partition and subpartitioning help
May 18, 2011 06:26AM

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.