Tag: MariaDB

Feed: Planet MySQL; Author: Jean-François Gagné; I ended one of my last posts - Fun with InnoDB Persistent Statistics - with a cryptic sentence: there is more to say about this but I will stop here for now.  What I did not share at the time is the existence of a crashing bug somehow related to what I found.  But let's start with some context. In Bug#86926, I found a way to put more than 64 characters in the field table_name of the mysql.innodb_table_stats table (which is a varchar(64)).  This field uses the utf8 (utf8mb3) character set, so the internal ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; While MySQL 8.0.x hardly has much impact on my regular work, recent MySQL 5.7.20 release is something to check carefully. MySQL 5.7 is widely used in production, as a base for Percona Server 5.7, some features may be merged into MariaDB 10.x etc. So, here is my review of some community reported bugs that were fixed in recently released MySQL 5.7.20, based on the release notes.Usually I start with InnoDB bug fixes, but in 5.7.20 several related fixes were made only to bugs reported internally. So, this time I have to start with partitioning: ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . From MariaDB 10.3, setting the sql_mode system variable to Oracle causes the server to understand a subset of Oracle's PL/SQL language instead of the traditional MariaDB syntax for stored routines. This work is in progress. See MDEV-10142 and MDEV-10764 for the current status and subtasks. Providing compatibility for basic PL/SQL constructs - MDEV-10411 %TYPE in variable declarations - MDEV-10577 cursor%ROWTYPE in variable declarations - MDEV-12011 table%ROWTYPE in variable declarations - MDEV-12133 FOR loop statement - MDEV-10580 Implicit cursor FOR loop - MDEV-12098 Explicit cursor FOR LOOP - MDEV-10581 Cursors with parameters - ... Read More

Feed: Planet MySQL; Author: MariaDB; The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.58, as well as the recent release of MariaDB Connector/ODBC 3.0.2. These are both stable (GA) releases. See the release notes and changelog for details. Download MariaDB 5.5.58 Release Notes Changelog What is MariaDB 5.5? MariaDB APT and YUM Repository Configuration Generator Download MariaDB Connector/ODBC 3.0.2 Release Notes Changelog About MariaDB Connector/ODBC Thanks, and enjoy MariaDB! ... Read More

Feed: Planet MySQL; Author: Vlad Mihalcea; Follow @vlad_mihalcea 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 JPA and Hibernate. Every entity needs to have an identifier which uniquely identifies the table record associated with this entity. JPA and Hibernate allow you to automatically generate entity identifiers based on three different strategies: IDENTITY SEQUENCE TABLE ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . MariaDB 10.2 introduces a fair amount of new features. In the following will be explained what impact some of those features have, when used together with MaxScale 2.1. The parser of MariaDB MaxScale has not been extended with the window function syntax (the OVER keyword is not recognized) and hence statements using window functions will not be completely parsed. Since the database firewall filter will block all statements that cannot be completely parsed, all statements that use window functions will be blocked, if the database firewall filter is used. Otherwise the statements ... Read More

Feed: Percona Database Performance Blog. Author: Bradley Mickel. Bradley Mickel  | October 9, 2017 |  Posted In: InnoDB, Insight for DBAs, MariaDB, MySQL PREVIOUS POST In this blog post, I’ll discuss some of the MySQL and MariaDB default configuration differences, focusing on MySQL 5.7 and MariaDB 10.2. Percona Server for MySQL uses the same defaults as MySQL, so I will not list them separately. MariaDB Server is a general purpose open source database, created by the founders of MySQL. MariaDB Server (referred to as MariaDB for brevity) has similar roots as Percona Server for MySQL, but is quickly diverging from MySQL compatibility ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . This document is designed with a developer's point-of-view in mind. It explains the lifecycle of the module and details about its internal workings. It refers to the source code which can be found at GitHub. Source Files and Data Structures The schemarouter router consists of the schemarouter.h header file located in the server/modules/include/ directory and the schemarouter.c file located in the server/modules/routing/schemarouter directory. This router implements the router interface defined in the router.h file. The entry points and structures this router uses can be found in the header file. The two main ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . The Transaction Performance Monitoring (TPM) filter is a filter module for MaxScale that monitors every SQL statement that passes through the filter. The filter groups a series of SQL statements into a transaction by detecting 'commit' or 'rollback' statements. It logs all committed transactions with necessary information, such as timestamp, client, SQL statements, latency, etc., which can be used later for transaction performance analysis.The configuration block for the TPM filter requires the minimal filter options in it's section within the maxscale.cnf file, stored in /etc/maxscale.cnf.The TPM filter does not support any filter ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . This document and the attached example code explain prospective plugin developers the MariaDB MaxScale plugin API and also present and explain some best practices and possible pitfalls in module development. We predict that filters and routers are the module types developers are most likely to work on, so the APIs of these two are discussed in detail. Table of Contents Introduction MariaDB MaxScale is designed to be an extensible program. Much, if not most, of the actual processing is done by plugin modules. Plugins receive network data, process it and relay it ... Read More