XAMPP 5.6.31 horrible slow & cant even import 600kb file

Problems with the Windows version of XAMPP, questions, comments, and anything related.

XAMPP 5.6.31 horrible slow & cant even import 600kb file

Postby allan256 » 19. September 2017 16:07

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?
allan256
 
Posts: 1
Joined: 19. September 2017 16:02
XAMPP version: 5.6.31
Operating System: windows 8

Re: XAMPP 5.6.31 horrible slow & cant even import 600kb file

Postby Nobbie » 19. September 2017 17:07

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.
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04

Re: XAMPP 5.6.31 horrible slow & cant even import 600kb file

Postby AITpro » 09. March 2022 02:14

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
AITpro
 
Posts: 4
Joined: 10. April 2014 19:51
Operating System: Windows 7

Re: XAMPP 5.6.31 horrible slow & cant even import 600kb file

Postby Altrea » 09. March 2022 07:52

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.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 128 guests