Storage analyzer: Difference between revisions

Storage analyzer (view source)

363 bytes added , 9 June 2021

9,275

edits

@@ Line 294: / Line 294: @@
 <syntaxhighlight lang="text">
-    ======= DbInternalsReport =======
+======= DbInternalsReport =======
-	LibVersion= Sqlite 3.8.8.1
-	DbSize= 7102060K
+LibVersion= Sqlite 3.8.8.1
-	WalSize= 0K
+DbSize= 7102060K
-	Unused pages= 6005
+WalSize= 97844K
-	page_size= 4096
+RegisterCollation() -> OK
-	cache_size= 20000 pages
+Selected PRAGMAs:
-	fullfsync= 0
+    freelist_count= 6005
-	CompileTimeOptions: ENABLE_COLUMN_METADATA HAS_CODEC SYSTEM_MALLOC THREADSAFE=1 SQLITE_THREADSAFE=1
+    page_size= 4096
-	*** MemoryInfo ***
+    cache_size= 20000 pages
-	SQLITE_STATUS_MEMORY_USED=87882304/88149272
+    fullfsync= 0
+CompileTimeOptions: ENABLE_COLUMN_METADATA HAS_CODEC SYSTEM_MALLOC THREADSAFE=1 SQLITE_THREADSAFE=1
+*** MemoryInfo ***
+SQLITE_STATUS_MEMORY_USED=87882288/87892888
+…
 </syntaxhighlight>
+Explanation:
+* WalSize refers to the size of the database log file.
+* RegisterCollation reports an eventual error when NOCASE collation (case-insensitive sorting) is registered with SQLite engine. (“OK” is the expected result.)
+* See [https://www.sqlite.org/ SQLite documentation] for more details.
 [[Category:Support]]