The article provides a detailed guide on MySQL Command Line Client and shares useful tips on how to download, install, and get started with it. Read the tutorial to find out the best MySQL client on the market today.

The post MySQL CLI (Command-Line Interface): How to Get Started With MySQL Database Management appeared first on Devart Blog.

This article covers some of the most popular MySQL performance monitoring tools alongside the key performance metrics that can help improve and optimize query performance in MySQL databases.

The post MySQL Performance Monitoring Tools and the Most Important Metrics to Monitor appeared first on Devart Blog.

MySQL has a set of built-in functions for data processing, transformation, and analysis. In particular, the following discussion will be about string functions. So, let's find out what they are and when to use them.

The post MySQL String Functions in Action appeared first on Devart Blog.

Vitess is a popular CNCF project that is used to scale some of the largest MySQL installations in the world — by companies like Slack, Square, Shopify, and GitHub. It provides sharding, connection pooling, and many other features that make it easy to scale MySQL horizontally. Vitess and MySQL are ideally suited for use as an Online Transaction Processing (OLTP) system — where the end-user interacts directly with the system and fast response times are essential as they get product and service information, generating critical business records such as orders, user profiles, and more.

We saw in the previous post how we can deal with data stored in the new VECTOR datatype that was released with MySQL 9.0. We implemented the 4 basic mathematical operations between two vectors. To do so we created JavaScript functions. MySQL JavaScript functions are available in MySQL HeatWave and MySQL Enterprise Edition (you can […]

A couple of weeks ago, my colleague Marco Tusa published an important announcement titled “Do Not Upgrade to Any Version of MySQL After 8.0.37.” The announcement highlighted a critical issue in MySQL 8.0.38, MySQL 8.4.1, and MySQL 9.0.0 that caused database server crashes. Good news! The upcoming minor releases for the community edition of MySQL and […]

MySQL 9.0.0 has brought the VECTOR datatype to your favorite Open Source Database. There are already some functions available to deal with those vectors: This post will show how to deal with vectors and create our own functions to create operations between vectors. We will use the MLE Component capability to create JavaScript functions. JS […]

pt-online-schema-change is an amazing tool for assisting in table modifications in cases where ONLINE ALTER is not an option. But if you have foreign keys, this could be an interesting and important read for you. Tables with foreign keys are always complicated, and they have to be handled with care. The use case I am […]

Introduction # I recently encountered an intriguing bug. A user reported that their query was causing vtgate to fetch a large amount of data, sometimes resulting in an Out Of Memory (OOM) error. For a deeper understanding of grouping and aggregations on Vitess, I recommend reading this prior blog post. The Query # The problematic query was: selectsum(user.type)fromuserjoinuser_extraonuser.team_id=user_extra.idgroupbyuser_extra.idorderbyuser_extra.id;The planner was unable to delegate aggregation to MySQL, leading to the fetching of a significant amount of data for aggregation.

MySQL 9.0 is an Innovation Release, but as you may have read in my Quick Peek, I found little innovation. However, one new item caught my eye, and it could be a way to track query performance. MySQL 9.0 EXPLAIN enhancement Here is the syntax that will be referenced in the post. {EXPLAIN | DESCRIBE […]