Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#11 2020-09-16 07:12:21

gaekwad
Admin
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 3,131

Re: Parse error: syntax error, unexpected 'yield' (T_YIELD),

detail wrote #325903:

One of my sites has over 1200 pages, and more than 5200 images at 1080 × 600 px.

Another is two-thirds of that.

That still feels too big to me. Images are (usually) held outside the database – I can totally see how that many images would be 6GB, but 1200 pages (plus two thirds again, and some more) of text should be way less than 6GB.

I’m curious – if you’re able to run a database query, this would show the table sizes:

SELECT 
     table_schema as `Database`, 
     table_name AS `Table`, 
     round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` 
FROM information_schema.TABLES 
ORDER BY (data_length + index_length) DESC;

Would you be able to run that on your main site and post the results, please? It’s read-only, it won’t change any data.

Offline

#12 2020-09-16 13:39:29

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 8,269
Website

Re: Parse error: syntax error, unexpected 'yield' (T_YIELD),

It does indeed sound too large. The NeMe site currently has 1582 images (plus their thumbnails) and 1921 articles, some of them very lengthy. The textpattern table is just over 33Mbs and the txp_image one is just under 199kb. Aside the plugins table which is about 2Mb (because of mostly disabled plugins) all other tables are well under 1Mb each as I have the logs expire every 2 days.

You should definitely look into it as 500Mb average/site is not very normal for txp.


Yiannis
——————————
neme.org | hblack.net | LABS | State Machines | NeMe @ github | Covid-19; a resource
I do my best editing after I click on the submit button.

Offline

#13 2020-09-16 13:52:34

etc
Developer
Registered: 2010-11-11
Posts: 3,863
Website

Re: Parse error: syntax error, unexpected 'yield' (T_YIELD),

And if indeed it comes from logs, you might want to disable them as well, nobody would notice :-)

Offline

Board footer

Powered by FluxBB