There is a new feature in MySQL 5.1 -- log tables. This session is devoted to this small, but nice feature and explains why one would like to have logs like this and how to use them. There will also be time for feedback: what do people think about the feature and do they want to extend it (e.g., add an error_log table? Add another table for audit needs?)

Topics covered include:

• What are log tables and when they appeared
• New abilities
• New logs are disable/able (on fly) => one doesn't need to stop
• Now one can use SQL to get info from logs
• Log tables could be at the same time human-readable (CSV)

• Why one might need a log table
• DBA's (no need to log into the machine)
• Application developers (now application can get info from server logs)

• How to use log tables: log tables + events (log rotation), DB audit with log tables
• Implementation details and restrictions: log tables and locking, updateable log tables
• Possible roadmap
• Feedback!