- discuss - lists.mariadb.org

[Maria-discuss] New MariaDB Connector Releases
by Daniel Bartholomew 16 Nov '15

16 Nov '15

The MariaDB project is pleased to announce the immediate availability of MariaDB Connector/Java 1.3.0-stable (GA) and MariaDB Connector/ODBC 2.0.9-beta. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Connector/Java 1.3.0-stable (GA) - Release Notes: https://mariadb.com/kb/en/mariadb-connector-j-130-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-connector-j-130-changelog - Downloads: https://downloads.mariadb.org/connector-java/1.3.0/ - About MariaDB Connector/J: https://mariadb.com/kb/en/about-mariadb-connector-j/ MariaDB Connector/ODBC 2.0.9-beta - Release Notes: https://mariadb.com/kb/en/mariadb-connector-odbc-209-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-connector-odbc-209-changelog - Downloads: http://downloads.mariadb.org/connector-odbc/2.0.9/ - About MariaDB Connector/ODBC: https://mariadb.com/kb/en/about-mariadb-connector-odbc/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - 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 or my.ini file! See http://mariadb.com/kb/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: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/en/donate/ We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] MariaDB 10.0.22 now available
by Daniel Bartholomew 16 Nov '15

16 Nov '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.22. This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.22 - Release Notes: https://mariadb.com/kb/en/mariadb-10022-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-10022-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.22 About MariaDB 10.0: - https://mariadb.com/kb/en/what-is-mariadb-100/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - 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 or my.ini file! See http://mariadb.com/kb/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: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/en/donate/ We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

5 8

[Maria-discuss] New Question: Cluster node sizes are different
by AskMonty KB 16 Nov '15

16 Nov '15

Hello, A new question has been asked in "MariaDB Galera Cluster" by chen-lin_li_g. Please answer it at http://mariadb.com/kb/en/cluster-node-sizes-are-different/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have three node MariaDB Galera Cluster. At first the databases size in all the three nodes were same. However now it has been noticed that database size are different on three node. But the three status(wsrep_local_state_comment) of the three nodes are synced. Could you let me know whether it is an expected behavior? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/cluster-node-sizes-are-different/

1 0

[Maria-discuss] R: doubt trigger
by Federico Razzoli 14 Nov '15

14 Nov '15

Standard SQL has triggers FOR EACH STATEMENT, but MariaDB has not. I would use a stored procedure instead. Regards Federico -------------------------------------------- Ven 13/11/15, Roberto Spadim <roberto(a)spadim.com.br> ha scritto: Oggetto: [Maria-discuss] doubt trigger A: "Maria Discuss" <maria-discuss(a)lists.launchpad.net> Data: Venerdì 13 novembre 2015, 21:50 hi guy, i'm with a doubt thre's a trigger to execute after insert/update/delete complete? not row by rowi want to change some tables and automatically execute a procedure to recalculate some values, but i will insert/update/delete many rows, that's why i want to execute it after query execution, but with a CALL PROCEDURE() any idea? -- Roberto Spadim -----Segue allegato----- _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss(a)lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp

2 1

[Maria-discuss] doubt trigger
by Roberto Spadim 13 Nov '15

13 Nov '15

hi guy, i'm with a doubt thre's a trigger to execute after insert/update/delete complete? not row by row i want to change some tables and automatically execute a procedure to recalculate some values, but i will insert/update/delete many rows, that's why i want to execute it after query execution, but with a CALL PROCEDURE() any idea? -- Roberto Spadim

1 0

[Maria-discuss] mysql_install_db as user
by Felipe Gasper 13 Nov '15

13 Nov '15

