#hubzilla #performance #database

sss

# Time: 220917  4:40:21
# User@Host: hubzilla[hubzilla] @ localhost [127.0.0.1]
# Thread_id: 4061083  Schema: hubzilla  QC_hit: No
# Query_time: 10.084959  Lock_time: 0.000071  Rows_sent: 0  Rows_examined: 1
# Rows_affected: 1  Bytes_sent: 52
SET timestamp=1663378821;
UPDATE session
            SET sess_data = 'return_url|s:56:\"~sss?page=2page=6page=1page=5page=1/?cat=sysadmin&page=3\";loadtime|s:19:\"2022-09-17 01:40:11\";channels_visited|a:1:{i:0;s:1:\"3\";}login_return_url|s:56:\"~sss?page=2page=6page=1page=5page=1/?cat=sysadmin&page=3\";', expire = '1663379111' WHERE sid = 'pnf6imai6dbh8lo4v0h316140i';
# Time: 220918  4:45:31
# User@Host: hubzilla[hubzilla] @ localhost [127.0.0.1]
# Thread_id: 4090438  Schema: hubzilla  QC_hit: No
# Query_time: 300.154981  Lock_time: 0.000157  Rows_sent: 1  Rows_examined: 630542
# Rows_affected: 0  Bytes_sent: 65
SET timestamp=1663465531;
SELECT count(id) as total FROM item
            WHERE uid = 3 and item_unseen = 1 AND item_wall = 0 AND item_private IN (0, 1)
            AND obj_type NOT IN ('Document', 'Video', 'Audio', 'Image')
            AND author_xchan != 'NijQxJmtlpSM5Dgmm10wh6Vu7CaLKdw9jm7ywYPX8iR1_5AKLcZRVRHAEOJlfgOfTfi2o-dOd9WWlA9sGcITBg'
            and item.item_hidden = 0 and item.item_type = 0 and item.item_deleted = 0
        and item.item_unpublished = 0 and item.item_delayed = 0 and item.item_pending_remove = 0
        and item.item_blocked = 0;
# User@Host: hubzilla[hubzilla] @ localhost [127.0.0.1]
# Thread_id: 4090502  Schema: hubzilla  QC_hit: No
# Query_time: 248.794053  Lock_time: 0.000125  Rows_sent: 1  Rows_examined: 630542
# Rows_affected: 0  Bytes_sent: 65
SET timestamp=1663465531;
SELECT count(id) as total FROM item
            WHERE uid = 3 and item_unseen = 1 AND item_wall = 0 AND item_private IN (0, 1)
            AND obj_type NOT IN ('Document', 'Video', 'Audio', 'Image')
            AND author_xchan != 'NijQxJmtlpSM5Dgmm10wh6Vu7CaLKdw9jm7ywYPX8iR1_5AKLcZRVRHAEOJlfgOfTfi2o-dOd9WWlA9sGcITBg'
            and item.item_hidden = 0 and item.item_type = 0 and item.item_deleted = 0
        and item.item_unpublished = 0 and item.item_delayed = 0 and item.item_pending_remove = 0
        and item.item_blocked = 0;
# Time: 220918  4:49:45
# User@Host: hubzilla[hubzilla] @ localhost [127.0.0.1]
# Thread_id: 4090641  Schema: hubzilla  QC_hit: No
# Query_time: 242.768878  Lock_time: 0.000129  Rows_sent: 1  Rows_examined: 630542
# Rows_affected: 0  Bytes_sent: 65
SET timestamp=1663465785;
SELECT count(id) as total FROM item
            WHERE uid = 3 and item_unseen = 1 AND item_wall = 0 AND item_private IN (0, 1)
            AND obj_type NOT IN ('Document', 'Video', 'Audio', 'Image')
            AND author_xchan != 'NijQxJmtlpSM5Dgmm10wh6Vu7CaLKdw9jm7ywYPX8iR1_5AKLcZRVRHAEOJlfgOfTfi2o-dOd9WWlA9sGcITBg'
            and item.item_hidden = 0 and item.item_type = 0 and item.item_deleted = 0
        and item.item_unpublished = 0 and item.item_delayed = 0 and item.item_pending_remove = 0
        and item.item_blocked = 0;
