Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have installed MySQL 5.1.73 in Oracle LINUX 5 server. Just after RPM installation, I checked system variables and found that version is 5.1.73-community. When I copid /usr/share/doc/MySQL-server-community-5.1.73/my-medium.cnf to /etc/my.cnf I got 5.1.73-community-log as value of version variable. I am curious to know about what is the difference between 5.1.73-community and 5.1.73-community-log

share|improve this question
    
This isn't an answer to your real question, but you really should not be using 5.1 for a new install. The current version 5.6 has been out and stable for quite a while. Many bug fixes, features, performance and security updates have been introduced since the 5.1 years –  atxdba Apr 23 at 19:48
    
@atxdba, true, I recommend using a newer version of MySQL too. But FWIW the package repo for conservative Linux distros (e.g. RHEL) haven't even updated to 5.5 yet. –  Bill Karwin Apr 23 at 20:08

1 Answer 1

up vote 2 down vote accepted

They are the same software. The -log suffix is simply appended to the version string at runtime.

Here's an explanation (nearly from the last century), by long-time MySQL author Paul DuBois:

I want to know what the -log means and how it got in there.

-log is added if you start the server with logging turned on.

-debug is added if you're running a debugging version of the server with debugging on.

-demo is added if the server is running in demo mode

I verified this in the source, in sql/mysqld.cc, function set_server_version():

. . .
if (opt_log || opt_slow_log || opt_bin_log)
  strmov(end, "-log");                        // This may slow down system
. . .

I think the meaning of that comment is not that appending four extra characters to the version slows down the system, but that logging may slow down the system, so it's worth noting to the DBA that logging is enabled.

share|improve this answer
    
+1 for quoting from nearly the last century and the gentle reminder about slowdowns due to logs. –  RolandoMySQLDBA Apr 23 at 20:08
    
As @RolandoMySQLDBA told, a simple and clear answer with the reference of lists.mysql.com. –  ursitesion Apr 24 at 6:12

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.