March 2014 - discuss - lists.mariadb.org

[Maria-discuss] New Question: Question about testing
by AskMonty KB 14 Mar '14

14 Mar '14

Hello, A new question has been asked in "MariaDB FAQ" by openiduser40: -------------------------------- I'd like to run the test suite on MariaDB-5 + MariaDB-10 both. https://mariadb.com/kb/en/mysql-test-overview gives some information + fails to give enough. Suggest docs add a full example. Something like this... 1) create a database net1# mysql_create_database --dbname=mariadb_test --dbuser=mariadb --dbpass=mariadb /usr/bin/mysql --defaults-extra-file=/etc/mysql/debian.cnf -e 'CREATE DATABASE mariadb_test CHARACTER SET utf8 COLLATE utf8_general_ci' /usr/bin/mysql --defaults-extra-file=/etc/mysql/debian.cnf -e 'GRANT ALL PRIVILEGES ON mariadb_test.* to 'mariadb@localhost' IDENTIFIED BY "mariadb"; FLUSH PRIVILEGES;' 2) run a test The reason I ask about this is every test I run fails. lsof shows my socket is /var/run/mysqld/mysqld.sock + here are the failures. mysql --defaults-extra-file=/etc/mysql/debian.cnf -e 'SHOW DATABASES' | grep mariadb_test shows my database exists. These tests fail to connect to database... net1# mysqltest --verbose --protocol=socket --socket=/var/run/mysqld/mysqld.sock --database=name=mariadb_test --user=mariadb --password=mariadb mysqltest: Logging to ''. mysqltest: Results saved in ''. mysqltest: Connecting to server (null):3306 (socket /var/run/mysqld/mysqld.sock) as 'mariadb', connection 'default', attempt 0 ... mysqltest: Could not open connection 'default': 1044 Access denied for user 'mariadb'@'localhost' to database 'name=mariadb_test' not ok net1# mysqltest --verbose --host=localhost --database=name=mariadb_test --user=mariadb --password=mariadb mysqltest: Logging to ''. mysqltest: Results saved in ''. mysqltest: Connecting to server localhost:3306 (socket /var/run/mysqld/mysqld.sock) as 'mariadb', connection 'default', attempt 0 ... mysqltest: Could not open connection 'default': 1044 Access denied for user 'mariadb'@'localhost' to database 'name=mariadb_test' not ok net1# /usr/bin/mysql --defaults-extra-file=/etc/mysql/debian.cnf -e 'SELECT db,user,host FROM mysql.db WHERE db="mariadb_test"' +--------------+---------+-----------+ | db | user | host | +--------------+---------+-----------+ | mariadb_test | mariadb | localhost | +--------------+---------+-----------+ Obviously I'm missing something simple + having a complete example would help. Please update this question with all steps required to run mysqltest. Thanks. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/question-about-testing/

1 0

[Maria-discuss] New Question: JSON error
by AskMonty KB 14 Mar '14

14 Mar '14

Hello, A new question has been asked in "MariaDB community" by miroigov: -------------------------------- Hello, I installed MariaDB Manager on CentOS 6.5 and when i open in browser http://domain.com:8080/MariaDBManager/ it starts loading and then displays error : API did not return JSON for: GET http://localhost/consoleAPI/api/user HTTP 500 - Errors: HTTP/1.1 500 Internal Server Error - The API is unable to function because PHP JSON functions are not available I do not have experience with Tomcat and have no idea how to set json for php. I have php 5 install and json is working fine with default config /etc/php.ini -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/json-error/

1 0

[Maria-discuss] New Question: Permanent link to download last version of MariaDB
by AskMonty KB 12 Mar '14

12 Mar '14

Hello, A new question has been asked in "MariaDB FAQ" by francocorbelli: -------------------------------- I suggest to create permanent link to last version of a given series. Something like this https://downloads.mariadb.org/mariadb-5.5/mariadb-current-winx64.msi With best regards for a great project. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/permanent-link-to-download-last-version-of-mariadb/

1 0

[Maria-discuss] New Question: creating pivot table fails
by AskMonty KB 12 Mar '14

12 Mar '14

