Why do I have to spend a lot of time in checking permissions when I drop table?

Source: Internet
Author: User
Tags percona

Yesterday, I drop a table in checking permissions spent 20s+, this time spent where? Often looking to find my profile innodb_file_per_table=1, InnoDB needs to traverse the LRU list and discard the pages in the table space that belong to the table. If the InnoDB buffer pool is large, it takes a long time, and Table_cache locks cannot be held by other query statements when performing this action.

Resources:

https://www.percona.com/blog/2011/02/03/performance-problem-with-innodb-and-drop-table/

https://www.percona.com/blog/2011/04/20/drop-table-performance/

Why do I have to spend a lot of time in checking permissions when I drop table?

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.