mysql.general_log custom colums
Posted by: enrico tenivella
Date: November 02, 2015 07:49AM

Hi, until mysql 5.5 i was able to add a custom column in mysql.general_log table, it's works fine

SET GLOBAL general_log = 'OFF';
RENAME TABLE general_log TO general_log_temp;
ALTER TABLE `general_log_temp`
ADD COLUMN `event_unix` int(10) NOT NULL AFTER `event_time`;
RENAME TABLE general_log_temp TO general_log;
SET GLOBAL general_log = 'ON';

In mysql 5.6 I can add the colums with success but no logs are stored

#mysql -V
Ver 14.14 Distrib 5.6.15, for debian6.0 (x86_64) using EditLine wrapper)

2015-11-02 14:22:52 7357 [ERROR] Failed to write to mysql.general_log:
2015-11-02 14:22:52 7357 [ERROR] Column count of mysql.general_log is wrong. Expected 6, found 7. The table is probably corrupted

Any help please^?

Options: ReplyQuote

Written By
mysql.general_log custom colums
November 02, 2015 07:49AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.