exp.test006.ksh

b树实现源码,linux和unix下运行,速度快,极好用

Case 1: -d option with no table
<Database Usage Statistics>
<DatabaseStatistics>
  <Database Name>  SYSTEMDB </Database Name>
  <Max Size> 1048576 </Max Size>
  <First Page> 17d84000 </First Page>
  <Total Pages> 109 </Total Pages>
  <Used Normal Pages> 11 </Used Normal Pages>
  <Used Merged Pages> 2 </Used Merged Pages>
  <Chunks Used> 13 </Chunks Used>
</DatabaseStatistics>
<ProcTable>
  <UsedSlots> 1 </UsedSlots>
  <FreeSlots> 99 </FreeSlots>
</ProcTable>
<TransactionTable>
  <UsedSlots> 0 </UsedSlots>
  <FreeSlots> 100 </FreeSlots>
  <UndoLogs>
    <TotalNodes> 0 </TotalNodes>
  </UndoLogs>
</TransactionTable>
<LockTable>
  <TotalBuckets> 2048  </TotalBuckets>
  <UsedBuckets> 0  </UsedBuckets>
  <TotalLockNodes> 0  </TotalLockNodes>
</LockTable>
<DatabaseStatistics>
  <Database Name>  userdb </Database Name>
  <Max Size> 10485760 </Max Size>
  <First Page> 17e7a000 </First Page>
  <Total Pages> 1279 </Total Pages>
  <Used Normal Pages> 0 </Used Normal Pages>
  <Used Merged Pages> 0 </Used Merged Pages>
  <Chunks Used> 0 </Chunks Used>
</DatabaseStatistics>
</Database Usage Statistics>
Table created
Index created for f1
Tables and Indexes are created
Case 2: -d option with 1 table
<Database Usage Statistics>
<DatabaseStatistics>
  <Database Name>  SYSTEMDB </Database Name>
  <Max Size> 1048576 </Max Size>
  <First Page> 17d84000 </First Page>
  <Total Pages> 109 </Total Pages>
  <Used Normal Pages> 11 </Used Normal Pages>
  <Used Merged Pages> 2 </Used Merged Pages>
  <Chunks Used> 13 </Chunks Used>
</DatabaseStatistics>
<ProcTable>
  <UsedSlots> 1 </UsedSlots>
  <FreeSlots> 99 </FreeSlots>
</ProcTable>
<TransactionTable>
  <UsedSlots> 0 </UsedSlots>
  <FreeSlots> 100 </FreeSlots>
  <UndoLogs>
    <TotalNodes> 0 </TotalNodes>
  </UndoLogs>
</TransactionTable>
<LockTable>
  <TotalBuckets> 2048  </TotalBuckets>
  <UsedBuckets> 0  </UsedBuckets>
  <TotalLockNodes> 0  </TotalLockNodes>
</LockTable>
<DatabaseStatistics>
  <Database Name>  userdb </Database Name>
  <Max Size> 10485760 </Max Size>
  <First Page> 17e7a000 </First Page>
  <Total Pages> 1276 </Total Pages>
  <Used Normal Pages> 2 </Used Normal Pages>
  <Used Merged Pages> 1 </Used Merged Pages>
  <Chunks Used> 3 </Chunks Used>
</DatabaseStatistics>
</Database Usage Statistics>
Table Dropped
Case 3: -d option after removing table
<Database Usage Statistics>
<DatabaseStatistics>
  <Database Name>  SYSTEMDB </Database Name>
  <Max Size> 1048576 </Max Size>
  <First Page> 17d84000 </First Page>
  <Total Pages> 109 </Total Pages>
  <Used Normal Pages> 11 </Used Normal Pages>
  <Used Merged Pages> 2 </Used Merged Pages>
  <Chunks Used> 13 </Chunks Used>
</DatabaseStatistics>
<ProcTable>
  <UsedSlots> 1 </UsedSlots>
  <FreeSlots> 99 </FreeSlots>
</ProcTable>
<TransactionTable>
  <UsedSlots> 0 </UsedSlots>
  <FreeSlots> 100 </FreeSlots>
  <UndoLogs>
    <TotalNodes> 0 </TotalNodes>
  </UndoLogs>
</TransactionTable>
<LockTable>
  <TotalBuckets> 2048  </TotalBuckets>
  <UsedBuckets> 0  </UsedBuckets>
  <TotalLockNodes> 0  </TotalLockNodes>
</LockTable>
<DatabaseStatistics>
  <Database Name>  userdb </Database Name>
  <Max Size> 10485760 </Max Size>
  <First Page> 17e7a000 </First Page>
  <Total Pages> 1279 </Total Pages>
  <Used Normal Pages> 0 </Used Normal Pages>
  <Used Merged Pages> 0 </Used Merged Pages>
  <Chunks Used> 0 </Chunks Used>
</DatabaseStatistics>
</Database Usage Statistics>