Database grows excessively

Hello

I am currently in process of builging a simple website using only WPMU tools and widely used WP Globus plugin for multi-linguality. My problem: the hosting provider reports that my database has grown to over 400 megabytes and suspended usage of the database. I extended the quota to 800 megabytes but that also was very soon exceeded. The site has almost no content. Only a couple of dozen articles and posts. Comments are disabled for articles so the site does not have one million viagra spam advertisments or anything like that. Looking at cpanel shows that the culprit is wp_posts table which has over 200 megabytes of content. We are using Fixer theme and have imported its default data.

I've granted administrative access to WPMU. Can you please look at the site: http://www.terracolligo.com

  • ossiman

    I have also read the DB optimization tutorial at https://premium.wpmudev.org/blog/optimizing-your-wordpress-database-a-complete-guide and enabled the setting in wp-config.php to enable the WP repair tools.

    phpmyadmin shows that wp_posts is currently eating some 77 megabytes. How can this table be so large? The site is using some 400 megabytes of disk space.

    Table Ascending Action Rows Type Collation Size Overhead
    wp_commentmeta Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8mb4_unicode_520_ci 48 KiB -
    wp_comments Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 InnoDB utf8mb4_unicode_520_ci 96 KiB -
    wp_links Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8mb4_unicode_520_ci 32 KiB -
    wp_options Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 269 InnoDB utf8mb4_unicode_520_ci 3.5 MiB -
    wp_postmeta Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 396 InnoDB utf8mb4_unicode_520_ci 192 KiB -
    wp_posts Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 296 InnoDB utf8mb4_unicode_520_ci 76.6 MiB -
    wp_termmeta Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8mb4_unicode_520_ci 48 KiB -
    wp_terms Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 13 InnoDB utf8mb4_unicode_520_ci 48 KiB -
    wp_term_relationships Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 84 InnoDB utf8mb4_unicode_520_ci 32 KiB -
    wp_term_taxonomy Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 13 InnoDB utf8mb4_unicode_520_ci 48 KiB -
    wp_usermeta Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 37 InnoDB utf8mb4_unicode_520_ci 48 KiB -
    wp_users Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2 InnoDB utf8mb4_unicode_520_ci 64 KiB -

  • Ash

    Hello ossiman

    I am extremely sorry, I didn't notice you are using Upfront, I apologize. WPML is not 100% compatible to upfront.

    To create a functional multi language site with Upfront you will need to use Multisite (so each language will be separate subsite) - and plugin like that
    - https://wordpress.org/plugins/multilingual-press/
    - https://wordpress.org/plugins/zanto/
    to create linking between sites.

    Or, if WP Globus plugin works fine unchecking the additional post types, then you may continue using that too.

    Have a nice day!

    Cheers,
    Ash

  • ossiman

    Thanks Ash. This is really a problem and essentially means that we can't use Upfront. Having multi-site just to offer language translations defies the whole purpose! Too bad that WPMUDEV does not offer its own simple translation plugin.

    WP Globus seems to be causing the excessive database growth so it is out of the question. Prefer to use WPML.

    Can you please advice which of the WPMUDEV's fine themes actually work with WPML?

    Regards,
    - Ossi

  • ossiman

    Hi

    Unfortunately the website we are currently building is intended for production and we cannot keep on trying different combinations to find out the problem. You see, when the database exceeds the limit, our service provider shuts us down and our site development process halts. Believe me, I would love to sort out the problem and play around with WP Globus. But we simply lack the resources.

    Multisite is totally overkill solution for simple need to translate just website text to different languages. So unfortunately we have to build our website without Upfront. This is not an ideal solution since I really like Upfront and it would be great asset.

    May I suggest that you would implement a simple WPMU Translate plugin that would allow different language versions of posts, articles and menus.

    Regards,
    - Ossi