Halaman utama Jelajahi Bantuan
Masuk
yl32940
/
TsDB2
1
0
Fork 0
Berkas Masalah 0 Permintaan Tarik 0 Wiki
Pohon: b146b7354e
Ranting Tag
TsDB2
/
demo
/
integrity_test
/
_out.log

_out.log 2.7 KB
Riwayat Mentahan

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263 
  1. ==============================================
    2. 

  2.   TsDB2 完整性测试 (100万行)
    3. 

  3. ==============================================
    4. 

  4. 

  5. ========== Phase 1: 打开数据库 ==========
    6. 

  6.   [初始状态] 磁盘:     0.00 MB | Go堆:    0.8 MB | Sys:    6.3 MB | Goroutines: 1
    7. 

  7. 

  8. ========== Phase 2: 批量插入 ==========
    9. 

  9.   [插入 100000 行] 磁盘:    15.66 MB | Go堆:    6.5 MB | Sys:   64.5 MB | Goroutines: 1
    10. 

  10.   [插入 200000 行] 磁盘:    23.41 MB | Go堆:   13.5 MB | Sys:   64.5 MB | Goroutines: 1
    11. 

  11.   [插入 300000 行] 磁盘:    38.89 MB | Go堆:    4.5 MB | Sys:   64.5 MB | Goroutines: 1
    12. 

  12.   [插入 400000 行] 磁盘:    46.64 MB | Go堆:   11.8 MB | Sys:   64.7 MB | Goroutines: 1
    13. 

  13.   [插入 500000 行] 磁盘:    62.14 MB | Go堆:    3.4 MB | Sys:   64.7 MB | Goroutines: 1
    14. 

  14.   [插入 600000 行] 磁盘:    69.89 MB | Go堆:    4.4 MB | Sys:   64.7 MB | Goroutines: 1
    15. 

  15.   [插入 700000 行] 磁盘:    77.64 MB | Go堆:   13.8 MB | Sys:   64.7 MB | Goroutines: 1
    16. 

  16.   [插入 800000 行] 磁盘:    93.13 MB | Go堆:    3.7 MB | Sys:   64.7 MB | Goroutines: 1
    17. 

  17.   [插入 900000 行] 磁盘:   100.88 MB | Go堆:    8.9 MB | Sys:   64.7 MB | Goroutines: 1
    18. 

  18.   [插入 1000000 行] 磁盘:   116.38 MB | Go堆:    3.5 MB | Sys:   64.7 MB | Goroutines: 1
    19. 

  19.   插入 1000000 行耗时: 24.95s (40078 rows/s)
    20. 

  20. 

  21. ========== Phase 3: Commit ==========
    22. 

  22.   [Commit 后] 磁盘:   116.38 MB | Go堆:    1.9 MB | Sys:   64.7 MB | Goroutines: 1
    23. 

  23.   Commit 耗时: 0.00s
    24. 

  24. 

  25. ========== Phase 4: 主键精确查找 ==========
    26. 

  26.   查找 8 个样本: 8 成功, 0 失败, 耗时 0.001s
    27. 

  27. 

  28. ========== Phase 5: 全量扫描验证 ==========
    29. 

  29.   扫描行数: 1000000
    30. 

  30.   Name 错误: 0
    31. 

  31.   Age 错误: 0
    32. 

  32.   全量扫描耗时: 1.53s (655062 rows/s)
    33. 

  33. 

  34. ========== Phase 6: 条件查询 ==========
    35. 

  35.   WHERE Age=25: 20000 行, 耗时 0.204s
    36. 

  36.   WHERE Score=500: 1000 行, 耗时 0.173s
    37. 

  37. 

  38. ========== Phase 7: 更新验证 ==========
    39. 

  39.   Update id=500: OK (Dept=UPDATED)
    40. 

  40.   更新+Commit 耗时: 0.003s
    41. 

  41. 

  42. ========== Phase 8: 删除验证 ==========
    43. 

  43.   Delete id=999: OK (已找不到)
    44. 

  44.   删除+Commit 耗时: 0.003s
    45. 

  45.   删除后 Count: 999999 (应为 999999)
    46. 

  46. 

  47. ========== Phase 9: 关闭重开验证 ==========
    48. 

  48.   [Close 后] 磁盘:   116.38 MB | Go堆:    1.4 MB | Sys:   64.7 MB | Goroutines: 1
    49. 

  49.   重开后 Count: 999999
    50. 

  50.   重开后 Find(1): OK (Name=Emp0000001)
    51. 

  51.   重开后 Find(1000000): OK (Name=Emp1000000)
    52. 

  52. 

  53. ========== Phase 10: 最终统计 ==========
    54. 

  54.   数据库文件大小: 116.38 MB
    55. 

  55.   每行平均占用: 122 bytes
    56. 

  56.   理论最小行大小: ~72 bytes (32+8+8+16+8)
    57. 

  57.   空间放大系数: 1.7x
    58. 

  58.   Go 堆内存: 3.0 MB
    59. 

  59.   总分配内存: 161743.5 MB
    60. 

  60. 

  61. ==============================================
    62. 

  62.   ✅ 完整性测试全部通过!
    63. 

  63. ==============================================
    64.