Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

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

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

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:

     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.


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

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

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.

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.


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

Registered: 2010-11-11
Posts: 3,855

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 :-)


Board footer

Powered by FluxBB