Tag: MySQL 8.0

Feed: Planet MySQL; Author: Oracle MySQL Group; We would like to announce the shows & conferences where you can find MySQL Community Team or MySQL representatives at. Please be aware that the list below could be subject of change. October 2018 GITEX, Dubai, United Arab Emirates, October 14-18, 2018 Same as last year Oracle & MySQL are part of GITEX converence. There is an Oracle booth (Stand A5-01, Hall 5) as well as MySQL one (POD2, Hall 5) where you can find us.  ZendCon, Las Vegas, US, October 15-17, 2018 We are Exhibitor sponsor same as last year, however newly ... Read More

Feed: Planet MySQL; Author: Jaime Crespo; Jaime Crespo  | October 15, 2018 |  Posted In: Events, MariaDB, MySQL, Open Source Databases PREVIOUS POSTFor Percona Live Europe this year, I got accepted a workshop on query optimization and a 50-minute talk covering TLS for MySQL at Large Scale, talking about our experiences at the Wikimedia Foundation.WorkshopThe 3-hour workshop on Monday, titled Query Optimization with MySQL 8.0 and MariaDB 10.3: The Basics is a beginners’ tutorial–though dense in content. It’s for people who are more familiar with database storage systems other than InnoDB for MySQL, MariaDB or Percona Server. Or who, already familiar with ... Read More

Feed: Planet MySQL; Author: Percona Community; Alexey Mikotkin  | October 12, 2018 |  Posted In: Entry Level, MariaDB, MySQL, Tools PREVIOUS POSTThere are a number of options for generating ID values for your tables. In this post, Alexey Mikotkin of Devart explores your choices for generating identifiers with a look at auto_increment, triggers, UUID and sequences.AUTO_INCREMENTFrequently, we happen to need to fill tables with unique identifiers. Naturally, the first example of such identifiers is PRIMARY KEY data. These are usually integer values hidden from the user since their specific values are unimportant.When adding a row to a table, you need to take ... Read More

Feed: Planet MySQL; Author: MyDBOPS; Mydbops has partnered with OSI days for the second consecutive year. OSI days is one of the Asia’s leading  open source conference. Presentations on MySQL  Topic        : Evolution of DBA’s in Cloud Presenter : Manosh Malai ,Senior Devops / DB Consultant Mydbops Kabilesh P R. Co-Founder / DB Consultant Mydbops As Cloud is more widely adopted by industry now DBA’s should focus on ramping up their Skills on core optimisation and designing more scalable database. Our consultants emphasis the role of DBA in cloud environment and share their experience in handling large scale ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; PREVIOUS POST The second alpha build of Percona XtraBackup 8.0.2 is now available in the Percona experimental software repositories. Note that, due to the new MySQL redo log and data dictionary formats, the Percona XtraBackup 8.0.x versions will only be compatible with MySQL 8.0.x and Percona Server for MySQL 8.0.x. This release supports backing up Percona Server 8.0 Alpha. For experimental migrations from earlier database server versions, you will need to backup and restore and using XtraBackup 2.4 and then use mysql_upgrade from MySQL 8.0.x PXB 8.0.2 alpha is available for the following ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; PREVIOUS POST Probably not well known but quite an important optimization was introduced in MySQL 5.6 – reduced overhead for “read only transactions”. While usually by a “transaction” we mean a query or a group of queries that change data, with transaction engines like InnoDB, every data read or write operation is a transaction. Now, as a non-locking read operation obviously has less impact on the data, it does not need all the instrumenting overhead a write transaction has. The main thing that can be avoided, as described by documentation, is the transaction ... Read More

Feed: Planet MySQL; Author: Geir Hoydalsvik; The MySQL Development team is very happy to announce that MySQL 8.0.13, the second 8.0 Maintenance Release, is now available for download at dev.mysql.com. In addition to bug fixes there are a few new features added in this release.  Please download 8.0.13 from dev.mysql.com or from the MySQL  Yum,  APT, or SUSE repositories.… ... Read More

Feed: Planet MySQL; Author: rathishDBA; The MySQL Replication was my first project as a Database Administrator (DBA) and I have been working with Replication technologies for last few years and I am indebted to contribute my little part for development of this technology. MySQL supports different replication topologies, having better understanding of basic concepts will help you in building and managing various and complex topologies. I am writing here, some of the key points to taken care when you are building MySQL replication. I consider this post as a starting point for building a high performance and consistent MySQL servers ... Read More

Feed: Planet MySQL; Author: Jesper Krogh; Since MySQL 5.6, the digest feature of the MySQL Performance Schema has provided a convenient and effective way to obtain statistics of queries based on their normalized form. The feature works so well that it has almost completely (from my experience) replaced the connector extensions and proxy for collecting query statistics for the Query Analyzer (Quan) in MySQL Enterprise Monitor (MEM). MySQL 8 adds further improvements to the digest feature in the Performance Schema including a sample query with statistics for each digest, percentile information, and a histogram summary. This blog will explore these ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; PREVIOUS POST The second alpha build of Percona XtraBackup 8.0.2 is now available in the Percona experimental software repositories. Note that, due to the new MySQL redo log and data dictionary formats, the Percona XtraBackup 8.0.x versions will only be compatible with MySQL 8.0.x and Percona Server for MySQL 8.0.x. This release supports backing up Percona Server 8.0 Alpha. For experimental migrations from earlier database server versions, you will need to backup and restore and using XtraBackup 2.4 and then use mysql_upgrade from MySQL 8.0.x PXB 8.0.2 alpha is available for the following ... Read More