May 2013 - discuss - lists.mariadb.org

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

11 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

2 1

[Maria-discuss] New Question: Netbeans 7.3 + Hibernate + MariaDB Java Client + MySQL database
by AskMonty KB 30 May '13

30 May '13

Hello, A new question has been asked in "MariaDB Java Client" by mr_lou_d: -------------------------------- Although I can access the database through Netbeans using this driver and MySQL database, I am having difficulty getting Hibernate to work with the driver. Hibernate.cfg file has these entries: <property name="hibernate.connection.driver_class">org.mariadb.jdbc.Driver</property> <property name="hibernate.connection.url">jdbc:mysql://localhost:3306 /myspecial?zeroDateTimeBehavior=convertToNull [MariaDB - root on myspecial]</property> <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property> Note that the Hibernate plugin can't seem to find (doesn't have) any valid dialects for the mariadb driver. Therefore I edited the above xml to force MySQLDialect. This allowed me to get a little further, but when I try to create new "Hibernate mapping files and pojos from database", I fill in the dialog - but no files are generated. When I follow the same steps with the MySQL Java "Connector", including the same hibernate.reveng, it generates the pojos, and all works fine. Thanks for taking a look at this... Any ideas? -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/netbeans-73-hibernate-mariadb-java-client-mysql-d…

1 0

