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

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.