TinyPortal

General => Chit chat => Topic started by: WSA on November 03, 2005, 11:24:19 PM

Title: SQL Disk Usage
Post by: WSA on November 03, 2005, 11:24:19 PM
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.
Title: Re: SQL Disk Usage
Post by: bloc on November 04, 2005, 01:56:22 AM
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.
Title: Re: SQL Disk Usage
Post by: WSA on November 04, 2005, 07:51:20 PM
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

Title: Re: SQL Disk Usage
Post by: WSA on November 04, 2005, 08:16:31 PM
holy cow, i just deleted my database
Title: Re: SQL Disk Usage
Post by: Moocat on November 04, 2005, 08:22:49 PM
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.
Title: Re: SQL Disk Usage
Post by: WSA on November 04, 2005, 08:26:25 PM
everything is gone

got a ticket in to see if i can get it restored
Title: Re: SQL Disk Usage
Post by: Moocat on November 04, 2005, 09:12:56 PM
that sucks, dude :( was your forum jampacked with posts?
Title: Re: SQL Disk Usage
Post by: WSA on November 04, 2005, 09:14:59 PM
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.
Title: Re: SQL Disk Usage
Post by: IchBin on November 04, 2005, 10:06:21 PM
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.
Title: Re: SQL Disk Usage
Post by: WSA on November 04, 2005, 10:25:32 PM
i'm learning about the importance of backups everyday
Title: Re: SQL Disk Usage
Post by: WSA on November 05, 2005, 06:29:48 PM
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.
Title: Re: SQL Disk Usage
Post by: gerrymo on November 05, 2005, 06:51:57 PM
60Mb is still way too high. One of my sites is about the same as yours, but the database in far, far smaller.
Title: Re: SQL Disk Usage
Post by: bloc on November 05, 2005, 07:21:36 PM
yeah, sounds big still... Try to use the admin section and clear "unimportant logs" for example. And of course the error logs. ;)
Title: Re: SQL Disk Usage
Post by: 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.
Title: Re: SQL Disk Usage
Post by: bloc on November 08, 2005, 12:39:00 PM
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.
Title: Re: SQL Disk Usage
Post by: WSA on November 08, 2005, 04:43:33 PM
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
Title: Re: SQL Disk Usage
Post by: gerrymo on November 08, 2005, 04:52:39 PM
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
Title: Re: SQL Disk Usage
Post by: gerrymo on November 08, 2005, 05:16:47 PM
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.
Title: Re: SQL Disk Usage
Post by: IchBin on November 08, 2005, 10:53:02 PM
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?
Title: Re: SQL Disk Usage
Post by: gerrymo on November 08, 2005, 11:37:34 PM
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.
Title: Re: SQL Disk Usage
Post by: WSA on November 08, 2005, 11:59:09 PM
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.