Problem: Huge amount of disk space is being used by elgg

Hi,

I am having problem with elgg;

previously i was using a paid social networking script, but now i have moved to elgg.

The problem is that in past my diskspace was used to max 3gb in one year.

but on elgg my diskspace is used more than 6gb in only 2 months.

I think there is some cron or corn jobs issue.

please help me in this regard

really worried about extra diskspace expenses.

 

  • Thank you very much

    I have already asked them.

    So nice of you CHAMBO

     

  • Check what your debug settings are in Site Administration.  If it's set to log errors, change it the recommended "Turn off debug mode."

  • elggusers_apisessions    
    elgghmac_cache    
    elgggeocode_cache    
    -- no probs, these are memory tables, no need for repair.

    goto yr phpmyadmin right hand side, copy and paste the tablenames & numbers from there.

  • @saifee:

    You really have to check first where all the disc space is used. The only information you gave us so far is the total disc space used. But you should really be able to find out more easily.

    Is it the Elgg data directory that is so big? Then it might be due to some user who might have uploaded something without your knowledge. You said that's not the case, but better check first.

    If not the data directory, is it the Elgg directory itself? The only reason I can imagine then is that there is some error log file that gets larger and larger. Check the directory tree and you should be able to find out easily where the large file is hidden. Or is the disc space used by server logs? It depends on your installation where these server logs are saved (/var/log, /var/log/apache ...).

    Check any error log file/server log file that is extremely large for possible reasons why so much is logged. Also turn off debug mode, as Brett suggested, if it's currently on.

  • @Brett

    Thanks

    DONE... It helped ... now 6.6GB have reduced to 4.5GB (althought its is also too much)

     

    @Dhruva

    Which NUMBERS?

    the RECORDS numbers or SIZE?

    NAMES ARE:

     

    elggaccess_collections
    elggaccess_collection_membership

    elggannotations

    elggapi_users

    elggconfig

    elggdatalists

    elggentities

    elggentity_relationships

    elggentity_subtypes

    elgggeocode_cache

    elgggroups_entity

    elgghmac_cache

    elggmetadata

    elggmetastrings

    elggobjects_entity

    elggprivate_settings

    elggriver

    elggsites_entity

    elggsites_log
    elggsystem_log_1266782521

     

    elggsystem_log_1269201751

    elggsystem_log_1271621041

    elggsystem_log_1274040377

    elggusers_apisessions

    elggusers_entity

    elggusers_sessions

     

    All of the above (26) tables are in the same order as they are in phpmyadmin.

    Thank you all for such a kind support and help.

    Regards.

     

  • it lookie likie this lolz ;- )

    Table Descending Action Records 1 Type Collation Size Overhead
    Browse Structure Search Insert Empty Drop 7 MyISAM utf8_general_ci 4.3 KiB -
    Browse Structure Search Insert Empty Drop 7 MyISAM utf8_general_ci 2.1 KiB -
    Browse Structure Search Insert Empty Drop 0 MyISAM utf8_general_ci 1.0 KiB -
    Browse Structure Search Insert Empty Drop 1 MyISAM utf8_general_ci 3.1 KiB -
    Browse Structure Search Insert Empty Drop 6 MyISAM utf8_general_ci 2.2 KiB -
    Browse Structure Search Insert Empty Drop 24 MyISAM utf8_general_ci 2.8 KiB -
    Browse Structure Search Insert Empty Drop 20 MyISAM utf8_general_ci 11.0 KiB -
    Browse Structure Search Insert Empty Drop 8 MyISAM utf8_general_ci 5.3 KiB -
    Browse Structure Search Insert Empty Drop 6 MyISAM utf8_general_ci 3.1 KiB -
    Browse Structure Search Insert Empty Drop 0 MEMORY latin1_swedish_ci 0 B -
    Browse Structure Search Insert Empty Drop 7 MyISAM utf8_general_ci 5.4 KiB -
    Browse Structure Search Insert Empty Drop 0 MEMORY latin1_swedish_ci 0 B -
    Browse Structure Search Insert Empty Drop 112 MyISAM utf8_general_ci 23.3 KiB -
    Browse Structure Search Insert Empty Drop 123 MyISAM utf8_general_ci 28.5 KiB -
    Browse Structure Search Insert Empty Drop 8 MyISAM utf8_general_ci 3.3 KiB -
    Browse Structure Search Insert Empty Drop 18 MyISAM utf8_general_ci 9.0 KiB -
    Browse Structure Search Insert Empty Drop 5 MyISAM utf8_general_ci 8.3 KiB -
    Browse Structure Search Insert Empty Drop 1 MyISAM utf8_general_ci 10.1 KiB -
    Browse Structure Search Insert Empty Drop 5,803 MyISAM utf8_general_ci 926.4 KiB -
    Browse Structure Search Insert Empty Drop 1,398 ARCHIVE latin1_swedish_ci unknown -
    Browse Structure Search Insert Empty Drop 0 ARCHIVE latin1_swedish_ci unknown -
    Browse Structure Search Insert Empty Drop 0 MEMORY utf8_general_ci 0 B -
    Browse Structure Search Insert Empty Drop 4 MyISAM utf8_general_ci 12.5 KiB -
  • hehehe

    lolz

    u look hyper

    :P

     

    8 MyISAM utf8_general_ci 4.4 KiB -
    20 MyISAM utf8_general_ci 2.2 KiB -
    627 MyISAM utf8_general_ci 77.9 KiB -
    0 MyISAM utf8_general_ci 1.0 KiB -
    5 MyISAM utf8_general_ci 2.2 KiB 40 B
    30 MyISAM utf8_general_ci 3.0 KiB -
    3,034 MyISAM utf8_general_ci 488.0 KiB -
    357 MyISAM utf8_general_ci 31.7 KiB -
    27 MyISAM utf8_general_ci 3.8 KiB -
    0 MEMORY latin1_swedish_ci 0 B -
    7 MyISAM utf8_general_ci 5.8 KiB -
    0 MEMORY latin1_swedish_ci 0 B -
    5,770 MyISAM utf8_general_ci 635.8 KiB 78 B
    1,618 MyISAM utf8_general_ci 202.2 KiB -
    2,849 MyISAM utf8_general_ci 747.6 KiB -
    8,768 MyISAM utf8_general_ci 519.6 KiB -
    424 MyISAM utf8_general_ci 74.5 KiB -
    1 MyISAM utf8_general_ci 7.1 KiB -
    17,304 MyISAM utf8_general_ci 2.5 MiB -
    0 ARCHIVE latin1_swedish_ci unknown -
    1,272 ARCHIVE latin1_swedish_ci unknown -
  • what's on the bottom line ?

    shud look like this

    24 table(s) Sum 7,567 MyISAM latin1_swedish_ci 1.1 MiB 2.2 KiB

     

    ps: i am not "hyper".. just have a very high threshold for workloads ;-)

  • hang on 1 sec....

    your 


    elggsystem_log_1266782521
    elggsystem_log_1269201751
    elggsystem_log_1271621041

    delete those

    goto

    elggsystem_log

    and EMPTY that table via PhpMyAdmin

    then look at disk space lolz ;-)

  • heres bottom line

     

    26 table(s)   Sum    96,230    MyISAM       latin1_swedish_ci  5.3 MiB 118 B