🧠 Why Internals Matter
When performance drops, SQL alone is not enough.
You need to inspect:
Storage layout
Sessions
Memory usage
🏗️ GBase Storage Structure
GBase organizes data into:
Dbspace → logical storage
Chunk → physical file
Page → smallest unit
🛠️ Inspect Storage with onstat -d
onstat -d
This shows:
Dbspace info
Chunk paths
Free space usage
Example output includes dbspace and chunk statistics
📊 Check Active Sessions
onstat -g ses
Use this to:
Identify long-running queries
Detect memory-heavy sessions
⚠️ Kill Problematic Sessions
onmode -z
🔬 Deep Inspection with oncheck
oncheck -pt database:table
This allows:
Page-level inspection
Row storage verification
🧪 Typical Debug Workflow
Detect slow query
Check sessions
Analyze storage
Inspect physical pages
⚡ Key Insight
GBase provides low-level observability, which many databases hide.
👉 You can debug at the storage layer
👉 Not just at SQL level
Final Thoughts
If SQL is your interface, onstat is your microscope.
👉 It reveals what’s really happening
👉 Helps pinpoint bottlenecks
👉 Enables deep optimization
Top comments (0)