Tag: MySQL 5.7

Feed: Planet MySQL; Author: Vlad Mihalcea; Follow @vlad_mihalcea Although there is an SQL Standard, every relational database is ultimately unique, and you need to adjust your data access layer so that you get the most out of the relational database in use. In this article, we are going to see what you can do to boost up performance when using MySQL with JPA and Hibernate. Every entity needs to have an identifier which uniquely identifies the table record associated with this entity. JPA and Hibernate allow you to automatically generate entity identifiers based on three different strategies: IDENTITY SEQUENCE TABLE ... Read More

Feed: Percona Database Performance Blog. Author: Bradley Mickel. Bradley Mickel  | October 9, 2017 |  Posted In: InnoDB, Insight for DBAs, MariaDB, MySQL PREVIOUS POST In this blog post, I’ll discuss some of the MySQL and MariaDB default configuration differences, focusing on MySQL 5.7 and MariaDB 10.2. Percona Server for MySQL uses the same defaults as MySQL, so I will not list them separately. MariaDB Server is a general purpose open source database, created by the founders of MySQL. MariaDB Server (referred to as MariaDB for brevity) has similar roots as Percona Server for MySQL, but is quickly diverging from MySQL compatibility ... Read More

Feed: Planet MySQL; Author: Ronald Bradford; Prior to MySQL 5.7 client communications with a MySQL instance were unencrypted by default. This plaintext capability allowed for various tools including pt-query-digest to analyze TCP/IP traffic. Starting with MySQL 5.7 SSL is enabled by default and will be used in client communications if SSL is detected on the server.We can detect and confirm this easily with the ngrep command. Default client connection traffic (5.6) On a MySQL 5.6 server we monitor the default MySQL port traffic. mysql56$ sudo ngrep -d eth1 -wi -P ' ' -W single -l port 3306 interface: eth1 (192.168.42.0/255.255.255.0) ... Read More

Feed: Planet MySQL; Author: MyDBOPS; Open Source India (OSI) is the premier Open Source conference in Asia targeted at nurturing and promoting the Open Source ecosystem in the subcontinent. Started as Linux Asia in 2004, OSI has been at the helm of bringing together the Open Source industry and the community since its inception. The objective of OSI is to convince you for the adoption of Open Source when you’re looking for software, using quantitative measures and NOT because these are cost free.. OSI emphasizes quantitative measures (such as use case experiments and case studies) to justify why using OSS is, in ... Read More

Feed: Percona Database Performance Blog. Author: Bradley Mickel. Bradley Mickel  | October 9, 2017 |  Posted In: InnoDB, Insight for DBAs, MariaDB, MySQL PREVIOUS POST In this blog post, I’ll discuss some of the MySQL and MariaDB default configuration differences, focusing on MySQL 5.7 and MariaDB 10.2. MariaDB Server is a general purpose open source database, created by the founders of MySQL. MariaDB Server (referred to as MariaDB for brevity) has similar roots as Percona Server for MySQL, but is quickly diverging from MySQL compatibility and growing on its own. MariaDB has become the default installation for several operating systems (such as ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; It was expected for a long time…. here is the fix for bug #199 !! The bug #199 submitted by PeterZ has been fixed in 8.0. Thank you to Zhang Simon for his contribution that inspired us to implement the fix. Let’s have a look at the test case described in the bug report, I will reproduce it on MySQL 5.7.19 & MySQL 8.0.3. The initial steps are exactly the same on both versions: mysql> create table a(id int unsigned not null primary key auto_increment); Query OK, 0 rows affected (0.17 sec) mysql> show ... Read More

Feed: Planet MySQL; Author: Dimitri Kravtchuk; The first release candidate of MySQL 8.0 is here, and I'm happy to share few performance stories about. This article will be about the "most simple" one -- our in-memory Read-Only performance ;-))However, the used test workload was here for double reasons : Going ahead to the second point, the main worry about New Sysbench was about its LUA overhead (the previous version 0.5 was running slower than the old one 0.4 due LUA) -- a long story short, I can confirm now that the New Sysbench is running as fast as the oldest ... Read More

Feed: Percona Database Performance Blog. Author: Alexander Rubin. Alexander Rubin  | October 1, 2017 |  Posted In: InnoDB, Insight for DBAs, MySQL, MySQL 8.0 PREVIOUS POST In my previous blog post, I talked about new general tablespaces in MySQL 8.0. Recently MySQL 8.0.3-rc was released, which includes a new data dictionary. My goal is to create one million tables in MySQL and test the performance. Background questions Q: Why million tables in MySQL? Is it even realistic? How does this happen? Usually, millions of tables in MySQL is a result of “a schema per customer” Software as a Service (SaaS) approach. For the purposes ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users, MySQL Connector/J 8.0.8 Development Release is a development milestonerelease for the 8.0.x series. This release includes the following new features and changes, alsodescribed in more detail on https://dev.mysql.com/doc/relnotes/connector-j/8.0/en/news-8-0-8.html MySQL Connectors and other MySQL client tools and applications nowsynchronize the first digit of their version number with the (highest)MySQL server version they support.This change makes it easy and intuitive to decide which client versionto use for which server version. As always, we recommend that you check the “CHANGES” file in the downloadarchive to be aware of changes in behavior that might affect your ... Read More

Feed: Percona Database Performance Blog. Author: Lorraine Pocklington. Lorraine Pocklington  | September 25, 2017 |  Posted In: Group Replication, High-availability, InnoDB, Insight for DBAs, Insight for Developers, MongoDB, MySQL, Percona Live PREVIOUS POST Welcome to the first day of the Percona Live Open Source Database Conference Europe 2017: Tutorials day! Technically the first day of the conference, this day focused on provided hands-on tutorials for people interested in learning directly how to use open source tools and technologies. Today attendees went to training sessions taught by open source database experts and got first-hand experience configuring, working with, and experimenting with various open source ... Read More