- discuss - lists.mariadb.org

[Maria-discuss] Doubt about 'atomic' insert
by Roberto Spadim 15 Dec '14

15 Dec '14

Hi guys i'm with a doubt about the "standard" (sql standand?) error reporting , about INSERT SELECT... should this insert select return duplicate key? INSERT INTO errorsX (id) SELECT MAX(id)+1 FROM errorsX; considering: ---- CREATE TABLE errorsX( id INT NOT NULL DEFAULT 0, PRIMARY KEY (id) ) ; ---- -- Roberto Spadim SPAEmpresarial Eng. Automação e Controle

4 14

[Maria-discuss] the future of --skip-innodb
by Federico Razzoli 14 Dec '14

14 Dec '14

Hi. In MySQL 5.7 documentation: https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html I read: "As of MySQL 5.7.5, the InnoDB storage engine can no longer be disabled, and the --innodb=OFF and --skip-innodb options are deprecated and have no effect. Their use results in a warning. These options will be removed in a future MySQL release." Will MariaDB remove --skip-innodb? If so, when? Regards Federico

3 2

[Maria-discuss] mariadb 10 build/link ignores specified linker path to specified lib (pcre). correct method?
by grantksupport＠operamail.com 13 Dec '14

13 Dec '14

building mariadb 10.0.15 on linux/64 i have a non-system instance of (lib)pcre, installed in /usr/local/test/pcre, that i need to build/link against reading Link MariaDB Client Library for C with specific external zlib and openssl https://mariadb.com/kb/en/mariadb/client-libraries/client-library-for-c/lin… i've built with cmake .. \ ... -DCMAKE_C_FLAGS="... -I/usr/local/test/pcre/includes" \ -DCMAKE_CXX_FLAGS="... -I/usr/local/test/pcre/includes" \ -DCMAKE_SHARED_LINKER_FLAGS="... -L/usr/local/test/pcre/lib64 -lpcre" \ ... and cmake .. \ ... -DCMAKE_C_FLAGS="... -I/usr/local/test/pcre/includes" \ -DCMAKE_CXX_FLAGS="... -I/usr/local/test/pcre/includes" \ -DCMAKE_SHARED_LINKER_FLAGS="... -L/usr/local/test/pcre/lib64 -Wl,-rpath,/usr/local/test/pcre/lib64 -lpcre " \ ... but id both cases, the resultant binary still links against system pcre libs ldd sql/mysqld | egrep -i "pcre" libpcre.so.1 => /usr/lib64/libpcre.so.1 (0x00007f6165a5e000) what's the correct method for linking against a specified, non-system path'd lib? specifically, here, libpcre?

3 8

[Maria-discuss] New Question: TokuDB
by AskMonty KB 13 Dec '14

13 Dec '14

Hello, A new question has been asked in "Development" by timosaarinen. Please answer it at http://mariadb.com/kb/en/tokudb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- We noticed, that MariaDB includes TokuDB engine too nowadays. We have read, that it should be more high-performance than the default one. We are curious to know, what's the reason, it's not the default engine in MariaDB. Is it ready for production use? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/tokudb/

3 2

[Maria-discuss] New Question: MaxScale Customisation - Filter, Routing of Clients, "Sticky" Statements
by AskMonty KB 11 Dec '14

11 Dec '14

