MySQL Forums
Forum List  »  Partitioning

Re: I divided table on two parts, but MySQL scanning full table
Posted by: oto shavadze
Date: February 09, 2012 11:12AM

Rick James Wrote:
-------------------------------------------------------

> If you do this before and after the SELECT, I think you will find a _difference_ of 30000 (or maybe 30001) for > one of the values:
> SHOW SESSION STATUS;

Here I did not understand well, you suggest what to make so:

mysql> SHOW SESSION STATUS

mysql> SELECT name FROM qwe WHERE id > 70000

mysql> SHOW SESSION STATUS


And see, whether there is a difference between the values ​​of the first and second request: "SHOW SESSION STATUS" ?
You spoke about it?

If yes - I checked the values ​​of each of the first and the second "SHOW SESSION STATUS" query, and the difference "30000" between them, was not (even approximately).

Excuse for my english and thank you that answered me :)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: I divided table on two parts, but MySQL scanning full table
1604
February 09, 2012 11:12AM


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.