- discuss - lists.mariadb.org

[Maria-discuss] "libmysqlclient.so.18 no version information" issue
by Terry 07 Aug '12

07 Aug '12

Hello, I am a relative newbie learning about Linux/MariaDB. I have a test server running Debian Squeeze 6.0.4 with MariaDB 5.5 installed from the MariaDB Squeeze repository. Everything worked great. I upgraded Squeeze to Wheezy (do have a back up so no issue reverting if necessary). Upgrade went rather smoothly. MariaDB running fine. Everything else working fine. On the first night after the upgrade, cron ran and I received several errors: /usr/lib/libmysqlclient.so.18: no version information available (required by exim4) /usr/lib/libmysqlclient.so.18: no version information available (required by /usr/lib/libmu_auth.so.4) The errors don't seem to cause any problems. I still get the e-mails sent by cron. Exim4 is running fine and I have no problems sending or receiving mail. MariaDB is doing fine and my test websites are performing as expected. Can someone give me a hint about where to start looking for the solutio to this? I've googled this and really couldn't find much info about it. Is this because the MariaDB deb package from the repo was built against Squeeze? If so, would the error be corrected if I downloaded the source and built it against Wheezy? Thanks. -- Terry

2 2

[Maria-discuss] MariaDB 5.5 compile error
by Brian Evans 07 Aug '12

07 Aug '12

