August 2014 - discuss - lists.mariadb.org

[Maria-discuss] Spider and query cache
by Roberto Spadim 23 Sep '14

23 Sep '14

Hi guys! I'm with a doubt, spider engine don't allow query cache right? But does it use sql_cache sql_no_cache when possible? -- Roberto Spadim SPAEmpresarial Eng. Automação e Controle

5 18

[Maria-discuss] optimization
by Roberto Spadim 04 Sep '14

04 Sep '14

guys, i have some queries like this: SELECT doc_hash_key FROM mov_documentos WHERE doc_hash_key LIKE "j;1;$;294007/3nfe-1%" UNION SELECT doc_hash_key FROM mov_documentos WHERE doc_hash_key LIKE "j;1;%;294007/3nfe-1%" UNION SELECT doc_hash_key FROM mov_documentos WHERE doc_hash_key LIKE "j;1;%;%294007/3nfe-1%" UNION SELECT doc_hash_key FROM mov_documentos WHERE doc_hash_key LIKE "%;%;$;%294007/3nfe-1%" UNION SELECT doc_hash_key FROM mov_documentos WHERE doc_hash_key LIKE "%;%;%;294007/3nfe-1%" UNION SELECT doc_hash_key FROM mov_documentos WHERE doc_hash_key LIKE "%;%;%;%294007/3nfe-1%" LIMIT 1 it's a search about a document number, but the problem is.... the first query at first line (with % at end of the query) return really fast, but executing others queries are very slow, the question is could we optimize this kind of query, since limit=1 row? the explain of this query: idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra1PRIMARY mov_documentosrangePRIMARYPRIMARY771Using where; Using index2UNION mov_documentosrangePRIMARYPRIMARY77625612Using where; Using index3UNION mov_documentosrangePRIMARYPRIMARY77625612Using where; Using index4UNION mov_documentosindexPRIMARY771798490Using where; Using index5UNION mov_documentosindexPRIMARY771798490Using where; Using index6UNION mov_documentosindexPRIMARY771798490Using where; Using indexUNION RESULT <union1,2,3,4,5,6>ALL -- Roberto Spadim

3 6

Re: [Maria-discuss] MariaDB Galera Cluster 10.0.13
by Cloud Foundry Services 29 Aug '14

29 Aug '14

Hello, Is MariaDB Galera Cluster 10.0.13 on track for release today? https://mariadb.atlassian.net/browse/MDEV/fixforversion/16800/ Thank you, On Mon, Aug 25, 2014 at 1:40 PM, Nirbhay Choubey <nirbhay(a)skysql.com> wrote: > Hi Shannon, > > On Mon, Aug 25, 2014 at 4:26 PM, Cloud Foundry Services < > cf-services-eng(a)pivotal.io> wrote: > >> Hi Nirbhay, >> >> We're looking forward to these fixes: >> >> https://mariadb.atlassian.net/browse/MDEV-5786 - We were previously >> running mysql_upgrade on every node and getting errors due to replication. >> We now disable replication while mysql_upgrade is running but this makes us >> vulnerable to writes while replication is disabled. We could prevent writes >> while replication is disabled, but we expect this fix will allow us to >> revert our automation around disabling replication. >> >> https://mariadb.atlassian.net/browse/MDEV-6492 - Our understanding is >> that until we receive this fix, nodes can receive writes that may not be >> replicated while in donor mode for an rsync SST. We expect this fix to >> prevent writes while in donor mode for rsync SST. >> >> We are also crossing our fingers that 10.0.13 resolves this issue (link >> is to codership forum, just posted the same question to maria-discuss a few >> minutes ago): >> https://groups.google.com/forum/#!topic/codership-team/OSnQ1FLloBI. We >> haven't filed a bug for it yet; were hoping to get a sanity check first. >> > > > Fix for both the above issues have been queued for MariaDB Galera Server > 10.0.13, and should quite likely fix the issues that you are facing. > > Thanks! > > - Nirbhay > > > >> Thank you, >> Shannon >> >> Cloud Foundry Service, Pivotal >> >> On Mon, Aug 25, 2014 at 1:05 PM, Nirbhay Choubey <nirbhay(a)skysql.com> >> wrote: >> >>> Hi, >>> >>> On Mon, Aug 25, 2014 at 3:45 PM, Cloud Foundry Services < >>> cf-services-eng(a)pivotal.io> wrote: >>> >>>> Hello, >>>> >>>> Any word on the release of MariaDB Galera Cluster 10.0.13? >>>> >>> >>> It should be out in a couple of days. >>> >>> >>>> We've been seeing issues with replication that we really hope this >>>> release will fix. >>>> >>> >>> What are the issues like? Could you describe them? Or report a bug? >>> >>> mariadb.org/jira >>> >>> Best, >>> Nirbhay >>> >>> >>>> Thank you, >>>> Shannon >>>> >>>> Cloud Foundry Services, Pivotal >>>> >>>> _______________________________________________ >>>> 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

Re: [Maria-discuss] MariaDB Galera Cluster 10.0.13
by Cloud Foundry Services 25 Aug '14

25 Aug '14

