Forum Activity for @claygordon

Deleting unused modules and deprecated versions of modules

Installation and Configuration

I am still struggling with what is causing creeping disk usage – about 1GB/hr from somewhere after a bare metal reinstall.

I have a partially installed (missing some dependencies) version of Site Builder that is deactivated. I assume I can delete it?

In 2015 I used the Ning Import module. Do I still need it? Ning Notes?

I am no longer using Google Analytics (now using Fathom). Can I disable it? Is it possible to delete?

I have deleted FoxyCart so I assume I can delete Merchandise, correct?

I am having trouble retrieving the YouTube API key –
Youtube module API key is not retreiving info, check API at Youtube
Nothing has changed for two years
updated by @claygordon: 08/04/24 11:02:25AM

Suddenly very slow performance – SLOOOOOW database performace

Installation and Configuration

Brian -

I am monitoring disk space through the dashboard and it is slowly creeping up. 500mb increase in about 30 minutes.

The only logging activity is CRItical. All other logging is turned off.
There is one queue worker: ten_minute_maintenance

Suddenly very slow performance – SLOOOOOW database performace

Installation and Configuration

Brian - sent. However, once the disk filled again the system was unreachable.

We ended up doing a complete backup from the terminal, downloaded everything, wiped the disk, and then did a reinstall. Things appear to be looking good and the response is very fast.

However, I did notice some critical errors in the activity log. I am not sure if these are a remnant of something from the install.

Suddenly very slow performance – SLOOOOOW database performace

Installation and Configuration

Can I send you credentials to the support email? There is still an account for you – I need to refresh the password.

Suddenly very slow performance – SLOOOOOW database performace

Installation and Configuration

Also see attached

Suddenly very slow performance – SLOOOOOW database performace

Installation and Configuration

I have turned off slow query logging and query logging but they are still being logged.

developer: slow query took 422ms

Suddenly very slow performance – SLOOOOOW database performace

Installation and Configuration

Brian:

The slow query log is disabled. I don’t think it has ever been set to a time.

I will get the admin log and email it to you.

Thanks!

Suddenly very slow performance – SLOOOOOW database performace

Installation and Configuration

I don’t know how many pages there are in the Activity Log there is no indicator – just the number of posts/page – but there appear to be LOTS of pages in the activity log. 100GB in a week?

Suddenly very slow performance – SLOOOOOW database performace

Installation and Configuration

Many developer: slow query took
core: 404 Page not found: that look to be spiders (favicon.ico e.g.)

The debug log is not that huge but there is this:


ACP
Dashboard
Users Online
Pending
Activity Log
Data Browser
Recycle Bin
Queue Viewer
MailGun
Activity Log
Debug Log
Error Log
Debug Log

(2024-04-29T15:24:03-06:00.0.40908500 : 0.036)-(mem: 4MB)-(pid: 3213661)-(ip: 51.222.253.3)-(sid: vri82g7q5npe7iudedn3djhilj)-(url: https://archive.thechocolatelife.com/angela-pettypiece/timeline/3219)
|core: recursive module trigger detected for jrCore/db_get_item|

and this:
(2024-04-29T15:24:03-06:00.0.40908500 : 0.036)-(mem: 4MB)-(pid: 3213661)-(ip: 51.222.253.3)-(sid: vri82g7q5npe7iudedn3djhilj)-(url: https://archive.thechocolatelife.com/angela-pettypiece/timeline/3219)
Array
(
[event] => db_get_item
[module] => jrCore
[trace] => Array

And this one

(2024-04-30T21:07:54-06:00.0.75795900 : 0.03)-(mem: 2MB)-(pid: 3912950)-(ip: 52.14.8.34)-(sid: g4kpt4f0880q8qu4svmeifhk9q)-(url: https://archive.thechocolatelife.com/jack-meyer/timeline/514)

With hundreds of lines after this – but not a huge file.

Suddenly very slow performance – SLOOOOOW database performace

Installation and Configuration

Oops - forgot this screenshot. The DB is now 149GB. Did I flip a toggle somehow?