Hi, I would like some assistance in figuring out a compile error in MariaDB 5.5 series (tested on 5.5.25). I'm trying to create a minimal (client only) build of 5.5.25. This is the cmake configure command used: cmake --no-warn-unused-cli -C /var/tmp/portage/dev-db/mariadb-5.5.25/work/mariadb-5.5.25_build/gentoo_common_config.cmake -DCMAKE_INSTALL_PREFIX=/usr -DCMAKE_INSTALL_PREFIX=/usr -DMYSQL_DATADIR=/var/lib/mysql -DSYSCONFDIR=/etc/mysql -DINSTALL_BINDIR=bin -DINSTALL_DOCDIR=share/doc/mariadb-5.5.25 -DINSTALL_DOCREADMEDIR=share/doc/mariadb-5.5.25 -DINSTALL_INCLUDEDIR=include/mysql -DINSTALL_INFODIR=share/info -DINSTALL_LIBDIR=lib64/mysql -DINSTALL_MANDIR=share/man -DINSTALL_MYSQLDATADIR=/var/lib/mysql -DINSTALL_MYSQLSHAREDIR=share/mysql -DINSTALL_MYSQLTESTDIR=share/mysql/mysql-test -DINSTALL_PLUGINDIR=lib64/mysql/plugin -DINSTALL_SBINDIR=sbin -DINSTALL_SCRIPTDIR=share/mysql/scripts -DINSTALL_SQLBENCHDIR=share/mysql -DINSTALL_SUPPORTFILESDIR=/usr/share/mysql -DWITH_COMMENT=Gentoo Linux mariadb-5.5.25 -DWITHOUT_UNIT_TESTS=1 -DNOT_FOR_DISTRIBUTION=1 -DDEFAULT_CHARSET=latin1 -DDEFAULT_COLLATION=latin1_swedish_ci -DWITHOUT_SERVER=1 -DWITHOUT_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DINSTALL_SQLBENCHDIR= -DWITH_SSL=system -DWITH_ZLIB=system -DWITHOUT_LIBWRAP=1 -DWITHOUT_READLINE=1 -DWITHOUT_ARCHIVE_STORAGE_ENGINE=1 -DWITHOUT_BLACKHOLE_STORAGE_ENGINE=1 -DWITHOUT_CSV_STORAGE_ENGINE=1 -DWITHOUT_FEDERATED_STORAGE_ENGINE=1 -DWITHOUT_HEAP_STORAGE_ENGINE=1 -DWITHOUT_INNOBASE_STORAGE_ENGINE=1 -DWITHOUT_MYISAMMRG_STORAGE_ENGINE=1 -DWITHOUT_MYISAM_STORAGE_ENGINE=1 -DWITHOUT_PARTITION_STORAGE_ENGINE=1 -DWITHOUT_INNOBASE_STORAGE_ENGINE=1 -DCMAKE_BUILD_TYPE=RelWithDebInfo -DCMAKE_INSTALL_DO_STRIP=OFF -DCMAKE_USER_MAKE_RULES_OVERRIDE=/var/tmp/portage/dev-db/mariadb-5.5.25/work/mariadb-5.5.25_build/gentoo_rules.cmake /var/tmp/portage/dev-db/mariadb-5.5.25/work/mysql gives the following error during build /var/tmp/portage/dev-db/mariadb-5.5.25/work/mysql/mysys/waiting_threads.c:196:21: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘key_WT_RESOURCE_cond’ make[2]: *** [mysys/CMakeFiles/mysys.dir/waiting_threads.c.o] Error 1 However, if i build the full server, I get no error. cmake configure with no error: cmake --no-warn-unused-cli -C /var/tmp/portage/dev-db/mariadb-5.5.25/work/mariadb-5.5.25_build/gentoo_common_config.cmake -DCMAKE_INSTALL_PREFIX=/usr -DCMAKE_INSTALL_PREFIX=/usr -DMYSQL_DATADIR=/var/lib/mysql -DSYSCONFDIR=/etc/mysql -DINSTALL_BINDIR=bin -DINSTALL_DOCDIR=share/doc/mariadb-5.5.25 -DINSTALL_DOCREADMEDIR=share/doc/mariadb-5.5.25 -DINSTALL_INCLUDEDIR=include/mysql -DINSTALL_INFODIR=share/info -DINSTALL_LIBDIR=lib64/mysql -DINSTALL_MANDIR=share/man -DINSTALL_MYSQLDATADIR=/var/lib/mysql -DINSTALL_MYSQLSHAREDIR=share/mysql -DINSTALL_MYSQLTESTDIR=share/mysql/mysql-test -DINSTALL_PLUGINDIR=lib64/mysql/plugin -DINSTALL_SBINDIR=sbin -DINSTALL_SCRIPTDIR=share/mysql/scripts -DINSTALL_SQLBENCHDIR=share/mysql -DINSTALL_SUPPORTFILESDIR=/usr/share/mysql -DWITH_COMMENT=Gentoo Linux mariadb-5.5.25 -DWITHOUT_UNIT_TESTS=1 -DNOT_FOR_DISTRIBUTION=1 -DDEFAULT_CHARSET=latin1 -DDEFAULT_COLLATION=latin1_swedish_ci -DENABLED_LOCAL_INFILE=1 -DEXTRA_CHARSETS=all -DMYSQL_USER=mysql -DMYSQL_UNIX_ADDR=/var/run/mysqld/mysqld.sock -DWITHOUT_READLINE=1 -DWITH_ZLIB=system -DWITHOUT_LIBWRAP=1 -DDISABLE_SHARED=OFF -DWITH_debug=OFF -DWITH_DEBUG=OFF -DWITH_Debug=OFF -DWITH_EMBEDDED_SERVER=OFF -DWITH_profiling=ON -DWITH_PROFILING=ON -DWITH_Profiling=ON -DENABLE_DTRACE=OFF -DWITH_SSL=system -DCMAKE_EXE_LINKER_FLAGS=-ljemalloc -DWITH_SAFEMALLOC=OFF -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_CSV_STORAGE_ENGINE=1 -DWITH_HEAP_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MYISAMMRG_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=ON -DWITH_PBXT_STORAGE_ENGINE=OFF -DWITH_OQGRAPH_STORAGE_ENGINE=OFF -DWITH_SPHINX_STORAGE_ENGINE=OFF -DWITH_FEDERATEDX_STORAGE_ENGINE=ON -DCMAKE_BUILD_TYPE=RelWithDebInfo -DCMAKE_INSTALL_DO_STRIP=OFF -DCMAKE_USER_MAKE_RULES_OVERRIDE=/var/tmp/portage/dev-db/mariadb-5.5.25/work/mariadb-5.5.25_build/gentoo_rules.cmake /var/tmp/portage/dev-db/mariadb-5.5.25/work/mysql gentoo_common_config.cmake contains: SET (LIB_SUFFIX 64 CACHE STRING "library path suffix" FORCE) SET (CMAKE_INSTALL_LIBDIR /usr/lib64 CACHE PATH "Output directory for libraries") I'm at a loss why one way works and the the other doesn't. Thank you.

