Tag: MariaDB

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: MySQL Performance Blog; Laurie Coffin  | April 20, 2018 |  Posted In: AWS, Containers, Database Monitoring, MariaDB, MongoDB, MySQL, MySQL 8.0, open source databases, Percona Live PREVIOUS POST It’s hard to believe Percona Live 2018 starts on Monday! We’re looking forward to seeing everyone in Santa Clara next week! Here are some quick highlights to remember: In addition to all the amazing sessions and keynotes we’ve announced, we’ll be hosting the MySQL Community Awards and the Lightning Talks on Monday during the Opening Reception. We’ve also got a great lineup of demos in the exhibit hall all day ... 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: MySQL Performance Blog; Dave Avery  | April 23, 2018 |  Posted In: MariaDB, MongoDB, MySQL, Percona Live, PostgreSQL PREVIOUS POST Announcing the Percona Live 2018 live stream. This year at Percona Live Open Source Database Conference 2018 we are live streaming the Keynote Talks on Day 1 and 2. Percona is streaming the keynotes on Tuesday, April 24, 2018, and Wednesday, April 25, 2018 beginning at 9 AM PDT (both days). The keynote speakers include people from VividCortex, Upwork, Oracle, Netflix and many more. The keynote panels feature a cloud discussion and a cool technologies showcase. Use the live stream link if you don’t want ... Read More

Feed: Planet MySQL; Author: MariaDB; The MariaDB Foundation is pleased to announce the immediate availability of MariaDB 5.5.60. This is a stable (GA) release. See the release notes and changelog for details. Download MariaDB 5.5.60 Release Notes Changelog What is MariaDB 5.5? MariaDB APT and YUM Repository Configuration Generator Contributors to MariaDB 5.5.60 Alexander Barkov (MariaDB Corporation)Alexey Botchkov (MariaDB Corporation)Daniel Bartholomew (MariaDB Corporation)Daniel Black (IBM)Eugene Kosov (Tempesta)Igor Babaev (MariaDB Corporation)Karim Geiger (TYVR)Marko Mäkelä (MariaDB Corporation)Oleksandr Byelkin (MariaDB Corporation)Sachin Setiya (MariaDB Corporation)Sergei Golubchik (MariaDB Corporation)Varun Gupta (MariaDB Corporation)Vicențiu Ciorbaru (MariaDB Foundation)Vladislav Vaintroub (MariaDB Corporation)14 Contributors Thanks, and enjoy MariaDB! ... 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: MySQL Performance Blog; Borys Belinsky and Dmitriy Kostiuk  | April 20, 2018 |  Posted In: Events and Announcements, MongoDB, MySQL, Percona Toolkit PREVIOUS POST Percona announces the release of Percona Toolkit 3.0.9 on April 20, 2018. Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL®, MongoDB® and system tasks that are too difficult or complex to perform manually. With over 1,000,000 downloads, Percona Toolkit supports Percona Server for MySQL, MySQL, MariaDB®, Percona Server for MongoDB and MongoDB. Percona Toolkit, like all ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . XtraDB和InnoDB存储引擎中的AUTO_INCREMENT处理方式有着显著的性能改进。系统变量innodb_autoinc_lock_mode决定了auto-increments的锁模式。 传统的锁模式 设置innodb_autoinc_lock_mode=0，此为传统锁模式。在INSERT操作过程中，它会一直持有表级锁，直到插入语句结束。 连续锁模式 设置innodb_autoinc_lock_mode=1，该连续锁模式对大批量插入语句(例如LOAD DATA INFILE、INSERT ... SELECT语句)生效，对于这些插入语句，它会持有表锁直到插入操作结束。而对于单独的INSERT语句，它不会持有表锁这样重量级的锁，而是持有一个轻量级的、粒度更细的互斥锁，这显然更适合绝大多数插入环境。这是默认设置。 隔行交叉扫描锁模式 设置innodb_autoinc_lock_mode=2，插入操作不会持有任何表级锁。这是最快的插入模式，但对于statement-based replication来说不够安全。 初始化 直到MariaDB 10.2.3，InnoDB/XtraDB使用一个存储在内存中的自增长计数器。当mysqld服务重新启动的时候，计数器会重置，因此所有表的AUTO_INCREMENT = N也会重置。从MariaDB 10.2.4开始，该限制已经被移除了，AUTO_INCREMNT的值可以是持久的。虽然持久，但不意味着是事务安全的，某些情况下AUTO_INCREMENT的值会出现断层。例如，当INSERT IGNORE忽略了某些错误记录时，手动执行了ROLLBACK或ROLLBACK TO SAVEPOINT操作。 例如： CREATE TABLE t1 (pk INT AUTO_INCREMENT PRIMARY KEY, i INT, UNIQUE (i)) ENGINE=InnoDB; INSERT INTO t1 (i) VALUES (1),(2),(3); INSERT IGNORE INTO t1 (pk, i) VALUES (100,1); Query OK, 0 rows affected, 1 warning (0.099 sec) SELECT * FROM t1; +----+------+ | pk | i | +----+------+ | 1 | 1 | | 2 | 2 | | 3 | 3 | +----+------+ SHOW CREATE TABLE t1G *************************** 1. row ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . dbForge Documenter for MySQL is a handy MySQL and MariaDB documentation tool that automatically generates documentation of an entire MySQL database in HTML, PDF, and MARKDOWN file formats. The tool allows users to customize the generated documentation up to their needs with help of a bunch of options and settings. The key functionality of the tool includes the following features: Database structure from A to Z dbForge Documenter for MySQL extracts an extensive database info about all MySQL objects, including their details, properties, SQL script and inter-object dependencies. Rich customization options Documenter ... Read More

Feed: Planet MySQL; Author: Colin Charles; Colin Charles  | April 13, 2018 |  Posted In: Amazon Aurora, AWS, MariaDB, MongoDB, MyRocks, MySQL, Percona Monitoring and Management, Percona Software, Percona XtraBackup, ProxySQL PREVIOUS POST Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Percona Live is just over a week away — there’s an awesome keynote lineup, and you really should register. Also don’t forget to save the date as Percona Live goes to Frankfurt, Germany November 5-7 2018! Prost! In acquisitions, we have seen MariaDB acquire MammothDB and Idera acquire Webyog. Some ... Read More