From 791a12762b4b3ab8b781e85d99c4316089f2a3f0 Mon Sep 17 00:00:00 2001 From: zhizhijie <zhizhijie@users.noreply.gitee.com> Date: 星期一, 21 九月 2026 10:20:46 +0800 Subject: [PATCH] docs(工作日结): 补记 2026-09-21 全库数据备份与同事交付包 --- docs/工作日结/工作日结_2026-09-21.md | 29 +++++++++++++++++++++++++++++ 1 files changed, 29 insertions(+), 0 deletions(-) diff --git "a/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-21.md" "b/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-21.md" index 3c1445c..29aef90 100644 --- "a/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-21.md" +++ "b/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-21.md" @@ -79,3 +79,32 @@ 1. 鎸夌敤鎴锋媿鏉跨殑鏂规瀹炴柦 P0-1锛堟柟妗� A锛夊苟鍑恒�婂姛鑳芥祴璇曟姤鍛娿��+ 鍙岄〉鍚屾瘮涓�鑷存�у洖褰掋�� 2. P0-2 鍏堝嚭 9 鏈堟瘝鐗堬紙鏂规 B 搴旀�ワ級锛屽啀鎺掓柟妗� A 鐨勬墿鍒楀櫒涓庛��7 鏈堟瘝鐗堟墿 8 鏈堛�嶉�愭牸 diff 楠岃瘉銆� 3. 閰嶅悎鎺ユ墜鍚屼簨杩囦竴閬嶃�婃眹鎬诲ぇ琛ㄩ棶棰樹氦鎺ヨ鏄庛�嬶紝绛旂枒骞惰ˉ鍏呴仐婕忋�� + +--- + +## 浜斻�佷笅鍗堣拷鍔狅細鍏ㄥ簱鏁版嵁澶囦唤锛堜氦浠樼粰鍚屼簨锛� + +鐢ㄦ埛瑕佹眰銆屾妸鎴戠殑鏁版嵁澶囦唤鍑烘潵锛屾嫹璐濈粰鍚屼簨銆嶏紝浜у嚭浜や粯鍖� `_缁欏悓浜媉2026-09-21\`锛堜粨搴撴牴锛屽凡鐢ㄥ寘鍐� `.gitignore` 鏁村寘鎺掗櫎鍏ュ簱锛夛細 + +| 鏂囦欢 | 璇存槑 | +| --- | --- | +| `traffic_audit_full_20260921.sql` | 鍏ㄥ簱澶囦唤锛�52,010,797 瀛楄妭锛堢害 49.6 MB锛夛紝`mysqldump` 8.0.29 瀵煎嚭锛屽惈 `CREATE DATABASE` + 鍏� 29 琛ㄧ粨鏋勪笌鏁版嵁锛屽叡 128,803 琛� | +| `杩樺師璇存槑_2026-09-21.md` | 澶囦唤淇℃伅 / 杩樺師姝ラ锛圓 鏁村簱杩樺師銆丅 宸叉湁搴撹ˉ鏁版嵁锛�/ 楠岃瘉鏄庣粏 / 娉ㄦ剰浜嬮」 | +| `浜ゆ帴鏂囨。_2026-09-21.md` | 鎬讳氦鎺ユ枃妗ｅ壇鏈紙涓�骞跺彂缁欏悓浜嬶級 | + +**瀵煎嚭鍛戒护**锛堟湇鍔＄鍚岀増鏈� mysqldump锛夛細 + +``` +mysqldump --host=127.0.0.1 --port=3308 --user=root --default-character-set=utf8mb4 \ + --single-transaction --routines --triggers --events --hex-blob \ + --databases traffic_audit --result-file=...\traffic_audit_full_20260921.sql +``` + +**楠岃瘉**锛堟部鐢� 2026-09-13 鐨勯獙璇佸彛寰勶級锛氭妸澶囦唤閲岀殑搴撳悕鎹㈡垚涓存椂搴� `traffic_audit_vfy` 鈫� 瀹屾暣瀵煎叆 鈫� 涓庢簮搴撻�愯〃 `COUNT(*)` 姣斿 鈫� 姣斿鍚� `DROP DATABASE traffic_audit_vfy`銆� +缁撹锛�**29 寮犺〃鍏ㄩ儴涓�鑷达紝0 宸紓**锛堝悎璁� 128,803 琛岋級銆傚叧閿〃锛歚city_taxi_auth` 85,272 / `h2031_enterprise_monthly` 15,811 / `h2032_enterprise_monthly` 13,056 / `audit_result` 3,393 / `city_bus_monthly` 2,860 / `investment_project` 152 / `investment_monthly` 284 / `freight_turnover_import` 234 鈥斺�� 涓庝氦鎺ユ枃妗� 搂1.2 璁板綍涓�鑷淬�� + +**鐣欎笅鐨勪复鏃舵枃浠�**锛堟湭鍒狅級锛歚_tmp/_verify_20260921.sql`锛堟敼鍚嶅悗鐨勯獙璇佸壇鏈紝52 MB锛夈�乣_tmp/_verify_counts.tsv`锛堥�愯〃姣斿缁撴灉锛夈�乣_tmp/_mk_pkg_20260921.py`銆乣_tmp/_fix_pkg_doc.py`銆� + +**鏈鏃犱唬鐮佹敼鍔�**锛屽睘鏁版嵁绫诲伐浣滐紝鏁呬笉鍙﹀嚭銆婂姛鑳芥祴璇曟姤鍛娿�嬨�� + +**寰呯敤鎴风‘璁�**锛氣憼 浜や粯鍖呮槸鍚﹂渶瑕佸帇缂� zip锛�50 MB 鈫� 渚夸簬寰俊/缃戠洏浼犺緭锛夛紱鈶� 鍚屼簨鐜鑻ヤ负 MySQL 5.7锛岄渶鍙﹀嚭涓�浠� 5.7 涓撶敤瀵煎嚭锛涒憿 鏄惁闇�瑕佹妸 `docs/`锛堟瘝鐗堛�佹姇璧勬簮鏂囦欢锛変竴骞舵墦鍖� 鈥斺�� 璇ラ儴鍒嗗凡鍦� git 浠撳簱鍐咃紝clone 鍗冲彲鑾峰緱銆� -- Gitblit v1.9.1