info@elgg.org
Security issues should be reported to security@elgg.org!
©2014 the Elgg Foundation
Elgg is a registered trademark of Thematic Networks.
Cover image by RaĆ¼l Utrera is used under Creative Commons license.
Icons by Flaticon and FontAwesome.
- iionly@iionly
iionly - 0 likes
- Bean@Bean
Bean - 0 likes
- iionly@iionly
iionly - 0 likes
You must log in to post replies.It could be the log table and possibly also archived but not deleted backups of the log table created by the Logrotate plugin.
Best would be to check the size of the tables for example in phpMyAdmin to see which tables are large. If it's not the log tables, there might be an issue resulting in some other table being larger than normal.
What version of Elgg are you using? And do you have the cronjobs of Elgg configured and then also the bundled Garbagecollector and Logrotate enabled and configured. These plugins will clean up the database regularly resulting in a smaller database (if the reason for the large size isn't some issue/bug not covered by these plugins). On newer versions of Elgg the Logrotate plugin also has the option to delete archived log tables older than the configured time automatically to reduce database size. Maybe best would be to just set up this option and let Elgg do the job of deleting older logs. Otherwise, you still could delete the tables of archived logs yourself (but do not delete the current log table!).
newest version .... I drop all now ,no time check which table cause the issue also, I guess the log should be write in file but database
It's the logging of database operations only that are saved in the database. And if you don't check the size of your database tables you wouldn't even know if it's the log table that got so large.
Why not check which table is large? This could be done surely faster than setting up again the whole site from start. And depending on what causes the database getting so large the same could happen again with the new installation. If it's just the log that got so large you would only have to set up the cronjobs and Logrotate plugin and it gets sorted out automatically.