Tag: Database

Feed: Planet MySQL; Author: MySQL Performance Blog; Bronwyn Campbell | September 19, 2018 |  Posted In: Events and Announcements, MariaDB, MongoDB, MySQL, Percona Live, Percona Monitoring and Management, PMM, PostgreSQL PREVIOUS POST Percona has revealed the line-up of in-depth tutorials for the Percona Live Europe 2018 Open Source Database Conference, taking place November 5–7, 2018 at the Radisson Blu Hotel in Frankfurt, Germany. Secure your spot now with Advanced Registration prices. Be sure to buy your tickets soon as tickets prices will only head up, not down! Sponsorship opportunities for the conference are still available. Percona Live Europe 2018 Open Source Database Conference is the premier open source ... Read More

Feed: Planet PostgreSQL. When working with database capacity planning, there are a lot of variables to consider, and Postgres is no different in this regard. One of the elements which requires management is storage. However, there’s an aspect of storage that escapes inspection almost without exception, and it’s hiding in the shadows between the columns themselves. Alignment Basics In most low-level computer languages like C, in which the venerable Postgres is written, data types are addressed by their maximum size, regardless of how large they actually are. Thus a standard 32-bit integer which can store a value of just over ... Read More

Feed: Planet MySQL; Author: Tony Darnell; Using a trigger to parse non-conforming data in MySQL September 21, 2018 1 Comment In another post, I explained how to use the MySQL Query Re-write Plugin to manipulate data that didn’t exactly match SQL standards of MySQL. In this post, I am going to give you another example on how to use a trigger to parse non-conforming data so the data can be written to a MySQL database. A customer came to me with a problem. They were using third-party software which produced multiple rows of comma-separated data (like a .csv file), but all ... Read More

Feed: Neo4j Graph Database Platform. Author: Bryce Merkl Sasaki. By Leena Bengani, Director of Communications, Neo4j | September 21, 2018Reading time: 4 minutes Last night at GraphConnect 2018, we announced the 11 winners of the 2018 Neo4j Graphie Awards at the conference’s closing reception. The Graphie Awards celebrate the world’s most innovative graph technology applications, recognizing success in connected data across multiple categories – not only for Neo4j customers but across the entire Neo4j community and ecosystem.Partners, startup program members, data journalists, community members and ambassadors were all encouraged to submit their graph-based projects for consideration. We had a wonderful ... Read More

Feed: R-bloggers. Author: John Mount. I’ve ended up (almost accidentally) collecting a number of different solutions to the “use a column to choose values from other columns in R” problem. Please read on for a brief benchmark comparing these methods/solutions. What we did is: build a 1,000,000 row variation of the original example. In this variation we ensured that the selections are all valid column names, and removed any extra code that the methods had included to defend against mis-matches. We then timed 13 solution variations. We present the results in a graph here. For this plot: being more to ... Read More

Feed: Planet MySQL; Author: Shiv Iyer; There are several possibilities to end up with inconsistent MySQL replication, This could be accidental or intentional. In this blog I would like to discuss on how to identify the inconsistent slaves with master and fix them. I used here pt-table-checksum (to find the difference between master and slave) and pt-table-sync (to sync. between MySQL master and slave) from Percona Toolkit, The detailed documentation of Percona toolkit is available here for your reference. I expect / recommend you to be careful (as I mentioned above, sometimes records are inserted / deleted on MySQL slave intentionally) before ... Read More

Feed: Planet MySQL; Author: Colin Charles; Colin Charles | September 21, 2018 |  Posted In: MariaDB, MongoDB, MySQL, open source databases, Percona Server for MongoDB, Percona XtraDB Cluster, PostgreSQL PREVIOUS POST Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. This week is clearly what I’d call a “MariaDB week” — plenty of announcements coming from MariaDB Corporation and MariaDB Foundation. It started with Alibaba Cloud and MariaDB Announce the Launch of ApsaraDB RDS for MariaDB TX, which makes Alibaba Cloud the first public cloud to offer the enterprise offering of MariaDB, MariaDB ... Read More

Feed: Planet MySQL; Author: EverSQL; Knowing the bits and bytes of an SQL query’s order of operations can be very valuable, as it can ease the process of writing new queries, while also being very beneficial when trying to optimize an SQL query. If you’re looking for the short version, this is the logical order of operations, also known as the order of execution, for an SQL query: FROM, including JOINs WHERE GROUP BY HAVING WINDOW functions SELECT DISTINCT UNION ORDER BY LIMIT and OFFSET But the reality isn’t that easy nor straight forward. As we said, the SQL standard ... Read More

Feed: Planet MySQL; Author: Severalnines; The majority of DBA’s perform health checks on their databases every now and then. Usually, it would happen on a daily or weekly basis. We previously discussed why such checks are important and what they should include. To make sure your systems are in a good shape, you’d need to go through quite a lot of information - host statistics, MySQL statistics, workload statistics, state of backups, database packages, logs and so forth. Such data should be available in every properly monitored environment, although sometimes it is scattered across multiple locations - you may have ... Read More

Feed: What's New. Parallel Query takes advantage of Aurora’s architecture by pushing processing down to the Aurora storage layer, spreading computation across thousands of nodes. By pushing query computation down to the storage layer where possible, Parallel Query limits CPU, memory, and network contention with the core workload. The feature is available for the MySQL 5.6-compatible edition of Amazon Aurora, and is currently available in the US East (N. Virginia), US East (Ohio), US West (Oregon), EU (Ireland), and Asia Pacific (Tokyo) Regions. You can get started by creating an Aurora cluster in the Amazon RDS Management Console and enabling ... Read More