Ubuntu 20.04, Apache 2.4, PHP 7.4.3, MySQL 8.0 & MediaWiki 1.35.7
Howdy,
usually the binlogs match (roughly) with the activities shown in the recent changes page. Sometimes within the last days I encountered a mysterious phenomenon; the binlog grows rapidly while there is only few activity in the wiki for some hours.
Example:
-rw-r----- 1 mysql mysql 3697808 Sep 22 01:25 mysql-bin.001100
-rw-r----- 1 mysql mysql 157288660 Sep 22 18:53 mysql-bin.001101
-rw-r----- 1 mysql mysql 157372133 Sep 22 20:50 mysql-bin.001102
-rw-r----- 1 mysql mysql 157311099 Sep 22 21:25 mysql-bin.001103
-rw-r----- 1 mysql mysql 157388609 Sep 22 21:50 mysql-bin.001104
-rw-r----- 1 mysql mysql 157291160 Sep 22 22:07 mysql-bin.001105
-rw-r----- 1 mysql mysql 157367584 Sep 22 22:34 mysql-bin.001106
-rw-r----- 1 mysql mysql 157343097 Sep 22 22:42 mysql-bin.001107
-rw-r----- 1 mysql mysql 157383979 Sep 22 22:50 mysql-bin.001108
-rw-r----- 1 mysql mysql 157354101 Sep 22 22:57 mysql-bin.001109
-rw-r----- 1 mysql mysql 157420107 Sep 22 23:17 mysql-bin.001110
-rw-r----- 1 mysql mysql 157487073 Sep 22 23:37 mysql-bin.001111
-rw-r----- 1 mysql mysql 157536460 Sep 22 23:55 mysql-bin.001112
-rw-r----- 1 mysql mysql 130376490 Sep 23 00:13 mysql-bin.001113
-rw-r----- 1 mysql mysql 157559320 Sep 23 00:35 mysql-bin.001114
-rw-r----- 1 mysql mysql 157322415 Sep 23 01:02 mysql-bin.001115
-rw-r----- 1 mysql mysql 72729153 Sep 23 01:25 mysql-bin.001116
On September 22th, from 0:01 am till 20:50 pm, I count approx. 130 changes. I don't quite understand why this few changes can produce 2 x 150 MB binlogs, but even worse: from 20:50 pm - 23:55 pm there are no more than 31 edits <-> 10 x 150 MB binlogs!?
Does anyone have any ideas WHAT the database is doing here?