Tech Flyin

Many of us would have faced the problem of slow running local XAMPP setup at times during a crucial development phase and wished there was a quick fix. One such issue is a slow mysql. There are many ways of tuning and fixing the problem. If the issue is around the growing size of the application and needing more resource, you can try replacing the mysql config file. XAMPP provides 4 default mysql config files my.ini for different size applications. They are named as below: my-small.ini my-medium.ini my-large.ini my-huge.ini Depending on the size of your application you can pick one and replace it in to my.ini . The path to this default files on a windows system is C:\xampp\mysql (if the xampp is installed under the root of c:). The my.ini file is placed under : C:\xampp\mysql\bin . Just copy the file my-<size>.ini in to the C:\xampp\mysql\bin and rename it to my.ini . Restart the XAMPP. This could turn out to be that quick fix you are looking for.

At times when you are busy running some query or importing/exporting some data it is very annoying to see the script timeout with default 300sec processing time. Well there is a simple solution to fix that. Modify or add the following variable in the config.inc.php file located under C:\xampp\phpMyAdmin folder for a xamp installation on Windows. $cfg['ExecTimeLimit'] = 0; /* 0 stands for unlimited time of execution*/ You can also just extend the time to what ever you want if unlimited is not your way of doing things. Here is another example: $cfg['ExecTimeLimit'] = 600; /* 600 seconds */ The file config.inc.php may be found under different paths based on your OS and installations. On my GNU/Linux server the path is /etc/phpMyAdmin/config.inc.php