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

_out.log 2.6 KB
Riwayat Mentahan

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657 
  1. ========== 1. 打开数据库 ==========
    2. 

  2.   表创建/打开成功
    3. 

  3. 

  4. ========== 2. 插入 200000 行 (禁用防抖, 仅脏页阈值触发) ==========
    5. 

  5. [DEBUG] Header: TablePage=2 NextFreePage=147 FreePageStart=0 FirstWAL=0 LastWAL=0 NextTxn=1
    6. 

  6. [DEBUG] BufferPool: total=145 dirty=145
    7. 

  7.   [ 20000行] Alloc=5.3MB Total=3132.5MB 耗时=0.6s
    8. 

  8. [DEBUG] Header: TablePage=2 NextFreePage=286 FreePageStart=0 FirstWAL=0 LastWAL=0 NextTxn=1
    9. 

  9. [DEBUG] BufferPool: total=284 dirty=284
    10. 

  10.   [ 40000行] Alloc=9.1MB Total=6304.1MB 耗时=1.0s
    11. 

  11. [DEBUG] Header: TablePage=2 NextFreePage=425 FreePageStart=0 FirstWAL=0 LastWAL=0 NextTxn=1
    12. 

  12. [DEBUG] BufferPool: total=423 dirty=423
    13. 

  13.   [ 60000行] Alloc=12.8MB Total=9474.5MB 耗时=1.5s
    14. 

  14. [DEBUG] Header: TablePage=2 NextFreePage=1003 FreePageStart=563 FirstWAL=0 LastWAL=0 NextTxn=2
    15. 

  15. [DEBUG] BufferPool: total=65 dirty=65
    16. 

  16.   [ 80000行] Alloc=3.2MB Total=12678.7MB 耗时=2.1s
    17. 

  17. [DEBUG] Header: TablePage=2 NextFreePage=1003 FreePageStart=703 FirstWAL=0 LastWAL=0 NextTxn=2
    18. 

  18. [DEBUG] BufferPool: total=205 dirty=205
    19. 

  19.   [100000行] Alloc=7.0MB Total=15853.9MB 耗时=2.6s
    20. 

  20. [DEBUG] Header: TablePage=2 NextFreePage=1003 FreePageStart=842 FirstWAL=0 LastWAL=0 NextTxn=2
    21. 

  21. [DEBUG] BufferPool: total=344 dirty=344
    22. 

  22.   [120000行] Alloc=13.5MB Total=19027.1MB 耗时=3.1s
    23. 

  23. [DEBUG] Header: TablePage=2 NextFreePage=1003 FreePageStart=980 FirstWAL=0 LastWAL=0 NextTxn=2
    24. 

  24. [DEBUG] BufferPool: total=482 dirty=482
    25. 

  25.   [140000行] Alloc=15.2MB Total=22199.3MB 耗时=3.5s
    26. 

  26. [DEBUG] Header: TablePage=2 NextFreePage=1499 FreePageStart=1119 FirstWAL=0 LastWAL=0 NextTxn=3
    27. 

  27. [DEBUG] BufferPool: total=125 dirty=125
    28. 

  28.   [160000行] Alloc=5.0MB Total=25407.0MB 耗时=4.2s
    29. 

  29. [DEBUG] Header: TablePage=2 NextFreePage=1499 FreePageStart=1259 FirstWAL=0 LastWAL=0 NextTxn=3
    30. 

  30. [DEBUG] BufferPool: total=265 dirty=265
    31. 

  31.   [180000行] Alloc=10.7MB Total=28581.2MB 耗时=4.7s
    32. 

  32. [DEBUG] Header: TablePage=2 NextFreePage=1499 FreePageStart=1397 FirstWAL=0 LastWAL=0 NextTxn=3
    33. 

  33. [DEBUG] BufferPool: total=403 dirty=403
    34. 

  34.   [200000行] Alloc=15.3MB Total=31753.8MB 耗时=5.1s
    35. 

  35. 

  36.   插入完成: 耗时=5.1s, Alloc=7.4MB
    37. 

  37. 

  38. ========== 3. 手动 Commit ==========
    39. 

  39.   Commit 耗时: 0.1s
    40. 

  40. 

  41. ========== 4. 验证行数 ==========
    42. 

  42.   当前行数: 200000 (期望 200000)
    43. 

  43.   ✅ 行数正确
    44. 

  44. 

  45. ========== 5. 关闭 → 重开验证 ==========
    46. 

  46.   重开后行数: 200000 (期望 200000)
    47. 

  47.   ✅ 数据完整持久化
    48. 

  48. 

  49. ========== 6. 抽查数据 ==========
    50. 

  50.   Row#1: Name=user_0 Age=20 Score=0 Dept=dept_0
    51. 

  51.   Row#200000: Name=user_199999 Age=69 Score=999 Dept=dept_9
    52. 

  52. 

  53. ========== 总结 ==========
    54. 

  54.   最终 Alloc=1.9MB, TotalAlloc=32012.8MB
    55. 

  55.   插入耗时: 5.1s
    56. 

  56.   脏页阈值: 10000 页 (≈156MB)
    57. 

  57.   ✅ 内存控制良好 (< 200MB), 脏页阈值生效!
    58.