?
Solved

Help with MYSQL questions

Posted on 2010-03-29
4
Medium Priority
?
708 Views
Last Modified: 2012-05-09
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
0
Comment
Question by:digitap
  • 2
  • 2
4 Comments
 
LVL 33

Author Comment

by:digitap
ID: 29045724
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
 
LVL 21

Accepted Solution

by:
K V earned 2000 total points
ID: 29910524

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
 
LVL 21

Expert Comment

by:K V
ID: 29910730
0
 
LVL 33

Author Comment

by:digitap
ID: 29914676
@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

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

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

This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
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

601 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