Hi Nirbhay, We're looking forward to these fixes: https://mariadb.atlassian.net/browse/MDEV-5786 - We were previously running mysql_upgrade on every node and getting errors due to replication. We now disable replication while mysql_upgrade is running but this makes us vulnerable to writes while replication is disabled. We could prevent writes while replication is disabled, but we expect this fix will allow us to revert our automation around disabling replication. https://mariadb.atlassian.net/browse/MDEV-6492 - Our understanding is that until we receive this fix, nodes can receive writes that may not be replicated while in donor mode for an rsync SST. We expect this fix to prevent writes while in donor mode for rsync SST. We are also crossing our fingers that 10.0.13 resolves this issue (link is to codership forum, just posted the same question to maria-discuss a few minutes ago): https://groups.google.com/forum/#!topic/codership-team/OSnQ1FLloBI. We haven't filed a bug for it yet; were hoping to get a sanity check first. Thank you, Shannon Cloud Foundry Service, Pivotal On Mon, Aug 25, 2014 at 1:05 PM, Nirbhay Choubey <nirbhay(a)skysql.com> wrote: > Hi, > > On Mon, Aug 25, 2014 at 3:45 PM, Cloud Foundry Services < > cf-services-eng(a)pivotal.io> wrote: > >> Hello, >> >> Any word on the release of MariaDB Galera Cluster 10.0.13? >> > > It should be out in a couple of days. > > >> We've been seeing issues with replication that we really hope this >> release will fix. >> > > What are the issues like? Could you describe them? Or report a bug? > > mariadb.org/jira > > Best, > Nirbhay > > >> Thank you, >> Shannon >> >> Cloud Foundry Services, Pivotal >> >> _______________________________________________ >> 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] Scaling up cluster results in missing rows on some existing nodes
by Cloud Foundry Services 25 Aug '14

25 Aug '14

Apologies for the cross-post; we submitted this question to the Codership forum a week ago and haven't received a response. https://groups.google.com/forum/#!topic/codership-team/OSnQ1FLloBI Hello, Hoping to get some perspective on an issue we saw yesterday. While scaling up from a single node cluster, we inserted into a table on node 0 and selected the row count for that table on all subsequent nodes (scripts below). For each node that was brought online, we observed that connections to node 0 were suspended during SST, and that there was an additional IST. At this point the nodes reported that they were synced. However, sometimes replication did not occur correctly - the additional nodes reported fewer rows than node 0. Each new node was added by itself, and all other nodes restarted during each scale-up. Nodes that became out-of-sync continued to have an incorrect row count even after restart, and sometimes got further out of sync (i.e. the discrepancy between the number of rows in node 0 and the other nodes increased) We were conducting this experiment to see whether* innodb_disallow_writes *was functioning correctly, but aren't sure whether this issue is related. Has anyone seen similar behavior while scaling up? Insert: #!/bin/bash mysql -u$db_user -p$db_password -e"create database if not exists $db_name;" mysql -u$db_user -p$db_password -e"use $db_name; create table if not exists $table_name (val int);" for i in `seq $start_val $end_val`; do echo "inserting $i" mysql -u$db_user -p$db_password -e"use $db_name; insert into $table_name VALUES ($i); select count(*) from $table_name;" sleep 0.1 done Select: #!/bin/bash for i in `seq $start_val $end_val`; do echo "statement $i" mysql -u$db_user -p$db_password -e"use replication_test; select count(*) from vals;" sleep 0.1 done Thank you, Shannon Cloud Foundry Services, Pivotal

1 0

[Maria-discuss] MariaDB Galera Cluster 10.0.13
by Cloud Foundry Services 25 Aug '14

25 Aug '14

Hello, Any word on the release of MariaDB Galera Cluster 10.0.13? We've been seeing issues with replication that we really hope this release will fix. Thank you, Shannon Cloud Foundry Services, Pivotal

1 0

[Maria-discuss] MariaDB Galera Cluster 5.5.39 now available
by Daniel Bartholomew 21 Aug '14

21 Aug '14

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 5.5.39 This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster 5.5.39 - Release Notes: https://mariadb.com/kb/en/mariadb-galera-cluster-5539-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-galera-cluster-5539-changelog - Downloads: https://downloads.mariadb.org/mariadb-galera/5.5.39 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 - - - - - - - - - - - - - - - - - - - - - - - - - - Building a Web Application with PHP and MariaDB: A Reference Guide is the latest MariaDB book in Packt's growing MariaDB book series. It guides you through all the steps to get your app up and running. - http://bit.ly/1qrqMQx The recently published MariaDB Cookbook contains nearly 100 recipes covering a variety of features in MariaDB 5.5 and 10.0. - http://bit.ly/WZs2Pd Another book, Getting Started with MariaDB is a how-to guide for beginners to help them get up to speed quickly with MariaDB. No prior database experience required. - http://bit.ly/MMElbQ - - 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

1 0

[Maria-discuss] doubt about spider and vertical partitioning
by Roberto Spadim 13 Aug '14

13 Aug '14

hi guys, i didn't tested, i was reading mariadb manual, and it tell that VP isn't implemented at mariadb, that's true? what could i do to help with it ? -- Roberto Spadim

