---
title: MAMP Pro for Windows - MySQL Runaway Storage
date: 2019-03-15T19:51:00-04:00
author: cc_admin
canonical_url: "https://caffeinecreations.ca/blog/mamp-pro-for-windows-mysql-runaway-storage/"
section: Blog
---
![Abstract-art-background-270456](https://caffeinecreations.ca/uploads/blog/_1920x660_crop_center-center_none_ns/abstract-art-background-270456.jpg)

- [Web Development](https://caffeinecreations.ca/blog/category/web-development/)

# MAMP Pro for Windows - MySQL Runaway Storage

Mamp Pro for Windows has runaway MySQL logs - here's how to fix that.

I've been running Mamp Pro for Windows for about 2 and half years now and find it a very convenient and simple way to run multiple sites locally. It works great.

However I didn't realize that it was the cause of my C: Drive running out of disk space. I have a relatively large SSD drive of 275gb which had run out of space and I kept having to remove stuff as it continued to fill up any empty space.

The reason it was running out of space is that MySQL runs logs by default and doesn't prune them. the folder with my database had 809 log files of over 100gb of space.

The solution was relatively simple after googling I found [this page](https://www.blue-bag.com/blog/binary-logs-are-filling-my-mac-help) which gave me the solution.

> f you don't need logging then you can turn it off (most don't unless you are replicating):  
> locate and edit your my.cnf (/etc/my.cnf - but may be somewhere else in WAMP/MAMP/XAMP etc)  
> locate and comment out the line:
> 
> ```
> log_bin = /var/log/mysql/mysql-bin.log
> ```
> 
> You also need to remove or comment following lines:
> 
> ```
> expire_logs_days = 1
> ```
> 
> ```
> max_binlog_size = 100M
> ```
> 
> Close and save the file. Finally, restart mysql server
> 
> 
> 
> ##### https://www.blue-bag.com

I'm not sure if I need logging or not, but I opened up my.cnf by using the Mamp Pro interface **file > edit template > MySQL mysql.ini** When I did I not see the expire\_logs\_days or max\_binlog\_size anywhere. So I added those lines below log-bin=mysql-bin like this:

```
<button class="absolute z-10 flex items-center justify-center w-8 h-8 -translate-y-1/2  -right-4 -top-4" clipboard="" title="Copy to Clipboard" to="" type="button" x-clipboard.raw="# Replication Master Server (default)
# binary logging is required for replication
log-bin=mysql-bin
expire_logs_days = 10
max_binlog_size = 500M" x-data="">
	<svg class="h-5 w-5" viewbox="0 0 64 64" xml:space="preserve" xmlns="http://www.w3.org/2000/svg">
  <rect fill="#f3f4f6" height="53" rx="3" width="41" x="7" y="2"></rect>
  <rect fill="#f3f4f6" height="51" rx="3" width="39" x="19" y="11"></rect>
  <path d="M53.98 9.143h-3.97c-.082 0-.155.028-.232.047V5.023C49.778 2.253 47.473 0 44.64 0H10.217C7.384 0 5.08 2.253 5.08 5.023v46.843c0 2.77 2.305 5.023 5.138 5.023h6.037v2.268c0 2.67 2.216 4.843 4.941 4.843H53.98c2.725 0 4.942-2.173 4.942-4.843v-45.17c0-2.671-2.217-4.844-4.942-4.844zM7.11 51.866V5.023c0-1.649 1.394-2.991 3.106-2.991H44.64c1.712 0 3.106 1.342 3.106 2.99v46.844c0 1.649-1.394 2.991-3.106 2.991H10.217c-1.712 0-3.106-1.342-3.106-2.99zm49.778 7.29c0 1.551-1.306 2.812-2.91 2.812H21.195c-1.604 0-2.91-1.26-2.91-2.811v-2.268H44.64c2.833 0 5.138-2.253 5.138-5.023V11.128c.077.018.15.047.233.047h3.968c1.604 0 2.91 1.26 2.91 2.811v45.17z"></path>
  <path d="M38.603 13.206H16.254a1.015 1.015 0 1 0 0 2.032h22.35a1.015 1.015 0 1 0 0-2.032zM38.603 21.333H16.254a1.015 1.015 0 1 0 0 2.032h22.35a1.015 1.015 0 1 0 0-2.032zM38.603 29.46H16.254a1.015 1.015 0 1 0 0 2.032h22.35a1.015 1.015 0 1 0 0-2.032zM28.444 37.587h-12.19a1.015 1.015 0 1 0 0 2.032h12.19a1.015 1.015 0 1 0 0-2.032z"></path>
</svg>
<div class="sr-only">Copy to clipboard</div></button>```php
# Replication Master Server (default)
# binary logging is required for replication
log-bin=mysql-bin
expire_logs_days = 10
max_binlog_size = 500M
```
```

#### Restart and Done

I then restarted the server and all the bin files except from the past ten days disappeared. IMO these settings should be in the default template that comes with Mamp Pro, but it doesn't. Hope this helps someone else out.