# User@Host: hubzilla[hubzilla] @ localhost [127.0.0.1]
# Thread_id: 4090650  Schema: hubzilla  QC_hit: No
# Query_time: 236.192593  Lock_time: 0.000170  Rows_sent: 1  Rows_examined: 630542
# Rows_affected: 0  Bytes_sent: 65
SET timestamp=1663465785;
SELECT count(id) as total FROM item
            WHERE uid = 3 and item_unseen = 1 AND item_wall = 0 AND item_private IN (0, 1)
            AND obj_type NOT IN ('Document', 'Video', 'Audio', 'Image')
            AND author_xchan != 'NijQxJmtlpSM5Dgmm10wh6Vu7CaLKdw9jm7ywYPX8iR1_5AKLcZRVRHAEOJlfgOfTfi2o-dOd9WWlA9sGcITBg'
            and item.item_hidden = 0 and item.item_type = 0 and item.item_deleted = 0
        and item.item_unpublished = 0 and item.item_delayed = 0 and item.item_pending_remove = 0
        and item.item_blocked = 0;
# Time: 220918  4:50:29
# User@Host: hubzilla[hubzilla] @ localhost [127.0.0.1]
# Thread_id: 4090854  Schema: hubzilla  QC_hit: No
# Query_time: 16.900736  Lock_time: 0.000166  Rows_sent: 1  Rows_examined: 16473
# Rows_affected: 0  Bytes_sent: 4841
SET timestamp=1663465829;
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.dark-alexandr.net' AND
                    hubloc_updated > '2022-08-19 01:50:12' AND
                    hubloc_primary = 1 AND hubloc_deleted = 0 AND
                    site_dead = 0
                    ORDER BY RAND() LIMIT 1;
# Time: 220918  4:52:29
# User@Host: hubzilla[hubzilla] @ localhost [127.0.0.1]
# Thread_id: 4090830  Schema: hubzilla  QC_hit: No
# Query_time: 170.620374  Lock_time: 0.000132  Rows_sent: 1  Rows_examined: 630542
# Rows_affected: 0  Bytes_sent: 65
SET timestamp=1663465949;
SELECT count(id) as total FROM item
            WHERE uid = 3 and item_unseen = 1 AND item_wall = 0 AND item_private IN (0, 1)
            AND obj_type NOT IN ('Document', 'Video', 'Audio', 'Image')
            AND author_xchan != 'NijQxJmtlpSM5Dgmm10wh6Vu7CaLKdw9jm7ywYPX8iR1_5AKLcZRVRHAEOJlfgOfTfi2o-dOd9WWlA9sGcITBg'
            and item.item_hidden = 0 and item.item_type = 0 and item.item_deleted = 0
        and item.item_unpublished = 0 and item.item_delayed = 0 and item.item_pending_remove = 0
        and item.item_blocked = 0;
# User@Host: hubzilla[hubzilla] @ localhost [127.0.0.1]
# Thread_id: 4090723  Schema: hubzilla  QC_hit: No
# Query_time: 211.584902  Lock_time: 0.000131  Rows_sent: 1  Rows_examined: 630542
# Rows_affected: 0  Bytes_sent: 65
SET timestamp=1663465949;
SELECT count(id) as total FROM item
            WHERE uid = 3 and item_unseen = 1 AND item_wall = 0 AND item_private IN (0, 1)
            AND obj_type NOT IN ('Document', 'Video', 'Audio', 'Image')
            AND author_xchan != 'NijQxJmtlpSM5Dgmm10wh6Vu7CaLKdw9jm7ywYPX8iR1_5AKLcZRVRHAEOJlfgOfTfi2o-dOd9WWlA9sGcITBg'
            and item.item_hidden = 0 and item.item_type = 0 and item.item_deleted = 0
        and item.item_unpublished = 0 and item.item_delayed = 0 and item.item_pending_remove = 0
        and item.item_blocked = 0;
# User@Host: hubzilla[hubzilla] @ localhost [127.0.0.1]
# Thread_id: 4090805  Schema: hubzilla  QC_hit: No
# Query_time: 200.903337  Lock_time: 0.000110  Rows_sent: 1  Rows_examined: 630542
# Rows_affected: 0  Bytes_sent: 65
SET timestamp=1663465949;
SELECT count(id) as total FROM item
            WHERE uid = 3 and item_unseen = 1 AND item_wall = 0 AND item_private IN (0, 1)
            AND obj_type NOT IN ('Document', 'Video', 'Audio', 'Image')
            AND author_xchan != 'NijQxJmtlpSM5Dgmm10wh6Vu7CaLKdw9jm7ywYPX8iR1_5AKLcZRVRHAEOJlfgOfTfi2o-dOd9WWlA9sGcITBg'
            and item.item_hidden = 0 and item.item_type = 0 and item.item_deleted = 0
        and item.item_unpublished = 0 and item.item_delayed = 0 and item.item_pending_remove = 0
        and item.item_blocked = 0;
