Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

MySQL on Windows (5.5.16) - Need a way to analyze/tune my.ini settings

Posted on 2011-10-04
1
Medium Priority
?
455 Views
Last Modified: 2012-05-12
I have MySQL version 5.5.16 running on Windows Server 2003.

I'd like a way to analyze the configuration settings for what I have currently in my.ini.  I want the performance to be as efficient as possible, but may have some non-optimal settings, but don't know how to find out.

Are there any tools out there (free, if possible), that can analyze a my.ini file?
Or, is there a forum or site that has people who are willing to take a look at your file & give you feedback?

Thanks!
0
Comment
Question by:sah18
1 Comment
 
LVL 24

Accepted Solution

by:
johanntagle earned 2000 total points
ID: 36909849
I don't know of any tool for windows but the following articles should help you determine optimal settings:

http://blog.codesherpas.com/on_the_path/2011/03/tuning-mysql.html
http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/

Re forum or site: EE? =)  Please note though that you do not look at my.ini on its own - it's always in relation to your actual data and usage.  You tune them side by side - add an index here, increase the buffer there.  We'll help you however we can, but you need to provide complete information.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question