Tag: Percona Server

Feed: Planet MySQL; Author: MySQL Performance Blog; PREVIOUS POST Percona is glad to announce the release of Percona XtraBackup 8.0.4 on December 10, 2018. You can download it from our download site and apt and yum repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered free as an open source solution, it drives down backup costs while providing unique features for MySQL backups. This release of Percona Xtrabackup is a General Availability release ready for use in a production environment. Please note the following about this release: The deprecated innobackupex has been ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; Probably all of us, MySQL users, DBAs and developers had seen error 1213 more than once, in one context or the other: mysql> select * from t1;ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction The first thing that comes to mind in this case is: "OK, we have InnoDB deadlock, let's check the details", followed by the SHOW ENGINE INNODB STATUS check, like this: mysql> show engine innodb statusG*************************** 1. row ***************************  Type: InnoDB  Name:Status:=====================================2018-12-08 17:41:11 0x7f2f8b8db700 INNODB MONITOR OUTPUT=====================================Per second averages calculated from the last 12 seconds-----------------BACKGROUND THREAD-----------------srv_master_thread ... Read More

Feed: Liquid Web. Author: Liquid Web; You might not realize it, but databases are everywhere. Whether or not you know very much about them, their effect on our daily lives is extensive. From weather applications to the movies you watch online, databases are responsible for many of the services we utilize daily.We have collected a few of the more well-known examples of how databases enhance your day-to-day life below. The most popular database server in our industry, MySQL, is prevalent in virtually every example listed below. Like this content? Subscribe now and have more just like it sent straight to your ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; PREVIOUS POST Percona announces the release of Percona Server for MySQL 5.7.24-26 on December 4, 2018 (downloads are available here and from the Percona Software Repositories). This release merges changes of MySQL 5.7.24, including all the bug fixes in it. Percona Server for MySQL 5.7.24-26 is now the current GA release in the 5.7 series. All of Percona’s software is open-source and free. This release includes fixes to the following upstream CVEs (Common Vulnerabilities and Exposures): CVE-2016-9843, CVE-2018-3155, CVE-2018-3143, CVE-2018-3156, CVE-2018-3251, CVE-2018-3133, CVE-2018-3144, CVE-2018-3185, CVE-2018-3247, CVE-2018-3187, CVE-2018-3174, CVE-2018-3171. For more information, see Oracle Critical Patch Update Advisory – October 2018. Improvements PS-4790: ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; For some reason the Committee of FOSDEM 2019 MySQL, MariaDB & Friends Devroom of all my talks submitted picked up the one on how to create a useful MySQL bug report, so I have no options but continue to write about MySQL bugs, as long and MySQL Community wants and even prefers to listen and read about them... That's what I do, with pleasure.Today I'll continue my series of posts about community bug reports I am subscribed to with the review of bugs reported since October 1, 2018, starting from the oldest and skipping ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; PREVIOUS POST Percona announces the release of Percona Server 5.6.42-84.2 on November 29, 2018 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.6.42, including all the bug fixes in it, Percona Server 5.6.42-84.2 is the current GA release in the Percona Server 5.6 series. All of Percona‘s software is open-source and free. Improvements PS-4790: Improve user statistics accuracy Bugs Fixed Slave replication could break if upstream bug #74145 (FLUSH LOGS improperly disables the logging if the log file cannot be accessed) occurred in master. Bug fixed PS-1017 (Upstream #83232). The binary log could be corrupted when the disk partition used for temporary. files (tmpdir system ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; PREVIOUS POST Percona announces the release of Percona Server for MySQL 5.7.23-25 on November 21, 2018 (downloads are available here and from the Percona Software Repositories). This release merges changes of MySQL 5.7.23, including all the bug fixes in it. Percona Server for MySQL 5.7.23-25 is now the current GA release in the 5.7 series. All of Percona’s software is open-source and free. This release fixes a critical bug in a RocksDB submodule. Bugs Fixed #5049: Severe memory leak regression in the RocksDB Block Cache Find the release notes for Percona Server for MySQL 5.7.23-25 in ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; PREVIOUS POST Percona announces the release of Percona Server for MySQL 5.5.62-38.14 on November 21, 2018 (downloads are available here and from the Percona Software Repositories). This release merges changes of MySQL 5.5.62, including all the bug fixes in it. Percona Server for MySQL 5.5.62-38.14 is now the current GA release in the 5.5 series. All of Percona’s software is open-source and free. Note that Percona Server for MySQL 5.5.62-38.14 is the last release of the 5.5 series. This series goes EOL on December 1st, 2018. Improvements #4790: The accuracy of user statistics has been improved Bugs ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; PREVIOUS POST ProxySQL 1.4.12, released by ProxySQL, is now available for download in the Percona Repository along with an updated version of Percona’s proxysql-admin tool. ProxySQL is a high-performance proxy, currently for MySQL and its forks (like Percona Server for MySQL and MariaDB). It acts as an intermediary for client requests seeking resources from the database. René Cannaò created ProxySQL for DBAs as a means of solving complex replication topology issues. The ProxySQL 1.4.12 source and binary packages available at https://percona.com/downloads/proxysql include ProxySQL Admin – a tool, developed by Percona to configure Percona XtraDB Cluster ... Read More

Feed: Planet MySQL; Author: Jean-François Gagné; In the last few months, I had to install Percona Server 5.7 (PS5.7) on Debian a few times.  I was regularly annoyed by apt-get -y install percona-server-server-5.7 prompting me for a password.  But that annoyance did not push me to investigate the subject in detail: it was always a quick manual fix and Googling did not lead to a straightforward solution.  However in the last days, I had to install PS5.7 on many servers, so it was worth finding how to do this.  I am writing this post in the hope that it will help some people ... Read More