Administrators davidebeatrici Posted December 31, 2020 Administrators Share Posted December 31, 2020 On our poor VPS: -rw-r----- 1 mysql mysql 179 Dec 8 23:56 binlog.000001 -rw-r----- 1 mysql mysql 200 Dec 9 00:00 binlog.000002 -rw-r----- 1 mysql mysql 179 Dec 9 00:10 binlog.000003 -rw-r----- 1 mysql mysql 46056943 Dec 9 01:25 binlog.000004 -rw-r----- 1 mysql mysql 5444227 Dec 9 01:47 binlog.000005 -rw-r----- 1 mysql mysql 104912408 Dec 9 04:09 binlog.000006 -rw-r----- 1 mysql mysql 104990838 Dec 9 08:36 binlog.000007 -rw-r----- 1 mysql mysql 104872782 Dec 9 13:37 binlog.000008 -rw-r----- 1 mysql mysql 104971758 Dec 9 23:04 binlog.000009 -rw-r----- 1 mysql mysql 104899387 Dec 10 04:18 binlog.000010 -rw-r----- 1 mysql mysql 149891974 Dec 10 06:01 binlog.000011 -rw-r----- 1 mysql mysql 104918500 Dec 10 15:41 binlog.000012 -rw-r----- 1 mysql mysql 104878351 Dec 10 21:01 binlog.000013 -rw-r----- 1 mysql mysql 104861882 Dec 10 21:45 binlog.000014 -rw-r----- 1 mysql mysql 174035130 Dec 10 21:53 binlog.000015 -rw-r----- 1 mysql mysql 104898500 Dec 10 22:29 binlog.000016 -rw-r----- 1 mysql mysql 68668734 Dec 10 23:21 binlog.000017 -rw-r----- 1 mysql mysql 284430778 Dec 10 23:46 binlog.000018 -rw-r----- 1 mysql mysql 182509281 Dec 11 00:15 binlog.000019 -rw-r----- 1 mysql mysql 104890111 Dec 11 00:49 binlog.000020 -rw-r----- 1 mysql mysql 104875611 Dec 11 01:23 binlog.000021 -rw-r----- 1 mysql mysql 105168224 Dec 11 06:11 binlog.000022 -rw-r----- 1 mysql mysql 104975380 Dec 11 11:42 binlog.000023 -rw-r----- 1 mysql mysql 28109046 Dec 11 19:03 binlog.000024 -rw-r----- 1 mysql mysql 326811970 Dec 11 21:16 binlog.000025 -rw-r----- 1 mysql mysql 105001957 Dec 12 03:24 binlog.000026 -rw-r----- 1 mysql mysql 104921143 Dec 12 12:48 binlog.000027 -rw-r----- 1 mysql mysql 104874102 Dec 12 16:08 binlog.000028 -rw-r----- 1 mysql mysql 104903322 Dec 13 00:48 binlog.000029 -rw-r----- 1 mysql mysql 104877881 Dec 13 09:23 binlog.000030 -rw-r----- 1 mysql mysql 104915421 Dec 13 10:38 binlog.000031 -rw-r----- 1 mysql mysql 108842640 Dec 13 14:07 binlog.000032 -rw-r----- 1 mysql mysql 104898135 Dec 13 17:49 binlog.000033 -rw-r----- 1 mysql mysql 106431699 Dec 13 22:34 binlog.000034 -rw-r----- 1 mysql mysql 104945664 Dec 14 01:19 binlog.000035 -rw-r----- 1 mysql mysql 105346164 Dec 14 02:55 binlog.000036 -rw-r----- 1 mysql mysql 104927381 Dec 14 08:28 binlog.000037 -rw-r----- 1 mysql mysql 104901573 Dec 14 14:18 binlog.000038 -rw-r----- 1 mysql mysql 105221572 Dec 14 20:02 binlog.000039 -rw-r----- 1 mysql mysql 105021279 Dec 14 23:39 binlog.000040 -rw-r----- 1 mysql mysql 105069235 Dec 15 06:58 binlog.000041 -rw-r----- 1 mysql mysql 104879080 Dec 15 13:52 binlog.000042 -rw-r----- 1 mysql mysql 104894646 Dec 15 17:03 binlog.000043 -rw-r----- 1 mysql mysql 104872079 Dec 15 17:40 binlog.000044 -rw-r----- 1 mysql mysql 104914392 Dec 15 20:44 binlog.000045 -rw-r----- 1 mysql mysql 116606911 Dec 15 21:39 binlog.000046 -rw-r----- 1 mysql mysql 104910943 Dec 16 03:49 binlog.000047 -rw-r----- 1 mysql mysql 104938497 Dec 16 08:16 binlog.000048 -rw-r----- 1 mysql mysql 104859775 Dec 16 15:52 binlog.000049 -rw-r----- 1 mysql mysql 104861605 Dec 16 22:08 binlog.000050 -rw-r----- 1 mysql mysql 143399810 Dec 17 01:50 binlog.000051 -rw-r----- 1 mysql mysql 104931878 Dec 17 09:54 binlog.000052 -rw-r----- 1 mysql mysql 104938480 Dec 17 16:00 binlog.000053 -rw-r----- 1 mysql mysql 131502572 Dec 17 19:15 binlog.000054 -rw-r----- 1 mysql mysql 105079457 Dec 18 02:08 binlog.000055 -rw-r----- 1 mysql mysql 104905286 Dec 18 05:34 binlog.000056 -rw-r----- 1 mysql mysql 108371666 Dec 18 07:02 binlog.000057 -rw-r----- 1 mysql mysql 105074051 Dec 18 13:53 binlog.000058 -rw-r----- 1 mysql mysql 105629296 Dec 18 20:51 binlog.000059 -rw-r----- 1 mysql mysql 168112644 Dec 19 01:53 binlog.000060 -rw-r----- 1 mysql mysql 104865744 Dec 19 09:28 binlog.000061 -rw-r----- 1 mysql mysql 104934699 Dec 19 13:43 binlog.000062 -rw-r----- 1 mysql mysql 112456287 Dec 19 18:24 binlog.000063 -rw-r----- 1 mysql mysql 120294428 Dec 19 23:58 binlog.000064 -rw-r----- 1 mysql mysql 127998385 Dec 20 06:21 binlog.000065 -rw-r----- 1 mysql mysql 127324557 Dec 20 11:56 binlog.000066 -rw-r----- 1 mysql mysql 104891112 Dec 20 16:57 binlog.000067 -rw-r----- 1 mysql mysql 105161665 Dec 21 00:17 binlog.000068 -rw-r----- 1 mysql mysql 105127390 Dec 21 03:16 binlog.000069 -rw-r----- 1 mysql mysql 104857920 Dec 21 08:14 binlog.000070 -rw-r----- 1 mysql mysql 104857767 Dec 21 12:36 binlog.000071 -rw-r----- 1 mysql mysql 104861851 Dec 21 17:56 binlog.000072 -rw-r----- 1 mysql mysql 104964529 Dec 21 22:54 binlog.000073 -rw-r----- 1 mysql mysql 104979558 Dec 22 04:36 binlog.000074 -rw-r----- 1 mysql mysql 111052403 Dec 22 08:25 binlog.000075 -rw-r----- 1 mysql mysql 104923796 Dec 22 15:08 binlog.000076 -rw-r----- 1 mysql mysql 104944693 Dec 22 22:25 binlog.000077 -rw-r----- 1 mysql mysql 222804475 Dec 23 05:22 binlog.000078 -rw-r----- 1 mysql mysql 104869035 Dec 23 12:31 binlog.000079 -rw-r----- 1 mysql mysql 105077389 Dec 23 19:14 binlog.000080 -rw-r----- 1 mysql mysql 104871082 Dec 23 20:36 binlog.000081 -rw-r----- 1 mysql mysql 105035770 Dec 23 23:39 binlog.000082 -rw-r----- 1 mysql mysql 104916744 Dec 24 03:17 binlog.000083 -rw-r----- 1 mysql mysql 104922947 Dec 24 07:45 binlog.000084 -rw-r----- 1 mysql mysql 196510657 Dec 24 08:38 binlog.000085 -rw-r----- 1 mysql mysql 105007845 Dec 24 13:22 binlog.000086 -rw-r----- 1 mysql mysql 104903348 Dec 24 20:15 binlog.000087 -rw-r----- 1 mysql mysql 104900690 Dec 24 23:06 binlog.000088 -rw-r----- 1 mysql mysql 104882345 Dec 25 03:17 binlog.000089 -rw-r----- 1 mysql mysql 109267029 Dec 25 07:58 binlog.000090 -rw-r----- 1 mysql mysql 104881394 Dec 25 13:47 binlog.000091 -rw-r----- 1 mysql mysql 105284708 Dec 25 20:07 binlog.000092 -rw-r----- 1 mysql mysql 158659168 Dec 25 23:00 binlog.000093 -rw-r----- 1 mysql mysql 104875119 Dec 26 05:49 binlog.000094 -rw-r----- 1 mysql mysql 128382349 Dec 26 09:07 binlog.000095 -rw-r----- 1 mysql mysql 140028059 Dec 26 14:34 binlog.000096 -rw-r----- 1 mysql mysql 104875128 Dec 26 19:11 binlog.000097 -rw-r----- 1 mysql mysql 104858689 Dec 27 01:33 binlog.000098 -rw-r----- 1 mysql mysql 201662399 Dec 27 06:44 binlog.000099 -rw-r----- 1 mysql mysql 104857651 Dec 27 11:11 binlog.000100 -rw-r----- 1 mysql mysql 150278058 Dec 27 17:24 binlog.000101 -rw-r----- 1 mysql mysql 119728826 Dec 27 22:05 binlog.000102 -rw-r----- 1 mysql mysql 104911464 Dec 28 03:33 binlog.000103 -rw-r----- 1 mysql mysql 104891521 Dec 28 06:16 binlog.000104 -rw-r----- 1 mysql mysql 104903945 Dec 28 11:54 binlog.000105 -rw-r----- 1 mysql mysql 180932014 Dec 28 12:07 binlog.000106 -rw-r----- 1 mysql mysql 104863472 Dec 28 18:21 binlog.000107 -rw-r----- 1 mysql mysql 104974876 Dec 28 23:57 binlog.000108 -rw-r----- 1 mysql mysql 229262180 Dec 29 04:40 binlog.000109 -rw-r----- 1 mysql mysql 105078709 Dec 29 09:40 binlog.000110 -rw-r----- 1 mysql mysql 105004849 Dec 29 14:30 binlog.000111 -rw-r----- 1 mysql mysql 123527877 Dec 29 16:03 binlog.000112 -rw-r----- 1 mysql mysql 105241497 Dec 29 20:55 binlog.000113 -rw-r----- 1 mysql mysql 158196887 Dec 29 23:33 binlog.000114 -rw-r----- 1 mysql mysql 104859041 Dec 30 04:07 binlog.000115 -rw-r----- 1 mysql mysql 144663023 Dec 30 06:09 binlog.000116 -rw-r----- 1 mysql mysql 104871369 Dec 30 09:37 binlog.000117 -rw-r----- 1 mysql mysql 104862123 Dec 30 13:01 binlog.000118 -rw-r----- 1 mysql mysql 104862276 Dec 30 16:23 binlog.000119 -rw-r----- 1 mysql mysql 105086536 Dec 30 19:49 binlog.000120 -rw-r----- 1 mysql mysql 104894537 Dec 30 23:21 binlog.000121 -rw-r----- 1 mysql mysql 104955689 Dec 31 03:25 binlog.000122 -rw-r----- 1 mysql mysql 104887447 Dec 31 07:10 binlog.000123 -rw-r----- 1 mysql mysql 15437824 Dec 31 08:10 binlog.000124 -rw-r----- 1 mysql mysql 1984 Dec 31 07:10 binlog.index The solution consists in stopping MariaDB/MySQL, deleting binlog*, adding skip-log-bin to the configuration and then starting the service again. Link to comment Share on other sites More sharing options...
Administrators davidebeatrici Posted January 18, 2021 Author Administrators Share Posted January 18, 2021 Turns out the option is disable_log_bin in recent versions of MariaDB/MySQL: https://dba.stackexchange.com/a/226944 Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now