oishf7
31st of January 2004 (Sat), 12:21
I am sure Pekka has pointed this out somewhere along the way but to bring this point to light again, I figured I'd remind everyone.
I noticed when backing up my EE database, that it had swollen to over 30 MB's. When I looked at my database, the Messages table was the culprit.
This table stores all your FTP messages, System messages and Export messages. You can view these under the Utilities heading in your Admin area. These messages are useful for troubleshooting errors, but not critical for long term storage or functionality.
When you view these via your Admin, there is a link to Clear The Messages. Doing so will delete them from your database.
In my case, my 30 MB database is back to 512 KB. and my site is running much faster. I believe this is due to the fact that my mySQL server was beginning to choke - the overall amount of disk space was shrinking rapidly, not just the database space. I don't know for sure that EE itself was running slower from the large Database size per se, but the space issue defintely was causing my entire webserver to act up. Deleting old monthly EE backups that existed of that same 30MB database also freed another 150 MB's of space.
At the very least, deleting these messages regularly will reduce the siza of your database backups which when stored on your server will begin to eat away at your available space. Which we all would rather use for more images.
Hope this tip helps someone!
I noticed when backing up my EE database, that it had swollen to over 30 MB's. When I looked at my database, the Messages table was the culprit.
This table stores all your FTP messages, System messages and Export messages. You can view these under the Utilities heading in your Admin area. These messages are useful for troubleshooting errors, but not critical for long term storage or functionality.
When you view these via your Admin, there is a link to Clear The Messages. Doing so will delete them from your database.
In my case, my 30 MB database is back to 512 KB. and my site is running much faster. I believe this is due to the fact that my mySQL server was beginning to choke - the overall amount of disk space was shrinking rapidly, not just the database space. I don't know for sure that EE itself was running slower from the large Database size per se, but the space issue defintely was causing my entire webserver to act up. Deleting old monthly EE backups that existed of that same 30MB database also freed another 150 MB's of space.
At the very least, deleting these messages regularly will reduce the siza of your database backups which when stored on your server will begin to eat away at your available space. Which we all would rather use for more images.
Hope this tip helps someone!