- discuss - lists.mariadb.org

[Maria-discuss] New Question: MariaDB 10.1 system variables
by AskMonty KB 26 Aug '15

26 Aug '15

Hello, A new question has been asked in "What is in the Different MariaDB Releases?" by diptijoshi. Please answer it at http://mariadb.com/kb/en/mariadb-101-system-variables/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- What is the difference between MariaDB 10.1 and MySQL 5.6 system variables ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-101-system-variables/

1 0

[Maria-discuss] New Question: SET Variable statement
by AskMonty KB 24 Aug '15

24 Aug '15

Hello, A new question has been asked in "MariaDB Community" by cisaksen. Please answer it at http://mariadb.com/kb/en/set-variable-statement/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I'm trying to write a SQL script that creates a database and a few other things. I'm having trouble with a user defined variable statement. SET @dbname = CAST(trees AS VARCHAR(10)); comes directly from https://mariadb.com/kb/en/mariadb/user-defined-variables/ And I keep getting --> Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'VARCHAR(10))' at line 1 Running MariaDB 10.0.20 on SLES 12, I have no idea what the problem is ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/set-variable-statement/

1 0

[Maria-discuss] New Question: Visual Studio - MariaDB - Entity Framework 6+
by AskMonty KB 23 Aug '15

23 Aug '15

Hello, A new question has been asked in "MariaDB FAQ" by vaclav. Please answer it at http://mariadb.com/kb/en/visual-studio-mariadb-entity-framework-6/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Dear Specialists, We can use at the moment "Visual Studio ADO.NET Driver for MySQL" (https://www.mysql.com/products/connector/) and also there was lots of work done with Visual Studio Integration for MySQL. (http://dev.mysql.com/doc/connector-net/en/connector-net-visual-studio.html) The question is while now it is compatible with MariaDB and I can use MariaDB instead of MySQL, how long if at all there will be a point when this won't become anymore compatible. Is this connection compatibility related with a core or some layer in MariaDB which doesn't change and so it should be working in the future. The reason I am asking is to decide with the strategy. I am testing MariaDB with Entity Framework and the driver/connection mentioned above and it is working but what if you deviate from the connectivity at certain point? Thank you. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/visual-studio-mariadb-entity-framework-6/

1 0

[Maria-discuss] problem with optimizer
by Roberto Spadim 21 Aug '15

21 Aug '15

Hi guys I'm running two queries: first: explain SELECT lote_spa,mov_id FROM est_mov WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa IN (1150150.0,1150532.0,1152187.0,1152361.0,1155813.0,1156244.0,1156654.0) AND item_id=67 AND item_id_red=1423 it use primary key and key_len =16 but including a new = element [AND oe_tipo='oe' ]: explain SELECT lote_spa,mov_id FROM est_mov WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa IN (1150150.0,1150532.0,1152187.0,1152361.0,1155813.0,1156244.0,1156654.0) AND item_id=67 AND item_id_red=1423 AND oe_tipo='oe' it use primary key but key_len=4 (near to a full table scan) what's wrong? -- Roberto Spadim

1 2

[Maria-discuss] New Question: Multiple DB instances - in multiple cnf files
by AskMonty KB 20 Aug '15

20 Aug '15

Hello, A new question has been asked in "MariaDB Community" by cisaksen. Please answer it at http://mariadb.com/kb/en/multiple-db-instances-in-multiple-cnf-files/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is it possible to breakup the [mysqldx] [mysqld1] .. [mysqld2] .. and so on into multiple cnf. files (like one each) and include them using the !includedir statement ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/multiple-db-instances-in-multiple-cnf-files/

1 0

[Maria-discuss] New Question: PDF or search area
by AskMonty KB 20 Aug '15

20 Aug '15

Hello, A new question has been asked in "MariaDB Documentation" by cisaksen. Please answer it at http://mariadb.com/kb/en/pdf-or-search-area/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is there a PDF version of the documentation or a way to search the online documentation ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/pdf-or-search-area/

1 0

