phpmariadbxamppdiskspacetmp

XAMPP tmp folder oversized and shows MySQL high CPU usage


I am running a PHP application on XAMPP (PHP 7.3) which my users are usually uploading files (Image and PDF) and the activities on the application are increasing day by day. But Recently I am facing low space on my drive and it shows MySQL high CPU usage up to 97%.

Then I found that in XAMPP, tmp folder ('C:\XAMPP\tmp') there are files with name mysql[random number] with .MAD extension that size of each file is more than 35 GB, and it continue to generate these files until the disk become full and application stop working.

Then I need to stop the XAMPP service and delete the files that the system back to normal.

There are solutions similar to this issue such as XAMPP tmp folder oversized and it recommended to disable xdebug profile in php.ini or xdebug.ini which I couldn't found it in PHP 7.3 version but I added at the end of php.ini like below and checked the php_xdebug.dll is available in php extension folder...

[XDebug] 
xdebug.remote_autostart=0
xdebug.remote_enable=0
xdebug.profiler_enable=0

... and How can I limit the size of temporary tables? which the answers was not to the point even though I followed the answers and implemented some points but still the application is facing the same problem.

Now, I am looking for step by step solution to avoid or to understand what is reason that I could solve the problem.


Solution