2 4

[Maria-discuss] Questions about GIS functionality (vs MySQL, InnoDB, PostGIS...)
by Henrik Ingo 06 Aug '12

06 Aug '12

Hi Holyfoot, others I've been reading up on the state of GIS functionality. It would be great if I can get some answers directly from the source! 1) Comparing MariaDB and what's there in MySQL 5.6.1: are these identical but independent implementations? If there are differences, what are they? 2) Apparently PostGIS requires to do all kinds of gymnastics both when installing and when doing version upgrades. MySQL/MariaDB spatial functions are just there to be used, right? 3) Speaking of PostGIS, its manual reveals that their GiST R-tree index actually only works on the bounding rectangles of shapes. Is this the case also for MyISAM/Aria R-tree indexes, or would MariaDB actually filter the result set to only return shapes that are within the search shape for real. And btw, does the search shape have to be a box, or can it be any shape? 4) Lack of InnoDB R-tree indexes... What would it take to do that? Is the current implementation re-usable in any way (ie just store current R-tree indexes into InnoDB pages...) or would it have to be a separate implementation? 5) Euclidean geometrics only... PostGIS and SQLite use the separate GEOS library (and cousins like PROJ.4). Why isn't this used in the MySQL/MariaDB implementation? It seems to me, you could get accurate handling of different (non-euclidean) projections by using these libraries, "for free". henrik -- henrik.ingo(a)avoinelama.fi +358-40-8211286 skype: henrik.ingo irc: hingo www.openlife.cc My LinkedIn profile: http://www.linkedin.com/profile/view?id=9522559

2 3

[Maria-discuss] MariaDB repositories - GPG keys and website distro version references
by Arjen Lentz 02 Aug '12

02 Aug '12

Hi Daniel The repository tool on mariadb.com is awesome! I spotted a few things, hope you find the feedback of use: 1) On Debian/Ubuntu, apt-get will require a valid gpg key in its keyring to accept the packages. As root, you can do gpg --keyserver keyserver.ubuntu.com --recv-keys 1BB943DB gpg --export 1BB943DB | apt-key add - ... the other stuff apt-get update although sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 1BB943DB should also work. This adds your key and after that apt-get update will add the repo info to its package database so packages can be installed/upgraded. That said, the nicer method from Karmic (9.10) is sudo apt-get install python-software-properties sudo add-apt-repository <path> sudo apt-get update where <path> is the url you now represent for adding into the apt software sources. The distro tag (natty, etc) and 'main' get sorted out automatically by default. (so the first method needs to be displayed for 8.04 (Hardy) 2) the repo install info on mariadb.com does not show which new package names become available for installation/upgrade. It'd be great if it were to show a list of "now you can install the server by doing "sudo apt-get install/upgrade ...", if you want just the command line client do ..., for the client libraries do ... 3) the distro names currently don't show version numbers, e.g. Ubuntu Natty is not identified as 11.04 For both Ubuntu and Debian it'd be handy to have the numbers there also as it's clearer for users; some people are fine with the naming, others need the numbers. Cheers, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Australian peace of mind for your MySQL infrastructure. Follow us at http://openquery.com/blog/ & http://twitter.com/openquery

2 1

[Maria-discuss] KB Question: Upgrading MariaDB version
by Daniel Bartholomew 01 Aug '12

01 Aug '12

