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

Posted on 2011-10-04
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?

Question by:sah18
    1 Comment
    LVL 24

    Accepted Solution

    I don't know of any tool for windows but the following articles should help you determine optimal settings:

    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.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (…
    I have been using r1soft Continuous Data Protection ( for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    734 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

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now