MySQL Forums
Forum List  »  Partitioning

Re: I divided table on two parts, but MySQL scanning full table
Posted by: oto shavadze
Date: February 11, 2012 01:10PM

Thanks, thanks, all working :)
But, this working if the type table is a InnoDB.
First, type of my table was a MyISAM, and results FROM first and second query: "SHOW SASSION STATUS" was identical.
After I changed the table type and:

result from first "SHOW SASSION STATUS" Handler_read_next , 0
result from second "SHOW SASSION STATUS" Handler_read_next , 30000

Thanks very much Mister James :)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: I divided table on two parts, but MySQL scanning full table
1581
February 11, 2012 01:10PM


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.