The following question has been posted to the Knowledgebase: http://kb.askmonty.org/en/upgrading-mariadb-version/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Upgrading MariaDB version OS: RHEL 6.2 (2.6.32-279.1.1.el6.x86_64) I originally installed MariaDB version mariadb-5.1.61-Linux-x86_64 (using generic linux tarball) and was able to copy data under mariadb install and restarted mariadb. Everything with respect from transition of MySQL to MariaDB worked great. Now I am trying to upgrade MariaDB version mariadb-5.1.61-Linux-x86_64 to mariadb-5.5.25-linux-x86_64 (generic linux tarball). I shutdown the 5.1 MariaDB instance, re-created the link to point to the 5.5 distro. Then I restarted MariaDB instance and attempted to upgrade the database using mysql_upgrade -u root -p It looks it made it through information_schema and mysql databases without issue, but ran into some trouble with the database that I had copied in from original MySQL 5.1 instance (database= sahtest, sahtest.ACCESS_ACCOUNTS, Error: Table 'sahtest.ACCESS_ACCOUNTS' doesn't exist, Status: Operation failed). This error happens for all of the tables in the sahtest database. It also tried to Repair the tables of the sahtest database, failing with same error. mysql_upgrade finishes, so then I connect to mariadb and list databases. sahtest is there. If I say use sahtest; show tables; all the tables are there and look ok. Am I on the right track with how to install and upgrade from 5.1 to 5.5 version of MariaDB? TIA, Scott - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Thanks. -- Daniel Bartholomew Google+ - http://gplus.to/dbart Twitter - http://twitter.com/daniel_bart MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://gplus.to/mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

1 0

[Maria-discuss] KB Question: InnoDB recovery under Maria
by Daniel Bartholomew 01 Aug '12

01 Aug '12

The following question has been posted to the Knowledgebase: http://kb.askmonty.org/en/innodb-recovery-under-maria/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - InnoDB recovery under Maria Hi, I have been using MySQL for various embedded situation over the years. I am currently working on a new version of an existing project which I'm also migrating to MariaDB (I think I prefer Monty's style!). OK. Some tables in this database get update from an external source in a complex manner, so I am using InnoDB on these table with a transaction to ensure the operation is either completed or completely abandoned. This is an embedded app, and it can be interupted abruptly, leaving the InnoDB tables blocked. The procedure in this case is to set InnoDB recover to 4, dump the database, manually delete the InnoDB files, restart normally, restore, and then force an update from the external source. I'm hoping I will eventually be able to solve this using Aria tables, but in the meantime is there any way I can automate the process. I don't need to recover the data in the InnoDB tables following a crash, I just need to know that it has happened so I can get a new dataset. Thanks in advance for any help or suggestions. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Thanks. -- Daniel Bartholomew Google+ - http://gplus.to/dbart Twitter - http://twitter.com/daniel_bart MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://gplus.to/mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

1 0

[Maria-discuss] Did we drop source for IBMDB2I?
by Colin Charles 28 Jul '12

28 Jul '12

Hi! Reading: http://kb.askmonty.org/en/mariadb-versus-mysql-features/ "IBMDB2I. Oracle removed this in MySQL 5.1.55 but we have kept the code in MariaDB until the version 5.5." I'm not so sure. I looked for this engine in a 5.5.25 tarball in storage/ and didn't see it. It is in 5.3 tree trunk, but not 5.5 Is this an oversight? Or have we decided to remove the engine? Thanks -- Colin Charles, http://bytebot.net/blog/ | twitter: @bytebot | skype: colincharles MariaDB: Community developed. Feature enhanced. Backward compatible. Download it at: http://www.mariadb.org/ Open MariaDB/MySQL documentation at the Knowledgebase: http://kb.askmonty.org/

2 1

[Maria-discuss] KB Question: GROUP BY trick has been optimized away
by Daniel Bartholomew 23 Jul '12

23 Jul '12

