Joomla!-开源天空

MySQL 5.1.29 的详细信息你可以在这里看到：available.
这是最后一个mysql 5.1.29的RC版本，令人焦躁的等待终于过去了，接下来就是正式的版本了。mysql 5.1.29提供了很多新的功能或者做出重要的改进，分区的性能已经完美，row-bases复制，时间计划等等。

SHOW PROFILES

It was already in a preview, but now SHOW PROFILES is available in 5.1 binaries. As you may recall, it is not active by default. It becomes active when the session variable profiling is set.
This feature is going to be very useful when measuring the impact of partitioning or RBR on your queries. I will do some testing soon.

这个不是默认启动的，需要设置profiling变量，这个功能对于检测分区和RBR的影响非常有用。

Logging

现在可以启用或者停滞general log或者slow query log，而不必重启服务器。同样，改变日志文件的名称也不必重启服务器。

Log on demand is one of the main features of MySQL 5.1. It means that you can enable and disable general logs and slow query logs without restarting the server. You can also change the log file names, again without a restart.
What was missing was the ability of setting a log file name in the options file, without actually starting the logging. The old option log, could set the general log file name, but it will also start the logging immediately. If you want to set the log file name without activating the logging, now you can use general_log_file=filename or slow_query_log_file=file_name in the options file. These features were already available as system variables, but not as startup options.

Row-base logging safety

From this version, setting the binlog format for a session will require the SUPER privilege.
This change was decided to make it consistent with similar events. If you want to stop or enable the binary log, you can use SET SQL_LOG_BIN=0, but only if you have the SUPER privilege. Both suspending the binary logging and changing its format are affecting replication, and as such, the SUPER privilege is required.

这一版本设置bin_log的格式需要超级用户权利，而进行这一设置将会影响到复制功能。对于row-bases复制更为安全。

关于 MySQL 5.1.29的详细信息请参考手册manual.