# User@Host: hubzilla[hubzilla] @ localhost [127.0.0.1]
# Thread_id: 4090761  Schema: hubzilla  QC_hit: No
# Query_time: 210.837949  Lock_time: 0.000091  Rows_sent: 1  Rows_examined: 630542
# Rows_affected: 0  Bytes_sent: 65
SET timestamp=1663465949;
SELECT count(id) as total FROM item
            WHERE uid = 3 and item_unseen = 1 AND item_wall = 0 AND item_private IN (0, 1)
            AND obj_type NOT IN ('Document', 'Video', 'Audio', 'Image')
            AND author_xchan != 'NijQxJmtlpSM5Dgmm10wh6Vu7CaLKdw9jm7ywYPX8iR1_5AKLcZRVRHAEOJlfgOfTfi2o-dOd9WWlA9sGcITBg'
            and item.item_hidden = 0 and item.item_type = 0 and item.item_deleted = 0
        and item.item_unpublished = 0 and item.item_delayed = 0 and item.item_pending_remove = 0
        and item.item_blocked = 0;
# Time: 220918  4:56:41
# User@Host: hubzilla[hubzilla] @ localhost [127.0.0.1]
# Thread_id: 4090976  Schema: hubzilla  QC_hit: No
# Query_time: 159.962483  Lock_time: 0.000153  Rows_sent: 1  Rows_examined: 630543
# Rows_affected: 0  Bytes_sent: 65
SET timestamp=1663466201;
SELECT count(id) as total FROM item
            WHERE uid = 3 and item_unseen = 1 AND item_wall = 0 AND item_private IN (0, 1)
            AND obj_type NOT IN ('Document', 'Video', 'Audio', 'Image')
            AND author_xchan != 'NijQxJmtlpSM5Dgmm10wh6Vu7CaLKdw9jm7ywYPX8iR1_5AKLcZRVRHAEOJlfgOfTfi2o-dOd9WWlA9sGcITBg'
            and item.item_hidden = 0 and item.item_type = 0 and item.item_deleted = 0
        and item.item_unpublished = 0 and item.item_delayed = 0 and item.item_pending_remove = 0
        and item.item_blocked = 0;
# User@Host: hubzilla[hubzilla] @ localhost [127.0.0.1]
# Thread_id: 4090972  Schema: hubzilla  QC_hit: No
# Query_time: 163.580866  Lock_time: 0.000126  Rows_sent: 1  Rows_examined: 630543
# Rows_affected: 0  Bytes_sent: 65
SET timestamp=1663466201;
SELECT count(id) as total FROM item
            WHERE uid = 3 and item_unseen = 1 AND item_wall = 0 AND item_private IN (0, 1)
            AND obj_type NOT IN ('Document', 'Video', 'Audio', 'Image')
            AND author_xchan != 'NijQxJmtlpSM5Dgmm10wh6Vu7CaLKdw9jm7ywYPX8iR1_5AKLcZRVRHAEOJlfgOfTfi2o-dOd9WWlA9sGcITBg'
            and item.item_hidden = 0 and item.item_type = 0 and item.item_deleted = 0
        and item.item_unpublished = 0 and item.item_delayed = 0 and item.item_pending_remove = 0
        and item.item_blocked = 0;
# Time: 220918  5:00:17
# User@Host: hubzilla[hubzilla] @ localhost [127.0.0.1]
# Thread_id: 4091093  Schema: hubzilla  QC_hit: No
# Query_time: 10.331611  Lock_time: 0.000215  Rows_sent: 1  Rows_examined: 16474
# Rows_affected: 0  Bytes_sent: 4888
SET timestamp=1663466417;
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.dark-alexandr.net' AND
                    hubloc_updated > '2022-08-19 02:00:07' AND
                    hubloc_primary = 1 AND hubloc_deleted = 0 AND
                    site_dead = 0
                    ORDER BY RAND() LIMIT 1;
