What is the Recommended Size for a MySQL Database in Bold Reports?
Overview
The database size in MySQL is affected by factors such as the number of users, reports, schedule executions, and report views. This article provides a clear understanding of how these activities impact database growth.
Scenario Overview
The following scenarios were considered to observe changes in database size :
-
Initial Server Setup with Single Site: After setting up a single site, the database size was 7 MB.
-
Second Site Creation Using Existing Database: Creating a second site using the same database increased the size to 10 MB.
-
User Addition : Despite adding 1,000 users, the database size remained at 10 MB, indicating minimal storage usage for user data.
-
Report Viewing: Viewing 1,0000 reports did not increase the database size, keeping it at 10 MB. Report rendering uses temporary storage without significant long-term impact.
-
Schedule Creation: Adding 1,000 report schedules also did not increase the database size, maintaining it at 10 MB.
-
Schedule Execution: After 1,000 report executions, the database size remained stable at 10 MB.
Database Size Estimation
-
For a typical environment with a single site, 1,000 users, 10,000 report views, 1,000 reports, schedules, and executions, the database size stabilized at 10 MB.
-
Based on this scenario, it is advisable to allocate a minimum database size of 20 MB to 25 MB. This buffer accounts for additional operations such as temporary storage, logs, indexes, and minor data growth.
-
Regular monitoring and database maintenance are recommended to ensure optimal performance and to manage any unexpected data growth effectively.
Conclusion
It is recommended to adjust the database size according to your operational requirements. While increased usage may lead to database growth, lower activity can minimize it. Continuous monitoring and optimization are essential to ensure efficient performance.