I am having issues trying to back my database up with backup-migrate. Right now my database is about 256 mb big... I have no idea if this is a good or bad thing. My site seems to be running ok, speedwise. I have just finished a university term with about 160 students that did about 10 nodes each, and I have created about 1500 nodes... I am not sure how many total node s I have created,,,
I did a quick search on druapal and saw some say they thought 20mb was big... and in the past I have never seen my database grow so large. I am trying to run some preventative maintenance and find out if this is a dangersous thing or not to have my database this large andif there is a quick fix or trouble shooting path I can go down to fix this, or am I worrying about nothing and is this normal?
Thanks for any feedback on this----
my site is at thecenterofthenet dot com FWIW----
Comments
The size is not a problem in
The size is not a problem in itself. There are Drupal sites with database sizes in the GBs. The question is if it's expected. You can check which database tables are largest by logging into Chive and sorting by size. If each of those over 3000 nodes contain a lot of content, this size is not surprising. Or maybe you are using revisions, that could add up quickly depending on how the nodes are used.
A larger db size may mean you have to work with it differently - e.g. don't backup from the webinterface, but from commandline.