Author: MySQL Planet

Feed: Planet MySQL; Author: Calvin Sun; MySQL 8.0.17 is officially released Yesterday. The most talked feature is the clone plugin, which enables the automatic node provisioning from an existing node (a Donor). This also closes the gap between MySQL Group Replication and Galera Cluster on usability.Congrats to MySQL engineering team on the excellent work! Specially expose the visibility of the operations:mysql> SELECT STATE FROM performance_schema.clone_status;+-----------+| STATE     |+-----------+| Completed |+-----------+1 row in set (0.02 sec) mysql> SELECT STAGE, STATE, END_TIME FROM performance_schema.clone_progress;+-----------+-------------+----------------------------+| STAGE     | STATE       | END_TIME                   |+-----------+-------------+----------------------------+| DROP ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; ERROR 1040…againA pretty common topic in Support tickets is the rather infamous error: ERROR 1040: Too many connections. The issue is pretty self-explanatory: your application/users are trying to create more connections than the server allows, or in other words, the current number of connections exceeds the value of the max_connections variable.This situation on its own is already a problem for your end-users, but when on top of that you are not able to access the server to diagnose and correct the root cause, then you have a really big problem; most times you ... Read More

Feed: Planet MySQL; Author: Dave Stokes; I would like to point out some 'small' things you may not have noticed in the MySQL 8.0.17 Release Notes.  They are small changes compared to things like MVIs, InnoDB cloning, and the like but these are the types of changes that are subtle that may catch you unaware.1. Host names have grown from 60 to 255 characters.  However your SSL/TLS package may not be able to handle the longer names.2. If you are an old C/C++ programmer, 'C-style &&, ||, and ! operators that are synonyms for the standard SQL AND, OR, and ... Read More

Feed: Planet MySQL; Author: Percona Community; Timur Solodovnikov  | July 23, 2019 |  Posted In: MySQL, Open Source Databases Starting at version MySQL5.6+ by default innodb_file_per_table is enabled and all data is stored in separate tablespaces.It provides some advantages. I will highlight some of them:You can reclaim disk space when truncating or dropping a table stored in a file-per-table tablespace. Truncating or dropping tables stored in the shared system tablespace creates free space internally in the system tablespace data files (ibdata files) which can only be used for new InnoDB data.You can store specific tables on separate storage devices, for I/O optimization, space management, ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; As follow up to the previous blog announcement about the conferences and events MySQL Team is attending, we would like to inform you about where you can find us during August & September 2019. Please find the list below. August 2019: Mid-Atlantic Developer Conference, Baltimore, US, August 1-2, 2019 MySQL Community team is a Bronze sponsor of this Developer conference. Our MySQL Community Manager, David Stokes will be giving 2 sessions as follows: "MySQL & GIS" scheduled for Aug 1 @11:30-12:30pm "MySQL without the SQL — Oh My!" Aug 2 @10:15-11:15am Please do not ... Read More

Feed: Planet MySQL; Author: Colin Charles; Codership is pleased to announce a new Generally Available (GA) release of Galera Cluster for MySQL 5.6 and 5.7, consisting of MySQL-wsrep 5.6.44-25.26 and MySQL-wsrep 5.7.26-25.18 with a new Galera Replication library 3.27 (release notes, download), implementing wsrep API version 25. This release incorporates all changes into MySQL 5.6.44 (release notes, download) and MySQL 5.7.26 (release notes, download) respectively. Compared to the previous 3.26 release, the Galera Replication library has a few fixes: to prevent a protocol downgrade upon a rolling upgrade and also improvements for GCache page storage on NVMFS devices. One point ... Read More

Feed: Planet MySQL; Author: Dave Stokes; JSON has become the standard document interchange format over the last several years.  MySQL 5.7 added a native JSON data type and it has been  greatly enhanced with version 8.0.  But many in the relational world have complained the the NoSQL approach does not allow you to have rigor on your data. That is to make sure an integer value is really an integer and within specified ranges or string of the proper length. And there was no way to make sure that email addresses are not listed under a combination of E-mail, e-mail, ... Read More

Feed: Planet MySQL; Author: Dave Stokes; MySQL 8.0.17 adds three new functions to the JSON repertoire.  All three can take advantage of the new Multi-Value Index feature or can be used on JSON arrays. JSON_CONTAINS(target, candiate[, path]) This function indicates with a 1 or 0 if a  candidate document is contained in the target document. The optional path argument lets you seek information in embedded documents.  And please note the 'haystack' is before the 'needle' for this function. mysql> SELECT JSON_CONTAINS('{"Moe": 1, "Larry": 2}','{"Moe": 1}');+------------------------------------------------------+| JSON_CONTAINS('{"Moe": 1, "Larry": 2}','{"Moe": 1}') |+------------------------------------------------------+|                                                    1 |+------------------------------------------------------+1 row in set (0.00 sec)mysql> SELECT JSON_CONTAINS('{"Moe": ... Read More

Feed: Planet MySQL; Author: Krunal Lathiya; SQL Aliases Example | Alias In SQL Tutorial is today’s topic. Aliases are the temporary names that exist for a particular query. It is used for better understanding and reducing the workload of writing big column names. Aliases are the temporary name and the changes made with the column name while retrieving does not reflect in the original database. Content Overview SQL Aliases Example An Alias is a shorthand for the table or column name. Aliases reduce the amount of typing required to write the query. Complex queries with the aliases are generally easier ... Read More

Feed: Planet MySQL; Author: FromDual; See also our former articles:When we do analysis of MariaDB Database servers we also check the memory (RAM and Swap) available: # free --kilo --wide total used free shared buffers cache available Mem: 16106252 4329952 703356 199008 307872 10765072 11042748 Swap: 31250428 528684 30721744 The values for buffers and especially for cache can be sometimes quite big. In this case they use about 10 GiB. So let us have a look what these things called buffers and cache are, using our valuable RAM... When we check the man pages of free we will find: # ... Read More