Re: [Maria-discuss] [DBD-mysql] mysql_server_prepare causes segmentation fault on execute (#44)
by Patrick Galbraith 28 May '13

28 May '13

Hi Jan, I suspect it's a server issue vs. client, since as you say mysql crashes. No client should be able to do that :) The real test, is to write a program in C against libmysql that uses the server-side prepared statement API and see if you can reproduce it there. Monty and his team definitely would want to know about the crash. Any chance you could run that with mysql running debug and capture a trace? I would want to get that to Monty and team ASAP. Regards, Patrick On May 25, 2013, at 6:02 AM, Jan Pingel <notifications(a)github.com> wrote: > I've been debugging an issue with prepared queries crashing on the 2nd execute() on my FreeBSD box with the following: > > perl-5.16.2_1 > p5-DBD-mysql-4.021 > p5-DBI-1.625 > mariadb-server-5.5.30 > After connect if I set $DB->{'mysql_server_prepare'} = 1 the first execute() works but on the 2nd one the connection is lost as mariadb/mysql crashes. If I set $DB->{'mysql_server_prepare'} = 0 after connect it works as expected. > > The prepared query is: > > our $shop::test_query = $DB->prepare("SELECT id, merchant_id, name, price, image FROM lbn_shop_products WHERE category_id = ? ORDER BY purchase_count DESC, ctime DESC LIMIT ?, ?"); > Executing the queries: > > #>print $shop::test_query->execute(11, 0, 15) > 3 > $VAR1 = 1; > > #>print $shop::test_query->execute(11, 0, 15) > Database Error: > Lost connection to MySQL server during query > File Line Subroutine > ...k/shared/lib/exceptions.pm 93 (eval) oyster::console::__ANON__ > ...ork/shared/lib/database.pm 17 exceptions::throw > ...ared/lib/oyster/console.pm 73 (eval) database::handle_error > ...ared/lib/oyster/console.pm 31 oyster::_console_execute > ...k/shared/lib/exceptions.pm 178 (eval) oyster::console::__ANON__ > ...ared/lib/oyster/console.pm 64 exceptions::try > script/console.pl 38 oyster::console::start > > ! HASH(0x7fdcf8abd5b8) > The mysql/mariadb log isn't very useful: > > 130525 08:45:41 mysqld_safe mysqld restarted > I believe this is the same issue mentioned on both of these: > http://bugs.mysql.com/bug.php?id=27421 > https://rt.cpan.org/Public/Bug/Display.html?id=83497 > > Is there any additional information that would be useful such as setting the trace level and reporting the output? > > — > Reply to this email directly or view it on GitHub. >

1 0

[Maria-discuss] Aria table with auto increment PK - no concurrent inserts?
by Dmitry Insta 27 May '13

27 May '13

Hello, Aria FAQ says: "Multiple concurrent inserters into the same table." However, if I create a table with autoincrement PK, ENGINE=Aria ROW_FORMAT=PAGE (tried also TRANSACTIONAL=1) then there is no concurrency - only 1 thread is working, others are stuck in "Waiting for table level lock". I couldn't find the exact description of Aria engine behaviour in docs/faq/discussions - is it the way it's supposed to be? Thank you!

1 0

[Maria-discuss] New Question: database password?
by AskMonty KB 27 May '13

27 May '13

Hello, A new question has been asked in "Getting Started" by TommiG: -------------------------------- Dear colleagues, is there a way to have user restrictions embedded into the database? I learned user accounts and passwords are stored as part of the DBMS, but not as part of the DB. Therefore someone could copy the physical DB-files to an memorystick, move it to another machine and with a fresh installation of MariaDB he can read and modify all data. We create a desktop application and would like to distribute a database with private information to the end users. Is there a way we can hide this information and restrict its access only by using our client application but not by any other client? Sure we could encrypt our secret data, but than the DBMS could not create inizes, constrains, etc. Thank you in advance. Best regards, Thomas Env: WinXP, Win7, Win8 -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/database-password/

1 0

[Maria-discuss] New Question: my.cnf
by AskMonty KB 25 May '13

25 May '13

Hello, A new question has been asked in "Getting Started" by mici: -------------------------------- Hallo people, Today I install mariaDB 5.5.31 from binary source in Linux, Installation was success but after that I could not find my.cnf file. I need to edit cnf.file because I have to change the port number. can you tell where is my my.cnf file ? thanks -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/mycnf/

1 0

[Maria-discuss] New Question: my.cnf
by AskMonty KB 25 May '13

25 May '13

Hello, A new question has been asked in "Getting Started" by mici: -------------------------------- Hallo people, Today I install mariaDB 5.5.31 from binary source in Linux, Installation was success but after that I could not find my.cnf file. I need to edit cnf.file because I have to change the port number. can you tell where is my my.cnf file ? thanks -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/getting-started-mycnf/

1 0

[Maria-discuss] Flush logs does not recreate slowlog.
by Rafał Radecki 24 May '13

24 May '13

Hi All. I use: MariaDB-server-5.5.30-1.x86_64 on CentOS release 6.4 (Final) 2.6.32-358.el6.x86_64 "flush logs" or "flush slow logs" does not recreate the file. In https://dev.mysql.com/doc/refman/5.5/en/flush.html there is "With no log_type option, FLUSH LOGS closes and reopens all log files." and "With a log_type option, only the specified log type is flushed." but neither command recreates the log file. I rotate slowlog through crontab: mv /var/log/mysqld-slow.log /var/log/mysqld-slow.log.old ; mysqladmin flush-logs Is it a bug or should it be so for some reason? Best regards, Rafal.

2 2

[Maria-discuss] MariaDB 5.5.31 now available
by Daniel Bartholomew 23 May '13

23 May '13

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.31. This is a bug-fix release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.31 Stable (GA) - Release Notes: https://kb.askmonty.org/en/mariadb-5531-release-notes - Changelog: https://kb.askmonty.org/en/mariadb-5531-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.5.31 Overview of MariaDB 5.5: https://kb.askmonty.org/en/what-is-mariadb-55 APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - 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 "feedback=ON" to your my.cnf (my.ini on Windows) file! See http://kb.askmonty.org/en/user-feedback-plugin for more information. - - Discontinued Builds - - - - - - - - - - - - - - - - - - - - - - - The MariaDB project tries to support as many different Operating Systems and Linux Distributions as we can. However, when a distribution or OS stops receiving security and other updates it becomes difficult to freely provide packages for that platform. In such cases, our policy is to deprecate that platform and stop providing binary packages for it. Accordingly, this will be the final release of MariaDB 10.0 for the following distributions: - Ubuntu 8.04 LTS "Hardy" - Ubuntu 11.10 "Oneiric" If your chosen Linux Distribution or Operating System is deprecated, packages or support are not completely unavailable. Companies such as SkySQL and others provide support for all versions of MariaDB back to even very old MySQL versions. This includes packaged binaries. Contact them for more details. More information on the deprecation policy can be found at: - https://kb.askmonty.org/en/mariadb-deprecation-policy/ - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to MariaDB, please see our "contributing" and "donations" pages. We also have merchandise available in a cafepress store. - https://kb.askmonty.org/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] Update mariadb-galera-server in Debian repository to 5.5.30
by Patric Falinder 17 May '13

17 May '13

Hi, I was just going to try MariaDB Galera on a couple of Debian 7.0 servers and noticed that the package mariadb-galera-server is not updated to version 5.5.30, it's still 5.5.29 which makes it impossible to install through the repository as it depends on libssl0.9.8 and Debian 7.0 is using libssl1.0.0. When looking at this bugreport https://mariadb.atlassian.net/browse/MDEV-4229 and if I understand it right, it's fixed in version 5.5.30, "Fix Version/s: 5.5.30-galera". Or have I misinterpreted that? Was mariadb-galera-server just missed when the updates where made? Can someone clarify that it's fixed in version 5.5.30 and if the repository is going to be updated? Thanks for your time, -Patric -

2 2