Đang tải bảng tin…
Lobsters0 Hot0 bình luận4 phút đọc
lobste.rs is now running on SQLite
The lobste.rs link aggregator has successfully migrated its production database from MariaDB to SQLite. The migration, which took roughly a year from initial interest to deployment, involved three pull request attempts and two deployment tries. The first deployment failed due to full table scans on large tables and an N+1 query issue, which were fixed before the successful second deploy on July 11th. Results after the Monday traffic spike were positive: CPU and memory usage dropped, the site feels snappier, and VPS costs will be halved once the MariaDB server is decommissioned. The migration used WAL mode for concurrency, a custom MariaDB-to-SQLite migration script, a slow query log, and nightly restic backups.
Nguồn: https://lobste.rs/s/ko1ji1/lobste_rs_is_now_running_on_sqlite. 8sync News chỉ tóm tắt và dẫn link; bản quyền nội dung thuộc tác giả và nguồn gốc.
Đề xuất cho bạn
Typescript119 Hot21 phútAI
Announcing TypeScript 7.0
TypeScript 7.0 ra mắt phiên bản biên dịch gốc bằng Go, cải thiện tốc độ build lên 8–12 lần …
