Title: Bloated Database Last modified: August 20, 2016 --- # Bloated Database * Resolved [stevepett](https://wordpress.org/support/users/stevepett/) * (@stevepett) * [13 years, 3 months ago](https://wordpress.org/support/topic/bloated-database/) * [http://www.theprobatedepartment.co.uk](http://www.theprobatedepartment.co.uk) has just over 300 pages and a database size of 102.6mb so the site is slow and it won’t allow me to add pages or export the database. It is an old database which has a limit of 100 mb, but surely that should be more than adequatre for a single WP install? * wp_options is 54.2mb wp_wfHoover 28.3 mb wp_postmeta 2.7mb wp_posts 2.1mb wp_direction_logs 5.5.mb wp_wfHits 3.2 mb * I am seriously non techie so please keep the replies simple – so far 1and1 have totally failed to understand the issue! Viewing 10 replies - 1 through 10 (of 10 total) * Thread Starter [stevepett](https://wordpress.org/support/users/stevepett/) * (@stevepett) * [13 years, 3 months ago](https://wordpress.org/support/topic/bloated-database/#post-3436867) * Current plug ins: Alexa Claim and Certify Improve My Load Times Jetpack by WordPress. com PushButtonSEO Redirection Revision Control SEO SearchTerms Tagging 2 SiteWit Website Analytics and Search Engine Marketing W3 Total Cache WordPress Database Backup WordPress Importer WordPress Ping Optimizer WordPress SEO WP-DBManager WP-Optimize * Steve * [damian.smith](https://wordpress.org/support/users/damiansmith/) * (@damiansmith) * [13 years, 3 months ago](https://wordpress.org/support/topic/bloated-database/#post-3436874) * The wp_direction_logs table can safely be emptied, this is just logs of 404 errors * [damian.smith](https://wordpress.org/support/users/damiansmith/) * (@damiansmith) * [13 years, 3 months ago](https://wordpress.org/support/topic/bloated-database/#post-3436876) * Not sure what wp_wfHoover is? I would guess one of the plugins… Can you view the table and say what is in there? * [damian.smith](https://wordpress.org/support/users/damiansmith/) * (@damiansmith) * [13 years, 3 months ago](https://wordpress.org/support/topic/bloated-database/#post-3436877) * Your wp_options table is probably that size due to the amount of plugins. I wouldn’t advise touching that table though. * Do you absolutely require all of the plugins? I know I used to collect a few and then realise I don’t actually need them. * Thread Starter [stevepett](https://wordpress.org/support/users/stevepett/) * (@stevepett) * [13 years, 3 months ago](https://wordpress.org/support/topic/bloated-database/#post-3436882) * First page of wp_Hoover: * ``` access www.theprobatedepartment.co.uk / ?�� 2 .htaccess www.theprobatedepartment.co.uk / ��2� 3 sitemap.xml www.theprobatedepartment.co.uk /wp-content/plugins/google-sitemap-generator/sitem... ?�� 4 sitemap.xml www.theprobatedepartment.co.uk /wp-content/plugins/google-sitemap-generator/sitem... ��2� 5 sitemap.xml www.w3.org /2001/XMLSchema-instance R � 6 sitemap.xml www.w3.org /2001/XMLSchema-instance |�o� 7 sitemap.xml www.sitemaps.org /schemas/sitemap/0.9 0�� 8 sitemap.xml www.sitemaps.org /schemas/sitemap/0.9 G�S 9 sitemap.xml www.sitemaps.org /schemas/sitemap/0.9/sitemap.xsd 0�� 10 sitemap.xml www.sitemaps.org /schemas/sitemap/0.9/sitemap.xsd G�S 11 sitemap.xml www.sitemaps.org /schemas/sitemap/0.9 0�� 12 sitemap.xml www.sitemaps.org /schemas/sitemap/0.9 G�S 13 sitemap.xml www.theprobatedepartment.co.uk / ?�� 14 sitemap.xml www.theprobatedepartment.co.uk / ��2� 15 sitemap.xml www.theprobatedepartment.co.uk /testimonials/london-probate-client/ ?�� 16 sitemap.xml www.theprobatedepartment.co.uk /testimonials/london-probate-client/ ��2� 17 sitemap.xml www.theprobatedepartment.co.uk /general/where-to-register-a-death/ ?�� 18 sitemap.xml www.theprobatedepartment.co.uk /general/where-to-register-a-death/ ��2� 19 sitemap.xml www.theprobatedepartment.co.uk /your-probate-questions/is-mother-entitled-to-anyt... ?�� 20 sitemap.xml www.theprobatedepartment.co.uk /your-probate-questions/is-mother-entitled-to-anyt... ��2� 21 sitemap.xml www.theprobatedepartment.co.uk /your-probate-questions/farming-wills/ ?�� 22 sitemap.xml www.theprobatedepartment.co.uk /your-probate-questions/farming-wills/ ��2� 23 sitemap.xml www.theprobatedepartment.co.uk /general/widows-inheritance-claim-fails/ ?�� 24 sitemap.xml www.theprobatedepartment.co.uk /general/widows-inheritance-claim-fails/ ��2� 25 sitemap.xml www.theprobatedepartment.co.uk /general/your-partner-dies/ ?�� 26 sitemap.xml www.theprobatedepartment.co.uk /general/your-partner-dies/ ��2� 27 sitemap.xml www.theprobatedepartment.co.uk /general/intestacy-new-rules-on-the-way/ ?�� 28 sitemap.xml www.theprobatedepartment.co.uk /general/intestacy-new-rules-on-the-way/ ��2� 29 sitemap.xml www.theprobatedepartment.co.uk /interesting-but-off-topic/after-probate-genealogy... ?�� 30 sitemap.xml www.theprobatedepartment.co.uk /interesting-but-off-topic/after-probate-genealogy... ``` * Thread Starter [stevepett](https://wordpress.org/support/users/stevepett/) * (@stevepett) * [13 years, 3 months ago](https://wordpress.org/support/topic/bloated-database/#post-3436886) * I clicked empty in the wp_direction_logs but it didn’t seem to change the size. Do I need to click all the boxes before doing that? * Steve * [damian.smith](https://wordpress.org/support/users/damiansmith/) * (@damiansmith) * [13 years, 3 months ago](https://wordpress.org/support/topic/bloated-database/#post-3436887) * Do you have a plugin called wordfence? * This seems to be an issue that I have found regarding “live scanning”. Basically that table is just filling up with live scans of site regarding Google Safe Browsing list – Not 100% sure for what reason though. * [https://www.wordfence.com/forums/topic/cpu-usage-high/](https://www.wordfence.com/forums/topic/cpu-usage-high/) * The moderator is saying that the table can safely be cleared out. But I would look into this in more detail first. * [damian.smith](https://wordpress.org/support/users/damiansmith/) * (@damiansmith) * [13 years, 3 months ago](https://wordpress.org/support/topic/bloated-database/#post-3436889) * Do you use phpmyadmin? * Thread Starter [stevepett](https://wordpress.org/support/users/stevepett/) * (@stevepett) * [13 years, 3 months ago](https://wordpress.org/support/topic/bloated-database/#post-3436938) * Wordfence is not a plugin I have tried (as far as I can remember!) * PHPMYADMIN – I can use as long as I am told exactly what to do!!!! * Thanks everyone so far. * Steve * Thread Starter [stevepett](https://wordpress.org/support/users/stevepett/) * (@stevepett) * [13 years, 3 months ago](https://wordpress.org/support/topic/bloated-database/#post-3437087) * I have managed to move the database elsewhere and that seems to have worked. * Steve Viewing 10 replies - 1 through 10 (of 10 total) The topic ‘Bloated Database’ is closed to new replies. ## Tags * [bloated](https://wordpress.org/support/topic-tag/bloated/) * [database](https://wordpress.org/support/topic-tag/database/) * [Large Database](https://wordpress.org/support/topic-tag/large-database/) * [msql](https://wordpress.org/support/topic-tag/msql/) * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 10 replies * 2 participants * Last reply from: [stevepett](https://wordpress.org/support/users/stevepett/) * Last activity: [13 years, 3 months ago](https://wordpress.org/support/topic/bloated-database/#post-3437087) * Status: resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics