Tag: MySQL 5.7

Feed: Planet MySQL; Author: MySQL Performance Blog; Percona announces the release of Percona Server for MySQL 5.7.27-30 on August 22, 2019 (downloads are available here and from the Percona Software Repositories). This release merges changes of MySQL 5.7.27, including all the bug fixes in it. Percona Server for MySQL 5.7.27-30 is now the current GA release in the 5.7 series. All of Percona’s software is open-source and free.Bug Fixes:Parallel doublewrite buffer writes must crash the server on an I/O error occurs. Bug fixed #5678.On a server with two million or more tables using foreign keys and AUTOINC columns, the shutdown may take a measurable ... Read More

Feed: Planet MySQL; Author: FromDual; ContentsIntroduction Recently we had a consulting engagement where we had to help the customer to migrate from latin1 Character Set to utf8mb4 Character Set. In the same MySQL consulting engagement we considered to upgrade from MySQL 5.6 to MySQL 5.7 as well [ Lit. ]. We decided to split the change in 2 parts: Upgrading to 5.7 in the first step and converting to uft8mb4 in the second step. There were various reasons for this decision: 2 smaller changes are easier to control then one big shot. We assume that in 5.7 we experience less ... Read More

Feed: Planet MySQL; Author: MyDBOPS; We are well aware that MySQL Group Replication is one of the faster evolving clustering Technology for MySQL. Flow Control plays a key factor in Group Replication performance and data integrity . In this blog I am going to explain about the Flow Control mechanism and How it has evolved in MySQL 8 ? What is Flow Control ? MySQL Group Replication / Native Async replication needs binary logs to get the data flow across the servers. What makes the difference ? In the MySQL Group Replication we are trying to achieve the Synchronous replication ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; Recently, PeterZ pointed a huge difference in memory usage of MySQL 8.0 compare to MySQL 5.7. This can be an issue for small instances if the same configuration for buffers like the buffer pool are not changed. As explained in Peter’s article, this can lead to the awakening of the so feared OOM Killer ! MorganT, pointed accurately in his comment what is the source of such difference and how this was then caused by the new instrumentation added in MySQL 8.0. Nothing is free, even as a beer. There is always a cost ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; While we often run MySQL on larger scale systems in Production for Test and Dev, sometimes we want to run MySQL on the tiniest cloud instances possible or just run it on our laptops. In these cases, MySQL 8 and MySQL 5.7 memory consumption is quite important.In comparing MySQL 8 vs MySQL 5.7, you should know that MySQL 8 uses more memory. Basic tests on a 1GB VM with MySQL 8 and MySQL 5.7 (actually they’re Percona Server versions) running the same light workload, I see the following vmstat output:MySQL 5.7 vmstat output ... Read More

Feed: Planet MySQL; Author: HowToForge; Matomo (formerly Piwik) is a free and open-source web analytics application developed by a team of international developers, that runs on a PHP/MySQL webserver. It tracks online visits to one or more websites and displays reports on these visits for analysis. You can think of it as an alternative to Google Analytics. Matomo is an open-source and its code is publicly available on Github. Some of the features it has are - A/B Testing, Heatmaps, Funnels, Tracking and Reporting API, Google AdWords, Facebook Ads, Bing Ads, Cost Per Click (CPC), etc. This tutorial will show you how to install Matomo ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; After a 3 months long break I'd like to continue reviewing MySQL bug reports that I am subscribed to. This issue is devoted to bug reports I've considered interesting to follow in May, 2019:Bug #95215 - "Memory lifetime of variables between check and update incorrectly managed". As demonstrated by Manuel Ung, there is a problem with all InnoDB MYSQL_SYSVAR_STR variables that can be dynamically updated. Valgrind allows to highlight it. Bug #95218 - "Virtual generated column altered unexpectedly when table definition changed". This weird bug (that does not seem to be repeatable on MariaDB 10.3.7 ... Read More

Feed: Planet MySQL; Author: Percona Community; Wayne Leutwyler  | August 1, 2019 |  Posted In: MySQL, Percona Server for MySQLThe blog post How to Compile Percona Server for MySQL 5.7 in Raspberry Pi 3 by Walter Garcia, inspired me to create an updated install of Percona Server for the Raspberry Pi 3+.This how-to post covers installing from source and being able to use Percona Server for MySQL in any of your maker projects. I have included everything you need to have a complete Percona Server, ready to store data collection for your weather station, your GPS data, or any other project you ... Read More

Feed: Planet MySQL; Author: Continuent; Continuent is pleased to announce that the following new software releases are now available:Tungsten Clustering version 5.4.0 Tungsten Replicator version 5.4.0 Releases 5.4.0 is significant in that it introduces MySQL 8 support, along with many new features, stability improvements and bug fixes. Highlights common to both products: Improvements, new features and functionality Two new utility scripts have been added to the release to help with setting the Replicator position: tungsten_find_position, which assists with locating information in the THL based on the provided MySQL binary log event position and outputs a dsctl set command as output ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; In MySQL 8.0, when using invalid values for date data types, an error is returned. This was not the case in 5.x versions. Let’s have a look using the table definition of bug 96361: CREATE TABLE `new_table` ( `id_table` int(11) NOT NULL AUTO_INCREMENT, `text_table` varchar(45) DEFAULT NULL, `date_table` date DEFAULT NULL, PRIMARY KEY (`id_table`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci Now we can try the following statement in MySQL 5.7 and MySQL 8.0: MySQL 5.7.26> SELECT id_table, text_table FROM new_table WHERE date_table = '' OR date_table IS NULL; Empty set, 1 warning (0.01 sec) MySQL ... Read More