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.