MongoDB: Best Practices, Performance Tricks, .NET Tips & Tricks

Presented at Devnot 2023 (Devnot Organization).

All gists which are used on the stage can be found here.

Transcript

1. MongoDB: Best Practices, Performance Tricks, .NET Tips & Tricks
2. SELÇUK USTA Sr. Engineering Manager /in/selcukusta selcukusta.com selcukusta ustasoglu selcukusta (at)gmail.com
3. AGENDA > MongoDB - Design Patterns > What should be observed? > How can be observed? > Index Optimization & Best Practices > MongoDB on .NET
4. Design Patterns Database!?! Design Patterns?!? wtf!?!
6. Design Patterns Database!?! Design Patterns?!? wtf!?! Bloated Attribute Subset Document Versioning etc… Polymorphic
7. Design Patterns Database!?! Design Patterns?!? wtf!?! WHY is it so IMPORTANT?
8. WORKING SET most frequently accessed documents by clients + all indexes should fit into the RAM! (RAM - 1) * 0,5 or 256 MB WIREDTIGER STORAGE ENGINE
9. needs to check periodically; > db.serverStatus().wiredTiger.cache[...] > db.stats().dataSize > db.stats().indexSize > mongostat --uri="<MONGO_URI>" --interactive --discover -o="COLUMN_1,COLUMN_2" WIREDTIGER STORAGE ENGINE WORKING SET (RAM - 1) * 0,5 or 256 MB
10. WORKING SET (RAM - 1) * 0,5 or 256 MB
12. Concurrency Ticket & Queue Max 128 Concurrent Read #qr Max 128 Concurrent Write #qw
13. MONGODB INDEXING OPTIMIZATION Range Equality Sort Selectivity Index Stats ExecutionStats Compound Cardinality B-Tree
14. TIPS TRICKS
15. use “appName” in your connection options Tips and Tricks
16. consider using an individual read preference setting instead of the one provided by connection settings Tips and Tricks
17. do not forget to use “maxTimeMS()” to avoid blocking concurrent operations Tips and Tricks
18. fine-tune “connection pooling” mechanism in order for both database and applications to perform expected Tips and Tricks
19. THANK YOU! /in/selcukusta selcukusta.com selcukusta ustasoglu selcukusta (at)gmail.com