MySQL Forums
Forum List  »  Utilities

Posted by: Khurram Naseem
Date: August 09, 2016 07:06AM


We have two tables (A=38 million rows) & (B=20 millions of rows), when we run count query after join both table (join column indexed) and we provide one where clause ( also indexed ). The query examine 200 thousand rows and return count. Query took 200 milliseconds to execute.

My first question is that is this time is OK! or we need to reduce this time ?

Second question when I use same query with mysqlslap with 100 concurrent value it took four minute to complete, why it took so long? A simple count query is not blocking on Innodb engine.

The testing instance has 15 GB RAM and 2VCPU (AWS RDS).

Thank you

Options: ReplyQuote

Written By
August 09, 2016 07:06AM
August 14, 2016 06:45PM

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.