Help with MYSQL questions

I am running a server with Windows 2003 Standard 64 bit.  I have a challenge where the binary log files are not being purged.  I don't have access to the command line to force a purge, but read through the my.ini file and noticied it has expire_logs_days=30.  However, this system has been up since 2007 and that's how many years worth of binary log files we have.  I assume there is a configuration issue in the my.ini file.  Below are my questions.

1. What's the difference between my.inf and my.cnf?
2. Please review the existing my.ini file and tell me what configuration settings need changed to allow the binary log files to be purged on server restart.
3. On the Internet, I'm seeing reference of a log-bin and a log_bin.  What is the different between the two?  In my ini file, I see both interchangebly.  I assume one is referencing linux/unix distro and the other is Windows, right?
4. Besides the binary log settings, does anyone have any advice for changes that might "optimize" the database?

Thanks in advance.
Copy-my.ini
LVL 33
digitapAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

digitapAuthor Commented:
After modifying the my.ini file (see attached file), I found that the files were purged as desired.  Appears the vendor didn't format the ini properly.  I still have questions 1, 3, and 4 above that need answered.
my.ini
0
theGhost_k8Database ConsultantCommented:

1. What's the difference between my.inf and my.cnf?
>>There is no INF file. There is ini file used for windows and on linux/unix we have cnf file for standard config.

3. On the Internet, I'm seeing reference of a log-bin and a log_bin.  What is the different between the two?  In my ini file, I see both interchangebly.  I assume one is referencing linux/unix distro and the other is Windows, right?
>>log-bin is used to specify through config-file while log_bin is variable name of the same

4. Besides the binary log settings, does anyone have any advice for changes that might "optimize" the database?
>> use mysqltuner for optimisation tip.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
digitapAuthor Commented:
@Ghost:

1. Yes, my mistake.  I meant INI.

2. Thanks.  That was just a little confusing.

3. I looked into this and it appears that it's only for Linux.  Any other ideas?

I'm going to go ahead and award points.  If you think of anything additional for question 3. then please post.  Otherwise, thanks for the advice.  It clarified things greatly!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.