Tag: query

Feed: Planet MySQL; Author: Peter Gulutzan; Let's start by combining one new MariaDB feature -- VALUES (5) which is the standard equivalent of the old non-standard "SELECT 5" -- with another new feature in MariaDB 10.3.5, the FOR ... END FOR statement. mariadb>BEGIN NOT ATOMIC > DECLARE v INT DEFAULT 0; > FOR a IN (VALUES (7)) DO SET v = v + 1; END FOR; > SELECT v; >END; Error 2013 (HY000) Lost connection to MySQL server during query Oops. However, the MariaDB folks now know about this, it's bug MDEV-15940" and they know about the other bugs that ... Read More

Feed: Planet MySQL; Author: Open Query; Sometimes you want to reduce disk usage on certain servers by adjusting the time that binary logs are kept.  Also, some installations of MySQL and MariaDB have suffered from a very-hard-to-catch bug where the binary logs end up not getting automatically expired (basically, the expire_logs_days option doesn’t always work effectively). A workaround can be scripted, but typically the script would specify the exact datetime to which the logs need to be kept.  The reference manual and examples all do this too, quite explicitly, noting: The datetime expression is in the format ‘YYYY-MM-DD hh:mm:ss’. However, ... Read More

Feed: Planet MySQL; Author: Tony Darnell; MySQL Enterprise Edition Database Firewall – Control and Monitor SQL Statement Executions April 23, 2018 Leave a comment As of MySQL 5.6.24, MySQL Enterprise Edition includes MySQL Enterprise Firewall, an application-level firewall (it runs within the mysql database process) that enables database administrators to permit or deny SQL statement execution based on matching against whitelists of accepted statement patterns. This helps harden MySQL Server against attacks such as SQL injection or attempts to exploit applications by using them outside of their legitimate query workload characteristics. Each MySQL account registered with the firewall has its own ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; This post serves as a quick start guide on how to use the MySQL Document Store with the official Node.js connector. It mainly highlights how easy it is to leverage CRUD-style operations and getting up and running with the X DevAPI. Make sure you have Node.js 7.6.0 (or higher) and MySQL 8.0.11 (or higher) installed on your machine. First, using the command line, let’s start by creating a directory for our sample application. $ mkdir myproject$ cd myproject Create a package.json manifest file using the following command: $ npm init -y Next, install the MySQL ... Read More

Feed: Planet MySQL; Author: Federico Razzoli; NOWAIT, WAIT and SKIP LOCKED are syntaxes added in MySQL 8.0 and MariaDB 10.3. The idea came from AliSQL (MySQL fork by Alibaba). It was revisited in MySQL, and I am not aware if MariaDB used the original implementation. While MySQL and MariaDB syntaxes are similar, there are important differences and the compatibility is only apparent. This article discusses these differences. WAIT This syntax is only available in MariaDB. It means that, if a row or table that we want to read is write-locked, we can wait up to the specified number of seconds ... Read More

Feed: Planet MySQL; Author: The Pythian Group; Introduction In this post we will explore one approach to MySQL high availability with HAProxy, Consul and Orchestrator.Let’s briefly go over each piece of the puzzle first:– HAProxy is usually installed on the application servers or an intermediate connection layer, and is in charge of connecting the application to the appropriate backend (reader or writer). The most common deployment I’ve seen is to have separate ports for writes (which are routed to the master) and reads (which are load balanced over a pool of slaves).– Orchestrator’s role is to monitor the topology and ... Read More

Feed: Planet MySQL; Author: MySQL Server Dev Team; The MySQL Development Team is proud to announce the second GA release of InnoDB cluster! We listened carefully to the feedback we got from the previous major release (1.0 GA) and the last release candidate (8.0.4 RC) and incorporated many of the suggested changes. And that’s not all, we have introduced exciting new features and fixed several bugs to reach the desired maturity state. Here are the highlights of this release! MySQL Shell 8.0 For this release, we have, as always, focused on the usability of InnoDB cluster as a whole. With ... Read More

Feed: Microsoft Azure Blog. Author: Chandrika Shankarnarayan. Today we’re pleased to announce two key capabilities that Azure Time Series Insights will be delivering later this year: A cost-effective long-term storage that enables a cloud-based solution to trend years’ worth of time series data pivoted on devices/tags.  A device-based (also known industry-wide as “tag-based”) user experience backed by a time series model to contextualize raw time series data with device metadata and domain hierarchies. Additionally, Time Series Insights will be integrating with advanced machine learning and analytics tools like Spark and Jupyter notebooks to help customers tackle time series data challenges ... Read More

Feed: Planet MySQL; Author: Federico Razzoli; MySQL 8.0 is out. Is this a great piece of news? No. But MySQL 8.0 is wonderful, and this IS a great piece of news! It has lots of interesting features, really. Oracle advertised some of them very well with talks at conferences, blog posts, etc. However I am very pleased by a features that they did not advertised at all: resource groups. The documentation describes them in detail, but here is a small recap. As we all know, MySQL has system (background) threads, and user (foreground) threads. Until now, nothing could be done ... Read More

Feed: Planet MySQL; Author: Kedar Vaijanapurkar; Restore requests are common and so are the restores of specific entities: a database, or one or more table(s). This has been discussed a lot and we have plenty of tools and solutions already available.In this blog post we will cover an interesting solution that I came across when I received a restoration request from a client with a specific scenario. The scenario? Well, the client was on a Windows server with 400GB of mysqldump and wanted to restore a table. As Linux players we already know of some tools and techniques to export ... Read More