Mysql on XAMPP performance issues and tuning

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.

Comments

Post a Comment

Popular posts from this blog

Delete multiple lines in Linux style Vi Editor

We often have situations were we need to modify a file using vi on Unix style file system and delete multiple lines. Here are some details and examples on how to do it. Syntax: xdd dd is the command to delete a complete row. x in the number of lines to be deleted. Examples: delete 2 lines 2dd delete 10 lines 10dd
Read more

Change Firefox Browser Default View Source Editor to your Favorite Text Editor

Firefox browser recent update reset my favorite default text editor and I ended up fixing it. Here are the steps to update it: In the Browser address bar type about:config . This will show you a warning message. Accept it. In the Search bar type view_source.editor.external . This will show you the matching entry below pane. Toggle the Boolean Value false to true by double clicking it. Next, in the search bar type view_source.editor.path . This will show you the matching entry below pane. double click the Value field and it will popup a dialog box with a text field. Enter the path to your favorite text editor and click OK. close the Tab. You are all set. Enjoy viewing the source code in your favorite text editor
Read more