• Resolved muyilleum

    (@muyilleum)


    Hi there, first my server seems to crash with high memory usage. My host said the high CPU usage is coming from mysql i.e. a query that is constantly running as shown below.

    Sending data 2182 SELECT option_name, option_value FROM wp_options WHERE autoload = ‘yes’

    When the server was restarted, in the few minutes before overloading, I noticed the site was reporting ‘Error connecting with database’ so I ran wordpress repair + optimize and got the following database problems:

    wp_users: 40 clients are using or haven’t closed the table properly
    wp_usermeta: 58 clients are using or haven’t closed the table properly
    wp_posts:
    wp_comments:
    wp_links:
    wp_options:
    wp_postmeta:
    wp_terms:
    wp_term_taxonomy:
    wp_term_relationships:
    wp_commentmeta:

    Any suggestions please?

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘Error’ is closed to new replies.