by Santhinesh Nagendran | May 3, 2023 | AWS RDS, Case Study, MySQL
Is Scaling/Autoscaling a blessing or curse ? There might be situations where we might have over provision resources ahead of time while capacity planning or resource planning in the initial stages of any application where we really can’t anticipate how much...
by Santhinesh Nagendran | Apr 28, 2023 | MySQL
We have come across several incidents where update stats have influenced a different choices of indexes causing the change in the execution plan which indeed degrades the query performance. Some of the most frequently asked questions about stats during those incident...
by Santhinesh Nagendran | Mar 6, 2023 | KnowledgeBase, MySQL
We were representing one of our audit report to one of our customers and he had some interesting question about the mysql default system users. So we thought it would be worth sharing our learning as a short note. The questions were like what are these users called...
by Santhinesh Nagendran | Mar 2, 2023 | MySQL
How many times have we come across a requirement of mysql cluster spread across different data centres , and each data centre offering its own failover strategy , and failover between data centre to data centre upon failure ? We have also come across such requirements...
by Selvaraj B | Aug 22, 2022 | Databases, General, KnowledgeBase, MySQL
Concurrency is one of the key features of Innodb and an interesting feature to understand to tune database systems. As per definition the concurrency is nothing but execution of multiple instructions in a sequence at the same time, and there are some commonly known...
by genexdb | Oct 8, 2021 | General, KnowledgeBase, MySQL
Introduction ENUM is a string object with a value chosen from a list of permitted values defined at the time of column creation. ENUM values are represented as integers internally. Enum datatype is chosen whenever a column has a limited possible data values like...
