1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Wordpress database problem. Slow queries.

Discussion in 'Hire a Freelancer' started by redim, Apr 9, 2014.

  1. redim

    redim Registered Member

    Joined:
    May 29, 2009
    Messages:
    68
    Likes Received:
    137
    Location:
    philippines
    Task:
    I am looking for someone who can:
    - Check, troubleshoot and confirm if there is a problem with the database tables of 1 wordpress install.
    - Offer solution and implement solution for the problem site and its database. Possible solution: repair and optimize database.


    - Check and optimize all other sites' database tables.


    - Offer any other solutions to improve loading times of all sites on my server.


    ** Very Important.
    The site and its database which has the problem and is causing all the other sites on the server to load slow, it is the most important site on the server. So I need to be very careful not to break the site when doing any database repairs or optimizations.


    Context:
    White screen when attempting to visit / load the site a few days ago on 1 wordpress install on a subdomain. The error screen message was like: "unable to establish connection to database." The problematic site is on a shared hosting account. And I have about 15 wordpress subdomain sites on the shared account. Those 15 subdomain wordpress sites have been functioning and loading fast for the past year. And only in the past week all sites are loading slow, and 1 site sometimes fails to load and displays the white screen error message.


    I called my host's help desk and they said that the database of 1 of the wordpress installs is causing the problem (too many or slow queries) and means that all sites are now loading slow. This could mean that the database of 1 subdomain wordpress install has a table problem and needs to be repaired and optimized.


    I started to solve the problem myself, but I am not confident with the necessary skills to implement the final solution, which I think is a repair and optimize of the problem database.


    Here is what I have done so far:
    - created a backup of the problem wordpress database;
    - created a new database and tried to import to the server, but I get error message and not all of the tables imported.


    The reason for this approach was:
    - I am cautious about running a simple repair and optimize on the problem in case I break the site.


    So, I first wanted to backup the problem database, then use myphpadmin to repair and optimize the newly created database, then repair and optimize that database, then edit the config.php file of the wordpress site to point to the imported database.


    But when I tried to import the database, I get an error message that the import did not complete and failed. For example, not all the tables imported completely.


    Please leave a reply in this thread if you are interested in this trouble-shoot and maintenance job.


    Thanks
    Leonard
     
    Last edited: Apr 9, 2014
  2. MrBlue

    MrBlue Senior Member

    Joined:
    Dec 18, 2009
    Messages:
    954
    Likes Received:
    664
    Occupation:
    Web/Bot Developer
    You should enable "slow query log" on your server. That will tell you which db request(s) are causing the bottleneck.
     
  3. redim

    redim Registered Member

    Joined:
    May 29, 2009
    Messages:
    68
    Likes Received:
    137
    Location:
    philippines
    MrBlue.

    Good tip. Thanks. I will try that now :)

    And I just checked the shared host throttling graph, and see a warning message that my account is being significantly throttled :(

    cheers
     
    Last edited: Apr 9, 2014