by Edwin Wang | May 20, 2024 | MySQL, Percona Software
If you were to ask me the question, “Would it be possible to set up a replicate filter within the Percona XtraDB Cluster?” my immediate response would be to question you right back. Why would you even want the cluster nodes to have different data when... by Edwin Wang | Feb 16, 2023 | Database Trends, Insight for DBAs, MySQL
ChatGPT is the hottest topic in the tech world right now. One story even says that ChatGPT has passed Google’s Level 3 programming interview. I wondered, does that mean ChatGPT is ready to replace MySQL DBAs, too? No. Let me show you why.Recently, one of... by Edwin Wang | Dec 27, 2022 | Insight for DBAs, MySQL
There are eight configuration options related to the character_set in MySQL, as shown below. Without reading the MySQL Character Set documentation carefully, it could be hard to know what these configuration options are used for. In addition, for some of the options,... by Edwin Wang | Sep 6, 2022 | Insight for DBAs, MySQL
We often see an int column of a table that needs to be changed to unsigned-int and then unsigned-bigint due to the value being out of range. Sometimes, there may even be blockers that prevent us from directly altering the table or applying pt-online-schema-change on... by Edwin Wang | Apr 15, 2022 | Insight for DBAs, MySQL
Abstract: By diving into the details of our case study, we will explain how incorrect table statistics may lead the optimizer to choose a suboptimal execution plan. We will also go into how MySQL calculates the table statistics and the ways to correct the table...