Planet MySQL

Planet MySQL - https://planet.mysql.com
  1. The following query gets data from performance_schema in MySQL and attempts to regex the digest to the list of tables in the same schema. SELECT d.*, (SELECT group_concat(distinct TABLE_NAME) FROM information_schema.TABLES WHERE table_schema = d.schema_name and d.digest_text regexp table_name) table_name FROM performance_schema.events_statements_summary_by_digest d WHERE d.DIGEST_TEXT regexp "^(SELECT|UPDATE|DELETE|REPLACE|INSERT|CREATE)" and d.LAST_SEEN >= curdate() - interval 7 day ORDER BY d.SUM_TIMER_WAIT DESC limit 10\G
  2. Introduction 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 … Continue reading 9 High-Performance Tips when using MySQL with JPA and Hibernate →
  3. MySQL Server 5.7.20, 5.6.38, and 5.5.58, new versions of the popular Open Source Database Management System, have been released. These releases are recommended for use on production systems. For an overview of what’s new, please see http://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html http://dev.mysql.com/doc/refman/5.5/en/mysql-nutshell.html For information on installing the release on new servers, please see the MySQL installation documentation at […]
  4. Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Beyond spending time getting ready for Velocity and Open Source Summit Europe this week, there was some feature testing this week that compared MySQL and MariaDB. Naturally, a long report/blog is coming soon. Stay tuned. Releases I reckon a lot of folks are swamped after Percona Live Europe Dublin and Oracle OpenWorld, so the releases in the MySQL universe are a bit quieter. Percona Monitoring and Management 1.3.2. Fixes around Query Analytics MariaDB 10.3.2. Another alpha release that included instant ADD COLUMN contributed by Tencent, as well as storage-engine-independent column compression contributed by Tencent/AliSQL. Percona Server for MySQL has column compression, but this is naturally a different implementation. Read more about Storage-Engine-Independent Column Compression, compare it with Compressed columns with dictionaries if you like, and probably the best documentation for instant ADD COLUMN is this blog post. Link List Query Analyzer: A Tool for Analyzing MySQL Queries Without Overhead. This is a cool post from LinkedIn. How To Test the Database. Daniel Nichter of Hack MySQL fame now writes at his new site, Hack Mongo. Different I/O Access Methods for Linux, What We Chose for Scylla, and Why. While the article has ScyllaDB in the title, it stands on its own when it comes to learning about different I/O patterns and tradeoffs. Well worth a read. Distributed consistency at scale: Spanner vs. Calvin The MySQL 8.0.3 release candidate has backup locks, quite similar to what’s been in Percona Server for MySQL. This is great news! Andy Jassy tweeted that Amazon Web Services Database Migration Service just hit 40,000 migrations. This is amazing, considering the service launched late 2015 and the general idea has always been “migrations are hard, start your next database project with the new tool.” Upcoming Appearances Percona’s website keeps track of community events, so check out where to see and listen to a Perconian speak. My upcoming appearances are: Velocity Europe – 17-20 October 2017, London, UK Open Source Summit Europe – 23-26 October 2017, Prague, Czech Republic Feedback I was asked why there weren’t many talks from MariaDB Foundation / MariaDB Corporation at Percona Live Europe 2017. Simple answer: there were hardly any submissions. We had two talk submissions from one speaker from the MariaDB Foundation (we accepted the one on MariaDB 10.3). There was another talk submission from a speaker from MariaDB Corporation (again, accepted). We announced the second talk in the sneak preview, but the talk was canceled as the speaker was unable to attend. We did, however, have a deep breadth of talks about MariaDB, with many talks that discussed high availability, security, proxies and the like. I look forward to feedback/tips via e-mail at colin.charles@percona.com or on Twitter @bytebot.
  5. What’s New in MariaDB Connector/ODBC 3.0 RalfGebhardt Fri, 10/13/2017 - 09:16 We are pleased to announce the general availability (GA) of MariaDB Connector/ODBC 3.0. MariaDB Connector/ODBC 3.0.2 is the newest version of MariaDB Connector/ODBC. This release is compatible with MariaDB Connector/ODBC 2.0 – no code changes necessary to upgrade. MariaDB Connector/ODBC 3.0 is based on the new MariaDB Connector/C 3.0. It therefore takes advantage of the new security enhancements and plugins provided by MariaDB Connector/C. Direct dependencies to functions of MariaDB Connector/C have been removed, only the functions provided by the documented API are used. This allows dynamic linking where preferred. Our own binaries still use the static linking. New features Support of a new bulk load implementation (needs MariaDB Server 10.2) SQLExecDirect, Prepares and executes a statement directly (needs MariaDB Server 10.2) New SSL options based on the implementation in MariaDB Connector/C GnuTLS Windows SChannel: removes dependencies on external libraries Windows SChannel: becomes the default for SSL on Windows  TLSv1.1 and TLSv1.2 support SSL option can now be defined in the setup dialog Download the MariaDB Connector now and learn about the newest evolution of MariaDB Connector/ODBC 3.0. Developer MariaDB Releases We are pleased to announce the general availability (GA) of MariaDB Connector/ODBC 3.0. MariaDB Connector/ODBC 3.0.2 is the newest version of MariaDB Connector/ODBC. This release is compatible with MariaDB Connector/ODBC 2.0 – no code changes necessary to upgrade. Login or Register to post comments