Clean Up Mysql

[mario4025]

Hello,

as my mysql database is getting bigger and bigger i want to ask if there are any unnecessary tables which i can empty like referrals etc. Database is 6 GB big.

Thanks for your help

[admin]

What tables are the biggest and how many records do they have ?

[mario4025]

im not sure where to see the space of every table. But which table can be emptied beside the gallery links wihtout losing any critical data?

[admin]

You can check it here

/scj/admin/?operation=maintainance&sub=db_repair&

or ask admin to check it for you.

I have to know what consumes space to answer your question.

[mario4025]

here we go:

Table Type Size, Kb
admin_access_log InnoDB 32
admin_sessions InnoDB 16
admins InnoDB 16
blacklist InnoDB 16
bookmarks MyISAM 7551
browsers MyISAM 2824
countries InnoDB 16
day MyISAM 218
day_last_hour MyISAM 675
forces MyISAM 1
functions_data MyISAM 5
ga_categories InnoDB 16
ga_sites MyISAM 1
history MyISAM 29972
inrules InnoDB 16
ips MyISAM 1216924
ips_history InnoDB 5648
language MyISAM 313689
links MyISAM 653
out_ips MyISAM 2049003
out_ips2trader MyISAM 1076070
outrules InnoDB 16
quality_settings InnoDB 16
refs MyISAM 733247
reports InnoDB 16
rot_cell_data MyISAM 14
rot_cell_skimming InnoDB 16
rot_comments InnoDB 64
rot_content MyISAM 1
rot_crop_profiles InnoDB 16
rot_gal2group InnoDB 17968
rot_gal2model InnoDB 16
rot_gal2tag InnoDB 194304
rot_galleries MyISAM 176816
rot_gallery_data InnoDB 130656
rot_gallery_info InnoDB 497136
rot_gallery_stats MyISAM 89522
rot_groups MyISAM 3
rot_groups_data MyISAM 3
rot_import_sets InnoDB 16
rot_linked_db MyISAM 3
rot_models MyISAM 1
rot_models_data InnoDB 16
rot_page_items MyISAM 12290
rot_pages InnoDB 240
rot_replacements MyISAM 1
rot_search_queries MyISAM 646
rot_servers InnoDB 16
rot_settings InnoDB 16
rot_sponsors MyISAM 3
rot_sponsors_data InnoDB 16
rot_tags MyISAM 12395
rot_user_fav InnoDB 32
rot_users InnoDB 32
script_messages InnoDB 2064
settings InnoDB 96
skim_rules InnoDB 16
tds_rules InnoDB 16
tds_schemes InnoDB 16
toplists InnoDB 16
trader_groups InnoDB 16
trader_plugs MyISAM 2
traders InnoDB 144

[admin]

99% you don't run cron.php every minute

[mario4025]

cron and rot php running every minute since 1 year ?

[admin]

I don't think so

Tables

out_ips MyISAM 2049003
out_ips2trader MyISAM 1076070
and so on

should be cleared every day

Can you please show me records from /logs/cron.log at 00:03 of any day ?

[mario4025]

<br />
<b>Fatal error</b>: Allowed memory size of 33554432 bytes exhausted (tried to allocate 177912795 bytes) in <b>/home/teen/public_html/scj/admin/files/logs.php</b> on line <b>0</b><br />
err

and there is the problem. should i increase php.ini to 150mb? currently it is at 32 MB ?

[mario4025]

or can i manually empty the big tables, if yes which one?