I just checked my MODX evo 1.0.4's database and found that the table 'modx_event_log' has 90011 records and 258.42 MB data size - it is overly large!
What is causing the large data size?
Can I truncate the table?
It is large because no-one has cleared it for years
Log into the control panel: reports => system events: press "clear log"
You will probably have a lot of errors due to PHP compatibility issues, 1.0.4 doesn't support recent versions of PHP
Go into the control panel: reports => manager actions: press "search"
You will get a report - in the top of the report there is a link stating "empty the log file", click it and the user logs will be deleted as well
Go back to your DB and you will see that it has shrunk in size
I assume no issues in emptying the modx_event_logo from PHPMyadmin? Myn is so big it hangs the manager!
No, shouldn't be any problem doing so - I do it as well sometimes