By sunilkumar on

Sorry for the duplicate thread (No reply for this http://drupal.org/node/449982 and I can not delete that post.)

I have a small site in Drupal 6.10 with MySQL database. I have uploaded few mp3 files and video files in the sites directory for playback with SWFTools. Rest all are text files in Indic unicode script.

My problem is the size of ht MySQL databse. Now it shows 50MB, after repairing and optimizing the size reduced to 48MB. But before one or two weeks ago it was only 10.13MB! I have not added any data after that.

Frequently the size of the database is changing without doing much by me! I have activated the devel. module.

Please let me have your expert comments. Do you need any more details? The site is an average site with not much pictures or other files except those mp3 of video files. But those are stored in my home directory, not in MySQL database.

Regards,
-S-

⋅ Categories: Drupal 6.x

Comments

sunilkumar’s picture

sunilkumar commented

Please give me your valuable comments.

Regards,
-S-

Jeff Burnz’s picture

Jeff Burnz commented

See how big the watchdog table is. One assumes there is an error somewhere causing data to be written to the database, probably in the watchdog table.

Pimp your Drupal 8 Toolbar - make it badass.
Adaptivetheme - theming system for people who don't code.
sunilkumar’s picture

sunilkumar commented

It has 1006 records and 257.5 KiB. What does that mean? We have other tables with more records and size. For example cache_ tables., access log, search-index,search_total,locales_source etc.

Is there is any error or problem with database?

Regards,
-S-

banesto’s picture

banesto commented

man, that's usual drupal stuff :)
i recommend turn off drupal search and use google-search instead for a start. other big tables i think should be cleaned out, correct me someone if i'm wrong. I didn't do big investigation in this, but there should be some cron job to clean old entries from these tables.

sunilkumar’s picture

sunilkumar commented

Can I empty watchdog table contents?

Anonymous’s picture

Anonymous (not verified) commented

check you cache tables

drahman’s picture

drahman commented

What is a safe way to clean up or reduce the size of the mySQL database? For instance, in phpMyadmin can I empty a table without suffering any problems in my drupal site?

Secondly, are corresponding tables automatically deleted from the database when you deactivate and uninstall a module?