[Maria-discuss] Mariadb 10.1.6, total cluster recovery - gvwstate.dat
by Max Zulio 19 Aug '15

19 Aug '15

Hi, I am using a Mariadb 10.1.6 three node cluster with wsrep. There is a gvwstate.dat file created in /var/lib/mysql, but in the log file when restarting the nodes I see: [Warning] WSREP: access file(gvwstate.dat) failed(No such file or directory). This seems to be the only thing stopping automatic cluster recovery. Where is mariadb looking for the file, or is there a way of configuring the file location? Thanks, M

4 5

[Maria-discuss] New Question: Fitting index not used
by AskMonty KB 19 Aug '15

19 Aug '15

Hello, A new question has been asked in "Query Optimizations" by mandark. Please answer it at http://mariadb.com/kb/en/fitting-index-not-used/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- MariaDB version: mysql Ver 15.1 Distrib 10.1.2-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 Here is the simplified situation (Query with like 10 joins, so I simplify to the simpliest query still reproducing the problem when working on slow queries): ``` SELECT article.article_id FROM article -- USE INDEX (s_ti_pd) LEFT JOIN member ON member.member_id = article.member_id WHERE article.thema_id = 29 AND article.state = 1 ORDER BY published_date LIMIT 0, 3; ``` - I have an index on `state, thema_id, published_date` which fit particularly well from my point of view (Query run in a few milliseconds using it) - When using `state, thema_id, published_date` index, explain give me: key_len: 8, ref: const,const, rows: 15006, filter: 100.00, Using where - I have another index on `published_date` only (Query run in ~1s using it) - When using `published_date` index, explain give me: key_len: 9, rows: 94, filtered: 100.00, Using where - Table have a few other indexes... - Forcing the usage of the index ran my query in a few milliseconds, without, one second. - Removing the LEFT JOIN makes MariaDB use the good index - Changing the thema_id sometimes change the index used I dont see any factor that may tell the query optimizer to use published_date. In fact I see only one, it's shorter, so faster to read. But the `status, thema_id, published_date` index seems, for me, obviously better, as it starts with two consts, and also can be used for the ORDER BY. What can I do to understand MariaDB on this choice ? I only tried an "analyze table" but engine side, not "table side", for the moment, it changed nothing. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/fitting-index-not-used/

1 0

[Maria-discuss] MariaDB Galera Cluster 10.0.21 and 5.5.45 now available
by Daniel Bartholomew 18 Aug '15

18 Aug '15

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 10.0.21 and 5.5.45. These are both Stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster 10.0.21 - Release Notes: https://mariadb.com/kb/en/mariadb-galera-cluster-10021-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-galera-cluster-10021-changelog - Downloads: https://downloads.mariadb.org/mariadb-galera/10.0.21 MariaDB Galera Cluster 5.5.45 - Release Notes: https://mariadb.com/kb/en/mariadb-galera-cluster-5545-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-galera-cluster-5545-changelog - Downloads: https://downloads.mariadb.org/mariadb-galera/5.5.45 About MariaDB Galera Cluster: https://mariadb.com/kb/en/what-is-mariadb-galera-cluster 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

1 0

[Maria-discuss] New Question: Mariadb match against a view (fulltext search) fails; succeeds in MySql
by AskMonty KB 18 Aug '15

18 Aug '15

Hello, A new question has been asked in "Moving to MariaDB" by henrik_bechmann_g. Please answer it at http://mariadb.com/kb/en/mariadb-match-against-a-view-fulltext-search-fails… as the person asking the question may not be subscribed to the mailing list. -------------------------------- The fulltext search query below fails in mariadb, but succeeds in mysql (mariadb database imported from mysql database using phpmyadmin). If a base table is substituted, the query succeeds in both mariadb and mysql. So apparently mariadb cannot match against views. Is there a solution to this? It's messing up my migration. Using 10.0.21. Thanks. SELECT Title FROM Nodes_View WHERE (MATCH(Title,Caption,Description,Location,Body) AGAINST ('something')) -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-match-against-a-view-fulltext-search-fails…

1 0