Hello, Is this script supposed to be runnable as a normal (i.e., non-root) user? In MySQL 5.6 there is logic that prevents the chown() of the mysql data dir when running as non-root. MariaDB 10.1.8 doesn’t seem to have this logic, so the script fails when chown() fails. Is this change intended? We have tests that verify functionality of user-created, UNIX-socket-only MySQL/MariaDB servers. These work on MySQL 5.6 but not on MariaDB 10.1. Here is the command-line output: --------------- ~/temp $ /usr/bin/mysql_install_db --datadir=mysqldata chown: changing ownership of `mysqldata': Operation not permitted Cannot change ownership of the database directories to the 'mysql' user. Check that you have the necessary permissions and try again. bash: __git_ps1: command not found --------------- Thank you for your time! -Felipe Gasper Houston, TX

2 4

[Maria-discuss] Donating during the downloads
by Colin Charles 12 Nov '15

12 Nov '15

Hi, Today I downloaded Ubuntu and saw this awesome page for donations. Do you think we should do this for the MariaDB Server / Connectors / etc. so that the MariaDB Foundation gets funded as well? I know that even LibreOffice has done this (http://donate.libreoffice.org/) We should consider this. Otto, what do you think? -- Colin Charles, Chief Evangelist, MariaDB Corporation blog: http://bytebot.net/blog/ | t: +1-347-903-3201 | Skype: colincharles | Twitter: @bytebot

3 2

[Maria-discuss] GRANT error - undocumented?
by Felipe Gasper 12 Nov '15

12 Nov '15

Hello, I’ve found an apparent discrepancy between MySQL 5.6 and MariaDB 10.1. When you GRANT ALL PRIVILEGES on a DB to a user/host that is not in the mysql.users table, MariaDB 10.1 throws ER_PASSWORD_NO_MATCH, whereas MySQL 5.6 creates the user/host entry. Is this by design? I don’t see the behavior discussed at https://mariadb.com/kb/en/mariadb/grant/. Thank you for your time! Below I am including the client outputs for both servers. -Felipe Gasper Houston, TX -------------------------- Server version: 10.1.8-MariaDB-log MariaDB Server Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> create database fgtemp; Query OK, 1 row affected (0.00 sec) MariaDB [(none)]> use fgtemp; Database changed MariaDB [fgtemp]> grant all on fgtemp.* to 'root'@'nowhere'; ERROR 1133 (28000): Can't find any matching row in the user table MariaDB [fgtemp]> -------------------------- Server version: 5.6.27-log MySQL Community Server (GPL) Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> create database fgtemp; Query OK, 1 row affected (0.00 sec) mysql> use fgtemp; Database changed mysql> grant all on fgtemp.* to 'root'@'nowhere'; Query OK, 0 rows affected (0.05 sec) --------------------------

4 5

Re: [Maria-discuss] Donating during the downloads
by Federico Razzoli 12 Nov '15

12 Nov '15

If you are talking about donations to the foundation (not the company) I agree that it's a great idea. If small donations are welcome, many people will probably donate (and I'm one of them). Just a hint: maybe you could even advertise merchandising in the download page. Regards Federico -------------------------------------------- Gio 12/11/15, Stephane VAROQUI <stephane(a)mariadb.com> ha scritto: Oggetto: Re: [Maria-discuss] Donating during the downloads A: "Colin Charles" <colin(a)mariadb.org> Cc: "Maria Discuss (maria-discuss(a)lists.launchpad.net)" <maria-discuss(a)lists.launchpad.net> Data: Giovedì 12 novembre 2015, 09:06 Hi Colin! Indeed that's an excellent idea for the foundation.Would enjoy an online shop for market place (maxscale commercial modules), rdba credits, foundation donations . /stephane Stéphane Varoqui, Senior ConsultantPhone: +33 695-926-401, skype: svaroquihttp://www.mariadb.com Le Nov 12, 2015 à 7:28 AM, Colin Charles a écrit : Hi, Today I downloaded Ubuntu and saw this awesome page for donations. Do you think we should do this for the MariaDB Server / Connectors / etc. so that the MariaDB Foundation gets funded as well? I know that even LibreOffice has done this (http://donate.libreoffice.org/) We should consider this. Otto, what do you think? -- Colin Charles, Chief Evangelist, MariaDB Corporation blog: http://bytebot.net/blog/ | t: +1-347-903-3201 | Skype: colincharles | Twitter: @bytebot <Contribute_to_Ubuntu___Ubuntu___Ubuntu.png>_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss(a)lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp -----Segue allegato----- _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss(a)lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp

1 0

[Maria-discuss] doubt with thread pool
by Roberto Spadim 11 Nov '15

11 Nov '15

i'm with a doubt if i have a thread pool with 1000 threads and a max_connections with 100 connections can i have more than 100 clients connected (1000 threads for example)? dos thread pool size limit the max connections, or max connections limite the thread pol size? -- Roberto Spadim

4 7