Set trigger to delete DB user/streams logs

[Apollo]

Hi,

If you don't want your SQL server to get huge, you should set trigger that will delete old logs records:

delimiter |

CREATE EVENT IF NOT EXISTS `Clean_Old_logs`
ON SCHEDULE
    EVERY 1 DAY
COMMENT 'Clean up logs'
DO
    BEGIN
        DELETE FROM stream_logs WHERE date < (UNIX_TIMESTAMP()-60*60*24*[b]2[/b]);
        DELETE FROM client_logs WHERE date < (UNIX_TIMESTAMP()-60*60*24*[b]2[/b]);
    END |
delimiter ;

You can change "2" to any numbers of days you want to save logs for.

 

[urgodfather]

Very nice! I think is better to create like, rotate, then drop, but this is definitely another nice clean way to handle pesky logs. Good work!

 

[deyoo]

Hi,

If you don't want your SQL server to get huge, you should set trigger that will delete old logs records:

delimiter |

CREATE EVENT IF NOT EXISTS `Clean_Old_logs`
ON SCHEDULE
    EVERY 1 DAY
COMMENT 'Clean up logs'
DO
    BEGIN
        DELETE FROM stream_logs WHERE date < (UNIX_TIMESTAMP()-60*60*24*[b]2[/b]);
        DELETE FROM client_logs WHERE date < (UNIX_TIMESTAMP()-60*60*24*[b]2[/b]);
    END |
delimiter ;

You can change "2" to any numbers of days you want to save logs for.

Is this a php script saved on the server?