Bloated Database

  • Resolved stevepett

    (@stevepett)


    11 years, 9 months ago

    https://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

    (@stevepett)

    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

    The wp_direction_logs table can safely be emptied, this is just logs of 404 errors

    Not sure what wp_wfHoover is? I would guess one of the plugins… Can you view the table and say what is in there?

    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

    (@stevepett)

    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

    (@stevepett)

    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

    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/

    The moderator is saying that the table can safely be cleared out. But I would look into this in more detail first.

    Do you use phpmyadmin?

    Thread Starter stevepett

    (@stevepett)

    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

    (@stevepett)

    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.