Hello, A new question has been asked in "CONNECT Table Types" by nobswolf: -------------------------------- I tried to create a pivot table based on an existing table "test1" and get an error. I am logged in and I can use "test1", so this error makes no sense to me. What I am doing wrong? Any hints? MariaDB [nav]> create table xsort engine=connect table_type=pivot tabname=test1; ERROR 1105 (HY000): (1045) Access denied for user 'root'@'localhost' (using password: NO) MariaDB [nav]> -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/creating-pivot-table-fails/

1 0

[Maria-discuss] postfixadmin and mariadb, want to add support for user 'groups'
by Tanstaafl 12 Mar '14

12 Mar '14

Hello all, We have a postfixadmin+mariadb sql database we have been using for many, many years (well, only recently migrated from mysql to mariadb, and it was totally transparent, so thanks for that!). This system is rock solid, and we have no desire to change it. We are in the process of setting up SOGo groupware, amd have run into a stumbling block. Not a show stopper, but it definitely put a heavy burden on me, as the SysAdmin. SOGo can Active Directory just fine for testing Group Memberships for purposes of applying ACLs (for shared calendars, contacts, etc)... We intentionally do not use SSO - we enforce very strong email passwords, but allow much weaker AD computer passwords - so email AUTH happens with our SQL DB. The problem is, SOGo does not have support for using 'Groups' for ACLs when using SQL for the AUTH backend. It also does not (yet) have support for different AUTH and USER DB backends. So, as things stand now, I'm going to have to manually add every single individual userid to every single resource they will need to have access too, rather than just doing this with groups. So, my first questions is, has anyone every come up with a decent schema that provides for managing user groups in the same way as AD groups that scales reasonably well? I'm very dangerous when it comes to this stuff, so can't even attempt this myself, but I have some options available to help get this done, especially if I can get some help/advice with getting started. One thing I do know is the SOGo guy had to create a 'View' to use, so whatever we end up using will have to work inside a View (probably displaying my ignorance to the world with that comment - is pretty much everything in an SQL DB compatible with 'Views'?)... I'd dearly appreciate any help anyone is willing to give... Thanks, Charles

3 5

[Maria-discuss] InnoDB selected projects (corrected links)
by Jan Lindström 12 Mar '14

12 Mar '14

Hi all, After careful weighting and selection process, I have selected following two projects as a starting point to improve InnoDB (1) InnoDB file space defragmentation Description: External tool to physically delete delete marked rows from InnoDB file space and freeing unused file space. https://mariadb.atlassian.net/browse/MDEV-5834 (2) InnoDB fast bulk load Description: External tool to load CVS file directly to InnoDB file space (innodb_file_per_table = 1). https://mariadb.atlassian.net/browse/MDEV-5835 Now, I hope these projects mostly represent the most frequently requested features and are most usable to current customers and/or potential new customers. Next, I would hope some indication which one of the selected project you would like to see first. Votes can be added above links. R: -- -- Jan Lindström, Principal Engineer SkySQL - The MariaDB Company MariaDB | MaxScale | skype: jan_p_lindstrom www.skysql.com <http://www.skysql.com/> Twitter <http://twitter.com/skysql> Blog <http://www.skysql.com/blog/> Facebook <http://www.facebook.com/skysql> LinkedIn <http://www.linkedin.com/company/1214250> Google+ <https://plus.google.com/117544963211695643458/posts>

1 0

[Maria-discuss] MariaDB 10.0.9 now available
by Daniel Bartholomew 10 Mar '14

10 Mar '14

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.9. This is a Release Candidate (RC) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.9 - Release Notes: https://mariadb.com/kb/en/mariadb-1009-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-1009-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.9 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 - - - - - - - - - - - - - - - - - - - - - - - - - SkySQL has held several MariaDB-focused Webinars recently which are available on an on-demand basis at: - http://www.skysql.com/why-skysql/webinars/ They are also planning several more MariaDB-focused webinars that will be held over the comming months. Details available at the above link. - - New MariaDB Book - - - - - - - - - - - - - - - - - - - - - - - - - A new MariaDB book has been released! Getting Started with MariaDB is a how-to guide for beginners to help them get up to speed quickly with MariaDB, no previous MariaDB or MySQL experience required. It's available from several booksellers in both paperback and DRM-free epub, mobi and pdf formats. See the PacktPub website for details: - http://www.packtpub.com/getting-started-with-mariadb/book - - 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: An Enhanced Drop-in Replacement for MySQL 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: unable to START MySQL server at BOOT "systemctl enable mysqld.service" does not work
by AskMonty KB 09 Mar '14

