MySQL in the first query when the time is very slow, the second query is relatively fast reason?

Source: Internet
Author: User

1, the default query_cache is open

You use show global variables like '%query_cache% ';

Confirm that there is no open, if open. First query read data file, the second time will go query_cache, so it will soon. Of course, if the data is updated, you need to re-cache it.

2, the second case, query table engine: Show variables like '%storage_engine% ', the table engine uses InnoDB. The first query will also walk the data file, the second direct walk Buffer_pool, also faster than querying data files directly


MySQL in the first query when the time is very slow, the second query is relatively fast reason?

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.