So when we need to adjust configures for RDBMS? Or DB Performance analysis tools through lazy eyes
Hi, the community! Today, I would like to speak about configuration for the RDBMS (like MySQL, PostgreSQL, MS SQL, Oracle) and I will be happy to read your feedback. That article will have 4 parts (overview, use cases, specific products, deadlock). Many times as I see into different environments, installations with Atlassian Suite, as most of the configs are defaults. Therefore I want to share with small tips and tricks, which is used by me for a long time. Based on that maybe someone will be interested in the short links, for first the configuration before starting to go deep into ANALYZE, EXPLAIN utils. Let’s start it. PostgreSQL My favorite tool is https://pgtune.leopard.in.ua/#/ Via that service, I can easy to set the first parameters. I do recommend you check the DB pool connections in dbconfig.xml ( KB of dbconfig.xml ) + add a few extra connections (typically I add +10 it depends on replication/bi/other connections), otherwise, you can’t lo...