--- Log opened sรกb abr 09 00:00:40 2022 08:15 < fikabot> ๐Ÿ’ฌ I am kinda blind today while restructuring my Friendica Instance :-) As far as I remember I always posted using @forumname to a forum and the post showd up as user via forum. the @ created a link currently to the forum, which works, but the post does not show up as via forum? Is it me or is there a bug in the current version? 09:22 < fikabot> ๐Ÿ’ฌ Karl (AT): does the exclamation point method work? E.g., !helpers 09:23 < fikabot> ๐Ÿ’ฌ nope, nor @ or ! works. both creates a link in thevpostvto the forum, but no "via" post 18:10 < fikabot> ๐Ÿ’ฌ ---------------------------+-----------+------------+ 18:10 < fikabot> ๐Ÿ’ฌ | Table | Size (MB) | TABLE_ROWS | 18:10 < fikabot> ๐Ÿ’ฌ +---------------------------+-----------+------------+ 18:10 < fikabot> ๐Ÿ’ฌ | storage | 1639 | 21389 | 18:10 < fikabot> ๐Ÿ’ฌ | conversation | 897 | 102023 | 18:10 < fikabot> ๐Ÿ’ฌ | post-content | 549 | 448334 | 18:10 < fikabot> ๐Ÿ’ฌ | post-user | 549 | 1051493 | 18:11 < fikabot> ๐Ÿ’ฌ | item-uri | 249 | 850322 | 18:11 < fikabot> ๐Ÿ’ฌ | post-media | 211 | 477791 | 18:11 < fikabot> ๐Ÿ’ฌ | contact | 197 | 82069 | 18:11 < fikabot> ๐Ÿ’ฌ | post-thread-user | 177 | 359335 | 18:11 < fikabot> ๐Ÿ’ฌ | post | 166 | 674812 | 18:11 < fikabot> ๐Ÿ’ฌ | parsed_url | 140 | 86806 | 18:11 < fikabot> ๐Ÿ’ฌ | apcontact | 132 | 56302 | 18:12 < fikabot> ๐Ÿ’ฌ | post-tag | 60 | 580213 | 18:12 < fikabot> ๐Ÿ’ฌ | post-thread | 58 | 314070 | 18:12 < fikabot> ๐Ÿ’ฌ | photo | 58 | 25008 | 18:12 < fikabot> ๐Ÿ’ฌ | gserver | 44 | 147257 | 18:12 < fikabot> ๐Ÿ’ฌ | diaspora-interaction | 20 | 12567 | 18:12 < fikabot> ๐Ÿ’ฌ | tag | 18 | 96056 | 18:12 < fikabot> ๐Ÿ’ฌ | contact-relation | 9 | 101036 | 18:12 < fikabot> ๐Ÿ’ฌ | inbox-status | 8 | 48781 | 18:12 < fikabot> ๐Ÿ’ฌ | fcontact | 4 | 3229 | 18:12 < fikabot> ๐Ÿ’ฌ | cache | 2 | 407 | 18:12 < fikabot> ๐Ÿ’ฌ | notify | 2 | 1817 | 18:12 < fikabot> ๐Ÿ’ฌ | post-link | 2 | 3707 | 18:13 < fikabot> ๐Ÿ’ฌ | workerqueue | 2 | 1429 | 18:13 < fikabot> ๐Ÿ’ฌ | post-delivery-data | 2 | 10006 | 18:13 < fikabot> ๐Ÿ’ฌ | notification | 1 | 5138 | 18:13 < fikabot> ๐Ÿ’ฌ | gserver-tag | 0 | 5439 | 18:13 < fikabot> ๐Ÿ’ฌ | mail | 0 | 157 | 18:13 < fikabot> ๐Ÿ’ฌ ``` 18:13 < fikabot> ๐Ÿ’ฌ +---------------------------+-----------+------------+ 18:13 < fikabot> ๐Ÿ’ฌ | Table | Size (MB) | TABLE\_ROWS | 18:13 < fikabot> ๐Ÿ’ฌ Besides photos what else is stored in the "storage" table? 18:13 < fikabot> ๐Ÿ’ฌ Across all photos (which I'm calculating as an inner join to the photo.bankend-ref column) I have about 208 MB of storage in the storage table but there is 1639 MB of data in it 18:14 < fikabot> ๐Ÿ’ฌ Per the comment on the Fediverse room (where I posted this first by accident): I turned off the contact/profile caching a while ago 18:14 < fikabot> ๐Ÿ’ฌ before that photos were using up almost 1.8 GB of space in the storage table 18:14 < fikabot> ๐Ÿ’ฌ But did you manage to look into what is stored there? 18:14 < fikabot> ๐Ÿ’ฌ Like, inspect the contents of 10 random rows. 18:14 < fikabot> ๐Ÿ’ฌ it's all garbage 18:16 < fikabot> ๐Ÿ’ฌ the few I looked at 18:16 < fikabot> ๐Ÿ’ฌ The 10 most recent ones perhaps? 18:18 < fikabot> ๐Ÿ’ฌ theer is something odd going on though 18:18 < fikabot> ๐Ÿ’ฌ And what were those linked to in other tables? 18:18 < fikabot> ๐Ÿ’ฌ information_schema.tables.data_length for the storage table is 1638 MB 18:19 < fikabot> ๐Ÿ’ฌ Did you try to GC/optimize it? 18:20 < fikabot> ๐Ÿ’ฌ that's this command: 18:20 < fikabot> ๐Ÿ’ฌ ``` 18:21 < fikabot> ๐Ÿ’ฌ SELECT 18:21 < fikabot> ๐Ÿ’ฌ TABLE_NAME, 18:21 < fikabot> ๐Ÿ’ฌ DATA_LENGTH, 18:21 < fikabot> ๐Ÿ’ฌ INDEX_LENGTH, 18:21 < fikabot> ๐Ÿ’ฌ TABLE_ROWS 18:21 < fikabot> ๐Ÿ’ฌ FROM 18:21 < fikabot> ๐Ÿ’ฌ INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'friendicadb'; 18:21 < fikabot> ๐Ÿ’ฌ 18:21 < fikabot> ๐Ÿ’ฌ ``` 18:21 < fikabot> ๐Ÿ’ฌ but this command shows it as only 208 MB 18:22 < fikabot> ๐Ÿ’ฌ ``` 18:22 < fikabot> ๐Ÿ’ฌ SELECT 18:22 < fikabot> ๐Ÿ’ฌ SUM(octet_length(storage.data)/1024/1024) 18:22 < fikabot> ๐Ÿ’ฌ FROM storage; 18:22 < fikabot> ๐Ÿ’ฌ ``` 18:22 < fikabot> ๐Ÿ’ฌ is GC/optimize like vacuuming in Postgres? 18:22 < fikabot> ๐Ÿ’ฌ I think so. 18:24 < fikabot> ๐Ÿ’ฌ i ran the OPTIMIZE TABLE storage; command but it didn't change the size at all 18:25 < fikabot> ๐Ÿ’ฌ doing SHOW TABLE STATUS on it shows about 700 MB of unused allocated space both before and after the optimize 18:27 < fikabot> ๐Ÿ’ฌ These are also linked in the guide, not sure what they do https://github.com/BMDan/tuning-primer.sh https://raw.githubusercontent.com/major/MySQLTuner-perl/master/mysqltuner.pl 18:33 < fikabot> ๐Ÿ’ฌ By the way, you can also find a GUI option for periodically optimizing your tables. 18:34 < fikabot> ๐Ÿ’ฌ it doesn't seem to be accounting for most of the difference though 18:34 < fikabot> ๐Ÿ’ฌ do you have a comparable disparity between those two calculations in your storage table? 19:05 < fikabot> ๐Ÿ’ฌ Well purging the binary logs helped a bunch (the first drop off) then all the optimizations even though the data and free lengths in the DB didn't change. 19:05 < fikabot> ๐Ÿ’ฌ https://matrix.org/_matrix/media/v1/download/myportal.social/YUdljKnDZTNaupxvYJzWntkz 19:07 < fikabot> ๐Ÿ’ฌ I have binary log lookback set to 1 day now...I'm not doing any replication and the like anyway --- Log closed dom abr 10 00:00:42 2022