| 1099 | hubzilla_user | localhost:44742 | hubzilla_db_27 | Execute | 73 | Sending data | select id, parent from item where (owner_xchan = 'https://relay.fedi.buzz/tag/news' or author_xchan = 'https://relay.fedi.buzz/tag/news') and uid = 2 and item_retained = 0 and item_starred = 0 | 1119 | hubzilla_user | localhost:49532 | db_XXXXXXXX| Execute | 63 | Sending data | SELECT item.parent AS item_id, item.verb, created FROM item LEFT JOIN abook ON (item.author_xchan = abook.abook_xchan and abook.abook_channel = 2 ) WHERE item.uid = 2 AND item.item_thread_top = 1 AND item.id = item.parent AND (abook.abook_blocked = 0 or abook.abook_flags is null) AND item.item_wall = 1 and item.item_hidden = 0 and item.item_type = 0 and item.item_deleted = 0 and item.item_unpublished = 0 and item.item_pending_remove = 0 and item.item_blocked = 0 and item.item_delayed = 0 AND item.item_private = 0 ORDER BY created DESC LIMIT 10 OFFSET 0 | 0.000 | | 1121 | hubzilla_user | localhost:49548 | db_XXXXXXXX | Execute | 62 | Sending data | SELECT item.parent AS item_id, item.verb, created FROM item LEFT JOIN abook ON (item.author_xchan = abook.abook_xchan and abook.abook_channel = 2 ) WHERE item.uid = 2 AND item.item_thread_top = 1 AND item.id = item.parent AND (abook.abook_blocked = 0 or abook.abook_flags is null) AND item.item_wall = 1 and item.item_hidden = 0 and item.item_type = 0 and item.item_deleted = 0 and item.item_unpublished = 0 and item.item_pending_remove = 0 and item.item_blocked = 0 and item.item_delayed = 0 AND item.item_private = 0 ORDER BY created DESC LIMIT 10 OFFSET 0 | 0.000 | | 1162 | hubzilla_user | localhost:59544 | db_XXXXXXXX | Execute | 32 | Sending data | SELECT item.parent AS item_id, item.verb, created FROM item LEFT JOIN abook ON (item.author_xchan = abook.abook_xchan and abook.abook_channel = 2 ) WHERE item.uid = 2 AND item.item_thread_top = 1 AND item.id = item.parent AND (abook.abook_blocked = 0 or abook.abook_flags is null) AND item.item_wall = 1 and item.item_hidden = 0 and item.item_type = 0 and item.item_deleted = 0 and item.item_unpublished = 0 and item.item_pending_remove = 0 and item.item_blocked = 0 and item.item_delayed = 0 AND item.item_private = 0 | 1190 | db_userxxxxx | localhost:38340 | hubzilla_db_27 | Execute | 0 | Sending data | SELECT item.parent AS item_id, item.verb, created FROM item LEFT JOIN abook ON (item.author_xchan = abook.abook_xchan and abook.abook_channel = 2 ) WHERE item.uid = 2 AND item.item_thread_top = 1 AND item.id = item.parent AND (abook.abook_blocked = 0 or abook.abook_flags is null) AND item.item_wall = 1 and item.item_hidden = 0 and item.item_type = 0 and item.item_deleted = 0 and item.item_unpublished = 0 and item.item_pending_remove = 0 and item.item_blocked = 0 and item.item_delayed = 0 AND item.item_private = 0 ORDER BY created DESC LIMIT 10 OFFSET 0 | 0.000 | +------+---------------+-----------------+----------------+---------+------+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+ # anderer Eintrag | 1099 | hubzilla_user | localhost:44742 | hubzilla_db_27 | Execute | 73 | Sending data | select id, parent from item where (owner_xchan = 'https://relay.fedi.buzz/tag/news' or author_xchan = 'https://relay.fedi.buzz/tag/news') and uid = 2 and item_retained = 0 and item_starred = 0 | 0.000 | # anderer Eintrag SELECT COUNT(*) -> FROM item -> WHERE (owner_xchan = 'https://relay.fedi.buzz/tag/news' -> OR author_xchan = 'https://relay.fedi.buzz/tag/news') -> AND uid = 2 -> AND item_retained = 0 -> AND item_starred = 0; ERROR 2006 (HY000): Server has gone away No connection. Trying to reconnect... Connection id: 1125 Current database: hubzilla_db_27 # anderer Eintrag EXPLAIN -> SELECT id, parent -> FROM item -> WHERE (owner_xchan = 'https://relay.fedi.buzz/tag/news' -> OR author_xchan = 'https://relay.fedi.buzz/tag/news') -> AND uid = 2 -> AND item_retained = 0 -> AND item_starred = 0; +------+-------------+-------+-------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------+---------+------+--------+----------------------------------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +------+-------------+-------+-------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------+---------+------+--------+----------------------------------------------------+ | 1 | SIMPLE | item | index_merge | uid_commented,uid_created,uid_item_unseen,uid_item_type,uid_item_thread_top,uid_item_blocked,uid_item_wall,uid_item_starred,uid_item_retained,uid_item_private,uid_resource_type,owner_xchan,author_xchan,uid_mid | owner_xchan,author_xchan | 764,764 | NULL | 175545 | Using union(owner_xchan,author_xchan); Using where | +------+-------------+-------+-------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------+---------+------+--------+----------------------------------------------------+ 1 row in set (0,010 sec) # anderer Eintrag SELECT id, parent, author_xchan, owner_xchan, created -> FROM item -> WHERE (owner_xchan = 'https://relay.fedi.buzz/tag/news' -> OR author_xchan = 'https://relay.fedi.buzz/tag/news') -> AND uid = 2 -> AND item_retained = 0 -> AND item_starred = 0 -> LIMIT 20; +----------+----------+----------------------------------+-----------------------------------------------------+---------------------+ | id | parent | author_xchan | owner_xchan | created | +----------+----------+----------------------------------+-----------------------------------------------------+---------------------+ | 5415998 | 5415997 | https://relay.fedi.buzz/tag/news | https://social.heise.de/users/heiseonline | 2025-06-23 15:48:04 | | 27471963 | 27471962 | https://relay.fedi.buzz/tag/news | https://802.3ether.net/users/news_economy | 2026-10-14 02:44:48 | | 27508418 | 27508417 | https://relay.fedi.buzz/tag/news | https://pubeurope.com/users/ro | 2026-10-14 17:09:41 | | 27519225 | 27519224 | https://relay.fedi.buzz/tag/news | https://channels.im/users/alojapan | 2026-10-14 21:48:37 | | 27519227 | 27519226 | https://relay.fedi.buzz/tag/news | https://802.3ether.net/users/news_society | 2026-10-14 21:48:49 | | 27519229 | 27519228 | https://relay.fedi.buzz/tag/news | https://802.3ether.net/users/news_society | 2026-10-14 21:48:49 | | 27519233 | 27519232 | https://relay.fedi.buzz/tag/news | https://pubeurope.com/users/ee | 2026-10-14 21:48:54 | | 27519235 | 27519234 | https://relay.fedi.buzz/tag/news | https://pubeurope.com/users/us | 2026-10-14 21:48:56 | | 27519241 | 27519239 | https://relay.fedi.buzz/tag/news | https://pubeurope.com/users/cz | 2026-10-14 21:49:02 | | 27519245 | 27519244 | https://relay.fedi.buzz/tag/news | https://pubeurope.com/users/es | 2026-10-14 21:49:11 | | 27519254 | 27519253 | https://relay.fedi.buzz/tag/news | https://pubeurope.com/users/lv | 2026-10-14 21:49:38 | | 27519256 | 27519255 | https://relay.fedi.buzz/tag/news | https://pubeurope.com/users/videos | 2026-10-14 21:49:58 | | 27519260 | 27519257 | https://relay.fedi.buzz/tag/news | https://pubeurope.com/users/no | 2026-10-14 21:49:58 | | 27519263 | 27519262 | https://relay.fedi.buzz/tag/news | https://pubeurope.com/users/us | 2026-10-14 21:49:58 | | 27519274 | 27519273 | https://relay.fedi.buzz/tag/news | https://pubeurope.com/users/ie | 2026-10-14 21:50:09 | | 27519278 | 27519277 | https://relay.fedi.buzz/tag/news | https://pubeurope.com/users/lt | 2026-10-14 21:50:15 | | 27519280 | 27519279 | https://relay.fedi.buzz/tag/news | https://social.heise.de/users/heiseautos | 2026-10-14 21:50:17 | | 27519285 | 27519284 | https://relay.fedi.buzz/tag/news | https://heads.social/users/AntiracistHippie | 2026-10-14 21:50:23 | | 27519289 | 27519288 | https://relay.fedi.buzz/tag/news | https://mastodon.social/ap/users/116701981151890111 | 2026-10-14 21:50:29 | | 27519291 | 27519290 | https://relay.fedi.buzz/tag/news | https://mastodon.social/ap/users/116701981151890111 | 2026-10-14 21:50:29 | +----------+----------+----------------------------------+-----------------------------------------------------+---------------------+ 20 rows in set (0,008 sec) # anderer Eintrag SELECT MAX(created), COUNT(*) -> FROM item -> WHERE author_xchan = 'https://relay.fedi.buzz/tag/news' -> AND uid = 2; +---------------------+----------+ | MAX(created) | COUNT(*) | +---------------------+----------+ | 2026-10-23 12:54:51 | 80043 | +---------------------+----------+ 1 row in set (47,127 sec) # anderer Eintrag SHOW FULL PROCESSLIST; +------+---------------+-----------------+----------------+---------+------+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +------+---------------+-----------------+----------------+---------+------+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+ | 1003 | hubzilla_user | localhost:55214 | db_XXXXXXXX| | Sleep | 921 | | NULL | 0.000 | | 1004 | hubzilla_user | localhost:55216 | db_XXXXXXXX| | Execute | 0 | Updating | DELETE FROM item WHERE id = 27554621 | 0.000 | | 1125 | root | localhost | db_XXXXXXXX| | Query | 0 | starting | SHOW FULL PROCESSLIST | 0.000 | | 1145 | hubzilla_user | localhost:42872 | db_XXXXXXXX| | Sleep | 620 | | NULL | 0.000 | | 1197 | hubzilla_user | localhost:44180 | db_XXXXXXXX| | Execute | 815 | Sending data | SELECT item.parent AS item_id, item.verb, created FROM item LEFT JOIN abook ON (item.author_xchan = abook.abook_xchan and abook.abook_channel = 2 ) WHERE item.uid = 2 AND item.item_thread_top = 1 AND item.id = item.parent AND (abook.abook_blocked = 0 or abook.abook_flags is null) AND item.item_wall = 1 and item.item_hidden = 0 and item.item_type = 0 and item.item_deleted = 0 and item.item_unpublished = 0 and item.item_pending_remove = 0 and item.item_blocked = 0 and item.item_delayed = 0 AND item.item_private = 0 ORDER BY created DESC LIMIT 10 OFFSET 0 | 0.000 | | 1200 | hubzilla_user | localhost:44206 | db_XXXXXXXX| | Execute | 813 | Sending data | SELECT item.parent AS item_id, item.verb, created FROM item LEFT JOIN abook ON (item.author_xchan = abook.abook_xchan and abook.abook_channel = 2 ) WHERE item.uid = 2 AND item.item_thread_top = 1 AND item.id = item.parent AND (abook.abook_blocked = 0 or abook.abook_flags is null) AND item.item_wall = 1 and item.item_hidden = 0 and item.item_type = 0 and item.item_deleted = 0 and item.item_unpublished = 0 and item.item_pending_remove = 0 and item.item_blocked = 0 and item.item_delayed = 0 AND item.item_private = 0 ORDER BY created DESC LIMIT 10 OFFSET 0 | 0.000 | | 1255 | hubzilla_user | localhost:58694 | db_XXXXXXXX| | Execute | 768 | Sending data | SELECT item.parent AS item_id, item.verb, created FROM item LEFT JOIN abook ON (item.author_xchan = abook.abook_xchan and abook.abook_channel = 2 ) WHERE item.uid = 2 AND item.item_thread_top = 1 AND item.id = item.parent AND (abook.abook_blocked = 0 or abook.abook_flags is null) AND item.item_wall = 1 and item.item_hidden = 0 and item.item_type = 0 and item.item_deleted = 0 and item.item_unpublished = 0 and item.item_pending_remove = 0 and item.item_blocked = 0 and item.item_delayed = 0 AND item.item_private = 0 ORDER BY created DESC LIMIT 10 OFFSET 0 | 0.000 | | 1322 | hubzilla_user | localhost:34422 | db_XXXXXXXX| | Execute | 752 | Sending data | SELECT item.parent AS item_id, item.verb, created FROM item LEFT JOIN abook ON (item.author_xchan = abook.abook_xchan and abook.abook_channel = 2 ) WHERE item.uid = 2 AND item.item_thread_top = 1 AND item.id = item.parent AND (abook.abook_blocked = 0 or abook.abook_flags is null) AND item.item_wall = 1 and item.item_hidden = 0 and item.item_type = 0 and item.item_deleted = 0 and item.item_unpublished = 0 and item.item_pending_remove = 0 and item.item_blocked = 0 and item.item_delayed = 0 AND item.item_private = 0 ORDER BY created DESC LIMIT 10 OFFSET 0 | 0.000 | | 1332 | hubzilla_user | localhost:43784 | db_XXXXXXXX| | Sleep | 0 | | NULL | 0.000 | | 1362 | hubzilla_user | localhost:33862 | db_XXXXXXXX| | Sleep | 318 | | NULL | 0.000 | | 1367 | hubzilla_user | localhost:59642 | db_XXXXXXXX| | Prepare | 0 | starting | NULL | 0.000 | | 1470 | hubzilla_user | localhost:34110 | db_XXXXXXXX| | Execute | 165 | Sending data | SELECT item.parent AS item_id, item.verb, created FROM item LEFT JOIN abook ON (item.author_xchan = abook.abook_xchan and abook.abook_channel = 2 ) WHERE item.uid = 2 AND item.item_thread_top = 1 AND item.id = item.parent AND (abook.abook_blocked = 0 or abook.abook_flags is null) AND item.item_wall = 1 and item.item_hidden = 0 and item.item_type = 0 and item.item_deleted = 0 and item.item_unpublished = 0 and item.item_pending_remove = 0 and item.item_blocked = 0 and item.item_delayed = 0 AND item.item_private = 0 ORDER BY created DESC LIMIT 10 OFFSET 0 | 0.000 | | 1474 | hubzilla_user | localhost:40600 | db_XXXXXXXX| | Execute | 51 | Sending data | SELECT * FROM hubloc LEFT JOIN abook ON abook_xchan = hubloc_hash LEFT JOIN site ON site_url = hubloc_url WHERE hubloc_network IN ( 'zot6','activitypub' ) AND abook_xchan IS NULL AND hubloc_url != 'https://hubzilla.markusgarlichs.de' AND hubloc_updated > '2026-10-16 13:50:14' AND hubloc_primary = 1 AND hubloc_deleted = 0 AND site_dead = 0 ORDER BY RAND() LIMIT 1 | 0.000 | | 1477 | hubzilla_user | localhost:40620 | db_XXXXXXXX| | Sleep | 9 | | NULL | 0.000 | +------+---------------+-----------------+----------------+---------+------+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+ 14 rows in set (0,001 sec) # anderer Eintrag EXPLAIN -> SELECT item.parent AS item_id, item.verb, item.created -> FROM item -> LEFT JOIN abook -> ON item.author_xchan = abook.abook_xchan -> AND abook.abook_channel = 2 -> WHERE item.uid = 2 -> AND item.item_thread_top = 1 -> AND item.id = item.parent -> AND (abook.abook_blocked = 0 OR abook.abook_flags IS NULL) -> AND item.item_wall = 1 -> AND item.item_hidden = 0 -> AND item.item_type = 0 -> AND item.item_deleted = 0 -> AND item.item_unpublished = 0 -> AND item.item_pending_remove = 0 -> AND item.item_blocked = 0 -> AND item.item_delayed = 0 -> AND item.item_private = 0 -> ORDER BY item.created DESC -> LIMIT 10 OFFSET 0; +------+-------------+-------+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+---------+----------------------------------+--------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +------+-------------+-------+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+---------+----------------------------------+--------+-------------+ | 1 | SIMPLE | item | range | uid_commented,uid_created,uid_item_unseen,uid_item_type,uid_item_thread_top,uid_item_blocked,uid_item_wall,uid_item_starred,uid_item_retained,uid_item_private,uid_resource_type,uid_mid,item_wall,item_deleted_pending_remove_changed,item_pending_remove_changed | uid_created | 4 | NULL | 274071 | Using where | | 1 | SIMPLE | abook | ref | abook_channel,abook_xchan | abook_xchan | 764 | hubzilla_db_27.item.author_xchan | 1 | Using where | +------+-------------+-------+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+---------+----------------------------------+--------+-------------+ 2 rows in set (0,002 sec) # anderer Eintrag SHOW INDEX FROM item; +-------+------------+-------------------------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Ignored | +-------+------------+-------------------------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+ | item | 0 | PRIMARY | 1 | id | A | 546911 | NULL | NULL | | BTREE | | | NO | | item | 1 | uuid | 1 | uuid | A | 546911 | NULL | NULL | | BTREE | | | NO | | item | 1 | parent | 1 | parent | A | 546911 | NULL | NULL | | BTREE | | | NO | | item | 1 | created | 1 | created | A | 546911 | NULL | NULL | | BTREE | | | NO | | item | 1 | edited | 1 | edited | A | 546911 | NULL | NULL | | BTREE | | | NO | | item | 1 | received | 1 | received | A | 546911 | NULL | NULL | | BTREE | | | NO | | item | 1 | uid_commented | 1 | uid | A | 2 | NULL | NULL | | BTREE | | | NO | | item | 1 | uid_commented | 2 | commented | A | 546911 | NULL | NULL | | BTREE | | | NO | | item | 1 | uid_created | 1 | uid | A | 2 | NULL | NULL | | BTREE | | | NO | | item | 1 | uid_created | 2 | created | A | 546911 | NULL | NULL | | BTREE | | | NO | | item | 1 | uid_item_unseen | 1 | uid | A | 2 | NULL | NULL | | BTREE | | | NO | | item | 1 | uid_item_unseen | 2 | item_unseen | A | 4 | NULL | NULL | | BTREE | | | NO | | item | 1 | uid_item_type | 1 | uid | A | 2 | NULL | NULL | | BTREE | | | NO | | item | 1 | uid_item_type | 2 | item_type | A | 6 | NULL | NULL | | BTREE | | | NO | | item | 1 | uid_item_thread_top | 1 | uid | A | 2 | NULL | NULL | | BTREE | | | NO | | item | 1 | uid_item_thread_top | 2 | item_thread_top | A | 6 | NULL | NULL | | BTREE | | | NO | | item | 1 | uid_item_blocked | 1 | uid | A | 2 | NULL | NULL | | BTREE | | | NO | | item | 1 | uid_item_blocked | 2 | item_blocked | A | 2 | NULL | NULL | | BTREE | | | NO | | item | 1 | uid_item_wall | 1 | uid | A | 2 | NULL | NULL | | BTREE | | | NO | | item | 1 | uid_item_wall | 2 | item_wall | A | 4 | NULL | NULL | | BTREE | | | NO | | item | 1 | uid_item_starred | 1 | uid | A | 2 | NULL | NULL | | BTREE | | | NO | | item | 1 | uid_item_starred | 2 | item_starred | A | 4 | NULL | NULL | | BTREE | | | NO | | item | 1 | uid_item_retained | 1 | uid | A | 2 | NULL | NULL | | BTREE | | | NO | | item | 1 | uid_item_retained | 2 | item_retained | A | 6 | NULL | NULL | | BTREE | | | NO | | item | 1 | uid_item_private | 1 | uid | A | 2 | NULL | NULL | | BTREE | | | NO | | item | 1 | uid_item_private | 2 | item_private | A | 6 | NULL | NULL | | BTREE | | | NO | | item | 1 | uid_resource_type | 1 | uid | A | 2 | NULL | NULL | | BTREE | | | NO | | item | 1 | uid_resource_type | 2 | resource_type | A | 10 | NULL | NULL | | BTREE | | | NO | | item | 1 | owner_xchan | 1 | owner_xchan | A | 136727 | NULL | NULL | | BTREE | | | NO | | item | 1 | author_xchan | 1 | author_xchan | A | 78130 | NULL | NULL | | BTREE | | | NO | | item | 1 | resource_id | 1 | resource_id | A | 144 | NULL | NULL | | BTREE | | | NO | | item | 1 | resource_type | 1 | resource_type | A | 8 | NULL | NULL | | BTREE | | | NO | | item | 1 | commented | 1 | commented | A | 546911 | NULL | NULL | | BTREE | | | NO | | item | 1 | verb | 1 | verb | A | 508 | NULL | NULL | | BTREE | | | NO | | item | 1 | obj_type | 1 | obj_type | A | 724 | NULL | NULL | | BTREE | | | NO | | item | 1 | expires | 1 | expires | A | 68 | NULL | NULL | | BTREE | | | NO | | item | 1 | revision | 1 | revision | A | 2 | NULL | NULL | | BTREE | | | NO | | item | 1 | mimetype | 1 | mimetype | A | 144 | NULL | NULL | | BTREE | | | NO | | item | 1 | mid | 1 | mid | A | 546911 | NULL | NULL | | BTREE | | | NO | | item | 1 | parent_mid | 1 | parent_mid | A | 546911 | NULL | NULL | | BTREE | | | NO | | item | 1 | uid_mid | 1 | uid | A | 102 | NULL | NULL | | BTREE | | | NO | | item | 1 | uid_mid | 2 | mid | A | 546911 | NULL | NULL | | BTREE | | | NO | | item | 1 | comment_policy | 1 | comment_policy | A | 288 | NULL | NULL | | BTREE | | | NO | | item | 1 | layout_mid | 1 | layout_mid | A | 2 | NULL | NULL | | BTREE | | | NO | | item | 1 | public_policy | 1 | public_policy | A | 2 | NULL | NULL | | BTREE | | | NO | | item | 1 | comments_closed | 1 | comments_closed | A | 1166 | NULL | NULL | | BTREE | | | NO | | item | 1 | changed | 1 | changed | A | 546911 | NULL | NULL | | BTREE | | | NO | | item | 1 | item_origin | 1 | item_origin | A | 2 | NULL | NULL | | BTREE | | | NO | | item | 1 | item_wall | 1 | item_wall | A | 2 | NULL | NULL | | BTREE | | | NO | | item | 1 | item_uplink | 1 | item_uplink | A | 2 | NULL | NULL | | BTREE | | | NO | | item | 1 | item_nsfw | 1 | item_nsfw | A | 2 | NULL | NULL | | BTREE | | | NO | | item | 1 | item_mentionsme | 1 | item_mentionsme | A | 2 | NULL | NULL | | BTREE | | | NO | | item | 1 | item_nocomment | 1 | item_nocomment | A | 2 | NULL | NULL | | BTREE | | | NO | | item | 1 | item_obscured | 1 | item_obscured | A | 2 | NULL | NULL | | BTREE | | | NO | | item | 1 | item_rss | 1 | item_rss | A | 2 | NULL | NULL | | BTREE | | | NO | | item | 1 | item_consensus | 1 | item_consensus | A | 2 | NULL | NULL | | BTREE | | | NO | | item | 1 | item_deleted_pending_remove_changed | 1 | item_deleted | A | 2 | NULL | NULL | | BTREE | | | NO | | item | 1 | item_deleted_pending_remove_changed | 2 | item_pending_remove | A | 4 | NULL | NULL | | BTREE | | | NO | | item | 1 | item_deleted_pending_remove_changed | 3 | changed | A | 546911 | NULL | NULL | | BTREE | | | NO | | item | 1 | item_pending_remove_changed | 1 | item_pending_remove | A | 2 | NULL | NULL | | BTREE | | | NO | | item | 1 | item_pending_remove_changed | 2 | changed | A | 546911 | NULL | NULL | | BTREE | | | NO | | item | 1 | thr_parent | 1 | thr_parent | A | 546911 | NULL | NULL | | BTREE | | | NO | +-------+------------+-------------------------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+ 62 rows in set (0,002 sec) # anderer Eintrag ANALYZE TABLE item; ANALYZE TABLE item; +---------------------+---------+----------+----------+ | Table | Op | Msg_type | Msg_text | +---------------------+---------+----------+----------+ | hubzilla_db_27.item | analyze | status | OK | +---------------------+---------+----------+----------+ 1 row in set (3,341 sec) #anderer Eintrag EXPLAIN SELECT item.parent AS item_id, item.verb, item.created FROM item LEFT JOIN abook ON item.author_xchan = abook.abook_xchan AND abook.abook_channel = 2 WHERE item.uid = 2 AND item.item_thread_top = 1 AND item.id = item.parent AND (abook.abook_blocked = 0 OR abook.abook_flags IS NULL) AND item.item_wall = 1 AND item.item_hidden = 0 AND item.item_type = 0 AND item.item_deleted = 0 AND item.item_unpublished = 0 AND item.item_pending_remove = 0 AND item.item_blocked = 0 AND item.item_delayed = 0 AND item.item_private = 0 ORDER BY item.created DESC LIMIT 10 OFFSET 0; # anderer Eintrag EXPLAIN -> SELECT item.parent AS item_id, item.verb, item.created -> FROM item -> LEFT JOIN abook -> ON item.author_xchan = abook.abook_xchan -> AND abook.abook_channel = 2 -> WHERE item.uid = 2 -> AND item.item_thread_top = 1 -> AND item.id = item.parent -> AND (abook.abook_blocked = 0 OR abook.abook_flags IS NULL) -> AND item.item_wall = 1 -> AND item.item_hidden = 0 -> AND item.item_type = 0 -> AND item.item_deleted = 0 -> AND item.item_unpublished = 0 -> AND item.item_pending_remove = 0 -> AND item.item_blocked = 0 -> AND item.item_delayed = 0 -> AND item.item_private = 0 -> ORDER BY item.created DESC -> LIMIT 10 OFFSET 0; +------+-------------+-------+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+---------+----------------------------------+--------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +------+-------------+-------+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+---------+----------------------------------+--------+-------------+ | 1 | SIMPLE | item | range | uid_commented,uid_created,uid_item_unseen,uid_item_type,uid_item_thread_top,uid_item_blocked,uid_item_wall,uid_item_starred,uid_item_retained,uid_item_private,uid_resource_type,uid_mid,item_wall,item_deleted_pending_remove_changed,item_pending_remove_changed | uid_created | 4 | NULL | 232564 | Using where | | 1 | SIMPLE | abook | ref | abook_channel,abook_xchan | abook_xchan | 764 | hubzilla_db_27.item.author_xchan | 1 | Using where | +------+-------------+-------+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+---------+----------------------------------+--------+-------------+ 2 rows in set (0,466 sec) Keine Idee mehr..... :-(