Posts by FishtankMike

Hi,

So I have a perch install trying to update the blog posts (see attached image)

The sheer amount of posts it has to get through is killing the server it is on and cannot complete the update.

Is there an SQL query I can do to do the update manually?

Unsure about the files uploaded but i've screenshot a few of the heavy table in the database (attached) if that helps. I can say that the reseources filder when its zipped up is over 10GB in size so there is a lot of physical files.

The site is filling up the server /tmp folder with .MAD files which then kills the server - screenshot attached

I'm told that they are created when INSERT and/or UPDATE queries are called to the database but sure that shouldn't happen with perch by just people visiting the site??

Hi,

So I have Perch runway site and as soon as the site has any kind of traffic ( like just 20 people ) the site completely dies.

The server spec is ample:

12 Core

12GB Ram

500GB HDD

The server tech people are telling me that the code and/or database of Perch is filling up the /var/tmp folder on the server to capacity and crashing it.

I really need some help!!

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.

Hi,

Here is my perch diagnostics:

My client has reported to me that he is trying to create a blog post but when he saves/publishes it - the content doesn't save. In some cases only there is some content saved but 90% of it just goes missing.

All the content is saved fine when in draft mode but as soon as its published the content goes missing??!

I have checked the error logs and found this...

Can anyone help?