Jump to content
Mumble forums

MariaDB/MySQL ate our disk space and caused today's downtime


davidebeatrici
 Share

Recommended Posts

  • Administrators

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

  • 3 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...