Bug #37692 mysql.slow_log can't be deleted

• Submitted: 27 Jun 2008 14:08
• Modified: 28 Jun 2008 16:14
• Reporter: Michael Neubert
• Status: Not a Bug
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.1.23
• OS: Any
• CPU Architecture: Any
• Tags: slow_log

[27 Jun 2008 14:08] Michael Neubert

Description:
Hello,

since the Mysql Version mentionned above, it is not possible to delete the mysql.sloq_log anymore.

Beste wishes
Michael

How to repeat:
root@localhost [mysql]>delete from slow_log;
ERROR 1556 (HY000): You can't use locks with log tables.

root@localhost [mysql]>truncate table slow_log;
ERROR 1178 (42000): The storage engine for the table doesn't support nullable columns

[28 Jun 2008 16:14] Sveta Smirnova

Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Please read about INSERT, UPDATE and DELETE on log tables at http://dev.mysql.com/doc/refman/5.1/en/log-tables.html

TRUNCATE part of the report I can not repeat.