09 Mar '14

Hello, A new question has been asked in "MariaDB community" by asifcyberdome: -------------------------------- unable to START MySQL server at BOOT "systemctl enable mysqld.service" does not work I am running FEDORA 20 and I have MySQL installed or the replacement MariaDB. same difference. I am able to do everything correcty. Everything works, except when I run the command: "systemctl enable mysqld.service", It gives me error "failed to issue method call: no such file or directory." Is this a known issue? Is this a known BUG? Is there a way to fix this? I am running Fedora 20 MySQL/MariaDB 5.5 version. Any help is greatly appreciated -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/unable-to-start-mysql-server-at-boot-systemctl-ena…

1 0

[Maria-discuss] New Question: V5.5.36 will only use default data directory
by AskMonty KB 08 Mar '14

08 Mar '14

Hello, A new question has been asked in "MariaDB community" by mdavies5: -------------------------------- I installed v5.5.36 on a new Mint16 installation and it started ok. I then modified my.cnf to point to an existing data directory. I made sure that all folders and files were owned by mysql user and the mysql group had permissions to read/write. I also deleted existing files ib_logfile0/1, ibdata1 and aria_log_control as I know these must be recreated. When restarting MariaDb I get: Can't create/write to file '/home/michael/mysql/aria_log_control' (Errcode: 13). Files ib_logfile0 & 1 and ibdata1 were created ok so it is not a permissions problems. Why does only aria_log_control fail to create. If I copy all this data to default /var/lib/mysql and reset my.cnf then they work fine -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/v5536-will-only-use-default-data-directory/

1 0

Re: [Maria-discuss] Index bug in aria engine?
by pslawek83 07 Mar '14

07 Mar '14

Ok i wasn't able to reproduce the issue fully, now data is different ... but again, "skipped rows" number changes, and index sizes differ a lot: Uniq index: http://screencast.com/t/SrBS1L5xeB8 http://screencast.com/t/3dVMU7b69AH2 Normal index: http://screencast.com/t/Zl5Jm2OZ http://screencast.com/t/P3SA8U6duly But again, unique index is working much worse than not unique... while it's bigger http://screencast.com/t/rjexoWKwFF http://screencast.com/t/qYdsmRbRbmG7 I'll quickly explain how tables were created... i first took part of the data with unique index, and made smaller copy, thats table 1 Then i just copied the table changed the index to non-unique. After this i copied the tables once again to be sure files are not fragmented, etc. SHOW WARNINGS returns nothing in both cases. It seems that the additional knowledge (only single row with same data) should make the optimizer and query behave better but it's actually behaving much worse... -- Query for reference: EXPLAIN extended SELECT attrib_id, raw_stats_value_id, sum(impressions)FROM raw_stats_other_copyi1_copy INNER JOIN raw_stats_lookupON raw_stats_lookup_id = raw_stats_lookup.idWHERE domain = 'mydomain.com'AND date = '2014-02-10'GROUP BY attrib_id, raw_stats_value_id; -- Thanks, Slawomir. Dnia 6 marca 2014 17:46 Sergei Golubchik <serg(a)mariadb.org> napisał(a): Hi, pslawek83! On Feb 17, pslawek83 wrote: > Hi Guys, > any comments on this issue? It seems that partial unique indexes can't be used in joins. > https://mariadb.atlassian.net/browse/MDEV-5663 Please, show EXPLAIN EXTENDED (and SHOW WARNINGS after it) for this query of yours. > * Why the server is treating same indexes differently depends on if > they're UNIQUE or not It doesn't, there're almost no differences between UNIQUE and non-unique indexes from the optimizer point of view. Optimizer knows that for a unique index there can be at most one matching row (if all index parts are known and are NOT NULL), for non-unique indexes there can be more. That's basically the only difference. > * That's probably not optimizer issue, as we can't FORCE the index You cannot force the index if it is not applicable at all. > * What's internal difference between unique and non-unique index (eg. > memory / file representation / data structure) none. > * What each index type is suitable for, considering query optimization > (as there's no data i was able to find on topic) Aria only supports BTREE indexes anyway. Regards, Sergei

2 2