MySQL Forums
Forum List  »  Optimizer & Parser

Re: how to speed up query on a table with over 20million records?
Posted by: li zheng
Date: March 25, 2018 08:13PM

innodb_buffer_pool_size is 1.5G

>so try either changing the PK to (symbol_id,time_period,datetime)
I noticed that, so I am changing it, needing some time, lots of data after all.
But could you check the second query I posted, the index should be right.

Options: ReplyQuote

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.