It looks like taxonomy queries (
include/taxonomy.php) are works extra slow after latest MySQL 8.0.17 update.
As result no /pubstream displayed because of timeout.
In previous versions I never see this issue. The only change I can suspect is
The SQL_CALC_FOUND_ROWS query modifier and accompanying FOUND_ROWS() function are now deprecated and will be removed in a future MySQL version. As a replacement, considering executing your query with LIMIT, and then a second query with COUNT(*) and without LIMIT to determine whether there are additional rows. For example, instead of these queries:
SELECT SQL_CALC_FOUND_ROWS * FROM tbl_name WHERE id > 100 LIMIT 10;
SELECT FOUND_ROWS();
Use these queries instead:
SELECT * FROM tbl_name WHERE id > 100 LIMIT 10;
SELECT COUNT(*) WHERE id > 100;
COUNT(*) is subject to certain optimizations. SQL_CALC_FOUND_ROWS causes some optimizations to be disabled.
I have temporary disabled pub_tagadelic() call but definitely we need to find a better solution.
!
Zotlabs|Hubzilla Development
