January 2015 - discuss - lists.mariadb.org

[Maria-discuss] Password Complexity Plugin
by Adam Scott 01 May '15

01 May '15

Hi, I noticed MySQL 5.6 has a validate_password plugin. Since it's open-source, can we add it to MariaDB 5.5. Or is that bad form, a hot potato, etc.? We need the features of this plugin in our environment, and the PAM integration is looking not a good "fit" (though it's working great). (I'm trying to get it to compile in right now, but it's having issues with the includes so far...working on it). Thanks, Adam C. Scott

4 7

[Maria-discuss] Serious problem with latest (10.0.16) Windows installer - destroys services.
by Peter Laursen 02 Mar '15

02 Mar '15

I have MariaDB 5.5, 10.0 and 10.1 installed (as Windows services named 'maria55'. 'maria10' and 'maria10_1' ) and always update them to latest soon after an update is available. Yesterday morning I installed 10.0.16 on top of 10.0.15 using the .msi installer. When I tried to connect to it a few hours later it was not possible. I thought the service might not be running. It wasn't. Actually it did not exist anymore at all! "net start maria10" returned "service does not exist" (and indeed it did not appear in Windows "services management" interface). I copied the /datadir, uninstalle , did a fresh install of 10.0.16d (choosing the option not to upgrade any existing server) and copied the old /datadir back. Now Maria 10.0(.16) works again. But now I see that the 'maria55' service is also gone from the system. Files are intact. I can repeat the exercise I did with 10.0 of course or install service again from commandline. Not a big problem, but very annoying and waste of time. MariaDB 10.1 installaton is not affected. 5 diiferent Oracle/MySQL servers (from 5.0 to 5.7) also are not. I need all those instances for application testing. Questions: * Has somebody else experienced this? * Has somebody replaced @wlad as maintainer of Windows installers? @wlad was the only person who ever was able to write reasonable MySQL/MariaDB installers. So I would regret that. It is perfectly legal on Windows to have multiple MariaDB servers simultaneously running as Windows services. They won't conflict as long as service name, port, basedir and datadir are all different. What happens with one should not affect another. I the installer does not respect this, it is a bug. -- Peter -- Webyog

5 10

[Maria-discuss] doubt... show table status
by Roberto Spadim 07 Feb '15

07 Feb '15

guys, i'm creating a table with: CREATE TABLE xxx SELECT * FROM yyyy this one take a long time (more than 1 hour) to end... my problem is... i'm using HeidiSQL sometimes to check tables and etc... when i open database it execute a SHOW TABLE STATUS FROM `database` but is blocked while create table don't end, could we implement a non block show table? or a timeout? -- Roberto Spadim SPAEmpresarial Eng. Automação e Controle

2 2

[Maria-discuss] Restated: JSON cannot represent binary data
by Tom Worster 06 Feb '15

06 Feb '15

I think we're getting lost in the detail. Beyond dispute are two facts: 1. BINARY is a valid datatype in dynamic columns. 2. JSON cannot represent binary data. It follows that: COLUMN_JSON() cannot (correctly) represent all dynamic column values. So I ask the question is: What *should* COLUMN_JSON() do when a dynamic column contains BINARY values? When I file a bug report, I like to give an expected result. I don't know what it is in this case. Every other decent JSON encoder errors on such input. Is that what Maria should do?

6 18

[Maria-discuss] MariaDB 10.0.16 now available
by Daniel Bartholomew 03 Feb '15

03 Feb '15

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

[Maria-discuss] The future of Dynamic Columns
by Tom Worster 01 Feb '15

01 Feb '15

I've been excited about the potential uses of Maria's Dynamic Columns (MDC) since I first read about the them. Now I am starting a new application development and want to use MDC. It's a server-side PHP webapp using the Yii 2.0 MVC framework. These days, for typical webapp pages, I seldom write SQL and use the ORM instead. So I started writing an extension to the Yii 2.0 Active Record ORM to provide an abstract interface to read and write structured dynamic attributes as well as use them in queries. I'm trying to do it so that I can make the same API work using PostgreSQL jsonb and perhaps other things. While this is very interesting work, I have developed a vague uncomfortable feeling about MDC. I have the sense that this wicked powerful feature is suffering from atrophy and possibly apathy. Contributing to this sense: 1. I haven't been able to discuss MDC with anyone who uses it. (If you do, contacts below). 2. In at least two places (one was here <https://mariadb.com/kb/en/mariadb/indexoptimizations-in-dynamic-columns/>) I've read text with the implied meaning, "we may improve such-and-such about MDC if and when people start actually using it." 3. The MDC syntax is so clunky I worry that people who might find it useful are turned away. 4. Did the 5.3 version with numbers for column names turn people off MDC for good? 5. The requirement to specify datatype when querying a dynamic column is agonizing. The manual says it is a limitation of SQL itself (presumably immutable) but PostgreSQL manages to avoid it when querying jsonb doc properties. 6. The lack of indexing of dynamic columns is a severe limitation but PostgreSQL manages to index jsonb document properties. And then... 7. I head a rumor that some kind of JSON features are coming to Maria. So, do Maria's Dynamic Columns have a future? Are my fears that MDC will be neglected as some better solution to the same problem receives all the attention? Basically, I'm trying to gauge the risk vs. return in my investment in developing the ORM extension I mentioned at the top. Tom fsb(a)thefsb.org tom[] on Freenode