# Time: 220918  6:12:02
# User@Host: hubzilla[hubzilla] @ localhost [127.0.0.1]
# Thread_id: 4092436  Schema: hubzilla  QC_hit: No
# Query_time: 66.368637  Lock_time: 0.000120  Rows_sent: 14009  Rows_examined: 28066
# Rows_affected: 0  Bytes_sent: 166372
SET timestamp=1663470722;
select parent from item left join term on term.oid = item.id where term.ttype in (1, 10) and term.term like 'linux' and term.uid = 3 and term.otype = 1 and item.verb != 'http://activitystrea.ms/schema/1.0/update';
# Time: 220918  6:47:24
# User@Host: hubzilla[hubzilla] @ localhost [127.0.0.1]
# Thread_id: 4093729  Schema: hubzilla  QC_hit: No
# Query_time: 22.994647  Lock_time: 0.000119  Rows_sent: 6065  Rows_examined: 12132
# Rows_affected: 0  Bytes_sent: 72148
SET timestamp=1663472844;
select parent from item left join term on term.oid = item.id where term.ttype in (1, 10) and term.term like 'microsoft' and term.uid = 3 and term.otype = 1 and item.verb != 'http://activitystrea.ms/schema/1.0/update';
# Time: 220918  6:59:21
# User@Host: hubzilla[hubzilla] @ localhost [127.0.0.1]
# Thread_id: 4094113  Schema: hubzilla  QC_hit: No
# Query_time: 19.970171  Lock_time: 0.000171  Rows_sent: 4408  Rows_examined: 8827
# Rows_affected: 0  Bytes_sent: 52584
SET timestamp=1663473561;
select parent from item left join term on term.oid = item.id where term.ttype in (1, 10) and term.term like 'security' and term.uid = 3 and term.otype = 1 and item.verb != 'http://activitystrea.ms/schema/1.0/update';
# Time: 220918  9:34:13
# User@Host: hubzilla[hubzilla] @ localhost [127.0.0.1]
# Thread_id: 4097018  Schema: hubzilla  QC_hit: No
# Query_time: 203.307576  Lock_time: 0.000106  Rows_sent: 1  Rows_examined: 630632
# Rows_affected: 0  Bytes_sent: 65
SET timestamp=1663482853;
SELECT count(id) as total FROM item
            WHERE uid = 3 and item_unseen = 1 AND item_wall = 0 AND item_private IN (0, 1)
            AND obj_type NOT IN ('Document', 'Video', 'Audio', 'Image')
            AND author_xchan != 'NijQxJmtlpSM5Dgmm10wh6Vu7CaLKdw9jm7ywYPX8iR1_5AKLcZRVRHAEOJlfgOfTfi2o-dOd9WWlA9sGcITBg'
            and item.item_hidden = 0 and item.item_type = 0 and item.item_deleted = 0
        and item.item_unpublished = 0 and item.item_delayed = 0 and item.item_pending_remove = 0
        and item.item_blocked = 0;
# Time: 220918  9:36:30
# User@Host: hubzilla[hubzilla] @ localhost [127.0.0.1]
# Thread_id: 4097112  Schema: hubzilla  QC_hit: No
# Query_time: 183.119678  Lock_time: 0.000100  Rows_sent: 1  Rows_examined: 630636
# Rows_affected: 0  Bytes_sent: 65
SET timestamp=1663482990;
SELECT count(id) as total FROM item
            WHERE uid = 3 and item_unseen = 1 AND item_wall = 0 AND item_private IN (0, 1)
            AND obj_type NOT IN ('Document', 'Video', 'Audio', 'Image')
            AND author_xchan != 'NijQxJmtlpSM5Dgmm10wh6Vu7CaLKdw9jm7ywYPX8iR1_5AKLcZRVRHAEOJlfgOfTfi2o-dOd9WWlA9sGcITBg'
            and item.item_hidden = 0 and item.item_type = 0 and item.item_deleted = 0
        and item.item_unpublished = 0 and item.item_delayed = 0 and item.item_pending_remove = 0
        and item.item_blocked = 0;
# Time: 220918  9:38:11
# User@Host: hubzilla[hubzilla] @ localhost [127.0.0.1]
# Thread_id: 4097294  Schema: hubzilla  QC_hit: No
# Query_time: 47.625896  Lock_time: 0.000160  Rows_sent: 1  Rows_examined: 630638
# Rows_affected: 0  Bytes_sent: 65
SET timestamp=1663483091;
SELECT count(id) as total FROM item
            WHERE uid = 3 and item_unseen = 1 AND item_wall = 0 AND item_private IN (0, 1)
            AND obj_type NOT IN ('Document', 'Video', 'Audio', 'Image')
            AND author_xchan != 'NijQxJmtlpSM5Dgmm10wh6Vu7CaLKdw9jm7ywYPX8iR1_5AKLcZRVRHAEOJlfgOfTfi2o-dOd9WWlA9sGcITBg'
            and item.item_hidden = 0 and item.item_type = 0 and item.item_deleted = 0
        and item.item_unpublished = 0 and item.item_delayed = 0 and item.item_pending_remove = 0
        and item.item_blocked = 0;
