Tag: MySQL 8.0

Feed: Planet MySQL; Author: Sveta Smirnova; PREVIOUS POST Please join Percona’s Principal Support Engineer, Sveta Smirnova, as she presents MySQL Performance Schema in 1 hour on Thursday, March 21st, 2019, at 10:00 am PDT (UTC-7) / 1:00 pm EDT (UTC-4). Register Now MySQL 8.0 Performance Schema is a mature tool, used by humans and monitoring products. It was born in 2010 as “a feature for monitoring server execution at a low level.” The tool has grown over the years with performance fixes and DBA-faced features. In this webinar, I will give an overview of Performance Schema, focusing on its tuning, ... Read More

Feed: Planet MySQL; Author: Geir Hoydalsvik; In this post we describe MySQL connections, user threads, and scaling. We hope that an increased understanding of how MySQL works will help application developers and system administrators to make good choices and trade-offs. We describe how connections work in a plain community server and we do not cover related topics such as thread pooling, resource groups, or connection multiplexing in this post. The MySQL Server (mysqld) executes as a single OS process, with multiple threads executing concurrent activities. MySQL does not have its own thread implementation, but relies on the thread implementation of ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; PREVIOUS POST Percona announces the release of Percona Server for MySQL 8.0.15-5 on March 15, 2019 (downloads are available here and from the Percona Software Repositories). This release includes fixes to bugs found in previous releases of Percona Server for MySQL 8.0. Incompatible changes In previous releases, the audit log used to produce time stamps inconsistent with the ISO 8601 standard. Release 8.0.15-5 of Percona Server for MySQL solves this problem. This change, however, may break programs that rely on the old time stamp format. Starting from release 8.0.15-5, Percona Server for MySQL uses the upstream implementation of binary log encryption. The variable encrypt_binlog is removed and the ... Read More

Feed: Planet MySQL; Author: FromDual; We see at various customers the request for consolidating their MariaDB and MySQL infrastructure. The advantage of such a measure is clear in the first step: Saving costs! And this requests comes typically from managers. But what we unfortunately see rarely is to question this request from the IT engineering perspective. Because it comes, as anything in life, with some "costs". So, saving costs with consolidation on one side comes with "costs" for operation complexity on the other side.To give you some arguments for arguing with managers we collected some topics to consider before consolidating: ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; .As a continue of the blog post submitted on Jan 31, we would like to share with you the list of events & conferences where you can find MySQL Community team and/or MySQL experts at. Please find below the list with all known details we have right now.  April 2019: DrupalCon, Seattle, US, April 8-10, 2019 This time you can find a talk of "MySQL 8 Features for Developers" given by David Stokes, the MySQL Community Manager. PyConTexas, Austin, TX, April 13-14, 2019 We are again proud to sponsor PyTexas and will have ... Read More

Feed: Planet MySQL; Author: Severalnines; Open source databases are quickly becoming mainstream, so migration from proprietary engines into open source engines is a kind of an industry trend now. It also means that we DBA’s often end up having multiple database backends to manage. In the past few blog posts, my colleague Paul Namuag and I covered several aspects of migration from Oracle to Percona, MariaDB, and MySQL. The obvious goal for the migration is to get your application up and running more efficiently in the new database environment, however it’s crucial to assure that staff is ready to support ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; MySQL Community with an APAC MySQL team are going to be part of the FOSSASIA Summit this week. We are a Bronze sponsor with a MySQL booth in the exhibition area. We are also having several talks in the Database track on Saturday, March 16, please see some of them below together with the details about the show: Name: FOSSASIA Summit 2019 Place: Singapore Date: March 14-17, 2019 MySQL talks in Database Track on Mar 16 in Training Room 2-1: "Replication: What's New in MySQL 8.0" by Narendra S Chauhan, the Principal Technical Staff ... Read More

Feed: Planet MySQL; Author: MinervaDB; MySQL error log contains diagnostics messages such as errors, warnings and notes that occur during MySQL startup, shutdown and while the server is running. For example, a InnoDB table is corrupted and need to repaired, This will be recorded in the error log. MySQL 8.0 Error uses the MySQL component architecture for log event filtering and writing. The MySQL system variable log_error_services controls which log components to enable and the rules for filtering the log events. The component table in the mysql system database contains the information about currently loaded comments and shows which components ... Read More

Feed: Planet MySQL; Author: Dave Stokes; I have had some requests to write some blogs on the basics of using PHP and MySQL together.  This will not be a series for the experienced as it will start at a level where I will go into a lot of details but expect very few prerequisites from the reader.  If this is not you, please move on. If it is you and you read something you do not understand, please contact me to show me where I assumed too much. PHP and MySQL are both in their mid twenties and both vital ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; Two weeks passed since my previous review of public MySQL bug reports I consider interesting enough to subscribe to them. Over this period I picked up a dozen or so new public bug reports that I'd like to briefly review today.Here is my recent subscriptions list, starting from the oldest bug reports:Bug #94431 - "Can't upgrade from 5.7 to 8.0 if any database have a hyphen in their name". It seems one actually needs a database like that created in MySQL 5.6 with at least one InnoDB table having FULLTEXT index to hit the ... Read More