The nextgen-gallery plug-in caused the MySQLbinlog to soar.

Source: Internet
Author: User
Tags what sql
After my Blog is optimized, it has been running well and fast. However, it suddenly became very difficult from yesterday. After logging on to the server, I checked that the disk space usage was 100%. Taking a closer look, MySQLbinlog occupies a vast majority of space and is growing rapidly at a pace of MB every 10 minutes. This is definitely not normal. I will go. I updated 1-on average every month-

After my Blog is optimized, it has been running well and fast. However, it suddenly became very difficult from yesterday. After logging on to the server, I checked that the disk space usage was 100%. Taking a closer look, MySQL binlog occupies a vast majority of space and is growing rapidly at a pace of MB every 10 minutes. This is definitely not normal. I will go. I updated 1-on average every month-

After my Blog is optimized, it has been running well and fast. However, it suddenly became very difficult from yesterday. After logging on to the server, I checked that the disk space usage was 100%. Taking a closer look, MySQL binlog occupies a vast majority of space and is growing rapidly at a pace of MB every 10 minutes.

This is definitely not normal. I will go. I only update 1-3 articles per month on average. There are not many people who come to comment, and even Spam will not have such a large volume. To find out what SQL is working, I stopped Nginx and logged on to mysql to select a binlog file, run "mysql-uroot-p-e 'show binlog events in 'binlog. 000041 'limit 10; '>/tmp/fuckedbyng. log, and then we can see the SQL statement that repeats repeatedly.

Through the related content in this SQL, Google found the cause of the problem, which is a Bug in the new nextgen-gellery plug-in.
Http://wordpress.org/support/topic/a-warning-ngg_delete_expired_transients-cronjob

In the previous Forum, a solution was provided to comment out a part of the updated code.
Because I have been irritated, I first corrected this bug according to the above method, restarted my Nginx, and then deleted this plug-in. In fact, I don't really use this album plug-in, huh, huh.

Original article address: The nextgen-gallery plug-in of the potholes caused MySQL binlog to soar. Thanks to the original author for sharing.

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.