How big is your site database?
albertc - June 22, 2009 - 17:34
Hi
I'm having performance problems with my site and I wonder if they may be caused by the DB size. I have just over 8.000 nodes and the DB is 88,8 MB, which I think is huge.
I have noted the biggest tables in phpMyAdmin:
- node_revisions: 31.6 MB
- cache_filter: 19.3 MB
- comments: 10 MB
- aggregator_item: 4.9 MB
- url_alias: 4.4 MB
- users: 3.4 MB
- adsense_clicks: 1.9 MB
- node: 1.8 MB
- locales_source: 1.5 MB
- locales_target: 1.0 MB
Can somebody explain is there's a way to slim down some of those big tables?
Thanks in advance!
--
Albert
Optimize tables
I have no idea how reliable these comparisons are without knowing about content types, modules installed, etc., but the database on my largest site is 48 MB, and it has just under 33,000 nodes (though the cache was recently cleared).
I'll bet you could cut your database's size way down by optimizing tables with overhead.
If you have access to PhpMyAdmin, go to the main page for your database, scroll down to the bottom, click 'Check tables with overhead' and then choose 'Optimize tables' from the dropdown list. I just knocked 20 MB off my database by doing that (from ~69 to 48).
your node_revisions is gobbling up db space?
Looks like your node_revisions is gobbling the biggest chunk of database space.
Unless you need this feature (so that you can go back to an earlier version) don't use this feature. I am not sure where is the global control for this. But, every time you update a node, before you save it revision tab comes up (along with input format, authorinfo etc.) If you don't need it don't use the feature. Unless you are tracking revisions, you don't need it.
No, I have never used the
No, I have never used the node revision feature. However, I have been unable to find a way to disable it, including the existing nodes. Can somebody help here?
Thanks for your suggestion,
Thanks for your suggestion, but I had already optimized the tables before noting their sizes.
Use Delete revisions permission
Please look up:
http://drupal.org/node/320614
Use Delete revisions permission.
I'm sorry, I can only give you a pointer.
Good luck.
The weird thing is that none
The weird thing is that none of my existing nodes has the 'create node revision' checkbox enabled, but the node_revisions table takes up one third of my database. Isn't there a sitewide setting for disabling the revisions? And can the node_revisions table be safely emptied without losing the current site content?
.
I'm pretty sure the answer to your last question is no: Don't empty the node_revisions table. Node bodies are stored there (if you're using them), and I believe Drupal expects to find at least the current revision of each node in there at all times.
How many rows do you have in the node_revisions table?
huge node revisions table, what can i do ?
huge node revisions table, what can i do ?
Hi,
My node revision table has 37000 records and 160 MiB.
Website is now super slow and most of the visitors cannot access, I repaired and optimized all the databases but it doesn't work with node_revisions, i can't repair or optimize this table.
What can I do ?
Thanks.
.
37000 records shouldn't be a problem, but 160 MB is surprisingly large for that many rows. You might try to figure out whether there are a relatively small number of nodes contributing most of that size.
If you want to get rid of your old node revisions, you might take a look at the Revision Deletion module, which enables you to delete old node revisions automatically.
I suspect there might be other problems contributing to the slow speed of your site, though. Keep searching for tips on speeding up your Drupal site. Also, consider whether your host might be part of the problem.
No revisions to delete
Thank you, I tried Node revision deletion and had nothing to delete, I guess it's just the "normal" content which is n node_revisions table.
I really don't know what to do now.