Hello, A new question has been asked in "MariaDB community" by moshpit. Please answer it at http://mariadb.com/kb/en/maxscale-customisation-filter-routing-of-clients-s… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hey guys, I am with a company that provides services and develops software for shipping companies. We usually deploy our web applications on our own infrastructure. I've been dealing with MariaDB and MaxScale for 2 weeks now and I'd say I do have a pretty good overview of whats going on. I already set up a demo environment with 1 master, 3 slaves, 1 client and 1 MaxScale proxy. Since we want to use MariaDB and MaxScale in production environments when it gets out of the Beta state, I am trying to test this technology for some requirements we have. This one might be rather tricky than trivial, though I wanted to discuss this here because I am having struggle setting it up the way I want. If you need more information on the requirements itself let me know so I can figure out if I can provide you with a more detailed description. Requirement: Our web applications excessively use temporary tables. This means, a lot of tables are generated on-the-fly and used within a session. They are deleted by cronjobs after a specified period of time (or after the current http session was closed/invalidated/timed out). The web applications then use these temporary tables to join them with persistent tables on the databases to generate reports. Usually, the table names of temporary tables are named somewhat similar to __tmp_<number>__ . The last part of those table names are equal to a part of the URL of the web application within the “session_id=” variable. For example: + URL: https://url.to.web.app./session_id=123 + temporary table name: __tmp_123 So, depending on the variable “session_id=” in the URL of the application the names of the temporary tables gets generated dynamically from within the application. To reduce network overhead, throughput decrease and other performance parameters, we do not want those tables to be replicated to the slaves. But we do not as well want to have all the read/write load for those temporary tables on one single master machine. So, this is when a multi-master setup comes on the plan. And with it the question on filters and how to manage and distribute the load on the available master servers. Suggestion: Supposing we have 4 master servers (master_00, master_01, master_02 and master_03). Supposing they are set up in a multi-master replication setup. Supposing we use MaxScale as the respective proxy for routing the requests. When a client sends one of those MySQL statements that create or read from a temporary table, we could use the RegEx filter to route the client to specific master machines (not slaves, since write statements are redirected to master servers in any case). Excluding the temporary tables from replication in the server configuration might be mandatory here. Questionnaire: Since the names of those temporary tables are unique throughout their lifecycle (meaning the name could be used again in another session after the table currently holding the name is being deleted), it might come in handy to do an operation such as: Table name: __tmp_<number>__ Operation: <number> MOD x (x being the number of master servers in the cluster) For example: <number> = 6091073567508922368; Number of master servers: 8  Resolves in 6091073567508922368 MOD 4 = 0, so the request gets routed to master_00 (assuming we start counting on 0 for the number of master servers) Regarding the (RegEx) filter, these questions come to mind: + Is it possible to do mathematic operations such as Modulo within the filter definition? + Is it possible to retrieve the number of current master servers being a member of the cluster from within the filter definition? + Is it possible to dynamically build the filter definitions with a script and inject them into a running MaxScale implementation or does MaxScale need to be restarted after changing the configuration? + What happens when one of the masters dies? + Is it possible to have join statements spread over multiple servers? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/maxscale-customisation-filter-routing-of-clients-s…

1 0

[Maria-discuss] What happened to 10.1 downloads
by Peter Laursen 10 Dec '14

10 Dec '14

Not listed here: https://downloads.mariadb.org/ -- Peter -- Webyog

2 2

[Maria-discuss] MariaDB 10.0.15 now available
by Daniel Bartholomew 10 Dec '14

10 Dec '14

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.15 This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.15 - Release Notes: https://mariadb.com/kb/en/mariadb-10015-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-10015-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.15 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/ - http://www.cafepress.com/mariadb 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

7 29

[Maria-discuss] New Question: Memory Instrumentaion
by AskMonty KB 10 Dec '14

10 Dec '14

Hello, A new question has been asked in "MariaDB community" by paskalkarsenti. Please answer it at http://mariadb.com/kb/en/memory-instrumentaion/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello, Is there a way to enable Memory instrumentation in performance_schema.setup_instruments ? Thanks for your help -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/memory-instrumentaion/

1 0

[Maria-discuss] Converting the whole database and tables from one charset+collation to another
by Honza Horak 10 Dec '14

10 Dec '14

Google does not provide any source I would be sure of, many different approaches.. so rather asking here.. Given I have a database with latin1 and some latin* collation, the same for tables and I want to convert database, tables and data to utf8. Are the following two commands really all I need to do? I mean if that is really enough to change the data as well.. ALTER DATABASE db_name DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE db_table CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; Thanks ahead for clarification. Honza

2 1

[Maria-discuss] New Question: MariaDB client/server (TCP) protocol
by AskMonty KB 07 Dec '14

07 Dec '14

Hello, A new question has been asked in "Geographic Features" by massimo.manca.pn. Please answer it at http://mariadb.com/kb/en/mariadb-clientserver-tcp-protocol/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, I am interested to interface embedded boards to MariaDB data bases. Actually I made some trials with Mysql and a LPC1769 based board. I am quite satisfied, the results are very good but there is a problem with the license of the Mysql TCP protocol that is released under GPL so... there is a problem to work with closed source applications. 1. I would like to know if client/server protocol is the same for MariaDB and MySql 2. I would like to know if client/server protocol for MariaDB is under GPL or LGPL 3. Is there any documentation about client/server protocol for MariaDB? Thank you very much and thank you also to fork MariaDB from MySQL, it is a better product. Massimo -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-clientserver-tcp-protocol/

2 1