Opengist

Explore

  • All gists
  • Topics
  • Users
Give feedback on the new UI Powered by Opengist ⋅ 227ms

user:thomas gists created by user

title:mygist gists with given title

description:sync gists with given description

filename:myfile.txt gists having files with given name

extension:yml gists having files with given extension

language:go gists having files with given language

topic:homelab gists with given topic

all:systemctl search all fields

Login
m

management

Recently created Least recently created Recently updated Least recently updated

timmy / Swap 檔案與分割區設定工具

Last active 5 hours ago management partition scripts setup swap swap-file

輕鬆設定與管理 Swap 檔案和分割區,讓系統更流暢運行。

0 0 0 3
1 # 檢查目前是否有 swap 啟用
2 swapon --show
3 free -h
4
5 # 建立 2GB 的 swap 檔案(如果 fallocate 不支援可改用 dd)
6 sudo fallocate -l 2G /swapfile
7 sudo dd if=/dev/zero of=/swapfile bs=1M count=2048
8
9 # 設定正確權限
10 sudo chmod 600 /swapfile

timmy / MySQL 資料庫與表格查詢

Last active 5 hours ago database management monitoring mysql query tables

這組 SQL 指令可查詢資料庫與各表的紀錄數及大小,方便監控與管理資料庫資源。

0 0 0 1
1 SHOW DATABASES;
2
3 USE myapp;
4 SHOW TABLES;
5
6 SELECT TABLE_NAME, TABLE_ROWS
7 FROM INFORMATION_SCHEMA.TABLES
8 WHERE TABLE_SCHEMA = 'myapp';
9
10 SELECT TABLE_NAME,