May 2012 - discuss - lists.mariadb.org

[Maria-discuss] explain for insert/update/delete
by MARK CALLAGHAN 08 Jul '25

08 Jul '25

Does MariaDB have any plans to support explain for insert/update/delete/replace/CTAS? There have been feature requests open for a very long time on official MySQL without any progress. I have had a few problems in production from 'bad' delete statements that had a very different plan than the select statement with the same where clause. The only way to check for a bad plan today is to use SHOW INNODB STATUS to determine whether the statement locks all rows in a table. http://bugs.mysql.com/bug.php?id=14745 http://bugs.mysql.com/bug.php?id=35355 -- Mark Callaghan mdcallag(a)gmail.com

3 3

[Maria-discuss] Compiling 5.5.20 on OS X
by Richard Dunn 03 Jun '12

03 Jun '12

I've been compiling MySQL and MariaDB on OS X for quite some time now, but this is the first time that I have ever used CMake to build an application. The 'make' step consistently fails with the following: Linking CXX executable ma_pagecache_consist_1k-t Undefined symbols for architecture x86_64: "_key_PAGECACHE_cache_lock", referenced from: _init_pagecache in libaria.a(ma_pagecache.c.o) ld: symbol(s) not found for architecture x86_64 I assume libaria.a is Maria specific. As a sanity check, I downloaded the MySQL source code for 5.5.21 from the MySQL site and I successfully compiled everything with CMake. Has anyone else successfully compiled a 64 bit 5.5.20 MariaDB on OS X? What am I missing?

5 9

[Maria-discuss] MariaDB 5.5.24 now available
by Daniel Bartholomew 31 May '12

31 May '12

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.24. This is a stable (GA) release. It includes MariaDB 5.3.7 and MySQL 5.5.24. This version of MariaDB introduces new RPM packages for RHEL 5, CentOS 5 & 6, and Fedora 16. We have also created YUM repositories for those distributions. Setup instructions are available here: http://kb.askmonty.org/en/installing-mariadb-with-yum/ We are also now offering packages for BSD 9, MacOS X 10.5 (will be available within 24 hours), and Ubuntu 12.04 "Precise" (via our Ubuntu APT repository). - - MariaDB 5.5 Links - - - - - - - - - - - - - - - - - - - - - - - - - Release Notes: http://kb.askmonty.org/en/mariadb-5524-release-notes Changelog: http://kb.askmonty.org/en/mariadb-5524-changelog Downloads: http://downloads.askmonty.org/mariadb/5.5.24 APT and YUM Repository Configuration Generator: http://downloads.askmonty.org/mariadb/repositories/ Overview of MariaDB 5.5: http://kb.askmonty.org/en/what-is-mariadb-55 - - MariaDB Crash Course - - - - - - - - - - - - - - - - - - - - - - - The MariaDB-specific book, MariaDB Crash Course, by Ben Forta, is an excellent way to learn more about MariaDB. This book - for beginner to intermediate level users - will get you up and running with MariaDB, even if you've never used a database before. More information is available at: http://forta.com/books/0321799941/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "plugin-load=feedback.so" to your my.cnf file! On Windows, add "feedback=ON" to your my.ini file, or click the checkbox during the installation of the MSI package. See http://kb.askmonty.org/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: https://bugs.launchpad.net/maria - - Where else to find us - - - - - - - - - - - - - - - - - - - - - - - We're on Facebook: http://www.facebook.com/MariaDB.dbms We're on Twitter: http://twitter.com/#!/mariadb We're on Google Plus: http://gplus.to/mariadb We hope you enjoy MariaDB! -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0