1 0

[Maria-discuss] Upgrade from 10.0.12 -> 10.0.13 changes default config file location behavior; build-time "-DDEFAULT_SYSCONFDIR=" is now ignored ?
by grantksupport＠operamail.com 12 Aug '14

12 Aug '14

I build MariaDB from src. I've been running v10.0.12 (r4252). I've upgraded to v10.0.13 (r4346). My build config always includes cmake .. --debug-output \ -DCMAKE_BUILD_TYPE="Release" \ -DCMAKE_INSTALL_PREFIX=/usr/local/mariadb \ -DINSTALL_LAYOUT=STANDALONE \ -DINSTALL_SYSCONFDIR=/usr/local/etc/mariadb.DEFAULT \ -DINSTALL_SYSCONF2DIR=/usr/local/etc/mariadb.DEFAULT/conf.d \ -DDEFAULT_SYSCONFDIR=/usr/local/etc/mariadb \ ... I have always kept my config only in /usr/local/etc/mariadb/my.cnf with no ~/.my.cnf in existence. Launching MariaDB (via systemd) with /usr/local/mariadb/bin/mysqld --defaults-file=/usr/local/etc/mariadb/my.cnf --basedir=/usr/local/mariadb --datadir=/var/db/mariadb --plugin-dir=/usr/local/mariadb/lib/plugin --log-error=/var/log/mariadb/mariadb-err.log --pid-file=/var/cache/mariadb/mariadb.pid --socket=/var/cache/mariadb/mariadb.sock --port=3306 and noting cat ./scripts/CMakeLists.txt ... IF(INSTALL_SYSCONFDIR) SET(sysconfdir ${DEFAULT_SYSCONFDIR}) ELSE() SET(sysconfdir "/etc") ENDIF() ... & cat ./mysys/my_default.c ... /* Which directories are searched for options (and in which order) */ ... /* This structure defines the context that we pass to callback function 'handle_default_option' used in search_default_file to process each option. This context is used if search_default_file was called from load_defaults. */ struct handle_option_ctx ... /** Create the list of default directories. @param alloc MEM_ROOT where the list of directories is stored @details The directories searched, in order, are: - Windows: GetSystemWindowsDirectory() - Windows: GetWindowsDirectory() - Windows: C:/ - Windows: Directory above where the executable is located - Unix: /etc/ or the value of DEFAULT_SYSCONFDIR, if defined - Unix: /etc/mysql/ unless DEFAULT_SYSCONFDIR is defined - ALL: getenv("MYSQL_HOME") - ALL: --defaults-extra-file=<path> (run-time option) - Unix: ~/ On all systems, if a directory is already in the list, it will be moved to the end of the list. This avoids reading defaults files multiple times, while ensuring the correct precedence. @retval NULL Failure (out of memory, probably) @retval other Pointer to NULL-terminated array of default directories */ ... & @ https://mariadb.com/kb/en/mariadb/documentation/getting-started/configuring… On a Linux, Unix or Mac server, MariaDB looks for the my.cnf file in the following locations: Location Scope /etc/my.cnf Global /etc/mysql/my.cnf Global SYSCONFDIR/my.cnf Global $MYSQL_HOME/my.cnf Server defaults-extra-file File specified with --defaults-extra-file=path, if any /.my.cnf User SYSCONFDIR is the directory specified with the CMake SYSCONFDIR option when MariaDB was built, by default etc under the compiled-in installation directory. with MariaDB v <= 10.0.12, changes to my config have always been correctly picked up, INCLUDING by all mysql client tools. So, for example, if in my.cnf I add ... [client] user = root password = 'XXXXXX' ... then at shell, instead of mysqlshow -u root -p password: XXXXXX I can just mysqlshow and the options as specified are picked up. With MariaDB 10.0.13, the config file is ignored; no changes to it are picked up. The client apps still require cmd line "-u" & "-p", e.g. mysqlshow -u root -p But if I simply cp -af /usr/local/etc/mariadb/my.cnf ~/.my.cnf then, the changes are picked up -- from the ~/.my.cnf location. and just mysqlshow works, as previously. Is this change in behavior intentional? What't the correct, expected/intended behavior? If it's changed, how do I now specify and use the default config file location? Grant

2 5

[Maria-discuss] MariaDB 10.0.13 now available
by Daniel Bartholomew 11 Aug '14

11 Aug '14

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.13 This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.13 - Release Notes: https://mariadb.com/kb/en/mariadb-10013-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-10013-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.13 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 - - - - - - - - - - - - - - - - - - - - - - - - - - Building a Web Application with PHP and MariaDB: A Reference Guide is the latest MariaDB book in Packt's growing MariaDB book series. It guides you through all the steps to get your app up and running. - http://bit.ly/1qrqMQx The recently published MariaDB Cookbook contains nearly 100 recipes covering a variety of features in MariaDB 5.5 and 10.0. - http://bit.ly/WZs2Pd Another book, Getting Started with MariaDB is a how-to guide for beginners to help them get up to speed quickly with MariaDB. No prior database experience required. - http://bit.ly/MMElbQ - - 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

1 0