Really slow site. How to optimise database?

  • Hi,


    I have quite an old site running perch Runway. Its running extremely slow... nearly a minute to load!


    The server tech reports are telling me that the database is the issue.


    I have attached a screen shot of the DB in phpMyAdmin. I know there are a lot of rows in the blog index table?


    Also attached is a MySQL log which highlights a lot of the same state of "Creating sort index". Is the following thread linked to this...


    http://forum.grabaperch.com/fo…ction-loading-speed-issue


    The server technicians have told me to optimise the database but I have no idea how or where to begin?!


    Here is the perch diagnostics


    • Perch Runway: 3.0.8, PHP: 7.0.33, MySQL: mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $, with PDO
    • Server OS: Linux, cgi-fcgi
    • Installed apps: content (3.0.8), assets (3.0.8), categories (3.0.8), perch_blog (5.5.1), perch_forms (1.9.1), perch_gallery (2.8.9)
    • App runtimes: <?php $apps_list = array( 'perch_blog', 'ftc_fixtures', 'ftc_sport_radar', 'perch_gallery', 'perch_forms' );
    • PERCH_LOGINPATH: /admin
    • PERCH_PATH: /home/***/public_html/admin
    • PERCH_CORE: /home/***/public_html/admin/core
    • PERCH_RESFILEPATH: /home/****/public_html/admin/resources
    • Image manipulation: GD
    • PHP limits: Max upload 512M, Max POST 512M, Memory: 512M, Total max file upload: 512M
    • F1: 0c66c2e1f82f9e0b7617b2cb8270f2c7
    • Resource folder writeable: Yes


    Any help or hints would be amazing.

  • drewm

    Approved the thread.