DataScaleFail #4 - How-to: MongoDB Capacity Planning, PostgreSQL DBaaS Query Performance & DBMS Auto-Tuning
- BenchANT
- Nov 6, 2023
- 1 min read
This newsletter edition is fully packed with some sophisticated content.
We are going deeper from standard performance measurements into a use-case and into the deep of performance engineering with query performance analytics for PostgreSQL. The third topic is a market research of DBMS auto-tuning tools.
We put a lot of our brain in these articles, and we hope you like the insights we created.
Thank you for reading!
How-to: MongoDB Capacity Planning @OTC Infrastructure
![[Section 1 image alt text]](https://static.wixstatic.com/media/387f15_4200230d85d84d8f83e9a12a42d94e23~mv2.png/v1/fill/w_980,h_926,al_c,q_90,usm_0.66_1.00_0.01,enc_avif,quality_auto/387f15_4200230d85d84d8f83e9a12a42d94e23~mv2.png)
Customer use-case to identify the best VM for next growth stage
Growth stage 1: 160% higher throughput for 48% higher costs
Growth stage 2: 250% higher throughput for 73% higher costs
PostgreSQL DBaaS – In-depth Query Performance Analysis
![[Section 2 image alt text]](https://static.wixstatic.com/media/387f15_7ef5b924290844408e29215394953709~mv2.png/v1/fill/w_713,h_550,al_c,q_90,enc_avif,quality_auto/387f15_7ef5b924290844408e29215394953709~mv2.png)
PostgreSQL DBaaS: AWS RDS, Azure Database and Google CloudSQL
TPC-H and TATP query performance analyzed
First hints on different tuning and storage layer problems identified
Market Analysis: DBMS Auto-Tuning Tools
![[Section 3 image alt text]](https://static.wixstatic.com/media/387f15_eebc6644d193425696d595a5f3a658de~mv2.png/v1/fill/w_600,h_494,al_c,q_85,enc_avif,quality_auto/387f15_eebc6644d193425696d595a5f3a658de~mv2.png)
Database configuration is a black art deemed difficult, error-prone, and time-consuming
AI-based auto-tuning tools promise up to 400% performance/cost optimisations
Analyzed: pgtune, MySQL-tuner, Ottertune, DBtune and Releem
More?
You found this interesting and you want more? Checkout the previous edition or try our archive with all previous and future issues of the newsletter. Checking archives is not what you want? You prefer getting new content directly to your mailbox? Then subscribe.
Comments