by Smit Arora | Sep 6, 2023 | Insight for DBAs, MySQL, PostgreSQL
A join in SQL combines columns from one or more tables to extract the required data. When used effectively, joins can simplify queries and save a lot of time. In this blog, we will look into an easy way to visualize the data captured by various joins using Venn... by Smit Arora | Jun 20, 2023 | Insight for DBAs, MySQL
Often while managing and creating new users, we use all the default options and tend not to use extra features provided by MySQL. These extra options could prevent a user from using all the resources and degrading the performance of MySQL. In this blog, we will... by Smit Arora | Mar 29, 2023 | Insight for DBAs, MySQL
A partitioned table in MySQL has its data separated into different tablespaces while still being viewed as a single table. Partitioning can be a useful approach in some cases when handling huge sets of data. Deleting huge data sets could be quickened up in a... by Smit Arora | Jan 5, 2023 | Insight for DBAs, MySQL
Space constraint has been an endless and painstaking process for many of us, especially in systems that have a high number of transactions and data growth exceeding hundreds of GBs in a matter of days. In this blog, I will share a solution to remove this space and...