posted by Sakila The Librarian
on
Mon 07 Sep 2009 12:11 UTC
Tags:
(
edit)
mysql,
innodb,
release,
MySQL 5.1,
online logging,
table-based logging,
logging,
alter table,
online alter table,
show processlist,
show full processlist,
processlist,
auto increment,
autoincrement,
auto_increment,
query cache,
prepared statements,
sheeri,
Pythian
In two words: online operations. In a paragraph: Forget partitioning, row-based replication and events. The big reasons most people are going to salivate over 5.1, and probably start plans to upgrade now, are the online operations: \tonline ALTER TABLE for column rename, column default value change, and adding values to the end of an ENUM/SET\tOnline, table-based logging. No more need to restart your server to enable or change the general or slow query logs. You can have the standard file-based output or choose a table format...which you can query.