Like most DBAs I have two copies of my entire system, one running on a commercial website provider and one on my development system. Both are identical: the same options, the same software level, and exactly the same database contents.

On my development system the ibdata1 file is 397MB.

On the production system the ibdata1 file keeps growing until it has occupied every byte on the site. It is now $23GB, well over 50% of the 40GB I have as part of my contract. I cannot just keep paying for more disk space to satisfy MariaDBs design decision to dump information into this file even though I have set the separate file for each table option.

I shut down the server, deleted the ibdata1 file, restarted the server, reloaded the databases and still the ibdata1 file keeps growing. How do I stop this?

My entire site is down until I can fix this problem, so this is an emergency.

Like most DBAs I have two copies of my entire system, one running on a commercial website provider and one on my development system. Both are identical: the same options, the same software level, and exactly the same database contents.

On my development system the ibdata1 file is 397MB.

On the production system the ibdata1 file keeps growing until it has occupied every byte on the site. It is now 23GB, well over 50% of the 40GB I have as part of my contract. I cannot just keep paying for more disk space to satisfy MariaDBs design decision to dump information into this file even though I have set the separate file for each table option.

I shut down the server, deleted the ibdata1 file, restarted the server, reloaded the databases and still the ibdata1 file keeps growing. How do I stop this?

My entire site is down until I can fix this problem, so this is an emergency.