perch2_content_index 585,000+ rows?
I have a site which has been upgraded many times as a Perch site, and is now a Runway site. The DB has grown to what I would consider to be a very large size considering the content. The two largest multiple item regions have been moved to collections, one with 31 items and one with 54 items.
Here are some table row stats from the DB:
perch2_collection_index: 1,620 rows
perch2_content_index: 585,149 rows
perch2_content_items: 345 rows
perch2_content_regions: 20 rows
perch2_resource_log: 1,480,855 rows
As a result of the number of rows, it is taking a very long time to save region content, with mysql hogging CPU and locking down the site during saving.
Any idea what could be wrong here? The DB doubled in size after updating to Runway.
SUMMARY INFORMATION Perch Runway: 2.8.19, PHP: 5.6.14-1+deb.sury.org~trusty+1, MySQL: mysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $, with PDO Server OS: Linux, apache2handler Installed apps: content (2.8.19), assets (2.8.19), categories (2.8.19), perch_blog (5.0), perch_forms (1.8.3), collection_2 (2.8.19), collection_1 (2.8.19), perch_members (1.4) App runtimes: <?php $apps_list = array( 'content', 'categories', 'perch_members', 'perch_blog', 'perch_forms' ); PERCH_LOGINPATH: /easton-admin PERCH_PATH: /var/www/public/easton.dev/easton-admin PERCH_CORE: /var/www/public/easton.dev/easton-admin/core PERCH_RESFILEPATH: /var/www/public/easton.dev/easton-admin/resources Image manipulation: GD Imagick PHP limits: Max upload 100M, Max POST 100M, Memory: 128M, Total max file upload: 100M Resource folder writeable: Yes HTTP_HOST: easton.dev DOCUMENT_ROOT: /var/www/public/easton.dev REQUEST_URI: /easton-admin/core/settings/diagnostics/ SCRIPT_NAME: /easton-admin/core/settings/diagnostics/index.php
Want to reply to this thread?Login with Perch