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.