In this article, we are going to talk about the MySQL SUBSTRING() function with its variations. Here, you will find a detailed guide with the basic syntax and examples of how to use this function. Moreover, we will demonstrate the benefits of MySQL coding in a handy IDE – dbForge Studio for MySQL that will […]
10 Older Entries »
Recently, while doing a test process to examine resource usage and the time required to alter the table using pt-osc, it leads to a loss of triggers even though the –preserve-triggers option is specified. I made the decision to recreate the identical circumstance so that everyone could see it.
Test environment :
OS: Amazon Linux 2
MySQL version: 5.7.40
pt-online-schema-change version: 3.1.0
Before digging deeper, we must first obtain the whole picture. Here is an illustration of the table’s structure.
In MySQL, the ORDER BY clause is used to sort the records fetched by the SELECT statement, in ascending or descending order. And while the usage of this command is simple in basic cases, there are more complex scenarios requiring much more attention. This article will explore the essence, the syntax, and the usage scenarios […]
Well, we can’t argue that Windows is the key platform for database development and management software—but what if you are a Mac user? Who said you can’t have equal opportunities to set up easy daily work with, for instance, MySQL databases? Simply take a closer look and you’ll see an abundance of top-tier MySQL tools […]
MySQL variables store data, label data, and let developers create more accurate and efficient code by turning long and complicated strings of characters into one simple variable. This article will explore user-defined variables. User-defined variables let us execute various data sets with one command and use this data whenever needed. Mastering variables in MySQL is […]
Linux has a reputation as an operating system for programmers. So, if you are a software developer who designs MySQL-based solutions, chances are high that you will do it on Linux. Thus, it would be great to have a MySQL IDE for Linux to simplify the work. But the question arises: is there an appropriate […]
MySQL 8.0.30 was released on 26-07-2022. It has a good list of features.
- Generated Invisible Primary Key
- Dynamic Redo log Sizing
- Instruments to monitor group replication memory
- Support for Ubuntu 22.04
A most notable feature for Database Administrators and database reliability engineers is Dynamic redo logging.
The more widely adopted open-source backup tool is Xtrabackup. The change in the redo log design has affected this hot backup tool.
2022-10-04T18:40:08.211998+05:30 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --datadir=/var/lib/mysql 2022-10-04T18:40:08.212264+05:30 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: …
Mydumper supports streaming of backups right from version 0.11.3 and the latest version Mydumper 0.12.3 it enabled its support for compressed streaming backup. This was the most awaited feature added to Mydumper, making it a more powerful tool for data migration to RDS or Cloud.
If you are hearing mydumper for the first time, then let’s have a quick catch-up on what Mydumper is and what it does exactly.
Mydumper is a multithread logical backup and restores tool for MySQL and its forks. To know more you can refer to our previous blogs/presentations below.[Read more]
Es gibt zwei Arten, wie man Tabellen in MySQL-Datenbanken erstellen kann: Ausführen einer Abfrage, die einen CREATE TABLE-Befehl enthält Nutzung der entsprechenden Funktionen von MySQL-bezogenen Tools und IDEs Der erste Ansatz ist hilfreich, wenn Sie Tabellen speziell über ein Skript erstellen müssen. Wenn Sie z.B. eine Tabelle zu einem ganz bestimmten Zeitpunkt erstellen möchten, es […]
The post Erstellen von Tabellen mit dem MySQL CREATE TABLE-Befehl in dbForge Studio for MySQL appeared first on Devart Blog.
10 Older Entries »