Category: MySQL & MariaDB

Feed: Planet MySQL; Author: Jesper Krogh; The other day, I was reading a blog by Magnus Hagander about tracking foreign keys throughout a schema in PostgreSQL. I thought it was a good idea, so I decided to look at how you can track foreign key in MySQL. The way I decided to do it was to start out with a table, then find all tables referencing the table by a foreign key. From this basic (and simple as it will be shown) query, it is possible to create a chain of relations. The key table for the queries is information_schema.KEY_COLUMN_USAGE ... Read More

Feed: Planet MySQL; Author: Dave Stokes; JSON has proven to be a very import data format with immense popularity. A good part of my time for the last two or so years has been dedicated to this area and I even wrote a book on the subject.  This is a comparison of the implementations of handling JSON data in MySQL and MariaDB. I had requests from the community and customers for this evaluation. JSON Data Types Are Not All Equal MySQL added a JSON data type in version 5.7 and it has proven to be very popular.  MariaDB has  JSON ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; Recently, I did some maintenance on Innotop and I merged several pull requests including one to support MySQL 8.0 (thank you yoku0825 for the contribution). As you know, Innotop is written in Perl and to be able to use it with MySQL 8.0, you need to have Perl DBD for MySQL compatible with MySQL 8.0 too (a driver that support the new default authentication plugin, caching_sha2_password). If you are using Fedora 29, I created such package and you can download it here: perl-DBD-MySQL-4.046-5.mysql8.fc29.x86_64 We can see the difference between the default package and this ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; PREVIOUS POST Percona announces the release of Percona Server for MySQL 5.7.23-24 on November 12, 2018 (downloads are available here and from the Percona Software Repositories). This release merges changes of MySQL 5.7.23, including all the bug fixes in it. Percona Server for MySQL 5.7.23-24 is now the current GA release in the 5.7 series. All of Percona’s software is open-source and free. This release introduces InnoDB encryption improvements and merges upstream MyRocks changes. Also, we’ve improved the usage of column families in MyRocks. The InnoDB encryption improvements are in Alpha quality and we don’t recommend ... Read More

Feed: Planet MySQL; Author: Sugu Sougoumarane; We continue the digest from the Slack discussions for Sep 22 2018 to Oct 5 2018. We've fallen slightly behind on this, but will catch up again soon. Enable VtGateExecute in vtctld Arsalan [Sep 22nd] Hi, I want to query vitess on vtgate but I have below error. How can i fix this problem? vitess@vtctldv3-hrl74:/$ vtctlclient -server 10.5.61.20:16999  VtGateExecute -server 10.5.61.21:16991 "show tables" E0923 05:14:55.169771    1102 main.go:61] Remote error: rpc error: code = Unknown desc = query commands are disabled (set the -enable_queries flag to enable) sougou you need to add this flag ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; We are happy to confirm that we are ready for another two shows which will take place this week. One in the US second in Europe. Please find details below: PHP[World] Place: Washington DC, US Date: November 14-15, 2018 MySQL Community team is a Workshop sponsor here with David Stokes, the MySQL Community Manager as MySQL representative on site.  BGOUG Place: Pravets, Bulgaria Date: November 16, 2018 MySQL sponsors & attends this show for years. This year Georgi Kodinov, the Senior Software Developer Manager for MySQL will have a talk on "Data Masking ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; We are happy to announce that this Thursday, November 15 at 7:00 p.m., there will be a MySQL meetup in Madrid, Spain. Please find more details below:   Date: Nov 15, 2018 Time: 7:00-9:00pm Place: booking.com @ Torre Europa Paseo de la Castellana 95, Planta 11 · Madrid Agenda: Morgan Tocker: "TiDB: Distributed, horizontally scalable, MySQL compatible” Simon Mudd: "Vitess and MySQL Cluster" More information & registration can be found on the Meetup website: https://www.meetup.com/Madrid-MySQL-users-group/events/255291731/   Do not forget to register on the page if you are coming. '); } else { var ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; DOAG 2018 Conference + Exhibition will be held November 20 - 23, 2018 in Nuremberg. Participants will have the opportunity to attend more than 400 talks and international top speakers, plus a wide choice of workshops and community activities. This is a great opportunity to expand your knowledge and benefit from the know-how of the Oracle community. As in the past years we will be present with more than 10+ specific MySQL talks from various MySQL customer and MySQL experts. During the 3 conference days, you'll have the chance to meet the MySQL and Cloud experts ... Read More

Feed: Planet MySQL; Author: Matt Casters; Dear Kettle and Neo4j friends, Since I joined the Neo4j team in April I haven’t given you any updates despite the fact that a lot of activity has been taking place in both the Neo4j and Kettle realms. First and foremost, you can grab the cool Neo4j plugins from neo4j.kettle.be (the plugin in the marketplace is always out of date since it takes weeks to update the metadata). Then based on valuable feedback from community members we’ve updated the DataSet plugin (including unit testing) to include relative paths for filenames (for easier git support), to ... Read More

Feed: Planet MySQL; Author: David Stokes; The old adage that time is money does not give any hints about buying more time. A MySQL Enterprise subscription does allow you to purchase time. Your technical staff has to do more with less time than ever before and operational delays add up extremely quickly.  Having the right tools when things go critical means staff can do what they need to do, when they need to do it.So how does MySQL Enterprise Edition buy you more time?When things inevitably go wrong, searching for free answers to problems on web sites with many dubious ... Read More