Tag: MySQL 8.0

Feed: Planet MySQL; Author: Dimitri Kravtchuk; 2018-08-14 15:00 | MySQL, Performance, InnoDB, Benchmarks, Sysbench, IO-bound, Optane, DoubleWrite, Binlog This article is inspired by Percona blog post comparing MySQL 8.0 and Percona Server 5.7 on IO-bound workload with Intel Optane storage. There are several claims made by Vadim based on a single test case, which is simply unfair. So, I'll try to clarify this all based on more test results and more tech details.. But before we start, some intro : InnoDB Parallel Flushing -- was introduced with MySQL 5.7 (as a single-thread flushing could no more follow), and implemented as ... Read More

Feed: Planet MySQL; Author: Jesper Krogh; MySQL 8.0 introduced a new feature that allows you to persist configuration changes from inside MySQL. Previously you could execute SET GLOBAL to change the configuration at runtime, but you needed to update your MySQL configuration file in order to persist the change. In MySQL 8.0 you can skip the second step. This blog discuss how this works and how to backup and restore the configuration. Using SET PERSIST to set a variable and the persisted_variables table in the Performance Schema to get a list of persisted variables.Persisting Variables You persist changes with either ... Read More

Feed: Planet MySQL; Author: FromDual; A while ago we released our FromDual Backup and Recovery Manager (brman) 2.0.0 for MariaDB and MySQL. So what are the new cool features of this new release?First of all brman 2.0.0 is compatible with MariaDB 10.3 and MySQL 8.0: shell> bman --target=brman:secret@127.0.0.1:3318 --type=full --mode=logical --policy=daily Reading configuration from /etc/mysql/my.cnf Reading configuration from /home/mysql/.my.cnf No bman configuration file. Command line: /home/mysql/product/brman-2.0.0/bin/bman.php --target=brman:******@127.0.0.1:3318 --type=full --mode=logical --policy=daily Options from command line target = brman:******@127.0.0.1:3318 type = full mode = logical policy = daily Resulting options config = target = brman:******@127.0.0.1:3318 type = full mode = logical policy ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Dimitri Vanoverbeke | August 13, 2018 |  Posted In: AWS, MySQL, MySQL 8.0, Technical Webinars PREVIOUS POST Please join Percona’s Solution Engineer, Dimitri Vanoverbeke as he presents Amazon Migration Service: The Magic Wand to Migrate Away from Your Proprietary Environment to MySQL on Tuesday, August 14th, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). In this talk, we will learn about the Amazon Migration Tool. The talk will cover the possibilities, potential pitfalls prior to migrating and a high-level overview of its functionalities. Register Now PREVIOUS POST Dimitri VanoverbekeAt the age of 7, ... Read More

Feed: Planet MySQL; Author: MyDBOPS; MySQL replication has evolved a lot in 5.6 ,5.7 and 8.0. This presentation focus on the changes made in parallel replication. It covers MySQL 8.0. It was presented at Mydbops database meetup on 04-08-2016 in Bangalore. Advertisements ... Read More

Feed: Planet MySQL; Author: EverSQL; Introduction The goal of this article is to evaluate and highlight the main similarities and differences between the MySQL Server Database and the MariaDB Server Database. We’ll look into performance aspects, security, main features, and list all aspects which need to be considered before choosing the right database for your requirements. Who is using MySQL and MariaDB? Both MySQL and MariaDB publish a respectful list of customers who are using their database as their core data infrastructure.You can speed up any SQL query, automatically. Try it now for free. For MySQL, we can see names ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; In my recent blog posts I presented lists of bugs, fixed and not yet fixed, as usual. Working on these lists side tracked me from the main topic of this summer - problems in Oracle's way of handling MySQL. Time to get back on track!Among things Oracle could do better for MySQL I mentioned QA: "Oracle's internal QA efforts still seem to be somewhat limited. We get regression bugs, ASAN failures, debug assertions, crashes, test failures etc in the official releases, and Oracle MySQL still relies a lot on QA by MySQL Community (while ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; This year again, the MySQL Team is eager to participate in the Oracle Open World conference. This is a great opportunity for our engineers and the entire MySQL Team to highlight what we’ve done, and also what we are working on. Another reason to be excited this year is our new participation to Code One, the Oracle developer focused conference. Oracle Code One will include a full track dedicated to MySQL. This is very good news for everybody attending, from DBAs to developers, as we will offer even more great content ! This year, ... Read More

Feed: Planet MySQL; Author: Colin Charles; Colin Charles | August 10, 2018 |  Posted In: Events and Announcements, MariaDB, MongoDB, MySQL, PostgreSQL, ProxySQL PREVIOUS POST Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. The call for submitting a talk to Percona Live Europe 2018 is closing today, and while there may be a short extension, have you already got your talk submitted? I suggest doing so ASAP! I’m sure many of you have heard of cryptocurrencies, the blockchain, and so on. But how many of you realiize that Coinbase, an ... Read More

Feed: Planet MySQL; Author: Jesper Krogh; MySQL has since version 5.7 had support for progress information for some queries. As promised in my previous post, I will here discuss how you can use that to get progress information for ALTER TABLE on InnoDB tables. Progress information is implemented through the Performance Schema using the stage events. In version 8.0.12 there are currently seven stages that can provide this information for  ALTER TABLE statements on InnoDB tables. In MySQL 8, it is easy to list the stages capable of reporting progress information by using the setup_instruments Performance Schema table: mysql> SELECT ... Read More