frequent Database connection errors

  • Resolved Lazymaze20

    (@lazymaze20)


    7 years ago

    Hi,

    since a Database Migration I have frequent Database connection issues and three different error messages apperaring on screen.
    My hoster gave me the information that the Plugin is creating a lot of Database roundtrips and thus fills up the SQL server cache resulting in the connection issues.

    In order to pevent this I switched the Plugin off. I would like to clean the database from any residues in order to setup the test configuration new.

    Which are actually the DB Tables to clean? I identified the following:

    wp_t_computed_variables
    wp_t_fields
    wp_t_field_values
    wp_t_formulas
    wp_t_passings
    wp_t_passing_answers
    wp_t_questions
    wp_t_schema_migrations
    wp_t_scores
    wp_t_sections

    Thank you. Best regards

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Plugin Contributor ustimenko

    (@ustimenko)

    You can just deactivate and delete plugin thourhg Plugins page. It should clean up after itself.

    But actually these tables with wp_t_ prefix are plugin’s tables.

    Regarding connection issues. You can try to research is your hoster supports persistent connections. May be this is one possible reason.

    Plugin is creating a lot of Database roundtrips and thus fills up the SQL server cache resulting in the connection issues.

    You can just use some WP cache plugins to avoid DB requests when it’s not needed.

    For example when you create /test/blabla/, you actually should cache it for all GET requests. Same is for any /test/blabla/dsa6sda6d6asd6as78d6/ like results pages.

    WP cache or nginx cache should cache all GET requests — it’s ok.

Viewing 1 replies (of 1 total)
  • The topic ‘frequent Database connection errors’ is closed to new replies.