99.29 Megabytes is what I am at right now on my disk usage. Before this whole arcade debacle, I was at about 50 megabytes of space.
I am only alloted 100 though. Does anybody know where this could be coming from?
I already deleted my error logs.
Check the database tables..maybe you got duplicates of tables - especially the smf_messages table is usually big.
Also check for uploaded games..they take a bit of space too.
Here is what happens when I click check
Checking Database
eric_smf1 is now being checked.
eric_smf1.mos_banner OK
eric_smf1.mos_bannerclient OK
eric_smf1.mos_bannerfinish OK
eric_smf1.mos_categories OK
eric_smf1.mos_components OK
eric_smf1.mos_contact_details OK
eric_smf1.mos_content OK
eric_smf1.mos_content_frontpage OK
eric_smf1.mos_content_rating OK
eric_smf1.mos_core_acl_aro OK
eric_smf1.mos_core_acl_aro_groups OK
eric_smf1.mos_core_acl_aro_sections OK
eric_smf1.mos_core_acl_groups_aro_map OK
eric_smf1.mos_core_log_items OK
eric_smf1.mos_core_log_searches OK
eric_smf1.mos_groups OK
eric_smf1.mos_mambots OK
eric_smf1.mos_menu OK
eric_smf1.mos_messages OK
eric_smf1.mos_messages_cfg OK
eric_smf1.mos_modules OK
eric_smf1.mos_modules_menu OK
eric_smf1.mos_newsfeeds OK
eric_smf1.mos_poll_data OK
eric_smf1.mos_poll_date OK
eric_smf1.mos_poll_menu OK
eric_smf1.mos_polls OK
eric_smf1.mos_sections OK
eric_smf1.mos_session OK
eric_smf1.mos_stats_agents OK
eric_smf1.mos_template_positions OK
eric_smf1.mos_templates_menu OK
eric_smf1.mos_users OK
eric_smf1.mos_usertypes OK
eric_smf1.mos_weblinks OK
eric_smf1.smf_attachments OK
eric_smf1.smf_ban_groups OK
eric_smf1.smf_ban_items OK
eric_smf1.smf_board_permissions OK
eric_smf1.smf_boards OK
eric_smf1.smf_calendar OK
eric_smf1.smf_calendar_holidays OK
eric_smf1.smf_categories OK
eric_smf1.smf_collapsed_categories OK
eric_smf1.smf_don_finan OK
eric_smf1.smf_don_logs OK
eric_smf1.smf_don_trans OK
eric_smf1.smf_log_actions OK
eric_smf1.smf_log_activity OK
eric_smf1.smf_log_banned OK
eric_smf1.smf_log_boards OK
eric_smf1.smf_log_errors OK
eric_smf1.smf_log_floodcontrol OK
eric_smf1.smf_log_karma OK
eric_smf1.smf_log_mark_read OK
eric_smf1.smf_log_notify OK
eric_smf1.smf_log_online OK
eric_smf1.smf_log_polls OK
eric_smf1.smf_log_ratings OK
eric_smf1.smf_log_search_fulltext OK
eric_smf1.smf_log_search_messages OK
eric_smf1.smf_log_search_results OK
eric_smf1.smf_log_search_subjects OK
eric_smf1.smf_log_topics OK
eric_smf1.smf_membergroups OK
eric_smf1.smf_members OK
eric_smf1.smf_message_icons OK
eric_smf1.smf_messages OK
eric_smf1.smf_mm_pins OK
eric_smf1.smf_moderators OK
eric_smf1.smf_package_servers OK
eric_smf1.smf_permissions OK
eric_smf1.smf_personal_messages OK
eric_smf1.smf_pm_recipients OK
eric_smf1.smf_poll_choices OK
eric_smf1.smf_polls OK
eric_smf1.smf_sessions OK
eric_smf1.smf_settings OK
eric_smf1.smf_shoutbox OK
eric_smf1.smf_smileys OK
eric_smf1.smf_themes OK
eric_smf1.smf_topics OK
eric_smf1.tportal_articles OK
eric_smf1.tportal_blocks OK
eric_smf1.tportal_settings OK
eric_smf1.tportal_variables OK
holy cow, i just deleted my database
uh oh, that's not good. it shouldn't have been 50mb or 90mb with an empty error log. i have something like 3000 posts on my board and the database is slightly less than 5mb last i checked.
everything is gone
got a ticket in to see if i can get it restored
that sucks, dude :( was your forum jampacked with posts?
yes, i probably had about 4000 and 238 members
just a ton of info there also. completely stinks. waiting for them to answer my ticket.
WSA, I would highly suggest you do your own backups at least weekly. I've seen your forum, and know that you have a farely busy site. Go into your admin for the forum and you can do a database dump there. It won't do the portal tables but at least you'll have your posts and users saved.
i'm learning about the importance of backups everyday
Well, I got it back now. There was a back-up done about 2 days ago. I lost some posts but who cares. I got most of them back. Woooweeee.
Also, I found another table on the server and deleted it. Back down to a respectable 60mb. I'll go through it again just to make sure nothing new is in there.
Thanks a bunch guys.
60Mb is still way too high. One of my sites is about the same as yours, but the database in far, far smaller.
yeah, sounds big still... Try to use the admin section and clear "unimportant logs" for example. And of course the error logs. ;)
I have cleared the error logs out and have cleared out all of the old Mambo tables on the database.
I am currently at 73mb. I can't find anything else in there.
Is the messages table the biggest? Looking at the tables in phpmyadmin will reveal any bigger ones..and normally xxx_messages is the largest.
Also..if any backups are laying around on the server, that will push it up by the 10ths of mb.
This is what I see on my database
Table Action RecordsTip Type Collation Size Overhead
smf_attachments Browse Structure Search Insert Empty Drop 14 MyISAM latin1_swedish_ci 4.5 KB -
smf_ban_groups Browse Structure Search Insert Empty Drop 0 MyISAM latin1_swedish_ci 1.0 KB -
smf_ban_items Browse Structure Search Insert Empty Drop 0 MyISAM latin1_swedish_ci 1.0 KB -
smf_board_permissions Browse Structure Search Insert Empty Drop 9,105 MyISAM latin1_swedish_ci 411.0 KB -
smf_boards Browse Structure Search Insert Empty Drop 47 MyISAM latin1_swedish_ci 11.9 KB -
smf_calendar Browse Structure Search Insert Empty Drop 5 MyISAM latin1_swedish_ci 5.2 KB -
smf_calendar_holidays Browse Structure Search Insert Empty Drop 185 MyISAM latin1_swedish_ci 11.5 KB -
smf_categories Browse Structure Search Insert Empty Drop 7 MyISAM latin1_swedish_ci 2.2 KB -
smf_collapsed_categories Browse Structure Search Insert Empty Drop 15 MyISAM latin1_swedish_ci 2.1 KB -
smf_don_finan Browse Structure Search Insert Empty Drop 2 MyISAM latin1_swedish_ci 2.1 KB -
smf_don_logs Browse Structure Search Insert Empty Drop 2 MyISAM latin1_swedish_ci 2.2 KB -
smf_don_trans Browse Structure Search Insert Empty Drop 5 MyISAM latin1_swedish_ci 3.0 KB -
smf_log_actions Browse Structure Search Insert Empty Drop 6 MyISAM latin1_swedish_ci 4.4 KB -
smf_log_activity Browse Structure Search Insert Empty Drop 173 MyISAM latin1_swedish_ci 12.9 KB -
smf_log_banned Browse Structure Search Insert Empty Drop 0 MyISAM latin1_swedish_ci 1.0 KB -
smf_log_boards Browse Structure Search Insert Empty Drop 2,562 MyISAM latin1_swedish_ci 54.0 KB -
smf_log_errors Browse Structure Search Insert Empty Drop 264 MyISAM latin1_swedish_ci 67.9 KB -
smf_log_floodcontrol Browse Structure Search Insert Empty Drop 1 MyISAM latin1_swedish_ci 2.0 KB -
smf_log_karma Browse Structure Search Insert Empty Drop 0 MyISAM latin1_swedish_ci 1.0 KB -
smf_log_mark_read Browse Structure Search Insert Empty Drop 328 MyISAM latin1_swedish_ci 9.2 KB -
smf_log_notify Browse Structure Search Insert Empty Drop 201 MyISAM latin1_swedish_ci 7.0 KB -
smf_log_online Browse Structure Search Insert Empty Drop 63 MyISAM latin1_swedish_ci 18.4 KB -
smf_log_polls Browse Structure Search Insert Empty Drop 142 MyISAM latin1_swedish_ci 5.1 KB -
smf_log_ratings Browse Structure Search Insert Empty Drop 3 MyISAM latin1_swedish_ci 3.0 KB -
smf_log_search_fulltext Browse Structure Search Insert Empty Drop 0 MyISAM latin1_swedish_ci 1.0 KB -
smf_log_search_messages Browse Structure Search Insert Empty Drop 0 MyISAM latin1_swedish_ci 1.0 KB -
smf_log_search_results Browse Structure Search Insert Empty Drop 0 MyISAM latin1_swedish_ci 1.0 KB -
smf_log_search_subjects Browse Structure Search Insert Empty Drop 1,633 MyISAM latin1_swedish_ci 78.0 KB 20 Bytes
smf_log_topics Browse Structure Search Insert Empty Drop 8,328 MyISAM latin1_swedish_ci 265.5 KB -
smf_membergroups Browse Structure Search Insert Empty Drop 26 MyISAM latin1_swedish_ci 4.1 KB -
smf_members Browse Structure Search Insert Empty Drop 244 MyISAM latin1_swedish_ci 68.6 KB 20 Bytes
smf_message_icons Browse Structure Search Insert Empty Drop 12 MyISAM latin1_swedish_ci 3.3 KB -
smf_messages Browse Structure Search Insert Empty Drop 3,622 MyISAM latin1_swedish_ci 2.4 MB -
smf_mm_pins Browse Structure Search Insert Empty Drop 1 MyISAM latin1_swedish_ci 4.0 KB -
smf_moderators Browse Structure Search Insert Empty Drop 0 MyISAM latin1_swedish_ci 1.0 KB -
smf_package_servers Browse Structure Search Insert Empty Drop 4 MyISAM latin1_swedish_ci 2.3 KB -
smf_permissions Browse Structure Search Insert Empty Drop 413 MyISAM latin1_swedish_ci 22.8 KB -
smf_personal_messages Browse Structure Search Insert Empty Drop 270 MyISAM latin1_swedish_ci 172.3 KB 1,076 Bytes
smf_pm_recipients Browse Structure Search Insert Empty Drop 274 MyISAM latin1_swedish_ci 16.4 KB 80 Bytes
smf_poll_choices Browse Structure Search Insert Empty Drop 50 MyISAM latin1_swedish_ci 3.2 KB -
smf_polls Browse Structure Search Insert Empty Drop 10 MyISAM latin1_swedish_ci 2.6 KB -
smf_sessions Browse Structure Search Insert Empty Drop 65 MyISAM latin1_swedish_ci 42.2 KB 6,404 Bytes
smf_settings Browse Structure Search Insert Empty Drop 231 MyISAM latin1_swedish_ci 25.1 KB -
smf_shoutbox Browse Structure Search Insert Empty Drop 0 MyISAM latin1_swedish_ci 1.0 KB -
smf_smileys Browse Structure Search Insert Empty Drop 23 MyISAM latin1_swedish_ci 2.7 KB -
smf_themes Browse Structure Search Insert Empty Drop 449 MyISAM latin1_swedish_ci 35.2 KB -
smf_topics Browse Structure Search Insert Empty Drop 447 MyISAM latin1_swedish_ci 49.7 KB -
tportal_articles Browse Structure Search Insert Empty Drop 0 MyISAM latin1_swedish_ci 1.0 KB -
tportal_blocks Browse Structure Search Insert Empty Drop 14 MyISAM latin1_swedish_ci 8.0 KB -
tportal_settings Browse Structure Search Insert Empty Drop 33 MyISAM latin1_swedish_ci 2.9 KB -
tportal_variables Browse Structure Search Insert Empty Drop 160 MyISAM latin1_swedish_ci 34.1 KB -
51 table(s) Sum 29,439 -- latin1_swedish_ci 3.8 MB 7.4 KB
Seems that your total is much lower that what it was. 3.8Mb
51 table(s) Sum 29,439 -- latin1_swedish_ci 3.8 MB 7.4 KB
Quote from: WSA on November 07, 2005, 11:45:55 PM
I have cleared the error logs out and have cleared out all of the old Mambo tables on the database.
I am currently at 73mb. I can't find anything else in there.
The Mambo files them selves will use up a load of disc space. Have you deleted them all? Mambo can be a real b*tch to get rid of. Took me a long time to get the files off my server.
This is his database we're talking about gerrymo. It appears your DB is not 70+ megs after all. Are you seeing the size report through CPanel? You have more than one DB?
I think there is a mix up between th Db and Disc usage. I'm sure there are files on the server that shouldnt be there. I had the same a few years ago. Turned out to be a "Catch All" e-mail addy that the host hadnt told me about, with 100Mb of spam in it. Once the e-mail account was closed; problem solved.
I really dont think WSA means the database, think it may be server disc usage.
You are correct. It is disc usage. My mistake on that. I did get rid of the mambo stuff and freed up a little bit. I also found about 12 backups in my packages folder that were about 1.2 mb each.
I am down to about 53 megs now overall.