# User@Host: hubzilla[hubzilla] @ localhost [127.0.0.1]
# Thread_id: 4097265  Schema: hubzilla  QC_hit: No
# Query_time: 73.013777  Lock_time: 0.000097  Rows_sent: 1  Rows_examined: 630638
# Rows_affected: 0  Bytes_sent: 65
SET timestamp=1663483091;
SELECT count(id) as total FROM item
            WHERE uid = 3 and item_unseen = 1 AND item_wall = 0 AND item_private IN (0, 1)
            AND obj_type NOT IN ('Document', 'Video', 'Audio', 'Image')
            AND author_xchan != 'NijQxJmtlpSM5Dgmm10wh6Vu7CaLKdw9jm7ywYPX8iR1_5AKLcZRVRHAEOJlfgOfTfi2o-dOd9WWlA9sGcITBg'
            and item.item_hidden = 0 and item.item_type = 0 and item.item_deleted = 0
        and item.item_unpublished = 0 and item.item_delayed = 0 and item.item_pending_remove = 0
        and item.item_blocked = 0;
# User@Host: hubzilla[hubzilla] @ localhost [127.0.0.1]
# Thread_id: 4097189  Schema: hubzilla  QC_hit: No
# Query_time: 106.803546  Lock_time: 0.000109  Rows_sent: 1  Rows_examined: 630638
# Rows_affected: 0  Bytes_sent: 65
SET timestamp=1663483091;
SELECT count(id) as total FROM item
            WHERE uid = 3 and item_unseen = 1 AND item_wall = 0 AND item_private IN (0, 1)
            AND obj_type NOT IN ('Document', 'Video', 'Audio', 'Image')
            AND author_xchan != 'NijQxJmtlpSM5Dgmm10wh6Vu7CaLKdw9jm7ywYPX8iR1_5AKLcZRVRHAEOJlfgOfTfi2o-dOd9WWlA9sGcITBg'
            and item.item_hidden = 0 and item.item_type = 0 and item.item_deleted = 0
        and item.item_unpublished = 0 and item.item_delayed = 0 and item.item_pending_remove = 0
        and item.item_blocked = 0;
# User@Host: hubzilla[hubzilla] @ localhost [127.0.0.1]
# Thread_id: 4097221  Schema: hubzilla  QC_hit: No
# Query_time: 83.498403  Lock_time: 0.000103  Rows_sent: 1  Rows_examined: 630638
# Rows_affected: 0  Bytes_sent: 65
SET timestamp=1663483091;
SELECT count(id) as total FROM item
            WHERE uid = 3 and item_unseen = 1 AND item_wall = 0 AND item_private IN (0, 1)
            AND obj_type NOT IN ('Document', 'Video', 'Audio', 'Image')
            AND author_xchan != 'NijQxJmtlpSM5Dgmm10wh6Vu7CaLKdw9jm7ywYPX8iR1_5AKLcZRVRHAEOJlfgOfTfi2o-dOd9WWlA9sGcITBg'
            and item.item_hidden = 0 and item.item_type = 0 and item.item_deleted = 0
        and item.item_unpublished = 0 and item.item_delayed = 0 and item.item_pending_remove = 0
        and item.item_blocked = 0;

# Time: 220917 4:40:21 # User@Host: hubzilla[hubzilla] @ localhost [127.0.0.1] # Thread_id: 4061083 Schema: hubzilla QC_hit: No # Query_time: 10.084959 Lock_time: 0.000071 Rows_sent: 0 Rows_examined: 1 # Rows_affected: 1 Bytes_sent: 52 SET timestamp=1663378821; UPDATE session SET sess_data = 'return_url|s:56:\"~sss?page=2page=6page=1page=5page=1/?cat=sysadmin&page=3\";loadtime|s:19:\"2022-09-17 01:40:11\";channels_visited|a:1:{i:0;s:1:\"3\";}login_return_url|s:56:\"~sss?page=2page=6page=1page=5page=1/?cat=sysadmin&...

Expand text...

18 Sep 2022 at 6:41 | Open on pleroma.dark-alexandr.net