8 35

Re: [Maria-discuss] JSON and binary strings
by Tom Worster 31 Jan '15

31 Jan '15

I could have been more direct. What should be the expected behavior in the following? SELECT COLUMN_JSON(COLUMN_CREATE('name', UNHEX('C1C2C3C4C5C6'))); From: Tom Worster <fsb(a)thefsb.org> Date: Friday, January 30, 2015 at 9:05 PM To: maria-discuss email list <maria-discuss(a)lists.launchpad.net> Subject: [Maria-discuss] JSON and binary strings BINARY is one of the datatypes you can use with dynamic columns. If you try saving binary string and then retrieve it with COLUMN_JSON() then you get an invalid JSON document back. All the JSON decoders I tested reject such documents. It doesn't make sense to me that COLUMN_JSON() would return a document that's invalid according to the JSON spec and can't be decoded. But I don't know what it should do. It seems that BINARY in dynamic columns means that COLUMN_JSON() is in an impossible position. [On a related note, if you save a valid utf8 string that includes control characters (e.g. "I went down to the river,\nI set down on the bank.") then COLUMN_JSON() fails to escape them. While similar, this I think is a bug.] Tom _______________________________________________ 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

3 11

[Maria-discuss] JSON and binary strings
by Tom Worster 31 Jan '15

31 Jan '15

BINARY is one of the datatypes you can use with dynamic columns. If you try saving binary string and then retrieve it with COLUMN_JSON() then you get an invalid JSON document back. All the JSON decoders I tested reject such documents. It doesn't make sense to me that COLUMN_JSON() would return a document that's invalid according to the JSON spec and can't be decoded. But I don't know what it should do. It seems that BINARY in dynamic columns means that COLUMN_JSON() is in an impossible position. [On a related note, if you save a valid utf8 string that includes control characters (e.g. "I went down to the river,\nI set down on the bank.") then COLUMN_JSON() fails to escape them. While similar, this I think is a bug.] Tom

1 0

[Maria-discuss] New Question: Why are almost all ROWS_EXAMINED values 0 in events_statements_* tables (performance_schema) !?
by AskMonty KB 30 Jan '15

30 Jan '15

Hello, A new question has been asked in "MariaDB Community" by fabian-atrada. Please answer it at http://mariadb.com/kb/en/why-are-almost-all-rows_examined-values-0-in-event… as the person asking the question may not be subscribed to the mailing list. -------------------------------- In the last days I started to explore the new possibilities of the perofmance_schema in 10.0.x. In this process I discovered the valuable event_statemens_* tables, which I could imagine using for some new monitoring approaches. While studying the content of the event_statemens_* on our production DB server, I have noticed, that almost all ROWS_EXAMINED values were always equal 0! Only on one server, in the events_statements_summary_by_digest table could I find a few entries with ROWS_EXAMINED > 0 (but in those cases, both DIGEST and DIGEST_TEXT were NULL ???) .... which is a real pity, because this value seems to be the best one to be used as some kind of "load" indicator (and it can show very quickly, if a query needs an unreasonable amount of rows to be examined ... etc. ..). Now the questions is, why is this happening? As far as I could see, all other values in the event_statemens_* tables seemed to have reasonable values. Only ROWS_EXAMINED was missing notoriously. Is there special reason for this? Is there some instrumentation setting needed to make this work? Is there some server variable which influences this? or is there some very special technical reason - from the servers logic - which prohibits to gather this value most of the time? By the way, I have also observed - and this might coincide with this issue - that neither do I ever see EXAMINED_ROWS > 0 in `information_schema`.`PROCESSLIST`! Even if I fire a lung running query, which uses a table scan. By the way, the only place where I always - and reliably - see ROWS_EXAMINED is in the slow_query_log! I am really curious about the background (and possible reasons) for this - seemingly - strange behavior. Thank you very much! -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/why-are-almost-all-rows_examined-values-0-in-event…

1 0

[Maria-discuss] New Question: What's the chance of a true Boolean data type in MariaDB?
by AskMonty KB 30 Jan '15

30 Jan '15

Hello, A new question has been asked in "MariaDB Community" by RobLewis. Please answer it at http://mariadb.com/kb/en/whats-the-chance-of-a-true-boolean-data-type-in-ma… as the person asking the question may not be subscribed to the mailing list. -------------------------------- As a MySQL user, I've often been bothered by the lack of a true Boolean data type in MySQL. Is there any chance this omission will be filled in MariaDB? And yes, I know there are workarounds. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/whats-the-chance-of-a-true-boolean-data-type-in-ma…

1 0