- discuss - lists.mariadb.org

[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

[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

[Maria-discuss] Latest round of Oracle CVE status on MariaDB
by Brian Evans 13 Aug '15

13 Aug '15

The quarterly CVE list from oracle was published[1]. The following CVEs are listed there affecting 5.5, but not listed on the MariaDB security page[2]. CVE-2015-4757 CVE-2015-4752 CVE-2015-4737 CVE-2015-2648 CVE-2015-2643 CVE-2015-2620 CVE-2015-2582 Are they fixed with 5.5.45 and 10.0.21, or any other version? Brian [1] http://www.oracle.com/technetwork/topics/security/cpujul2015-2367936.html#A… [2] https://mariadb.com/kb/en/mariadb/security/

2 1

[Maria-discuss] faling tests
by Reindl Harald 06 Aug '15

06 Aug '15

just built 10.0.21 and thought it can't be wrong to report the faling test below - this is not new and virtually forever - however, maybe woth a look ______________________________________________________________ /usr/bin/su -c 'cd /usr/share/mysql-test; ./mysql-test-run.pl --default-myisam --parallel=1 --max-test-fail=0 --mysqld=--binlog-format=mixed --skip-ndb --force' mysql ______________________________________________________________ rpl.rpl_not_null_innodb 'row,xtradb' [ fail ] Test ended at 2015-08-06 21:30:45 CURRENT_TEST: rpl.rpl_not_null_innodb mysqltest: In included file "./include/rpl_init.inc": included from ./include/master-slave.inc at line 38: included from /usr/share/mysql-test/suite/rpl/t/rpl_not_null_innodb.test at line 15: At line 179: query 'SET GLOBAL gtid_slave_pos= ""' failed: 1198: This operation cannot be performed as you have a running slave ''; run STOP SLAVE '' first The result from queries just before the failure was: include/master-slave.inc - saving '/usr/share/mysql-test/var/log/rpl.rpl_not_null_innodb-row,xtradb/' to '/usr/share/mysql-test/var/log/rpl.rpl_not_null_innodb-row,xtradb/'

1 1