Apache Friends Support Forum

My version of XAMPP 5.6.31 sucks, been like this for months,

so I decided to redownload a fresh copy of XAMPP 5.6.31, and nothing change, and got even worse, I cannot even import a 600kb sql file, it timeout with 'Fatal error: Maximum execution time of 300 seconds exceeded in C:\xampp\phpMyAdmin\libraries\dbi\DBIMysqli.php on line 184'

Dropping tables in database took forever, why is this happening?

The size only does not matter. Maybe you have lots of indexes in your tables which requires lots of index builds. I know exactly as much about your tables as you told us: nothing.

The reason for that is the InnoDB settings in the /xampp/mysql/bin/my.ini file are set very low.

Had a 14MB .sql file that I was trying to import. Took 3 hours to import it. I then made this my.ini setting changes below and the same DB import took 3 minutes.

Note: I have 16GB of RAM on my computer. So I set the innodb_buffer_pool_size=8G setting to 8GB, which is 50% of my RAM.

# Comment the following if you are using InnoDB tables
#skip-innodb
innodb_data_home_dir="C:/xampp/mysql/data"
innodb_data_file_path=ibdata1:10M:autoextend
innodb_log_group_home_dir="C:/xampp/mysql/data"
#innodb_log_arch_dir = "C:/xampp/mysql/data"
## You can set .._buffer_pool_size up to 50 - 80 %
## of RAM but beware of setting memory usage too high
innodb_buffer_pool_size=8G
## Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size=1G
innodb_log_buffer_size=500M
innodb_flush_log_at_trx_commit=0
innodb_lock_wait_timeout=50

Yeah, the settings are set low because most first time XAMPP users are installing and using XAMPP byside many other software and can most likely not spare 50% of RAM for just MariaDB.