The following question has been posted to the Knowledgebase: https://kb.askmonty.org/en/group-by-trick-has-been-optimized-away/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - GROUP BY trick has been optimized away Group-by trick example: Find the most populous city in each state: SELECT state, city, population, COUNT(*) AS num_cities FROM ( SELECT state, city, population FROM us ORDER BY state, population DESC ) p GROUP BY state ORDER BY state; +-------+-------------+------------+------------+ | state | city | population | num_cities | +-------+-------------+------------+------------+ | AK | Anchorage | 276263 | 16 | | AL | Birmingham | 231621 | 58 | | AR | Little Rock | 184217 | 40 | | AZ | Phoenix | 1428509 | 51 | | CA | Los Angeles | 3877129 | 447 | ... That was the output in MySQL 5.1. But with MariaDB 5.5.23, I get: +-------+-------------------+------------+------------+ | state | city | population | num_cities | +-------+-------------------+------------+------------+ | AK | Anchorage | 276263 | 16 | | AL | Alabaster | 26738 | 58 | | AR | Arkadelphia | 11062 | 40 | | AZ | Apache Junction | 34904 | 51 | | CA | Adelanto | 21955 | 447 | ... The EXPLAIN plan do longer shows a subquery, as if the inner ORDER BY has been thrown away. Granted, there is nothing in the definition of MySQL (much less in the SQL standard) that requires that Los Angeles should be bigger than Adelanto. But the replacement code for this 'trick' is quite messy. Am I correct in deducing (from the outside, looking in) that MariaDB's optimizations are the cause of the change? - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Thanks. -- Daniel Bartholomew Google+ - http://gplus.to/dbart Twitter - http://twitter.com/daniel_bart MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://gplus.to/mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

1 0

[Maria-discuss] KB Question: DROP TABLE Syntax Causing Memory Leak
by Daniel Bartholomew 23 Jul '12

23 Jul '12

The following question has been posted to the Knowledgebase: https://kb.askmonty.org/en/drop-table-syntax-causeing-memory-leak/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - DROP TABLE Syntax Causing Memory Leak I have a Server with 2 Xeon E5645 total 12cores and 24 threads on a X8DAH+-F-B Motherboard and 96Gigs of Memory and 4 Terabytes of hard drive space. We are running the newest stable release of MariaDB 5.5.25. every night I run a PHP script to bring a large data set roughly 500K records or so into a XtraDB Table I use as a "SWAP" table. I processing,filtering, massaging the data in this table then insert this processed data into other tables where it can be accessed by a web application. At the end of this Script I DROP this "SWAP" table. This Script runs 24 times a day and does not seem to have much issues. But For Some reason seemingly randomly the DROP table Command while checking permissions to drop the Table will lockup the database. I have tried truncate too and it seems to have the same issue. The innodb_buffer_pool_size=35G. Any Ideas what the problem could be or where to start looking? Noctechie - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Thanks. -- Daniel Bartholomew Google+ - http://gplus.to/dbart Twitter - http://twitter.com/daniel_bart MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://gplus.to/mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

1 0

[Maria-discuss] MariaDB 5.5.25 now available
by Daniel Bartholomew 23 Jun '12

23 Jun '12

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.25. This is a stable (GA) release. It includes MariaDB 5.3 and MySQL 5.5.25. - - MariaDB 5.5 Links - - - - - - - - - - - - - - - - - - - - - - - - - Release Notes: http://kb.askmonty.org/en/mariadb-5525-release-notes Changelog: http://kb.askmonty.org/en/mariadb-5525-changelog Downloads: http://downloads.mariadb.org/mariadb/5.5.25 APT and YUM Repository Configuration Generator: http://downloads.mariadb.org/mariadb/repositories/ Overview of MariaDB 5.5: http://kb.askmonty.org/en/what-is-mariadb-55 - - Where else to find us - - - - - - - - - - - - - - - - - - - - - - - We're on: Facebook: http://www.facebook.com/MariaDB.dbms Twitter: http://twitter.com/#!/mariadb Google+: http://gplus.to/mariadb Follow, friend, and add us to your circles to keep up to date with MariaDB! - - 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. - - 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/ - - 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 We hope you enjoy MariaDB! -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0