Category: MySQL & MariaDB

Feed: Planet MySQL; Author: MySQL Performance Blog; Primary Key design is an important thing for InnoDB performance, and choosing a poor PK definition will have an impact on performance and also write propagation in databases. When this comes to Aurora, this impact is even worse than you may notice. In short, we consider a poor definition of a Primary Key in InnoDB as “anything but quasi sequential values”, which may cause very random access to data and thus increase the IO dependency. In this post, I’ll try to demonstrate the potential impact of the primary key design when running on ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; The new MyDumper 0.11.1 version, which includes many new features and bug fixes, is now available.  You can download the code from here. For this release, there are three main changes: 1) we added config file functionality which allows users to set session-level variables (one of the most requested features!), 2) we developed a better and robust import mechanism, and 3) we fixed all the filename related issues.  Those changes and mostly the last one forced us to change the version number from 0.10.9 to 0.11.1 as a backup taken in 0.10.x will ... Read More

Feed: Planet MySQL; Author: Alena Subotina; More good news coming our way! It is inspiring to see that all the hard work we put into our products pays off as happy users and good reviews bring us more and more recognition on independent software reviewing platforms and marketplaces. Today, the products in question are dbForge Studios for MySQL and Oracle, which have earned new badges in the Database Software category on G2. First and foremost, our high-end database product for MySQL and MariaDB databases—dbForge Studio for MySQL—has been awarded G2 Leader Fall 2021. In the meantime, dbForge Studio for Oracle ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Syntax UUID Description The UUID data type is intended for the storage of 128-bit UUID (Universally Unique Identifier) data. Retrieval Data retrieved by this data type is in the string representation defined in RFC4122. Casting String literals of hexadecimal characters and CHAR/VARCHAR/TEXT can be cast to the UUID data type. Likewise hexadecimal literals, binary-literals, and BINARY/VARBINARY/BLOB types can also be cast to UUID. The data type will not accept a short UUID generated with the UUID_SHORT function, but will accept a value without the - character generated by the SYS_GUID function (or ... Read More

Feed: Planet PostgreSQL. Date: 20.09.2021 Tags:   postgresql    israel    coc    pgday-israel    pgday.org.il    awide.io    postgrespro.co.il    swag    Category:   Interviews    Interviewed by: Andreas Scherbaum PostgreSQL is the World’s most advanced Open Source Relational Database. The interview series “PostgreSQL Person of the Week” presents the people who make the project what it is today. Read all interviews here. Please tell us about yourself, and where you are from. I’m from a small town located in the Ural mountains. In 1991 our family moved to Israel. I live in Tel Aviv since then. Michael Goldberg ... Read More

Feed: Planet MySQL; Author: Dave Stokes;     This week's MySQL was a great one for novices looking to level up from beginner level SQL development to a higher level.      The problem:  Find the customers with more than one unreturned rented movies that are past their return due date.  You might to look at this for the example of finding an overdue rentals. The answer:First we need to get the customer_id from the customer table.  Then it takes a bit of struggle to get the information on the rental.   It is often easier to write queries by determining the needed output columns, ... Read More

Feed: Planet MySQL; Author: parvez alam; in this tutorial, We’ll learn about how to add add, edit, delete functionality using Bootstrap 5, PHP and MySQL.I am extending previous tutorial Ajax Pagination with Search and Sort.We have already added functionality to listing, searching, and sorting into datatable, So Let’s add functionality to CRUD operation without page refresh.We have already added the CRUD button into the previous tutorial, we just add into them fucntionality.We will cover the following features in this Datatable Tutorial:Add Record into the DatatableEdit record into the DatatableDelete record from the datatablejQuery Datatable CRUD OperationYou will learn how to ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . MariaDB 10.7 is the current development branch. New Features & Improvements UUID JSON Natural Sort Optimization Provider Plugins Five provider plugins (bzip2, lzma, lz4, lzo, snappy) provide compression capabilities to the server and storage engines (MDEV-12933) SFORMAT mariadb-dump JSON Histograms Histograms in the statistics tables are more precise and stored as JSON, not binary (MDEV-26519) Convert Partitions ALTER TABLE ... CONVERT PARTITION .. TO TABLE (MDEV-22166), and ALTER TABLE ... CONVERT TABLE ... TO PARTITION ... (MDEV-22165) as an easy way to convert tables to partitions and back in one command, instead ... Read More

Feed: Planet MySQL; Author: Kristian Köhntopp; My task is to collect performance data about a single query, using PERFORMANCE_SCHEMA (P_S for short) in MySQL, to ship it elsewhere for integration with other data. In a grander scheme of things, I will need to define what performance data from a query I am actually interested in. I will also need to find a way to attribute the query (as seen on the server) to a point in the codebase of the client, which is not always easy when an ORM or other SQL generator is being used. And finally I will ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Description The SFORMAT function takes an input string and a formatting specification and returns the string formatted using the rules the user passed in the specification. It use the fmtlib library for Python-like (as well as Rust, C++20, etc) string formatting. Only fmtlib 7.0.0+ is supported. There is no native support for temporal and decimal values: TIME_RESULT is handled as STRING_RESULT DECIMAL_RESULT as REAL_RESULT Examples SELECT SFORMAT("The answer is {}.", 42); +----------------------------------+ | SFORMAT("The answer is {}.", 42) | +----------------------------------+ | The answer is 42. | +----------------------------------+ CREATE TABLE test_sformat(mdb_release char(6), mdev ... Read More