As the concurrency and data volume of a database keep increasing, the database performance decreases. If the performance is not tuned in time, the database may break down. This may cause catastrophic losses.
Database performance can be tuned in terms of system architecture, application architecture, hardware configuration, OS, and database itself. The system architecture, application architecture, and hardware configuration should be tuned before the database rollout and further optimized during the database running.
This guide aims to help you tune the performance of your StoneDB from the following aspects:
- Common commands used for performance monitoring
- OS performance tuning
- Database performance tuning
- Architecture optimization
- Performance testing