Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Unable To Enable Binary Log On MySQL 4.1.22

Posted on 2010-11-11
4
Medium Priority
?
1,033 Views
Last Modified: 2012-06-21
Greetings,

I have been unable to enable binary log for MySQL 4.1.22 on linux OS. I am using the following variable:

log-bin=/mysql/log/mysql-bin

Please help
0
Comment
Question by:Omega002
  • 3
4 Comments
 
LVL 3

Accepted Solution

by:
dnadavis earned 1500 total points
ID: 34117618
add this to your /etc/my.cnf file(mysql conf file)

log-slow-queries =/var/log/log-slow-queries.log(path to the file where to store the slow queries .Give 777 permission to this file chown 777 <filename>)
long_query_time = 2  ( if it is 2 mysql will log all those queries taking more than 2 ms )
log-queries-not-using-indexes  ( if you add this too in your conf file it will consider the queries that are not using indexes )

restart mysqld .
Go to your mysql .
try this there
mysql>show global variables ;
check  whether log_slow_queries  =  ON.
if it is det then you can start querying and if any slow queries comes you can see them in the log file you mentioned in your my.cnf file.
0
 

Author Comment

by:Omega002
ID: 34123710
I just need to enable it so the following variable is on:

log_bin  ON


0
 

Author Comment

by:Omega002
ID: 34123988
hello hello are you there? I just need to turn on Binary loggin which should show the following value if enable:

log_bin ON


How do I enable Binary logging on MySQL 4.1.22? Please help.
0
 

Author Closing Comment

by:Omega002
ID: 34431670
Good suggestion
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

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

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
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

783 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