chcpu can disable and enable CPU cores online
chcpu -d 4,5,6,7,8,9,10,11,12,13,14,15
chcpu -e 4,5,6,7,8,9,10,11,12,13,14,15To disable or enable SMT / Hyperthreading online
echo off | sudo tee /sys/devices/system/cpu/smt/control
echo on | sudo tee /sys/devices/system/cpu/smt/controlOn my instance metapixl.com the alt text for post was cut of after 191 characters. 191 chars is a hint that the colum type is set to varchar(191) whis is obviouly wrong if you want to store more than 191 chars inside it. Pixelfed stores the alt text to a posted picture in a colum named caption you can check the colums and types inside the mariadb interface.
MariaDB [pixelfed]> use pixelfed;
Database changed
MariaDB [pixelfed]> SHOW COLUMNS FROM media;
+-------------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+---------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| status_id | bigint(20) unsigned | YES | MUL | NULL | |
| profile_id | bigint(20) unsigned | YES | MUL | NULL | |
| user_id | bigint(20) unsigned | YES | MUL | NULL | |
| is_nsfw | tinyint(1) | NO | | 0 | |
| remote_media | tinyint(1) | NO | MUL | 0 | |
| original_sha256 | varchar(191) | YES | MUL | NULL | |
| optimized_sha256 | varchar(191) | YES | MUL | NULL | |
| media_path | varchar(191) | NO | | NULL | |
| thumbnail_path | varchar(191) | YES | | NULL | |
| cdn_url | text | YES | | NULL | |
| optimized_url | varchar(191) | YES | | NULL | |
| thumbnail_url | varchar(191) | YES | | NULL | |
| remote_url | varchar(191) | YES | | NULL | |
| caption | varchar(191) | YES | | NULL | |
| hls_path | varchar(191) | YES | | NULL | |
| order | tinyint(3) unsigned | NO | | 1 | |
| mime | varchar(191) | YES | MUL | NULL | |
| size | int(10) unsigned | YES | | NULL | |
| orientation | varchar(191) | YES | | NULL | |
| filter_name | varchar(191) | YES | | NULL | |
| filter_class | varchar(191) | YES | | NULL | |
| license | varchar(191) | YES | MUL | NULL | |
| processed_at | timestamp | YES | | NULL | |
| hls_transcoded_at | timestamp | YES | | NULL | |
| created_at | timestamp | YES | | NULL | |
| updated_at | timestamp | YES | | NULL | |
| deleted_at | timestamp | YES | MUL | NULL | |
| key | varchar(191) | YES | | NULL | |
| metadata | longtext | YES | | NULL | |
| version | tinyint(4) | NO | MUL | 1 | |
| blurhash | varchar(191) | YES | | NULL | |
| srcset | longtext | YES | | NULL | |
| width | int(10) unsigned | YES | | NULL | |
| height | int(10) unsigned | YES | | NULL | |
| skip_optimize | tinyint(1) | YES | MUL | NULL | |
| replicated_at | timestamp | YES | MUL | NULL | |
+-------------------+---------------------+------+-----+---------+----------------+
37 rows in set (0.001 sec)As you can see the type is set to varchar(191) so I changed it to text as it should be
MariaDB [pixelfed]> ALTER TABLE media MODIFY caption text;
Query OK, 1996326 rows affected (1 min 0.749 sec)
Records: 1996326 Duplicates: 0 Warnings: 0
MariaDB [pixelfed]> SHOW COLUMNS FROM media;
+-------------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+---------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| status_id | bigint(20) unsigned | YES | MUL | NULL | |
| profile_id | bigint(20) unsigned | YES | MUL | NULL | |
| user_id | bigint(20) unsigned | YES | MUL | NULL | |
| is_nsfw | tinyint(1) | NO | | 0 | |
| remote_media | tinyint(1) | NO | MUL | 0 | |
| original_sha256 | varchar(191) | YES | MUL | NULL | |
| optimized_sha256 | varchar(191) | YES | MUL | NULL | |
| media_path | varchar(191) | NO | | NULL | |
| thumbnail_path | varchar(191) | YES | | NULL | |
| cdn_url | text | YES | | NULL | |
| optimized_url | varchar(191) | YES | | NULL | |
| thumbnail_url | varchar(191) | YES | | NULL | |
| remote_url | varchar(191) | YES | | NULL | |
| caption | text | YES | | NULL | |
| hls_path | varchar(191) | YES | | NULL | |
| order | tinyint(3) unsigned | NO | | 1 | |
| mime | varchar(191) | YES | MUL | NULL | |
| size | int(10) unsigned | YES | | NULL | |
| orientation | varchar(191) | YES | | NULL | |
| filter_name | varchar(191) | YES | | NULL | |
| filter_class | varchar(191) | YES | | NULL | |
| license | varchar(191) | YES | MUL | NULL | |
| processed_at | timestamp | YES | | NULL | |
| hls_transcoded_at | timestamp | YES | | NULL | |
| created_at | timestamp | YES | | NULL | |
| updated_at | timestamp | YES | | NULL | |
| deleted_at | timestamp | YES | MUL | NULL | |
| key | varchar(191) | YES | | NULL | |
| metadata | longtext | YES | | NULL | |
| version | tinyint(4) | NO | MUL | 1 | |
| blurhash | varchar(191) | YES | | NULL | |
| srcset | longtext | YES | | NULL | |
| width | int(10) unsigned | YES | | NULL | |
| height | int(10) unsigned | YES | | NULL | |
| skip_optimize | tinyint(1) | YES | MUL | NULL | |
| replicated_at | timestamp | YES | MUL | NULL | |
+-------------------+---------------------+------+-----+---------+----------------+
37 rows in set (0.001 sec)As you can see, the type is converted from varchar(191) to text and it’s now possible to post pictures with alt text wirth max 2000 characters (again).
Never do those things without an actual backup!
media:cloud-url-rewrite
This is a command to update S3 media urls in the database, useful for when you migrate S3 buckets or want to add a proxy in front of your S3 media.
Usage:
Run php artisan media:cloud-url-rewrite and enter the old and new S3 domains when prompted, or you can provide them as arguments like
php artisan media:cloud-url-rewrite old.pixelfed.example.org new.pixelfed.example.orgNotes:
Before you can update S3 media urls, you have to configure the new bucket and then re-cache configuration
php artisan config:cache && php artisan cache:clearbefore you run this command You need to run
php artisan cache:clearafter the command is run to purge old S3 media urls from your cache
Disable two factor authentication for given username:
php artisan user:2fa {username}Cleanup avatar storage:
php artisan avatar:storage-deep-cleanMake a user an admin, or remove admin privileges:
php artisan user:admin {username}Create an invite link:
php artisan admin:inviteFix Like counts:
php artisan fix:likesDelete (local) media uploads that exist on S3:
php artisan media:s3gc {--limit=200} {--huge} {--log-errors}Delete media uploads not attached to any active statuses:
php artisan media:gcDelete password reset tokens over 24 hours old:
php artisan gc:passwordresetCreate a new user:
php artisan user:create {--name=} {--username=} {--email=} {--password=} {--is_admin=0} {--confirm_email=0Delete account:
php artisan user:delete {id} {--force}ZSH has a simple built-in function for repeating a command n times:
repeat 5 echo "Command"
For multiple commands:
repeat 5 {echo "Command1"; echo "Command2"}
Ad S3 storage block to Pixelfed .env file
## S3 Configuration (Post-Installer) PF_ENABLE_CLOUD=true FILESYSTEM_DRIVER=local FILESYSTEM_CLOUD=s3 AWS_ACCESS_KEY_ID=[KEY_ID] AWS_SECRET_ACCESS_KEY=[KEY_SECRET] AWS_DEFAULT_REGION=[REGION] AWS_BUCKET=metapixl-media AWS_ENDPOINT=[URL_TO_S3_STORAGE] AWS_USE_PATH_STYLE_ENDPOINT=true
Enable Cloud storage in admin dashboard
Run this command to migrate media to S3 storage
php artisan media:migrate2cloud
Move avatar storage to S3 with this command
php artisan avatar:storage
Check Nodes
kubectl get nodes ➜ ~ kubectl get nodes NAME STATUS ROLES AGE VERSION master1 Ready control-plane,master 517d v1.21.5 master2 Ready control-plane,master 517d v1.21.5 master3 Ready control-plane,master 517d v1.21.5 worker1 Ready worker 517d v1.21.5 worker2 Ready worker 517d v1.21.5 worker3 Ready worker 517d v1.21.5
Cordon the node
kubectl cordon [NODENAME]
Drain the node
kubectl drain [NODENAME] --ignore-daemonsets --force --delete-local-data
Uncordon the node
kubectl uncordon [NODENAME]