- discuss - lists.mariadb.org

[Maria-discuss] New KB Question: millisecond part is trimmed away when saving Java Date obj by hibernate
by Daniel Bartholomew 14 Feb '12

14 Feb '12

A new question has been posted in the Knowledgebase: http://kb.askmonty.org/en/millisecond-part-is-trimmed-away-when-saving-java… ---------------------------------------- Hi, I recently upgraded my MySQL DB to MariaDB for millisecond support. I can see the millisecond part in my upgraded database. And I tested the millisecond support by inserting a row to a table of my db. It functions well. But when I use hibernate to save a java.util.Date obj into database, millisecond part is trimmed and in MariaDB date obj is saved as: 2012-02-13 18:40:55.000. Do I need to set up something to activate millisecond support? Or I need to config hibernate for millisecond support? Thanks a lot! ---------------------------------------- Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

Re: [Maria-discuss] MySQL's future in Debian and Ubuntu
by Marc Deslauriers 13 Feb '12

13 Feb '12

On Mon, 2012-02-13 at 02:20 -0500, Eddie Bachle wrote: > In general, I am generally an simply an observer on most of these > mailing lists, however my concerns with a switch are far less > technical and far more practical. I work currently for a college in > Michigan which utilizes almost solely Windows servers simply because > it is what the IT staff here knows. As a student here, I was brought > in to assist with the web server administration, and as time went by > because I have a degree of Linux knowledge, I was given permission to > put together a Ubuntu LAMP server to serve a couple of interested > parties on campus who wanted simply to demo several small scale web > apps that were Linux exclusive. This server would serve as an > exception to the general rule of our server architecture. However as > time has went by and my knowledge looks more like it will be a fixture > here after graduation, along with the simple instability of PHP and > Apache on the Windows platform, my boss is giving far more > consideration to moving to Linux. > > > As Linux gains more public recognition, more and more Windows-only > organizations will consider using it as an alternative, especially for > their web servers. This is especially true because of the fact that > each of the necessarily main components of a web server exist in Linux > in the same form as the do on Windows and often run much better. > Then, the only piece one would need to learn would be the new > operating system, not the database, HTTP server, or PHP scripting > language software. However, this is going to be a more difficult > proposition if the aforementioned advantage is somewhat eliminated. > Were I to have to tell my boss that we could switch to Ubuntu but it > would mean that would need to use a "MySQL compatible" database if we > want to use the native database (which we likely would because it's > tested to be stable and it is supported by the developers), then she > would be much more hesitant. If you prefer MySQL, you'll still be able to manually install it MySQL on Ubuntu and Debian, much like you manually install it on Windows. > > > There simply is a much greater sense of trepidation for those who are > not significantly Linux savvy if there exists a possibility that they > would have to make something work in an unfamiliar environment, > especially if it were to happen unexpectedly. If we ported our www > website server over to Ubuntu and then 6 months down the road we were > to upgrade our Joomla version and there became an issue with MariaDB > because it lacks some MySQL feature that it needs, or even that Joomla > would fail to recognize Maria as being equivalent to MySQL at some > point, then that would be a huge detraction against switching. I predict it will be the opposite. Once distros and people start switching to MariaDB, other projects will be testing on MariaDB by default, and compatibility with MySQL will then become problematic. Marc.

1 0

[Maria-discuss] New KB Question: ODBC
by Daniel Bartholomew 08 Feb '12

08 Feb '12

A new question has been posted to the Knowledgebase: http://kb.askmonty.org/en/mariadb-odbc ==================== Is there an ODBC driver for use with MariaDB that is compatible with the driver provided with MySQL? ==================== Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] New KB Question: Locking SQL_MODE against client changes
by Daniel Bartholomew 05 Feb '12

05 Feb '12

A new question has been posted in the Knowledgebase: http://kb.askmonty.org/en/locking-sql_mode-against-client-changes ==================== Is there any way for locking out sql_mode against client-side changes other than MySQL Proxy (which does not allow for SSL connections)? Perhaps some MariaDB-specific setting? ==================== Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] auth_pam does not compile on OSX
by Terin Stock 20 Jan '12

20 Jan '12

The 5.2.10 version of MariaDB is not compiling for me (using homebrew) on OSX. The error and other information, is as follows. I've resolved the issue for now by passing in --without-plugin-auth_pam to configure. libtool: compile: /usr/bin/llvm-gcc -DHAVE_CONFIG_H -I. -I. -I../../include -I../../include -I/usr/local/Cellar/readline/6.2.1/include -DMYSQL_DYNAMIC_PLUGIN -O3 -w -pipe -march=core2 -msse4 -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DIGNORE_SIGHUP_SIGQUIT -DDONT_DECLARE_CXA_PURE_VIRTUAL -c auth_pam.c -fno-common -DPIC -o .libs/auth_pam_la-auth_pam.o auth_pam.c:107: error: ‘pam_info’ redeclared as different kind of symbol /usr/include/security/openpam.h:104: error: previous declaration of ‘pam_info’ was here make[2]: *** [auth_pam_la-auth_pam.lo] Error 1 $ ./configure --without-docs --without-debug --disable-dependency-tracking --prefix=/usr/local/Cellar/mariadb/5.2.10 --localstatedir=/usr/local/var/mysql --sysconfdir=/usr/local/etc/ --with-extra-charsets=complex --without-readline --enable-assembler --enable-thread-safe-client --with-big-tables --without-plugin-innodb_plugin --with-mysqld-ldflags=-static --with-client-ldflags=-static --with-plugins=max-no-ndb --with-embedded-server --with-libevent C: /usr/bin/llvm-gcc => /usr/llvm-gcc-4.2/bin/llvm-gcc-4.2 CXX: /usr/bin/llvm-g++ => /usr/llvm-gcc-4.2/bin/llvm-g++-4.2 LD: /usr/bin/llvm-gcc => /usr/llvm-gcc-4.2/bin/llvm-gcc-4.2 CFLAGS: -O3 -w -pipe -march=core2 -msse4 CXXFLAGS: -O3 -w -pipe -march=core2 -msse4 -O3 -fno-omit-frame-pointer -felide-constructors CPPFLAGS: -I/usr/local/Cellar/readline/6.2.1/include LDFLAGS: -L/usr/local/Cellar/readline/6.2.1/lib MAKEFLAGS: -j4 -- #Terin Stock

4 5

[Maria-discuss] pam plugin does't compile on FreeBSD
by geoffroy desvernay 09 Jan '12

09 Jan '12

Hi everyone, I'm mariadb's port maintainer for FreeBSD, and I'd like to get it compile before pushing the 5.2.10 update... Seems to be the same problem than under OSX: (with openpam) https://lists.launchpad.net/maria-discuss/msg00506.html Under FreeBSD 9.0RC3 (and 8.2) amd64: libtool: compile: cc -DHAVE_CONFIG_H -I. -I. -I../../include -I../../include -I/usr/local/include -DMYSQL_DYNAMIC_PLUGIN -O2 -pipe -fno-strict-aliasing -MT auth_pam_la-auth_pam.lo -MD -MP -MF .deps/auth_pam_la-auth_pam.Tpo -c auth_pam.c -fPIC -DPIC -o .libs/auth_pam_la-auth_pam.o auth_pam.c:107: error: 'pam_info' redeclared as different kind of symbol /usr/include/security/openpam.h:102: error: previous declaration of 'pam_info' was here *** Error code 1 1 error *** Error code 1 1 error *** Error code 1 1 error *** Error code 1 Sergei Golubchik wrote 'Fixed' in the referenced mail, but I don't know if it's fixed by removing pam support for OSX or ? (did not find any difference in bzr branch 5.2) Should I disable pam support for FreeBSD or is there any patch I could include in the port for 5.2.10 ? Thanks, -- *Geoffroy Desvernay* C.R.I - Administration systèmes et réseaux Ecole Centrale de Marseille

2 2

[Maria-discuss] MariaDB 5.3.3-rc now available
by Daniel Bartholomew 21 Dec '11

21 Dec '11

The MariaDB project would like to announce the availability of MariaDB 5.3.3-rc, the latest addition to our growing lineup of supported software. MariaDB 5.3.3-rc is the first Release Candidate release in the 5.3 series. We hope to follow it up soon with a stable (GA) 5.3 release. == MariaDB 5.3.3-rc Release Notes, Changelog, Downloads =============== The release notes for MariaDB 5.3.3-rc are available from: http://kb.askmonty.org/en/mariadb-533-release-notes A complete changelog for this beta is available from: http://kb.askmonty.org/en/mariadb-533-changelog Sources, binaries and packages can be downloaded from: http://downloads.askmonty.org/mariadb/5.3.3/ Debian and Ubuntu packages (now including Ubuntu 11.10 "Oneiric") are available from our mirrored apt repositories. A sources.list generator can be found at: http://downloads.askmonty.org/mariadb/repositories/ == About MariaDB 5.3.3-rc ============================================= In MariaDB 5.3.3-rc there are a couple of changes compared to previous 5.3 releases: === Performance: Several optimizer features introduced in MariaDB 5.3 have been thoroughly tested, and switched on by default in 5.3.3. These include: * Subquery materialization (materialization=on) http://kb.askmonty.org/en/non-semi-join-subquery-optimizations * Semi-join optimizations (semijoin=on,firstmatch=on,loosescan=on) http://kb.askmonty.org/en/semi-join-subquery-optimizations * Derived table optimization (derived_merge=on,derived_with_keys=on) (Documentation is being worked on) * Index Condition Pushdown (index_condition_pushdown=on) http://kb.askmonty.org/en/index-condition-pushdown * Nested loop join will use its Block-based variant more aggressively http://kb.askmonty.org/en/block-based-join-algorithms * Block-based join for OUTER JOINs (outer_join_with_cache=on) * Block-based join for semi-joins (semijoin_with_cache=on) * Linked join buffers (more aggressive buffering of multi-way joins) (@@join_cache_level==2) Also, DISTINCT and GROUP BY clauses are now removed from subqueries when possible. This allows for more efficient query plans. (backported from MySQL 5.6) === Usability: EXPLAIN output has been improved in MariaDB 5.3.3 to be easier to understand: * The select_type column now shows MATERIALIZED for subqueries that are executed with Materialization (it used to show SUBQUERY, which made it hard to distinguish materialized subqueries from other kinds subqueries). * For a Duplicate Elimination strategy, Start temporary is now shown at the first table from the subquery. See also: http://kb.askmonty.org/en/explain === GIS Operations: GIS precise operations were added in MariaDB 5.3.3 (Documentation for this is still being worked on). == About MariaDB 5.3 ================================================== The MariaDB 5.3 series introduces many new features, includes MariaDB 5.2, and is based on MariaDB 5.1 & MySQL 5.1. Some highlights of new features in MariaDB 5.3 include: - subquery optimizations that finally make subqueries usable - many optimizer changes, including Classic Hash Join, Batched Key Access, a new implementation of Multi-Range-Read optimizations as well as Index Condition Pushdown - NoSQL-style interfaces via the HandlerSocket plugin as well as dynamic columns - group commit in XtraDB when the binary log is enabled - Microsoft Windows performance improvements These are just some of the highlights, and for a more complete list of changes, please read the What is MariaDB 5.3 page: http://kb.askmonty.org/en/what-is-mariadb-53 == User Feedback plugin =============================================== MariaDB 5.3 includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits anonymous basic MariaDB usage information. This information will be 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 book ========================================== We would also like to mention the book "MariaDB Crash Course", by Ben Forta. 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 some time to report any issues you encounter at: https://bugs.launchpad.net/maria We hope you enjoy MariaDB 5.3.3-rc! -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] MariaDB fails to compile with boost
by Terin Stock 21 Dec '11

21 Dec '11

A downstream user is reporting that 5.2.8 (and, after fixing the already reported issue with auth_pam, 5.2.10) does not install with boost 1.48.0 installed. Removing boost from the link path allows MariaDB to compile successfully. I've attached their output, in hopes it will arrive to the list safely. :) -- #Terin Stock

2 1

[Maria-discuss] MariaDB 5.2.10 and 5.1.60 Released
by Daniel Bartholomew 06 Dec '11

06 Dec '11

This email is longer than usual, but that is because we are announcing today the availability of both MariaDB 5.2.10 and 5.1.60, the latest additions to our growing lineup of supported software. MariaDB 5.2.10 and 5.1.60 are primarily bug-fix updates to the previous 5.2.9 and 5.1.55 releases, respectively. == About MariaDB 5.2 MariaDB 5.2 contains features that didn't have time to go into MariaDB 5.1. For all practical purposes it's a drop in replacement for MariaDB 5.1 (and thus MySQL 5.1). The new features in 5.2 are quite isolated and as most have been in use by members in the MySQL community for a long time. Current versions of MariaDB 5.2 are stable. This is equivalent to a MySQL GA release. For a list of the various changes in the MariaDB 5.2 series, please see: * http://kb.askmonty.org/en/what-is-mariadb-52 === PAM authentication plugin in MariaDB 5.2.10 One change in MariaDB 5.2.10 which we want to make you aware of is the inclusion of a new open source PAM authentication plugin. See http://kb.askmonty.org/en/pam-authentication-plugin for more information. === Windows Binaries delayed Due to some issues with our Windows build server, the Windows binaries for 5.2.10 have been delayed. They should be released soon. === MariaDB 5.2.10 Release Notes, Changelog, Downloads See the following pages for more information on MariaDB 5.2.10 and to download it: * http://kb.askmonty.org/en/mariadb-5210-release-notes * http://kb.askmonty.org/en/mariadb-5210-changelog * http://downloads.askmonty.org/mariadb/5.2.10/ == About MariaDB 5.1 MariaDB 5.1 is a binary drop in replacement of MySQL 5.1, but with performance like MySQL 5.5 (thanks to XtraDB), fewer bugs, and more features. Thanks to the extended and improved mysql_upgrade program it's also easier to upgrade from MySQL 5.0 to MariaDB 5.1 than to MySQL 5.1. MariaDB 5.1 is based on MySQL 5.1. In particular, MariaDB 5.1.60 is based on MySQL 5.1.60, with many improvements. For a list of the various improvements in the MariaDB 5.1 series, please see: * http://kb.askmonty.org/en/what-is-mariadb-51 === MariaDB 5.1.60 Release Notes, Changelog, Downloads See the following pages for more information on MariaDB 5.1.60 and to download it: * http://kb.askmonty.org/en/mariadb-5160-release-notes * http://kb.askmonty.org/en/mariadb-5160-changelog * http://downloads.askmonty.org/mariadb/5.1.60/ == Debian & Ubuntu Software Repositories Debian and Ubuntu packages are available from our mirrored apt repositories. A sources.list generator can be found at: http://downloads.askmonty.org/mariadb/repositories/ == MariaDB Crash Course book We would also like to mention the book "MariaDB Crash Course", by Ben Forta. 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/ == Reporting issues The project always strives for quality, and being a beta release, we know that not everything may be perfect. Please take some time to report any issues you may encounter at: https://bugs.launchpad.net/maria Enjoy MariaDB 5.2.10 and 5.1.60! -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 1

[Maria-discuss] Oneric DEBs are missing?
by Colin Charles 18 Nov '11

18 Nov '11

Hi! http://mirror.aarnet.edu.au/pub/MariaDB/repo/5.3/ubuntu/dists/ The mirror select tool allows you to choose Oneric as a distribution, but it seems to be missing from all the mirrors This probably needs to be fixed -- 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