Re: [Maria-discuss] Expected release of 10.0.28

Hi, Colin! On Oct 05, Colin Charles wrote: > While this isn't authoritative, if you go to jira.mariadb.org, you'll see > it's targeted to be released at 24 November 2016 (but the galera release > claims 13 Oct 2016). This is how I figure out what's coming out next... I've fixed the

Re: [Maria-discuss] Critical Update for CVE-2016-6662

Hi, Alex! On Sep 13, Alex wrote: > From what i noticed , centos6 hosts that were on mysql 5.6 , or mariadb > 10.1.17 is using the mysqld_safe. > Upgraded centos7 hosts , and mysqld_safe is no longer a running process > for mariadb 10.1.17. > > Would this mean that only the hosts that do not

Re: [Maria-discuss] Critical Update for CVE-2016-6662

Hi, Alex! On Sep 12, Alex wrote: > Hello, > > In regards to this zero day remote exploit , it seems MariaDB is also > affected. Percona seems to have released new versions out to fix this. > Any news from MariaDB side ? > >

Re: [Maria-discuss] howto get MariaDB T-Shirts and Hoodies?

Hi, Lukas! On Aug 21, Lukas Lehner wrote: > Hi > > I have lots (> 10) of MongoDB T-Shirts, but I prefer to run MariaDB. Howto > get cool MariaDB Shirts and Hoodies? > > Witch a search engine I found only "Support MariaDB" products (CafePress). > That's not my taste :-( It seems like CafePress

Re: [Maria-discuss] Backporting bug fixes to 1.0?

Hi, Justin! On Aug 24, Justin Swanhart wrote: > I have been fired for speaking out about the GPL and MariaDB actions > that have caused great harm to our ecosystem. I'm sorry to hear that. Where were you fired from? Regards, Sergei Chief Architect MariaDB and secur...@mariadb.org

Re: [Maria-discuss] maxscale 2.0 bug fixes

Hi, Federico! On Aug 17, Federico Razzoli wrote: > 2) At some point MaxScale 2.0 will be open and 3.0 will be released > but not open. When a software exists in both an open and a closed > source, I expect the open form to be low-quality. This applies to all > examples I can think of. I will feel

Re: [Maria-discuss] Help on ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

Hi, Karthick! On Jul 03, Karthick Subramanian wrote: > Dear Experts, > > I almost tried all sort of combinations that I think of very difficult to > crack, but repeatedly failed to satisfy MariaDB not throw this error. > > Can anyone guide me on what is the specific needs for successful

Re: [Maria-discuss] Orphaned TokuDB tables

Hi, Rich! Shall we include it in packages together with ha_tokudb.so? Or is it too dangerous for that? On Aug 02, Rich Prohaska wrote: > Hello All, > > Sometimes, TokuDB gets left in a state where it thinks that parts of a > table exist (as observed in TokuDB's file map), but not all of the >

Re: [Maria-discuss] MariaDB Knowledge base - 500 error

Hi, Karthick! On Jul 27, Karthick Subramanian wrote: > Did anyone facing this 500 error while accessing the Maria DB Knowledge > Base. Thank you. I've just tried it - seems to work for me. And yesterday it worked too. Did you get this error for any KB page or for some specific url? > Don't know

Re: [Maria-discuss] Finicky syntax with RETURNING?

Hi, Rhys.Campbell! On Jul 27, rhys.campb...@swisscom.com wrote: > Hi Sergei, > > Thanks for your response. Shouldn't this work? > > EXPLAIN DELETE uc FROM t1 AS uc > WHERE uc.id IN (SELECT p.id FROM t2 AS p WHERE p.account_id = ) > RETURNING uc.some_id; > > Or does that count in the

Re: [Maria-discuss] Creating Custom Storage Engine

Hi, Jonathan! On Jul 20, Jonathan Ellithorpe wrote: > > Hmm... thanks for pointing that out about system metadata caching. I'll > have the solve the problem of MariaDB thinking something exists > (table/index/...) when it doesn't, or thinking that something doesn't exist > when it does We

Re: [Maria-discuss] Creating Custom Storage Engine

Hi, Jonathan! On Jul 18, Jonathan Ellithorpe wrote: > Hi All, > > I searched around but couldn't find documentation / tutorials on creating a > custom storage backend for MariaDB. Could anyone point me in the right > direction? Storage engine examples in the source tree. "MySQL 5.1 Plugin

Re: [Maria-discuss] Key lengths for file_key_management plugin

Hi, Honza! On Jul 19, Honza Horak wrote: > On 07/15/2016 11:31 AM, Sergei Golubchik wrote: > > > > On Jul 14, Honza Horak wrote: > >> I've asked directly in the documentation page, but maybe someone will > >> know answer here: > >> https://mariadb

Re: [Maria-discuss] mariadb-connect-engine-10.1 : Depends: unixODBC but it is not installable

Hi, Umarzuki! On Jul 13, Umarzuki Mochlis wrote: > 2 of 3 mariadb servers 10.1, ubuntu 16.04 unable to install > mariadb-connect-engine-10.1 with error > > The following packages have unmet dependencies: > mariadb-connect-engine-10.1 : Depends: unixODBC but it is not installable > E: Unable to

Re: [Maria-discuss] Key lengths for file_key_management plugin

Hi, Honza! On Jul 14, Honza Horak wrote: > I've asked directly in the documentation page, but maybe someone will > know answer here: > https://mariadb.com/kb/en/mariadb/data-at-rest-encryption/#comment_2346 > > In that article it is said that 128, 192 or 256-bit keys are supported, > but later

Re: [Maria-discuss] Include TokuDB Hot Backup in the bundled plugin list

Hi, Jocelyn! Yes, it's MDEV-8843. The plan is to do it in 10.1, but it's unlikely to happen in time for the 10.1.15. On Jun 25, jocelyn fournier wrote: > Hi, > > > In MariaDB, TokuDB is bundled as a plugin, but it's not the case for the > Hot Backup plugin

Re: [Maria-discuss] Event types in performance schema

Hi, Rhys.Campbell! On Jun 07, rhys.campb...@swisscom.com wrote: > > I'm doing some stuff with the performance_Schema and have a quick > question about event types. > > These appear in the events_statements_summary_by_account_by_event_name > table (and others) and look like... > >

Re: [Maria-discuss] ALGORITHM INPLACE for 10.0.24-MariaDB

Hi, Rhys.Campbell! On May 04, rhys.campb...@swisscom.com wrote: > Hi All, > > For the following statement... > > ALTER ONLINE TABLE dom_audit_event ENGINE=INNODB, ALGORITHM=INPLACE; > > I can still see that MariaDB is still using the value of tmpdir. We > have this set to tmpfs on some of our

Re: [Maria-discuss] Dynamically rewrite query

Hi, Erik! On Apr 20, Erik Cederstrand wrote: > > CREATE TABLE `t1` ( `i` int(11) NOT NULL, `j` int(11) NOT NULL, `l` > int(11) NOT NULL, `m` int(11) DEFAULT NULL, PRIMARY KEY > (`i`,`j`,`l`)); > > CREATE TABLE `t2` ( `i` int(11) NOT NULL, `k` int(11) DEFAULT NULL, > PRIMARY KEY (`i`))

Re: [Maria-discuss] expire_logs_days

Hi, Reindl! On Apr 05, Reindl Harald wrote: > i find a config variable with "days" just annoying - why - because in > case of thin-provisioned virtual servers it wastes space in > environment where the slave is for sure not down longer then a few > hours and if it is longer down it's just my

Re: [Maria-discuss] The insert performance issue

Hi, 林澤宇! On Mar 10, 林澤宇 wrote: > Hi ALL , > > I test the MariaDB performance of insert command . > I use a file include 10 insert command statements to test the insert > performanc . > On local server ,the Mariadb spent about 20 second to insert data;but on > remote server ,the MariaDB spent

Re: [Maria-discuss] How to rollback XA Transactions

Hi, Marc! While not exactly user-friendly, you can still run $ mysql -e 'xa recover'|hexdump -C You'll see hex data there. Regards, Sergei On Feb 22, Marc Schöchlin wrote: > Hi Justin, > > how can i get the hex representation of the the transaction identification > strings? > ("XA RECOVER

Re: [Maria-discuss] kb login doesn't work!

Hi, Justin! On Feb 22, Justin Swanhart wrote: > I said it returns a 500! > > I don't know why it doesn't work for my account. > > And it doesn't change the fact that you can't reply to messages from > this mailing list. How hard is it to make it do so? Seriously, others > have complained about

Re: [Maria-discuss] Adding timestamp column to a system

Hi, Peter! On Jan 29, Peter Mclarty wrote: > Hi All > Running Mariadb 10.0.16 and need to add a timestamp column to a table with > has around 60m rows > > Testing on lesser hardware instances suggest around 40 minutes to make this > change on the production system. > > To reduce the down time I

Re: [Maria-discuss] mariadb on freebsd: spinlocks or mutex?

Hi, Federico! On Jan 21, Federico Razzoli wrote: > While compiling MariaDB on FreeBSD, I've noted that it can optionally > be compiled with spinlocks instead of mutexes. What's the best choice? > Any experience? Yes, this option enables MariaDB "fast mutexes". They're disabled by default for

Re: [Maria-discuss] Select optimizations

Hi, Roberto! On Jan 20, Roberto Spadim wrote: > Hi guys! There's a "easy/fast" way to rewrite a query from this: > > Select datetime,key,value from table where ... > > To this: > > Select datetime, value1 as key1, value2 as key2, From table where ... > > I don't remember the right name

Re: [Maria-discuss] mariadb still uses indexes with high average value group size.

Hi, dE! On Jan 02, dE wrote: > Hi! > I was playing around with indexes after we faced problems with > mariadb choosing the wrong index because of high average value group size. > > So I created a table with 4 text columns and indexed the 4th column with > a prefix length of 1. > >

Re: [Maria-discuss] MariaDB 10.0.23 now available

Hi, Reindl! On Dec 19, Reindl Harald wrote: > > [root@buildserver:~]$ mysql-test.sh > Logging: ./mysql-test-run.pl --default-myisam --parallel=1 > --max-test-fail=0 --mysqld=--binlog-format=mixed --skip-ndb --force > Invalid option "--default-myisam" > > seriously in a minor-update? You're

Re: [Maria-discuss] MariaDB 10.1.8 Stable (GA) now available

Hi, Honza! On Dec 09, Honza Horak wrote: > Just a friendly poke to see whether there are some news about 10.1 > support/EOL plans.. Thanks and sorry for not getting to you earlier. We've just decided to support all GA releases for five years, so 10.1 will EOL at the end of 2020. But the

Re: [Maria-discuss] mysql_install_db as user

Hi, Felipe! On Nov 12, Felipe Gasper wrote: > Hello, > > Is this script supposed to be runnable as a normal (i.e., non-root) > user? > > In MySQL 5.6 there is logic that prevents the chown() of the mysql > data dir when running as non-root. MariaDB 10.1.8 doesn’t seem to have > this logic, so

Re: [Maria-discuss] mysql_install_db as user

Hi, Felipe! On Nov 13, Felipe Gasper wrote: > > > > There's no special logic around it in MySQL 5.6 and no changes in > > MariaDB 10.1. > > > > chown is done if user=xxx is specified on the command line or in the > > my.cnf file. And if chown fails, you'll see the error message and > >

Re: [Maria-discuss] TokuDB + virtual column

Hi, Roberto! On Nov 03, Roberto Spadim wrote: > Hi guys, there's a plan to include virtual column to tokudb storage? > > > /* Erro SQL (1910): TokuDB storage engine does not support computed columns > */ It's MDEV-6186. As for the _plan_ - I don't know yet, ask again in a couple of weeks :)

Re: [Maria-discuss] MariaDB 10.0.22 now available

Hi, Reindl! Could you show more of the build log please? You've cut the compiler error out. On Oct 30, Reindl Harald wrote: > seems to be broken - at least i don't expect anything to for a minor > release then just chnage the version line in a RPM-SPEC and fire > "rpmbuild -bb" > > [ 45%]

Re: [Maria-discuss] MariaDB 10.0.22 now available

Hi, Reindl! On Oct 30, Reindl Harald wrote: > Am 30.10.2015 um 09:20 schrieb Sergei Golubchik: > > > > Could you show more of the build log please? You've cut the compiler > > error out. > > output of "rpmbuild -bb mariadb.spec >> mariadb.log 2>> maria

Re: [Maria-discuss] Error when migrating from TokuDB 7.5.2 to MariaDB 5.5.44 (works with 5.5.41)

Hi, Fernando! On Sep 28, Fernando Marcelo wrote: > I'm trying to migrate a TokuDB 7.5.2 server to MariaDB 5.5.44. > > Since I can't stop the production server, I got a snapshot of the running > instance. So MariaDB will have to recover. > > Unfortunately i get an error when TokuDB recovery is

Re: [Maria-discuss] what is adding the -g compile parm?

Hi, Reindl! On Sep 20, Reindl Harald wrote: > Am 20.09.2015 um 19:14 schrieb Sergei Golubchik: > > > > On Sep 20, Reindl Harald wrote: > >> "-O3 -g" appears in the cmake output, that likely breaks ld.gold / -flto > >> and so the question: who t

Re: [Maria-discuss] what is adding the -g compile parm?

Hi, Reindl! On Sep 20, Reindl Harald wrote: > "-O3 -g" appears in the cmake output, that likely breaks ld.gold / -flto > and so the question: who the explain the build *not* add that useless > param for production builds like most oterh software don't > > without one could also remove the

Re: [Maria-discuss] writing plugin with .net language (C#)

Hi, Roberto! On Sep 18, Roberto Spadim wrote: > guys , i'm still with doubts... but not more about c#, now about c++ > i was thinking about rewrite the code with c++ > > my doubt is could i use C++ 11 ? or i will have problem with mariadb > makefiles etc etc? Sure, you can use any language

Re: [Maria-discuss] Cross compile issue

Hi, Johnson! Thanks a lot! Based on this thread I've created a page in the knowledge base with the instructions: https://mariadb.com/kb/en/mariadb/cross-compiling-mariadb/ Hopefully, the next developer who will try cross-compiling MariaDB will find it almost as simple as normal compilation :)

Re: [Maria-discuss] writing plugin with .net language (C#)

Hi, Roberto! On Sep 13, Roberto Spadim wrote: > Hi guys, > I have a program wrote in c#, it process some code and the result is a > struct (an array of string/double/int) > I want to include this program inside mariadb server as a daemon plugin (to > process data) + a storage engine (to read

Re: [Maria-discuss] MySQL 5.7 JSON

Hi, Tom! On Sep 03, Tom Worster wrote: > Are MySQL 5.7 JSON features > -json> likely to end up in MariaDB anytime? If so, would it be 10.2? Yes, likely. Yes, 10.2. Although this is not a promise - 10.2 is still being

Re: [Maria-discuss] Cross compile issue

Hi, Johnson! On Sep 03, Johnson Cheng wrote: > Dear Sergei, > > Thanks for your reply. > I am not sure what it happened because it is disappeared when I > re-cross-compile mariaDB at another new environment. > Actually I am dig out a problem about DB_TXN error message as below, > [ 80%]

Re: [Maria-discuss] Cross compile issue

Hi, Johnson! On Sep 01, Johnson Cheng wrote: > Dear Sergei, > > I am sorry that I meet another cross compile issue about this, > > Linking CXX shared module ha_archive.so > [ 72%] Built target archive > Scanning dependencies of target tokuportability_static_conv > [ 72%] Building CXX object >

Re: [Maria-discuss] Cross compile issue

Hi, Johnson! On Aug 27, Johnson Cheng wrote: Dear Sergei, Sorry to update again. (I am a newer on cmake) I did some modifications on my configure command as below, LD=/home/johnson/x86_64_TCglibc-2.19-3/usr/bin/x86_64-buildroot-linux-gnu-ld

Re: [Maria-discuss] Cross compile issue

Hi, Johnson! On Aug 27, Johnson Cheng wrote: Dear Sergei, Thanks for your reply. I am sorry that I can NOT find any document about cross compile from knowledge base. https://mariadb.com/kb/en/mariadb/getting-installing-and-upgrading-mariadb/ Yes, that's why I suggested to search the

Re: [Maria-discuss] Cross compile issue

Hi, Johnson! On Aug 25, Johnson Cheng wrote: Hi, I have problem to do cross compile on mariadb-10.0.21. Where can I find the relative document? Check the knowledgebase and if there's nothing there, then mailing list archives. I'm not sure about knowledgebase, but this topic was certainly

Re: [Maria-discuss] Latest round of Oracle CVE status on MariaDB

Hi, Brian! Thanks. I've updated the security page now. I think that CVE-2015-4757 is fixed in 5.5.43 (and 10.0.18), and CVE-2015-4752 CVE-2015-2648 CVE-2015-2643 CVE-2015-2582 are fixed in 5.5.44 (and 10.0.20). While I cannot be sure what CVE-2015-4737 and CVE-2015-2620 are about, I

Re: [Maria-discuss] why stdout? - [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 115096

Hi, Reindl! On Aug 06, Reindl Harald wrote: Aug 6 12:24:24 testserver mysqld: 150806 12:24:24 [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 115096 ... why is this now stdout instead mysql logs? I cannot repeat it. Here: $ ./mysqld out 2err $ grep starting err

Re: [Maria-discuss] why stdout? - [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 115096

Hi, Reindl! On Aug 06, Reindl Harald wrote: Am 06.08.2015 um 14:25 schrieb Sergei Golubchik: On Aug 06, Reindl Harald wrote: Am 06.08.2015 um 13:56 schrieb Sergei Golubchik: On Aug 06, Reindl Harald wrote: Aug 6 12:24:24 testserver mysqld: 150806 12:24:24 [Note] /usr/libexec/mysqld

Re: [Maria-discuss] will maria db overcome mysqls feature limitations? (foreign keys+triggers, recursive triggers)

Hi, Ludwig! On Jun 21, Ludwig Gramberg wrote: Hi, I was wondering if mariadb plans to overcome mysqls limitations such as - foreign key operations do not start triggers - triggers can’t be recursive (error 1442) I haven't heard about any plans about these specific limitations. That's

Re: [Maria-discuss] will maria db overcome mysqls feature limitations? (foreign keys+triggers, recursive triggers)

Hi, Justin! On Jul 19, Justin Swanhart wrote: Hi, Foreign keys need support in SE to fix the first item. Cascading operations don't work for triggers, but even worse, they don't work for RBR replication if a) storage engines differ on master and slave or b) the slave lacks the

Re: [Maria-discuss] MariaDB 10.1.4 Progress output

Hi, Rhys! On Apr 20, Rhys Campbell wrote: Note the progress output below. I've seen several like this. i.e... Stage: 1 of 72 'altering table' 350% of stage done. Is this intentional? No, not exactly :) This happens when the engine miscalculates number of steps it needs to do for an ALTER.

Re: [Maria-discuss] performance_schema

Hi, Rhys! On May 14, Rhys Campbell wrote: Hi All, Does anyone know if the performance_schema guarantees that every statement executed will appear in the events_statement_summary_by_digest table (excluding those that could be pushed out due to size restrictions). Or is it a best effort

Re: [Maria-discuss] query cache dump_at_shutdown/load_at_startup useful + no character set/collation?

Hi, Daniel! On May 12, Daniel Black wrote: I was testing out using the query_cache_info plugin (https://mariadb.com/kb/en/mariadb/query_cache_info-plugin/) to pre-cache data into a server after an upgrade. The read only slaves have a fairly high cache hit ratio. select concat('use ',

Re: [Maria-discuss] MariaDB 10.0.18 now available

Hi, Reindl! On May 07, Reindl Harald wrote: No, it affects the server, not mysql_upgrade. But it's a new statement, that mysql_upgrade is using, no existing query can possibly trigger that bug well, in other words anybody could crash the server by write a specific query and so i am

Re: [Maria-discuss] MariaDB 10.0.18 now available

Hi, Reindl! On May 07, Reindl Harald wrote: Am 07.05.2015 um 21:27 schrieb Sergei Golubchik: Hi, Reindl! On May 07, Reindl Harald wrote: Don't build on Fedora 21 / gcc-4.9.2-6.fc21.x86_64 but on Fedora 20 / gcc-4.8.3-7.fc20.x86_64 which is not a good sign since 10.0.17 with identical

Re: [Maria-discuss] MariaDB 10.0.18 now available

Hi, Reindl! On May 07, Reindl Harald wrote: Am 07.05.2015 um 22:29 schrieb Sergei Golubchik: On May 07, Reindl Harald wrote: Am 07.05.2015 um 21:02 schrieb Reindl Harald: Don't build on Fedora 21 / gcc-4.9.2-6.fc21.x86_64 but on Fedora 20 / gcc-4.8.3-7.fc20.x86_64 which is not a good

Re: [Maria-discuss] MariaDB 10.0.18 now available

Hi, Reindl! On May 07, Reindl Harald wrote: Am 07.05.2015 um 21:02 schrieb Reindl Harald: Don't build on Fedora 21 / gcc-4.9.2-6.fc21.x86_64 but on Fedora 20 / gcc-4.8.3-7.fc20.x86_64 which is not a good sign since 10.0.17 with identical environment builds on both and the Fedora 20

Re: [Maria-discuss] MariaDB 10.0.18 now available

Hi, Reindl! On May 07, Reindl Harald wrote: interesting - in fact it's -mtune=sandybridge versus -mtune=westmere while i am pretty sure that i rebuilt any local maintained packages recently for sandybrige to test because a hardware replacement is planned in august resulting in the oldest

Re: [Maria-discuss] Password Complexity Plugin

Hi, Adam! On Apr 27, Adam Scott wrote: It's taken some time, but I have backported the simple_password_check plugin and the password api to MariaDB 5.5 The mysql-test is succeeding on all but the test of the strict_password_validation variable. My question is, should a pure backport

Re: [Maria-discuss] user map auth plugin

Hi, Felipe! On Apr 28, Felipe Gasper wrote: So, I recently wrote an auth plugin with the intent of implementing a simple user map, authenticated against the hashed password that would be retrieved via the normal password entry scheme. I got far too far along before realizing that this

Re: [Maria-discuss] Proxy users in MariaDB?

Hi, Felipe! On Apr 24, Felipe Gasper wrote: On 4/23/15 5:48 PM, Geoff Montee wrote: I'm not a big fan of this bit from the MySQL documentation: When a single account has been granted proxy privileges on more than one account, the server mapping is nondeterministic. Therefore,

Re: [Maria-discuss] How many open files by daemon is still sane?

Hi, Justin! On Apr 21, Justin Swanhart wrote: It is in fact, negatively scaleable without partitioning it: http://www.percona.com/blog/2009/11/16/table_cache-negative-scalability/ This doesn't directly apply to MariaDB. We didn't partition it because our table definition cache is lock-free.

Re: [Maria-discuss] SHOW GRANTS change?

Hi, Felipe! On Apr 13, Felipe Gasper wrote: Note: I believe “dbguy” came from a My5.6 - Ma10.0 upgrade. Is it possible that something in MariaDB isn’t reading MySQL stuff correctly? Could be. There was one issue in the way MySQL started confusing a password and the authentication string

Re: [Maria-discuss] [Maria-developers] Enabling feedback pluging for MariaDB 10.1.4

Hi, Ian! On Mar 11, Ian Gilfillan wrote: I understand that the statistics would have some meaning, and understand that there's no actual data being sent, etc. However, enabling the feedback plugin by default IS going to create a whole lot of negative publicity for MariaDB. Is the limited

Re: [Maria-discuss] [Maria-developers] Enabling feedback pluging for MariaDB 10.1.4

Hi, Jeremy! On Mar 12, Jeremy Cole wrote: But asking people to please enable the feedback plugin just doesn't work. It seems that most of our users don't care about it at all - I mean, they don't care whether it's enabled or not, and don't care to do anything. That is, if the plugin is

Re: [Maria-discuss] [Maria-developers] Enabling feedback pluging for MariaDB 10.1.4

Hi, Vladislav! On Mar 12, Vladislav Vaintroub wrote: Hi Serg, On 03/12/15 09:17, Sergei Golubchik wrote: MariaDB Windows installer has a special dialog about it with a checkbox that's enabled by default, if I'm not mistaken). I'm sorry, but you are mistaken :) Checkbox is off

Re: [Maria-discuss] R: GSOC 2015 :UDFs returning arrays

Hi, Justin! On Mar 10, Justin Swanhart wrote: wl#820 also has table functions in it: http://antbits.blogspot.com/2009/01/table-functions-in-mysql.html mysql INSTALL PLUGIN Deep_Thought SONAME 'psm_example.so'; mysql CREATE FUNCTION test.FooAnswer() - RETURNS TABLE(answer TEXT) -

Re: [Maria-discuss] Enabling feedback pluging for MariaDB 10.1.4

Hi, Justin! On Mar 09, Justin Swanhart wrote: I agree with Kristian. Given the way it works, the statistics are really meaningless and I feel you shouldn't drive important choices based on bad statistics. Of course. This statistics is not *the only* argument. For important decisions there

Re: [Maria-discuss] Enabling feedback pluging for MariaDB 10.1.4

Hi, Kristian! On Mar 09, Kristian Nielsen wrote: As most MariaDB users should know, the feedback is totally anonymous and no private or sensitive information is being sent. Any comments, suggestions or recommendations? I think it is a bad idea. Please do not do it. Phone-home is a

Re: [Maria-discuss] Enabling feedback pluging for MariaDB 10.1.4

Hi, Adam! On Mar 09, Adam Scott wrote: Maybe make it an option when installing? Yes, that'd be great. On Windows there's a GUI installer, and it has a checkbox for feedback plugin. That's why we get 95% of reports from Windows. Most users don't mind having it enabled, so it seems. So if

Re: [Maria-discuss] Enabling feedback pluging for MariaDB 10.1.4

Hi, Justin! On Mar 10, Justin Swanhart wrote: Where is it described exactly what is collected? Descriptions I see say it is basically ... well, no, I want a full description of all data collected, particularly if it collects versions of software as knowing what version of software I'm

Re: [Maria-discuss] Enabling feedback pluging for MariaDB 10.1.4

Hi, Federico! On Mar 10, Federico Razzoli wrote: I am no lawyer, but please consider possible legal problems for users. 1) I sign an NDA with my customer 2) I enable Feedback 3) You see things I shouldn't reveal. I know that my data are not sent. And you say it's anonymous. But you will

Re: [Maria-discuss] stored programs

Hi, Justin! On Mar 03, Justin Swanhart wrote: So uhmm, use a new parser. Like the one antony wrote in LLVM? :) I mean, we would like to have window functions, CTE, and all those other fun things. SQL-92 is a not relevant anymore. In MySQL times we've tried to replace a parser. Twice. Antony

Re: [Maria-discuss] stored programs

Hi, Igor! On Mar 03, Igor Babaev wrote: I'd also like to discuss window functions too. I've implemented them in shard-query and have ideas about how to implement them in the server, but pluggable parser would be really useful here. Window functions have a good chance of being in

Re: [Maria-discuss] Giving up on dynamic columns

Hi, Tom! On Mar 01, Tom Worster wrote: so it turns out the problem is my incompetence. i thought blob allowed long values. i've been using mysql since 3.something and i still don't know much about its abundance of types. i retract my comments and crawl back into my hole. In fact, I

Re: [Maria-discuss] Dependency questions regarding MariaDB 10 on CentOS6.5 with local mirror of repo

Hi, Sophie! On Feb 23, Sophie L wrote: Hi everybody, I mirrored MariaDB repo,but noticed servers had unmet dependencies when I tried to install. I have this message: Error: Package: MariaDB-client-10.0.16-1.fc20.x86_64 (mariadb) Error: Package:

Re: [Maria-discuss] doubt... show table status

Hi, Roberto! On Dec 15, Roberto Spadim wrote: guys, i'm creating a table with: CREATE TABLE xxx SELECT * FROM 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

Re: [Maria-discuss] Restated: JSON cannot represent binary data

Hi, Tom! On Feb 03, Tom Worster wrote: Hi Sergei, On 2/3/15, 7:13 AM, Sergei Golubchik s...@mariadb.org wrote: A dynamic column cannot be NULL, so using a JSON null (a different kind of null) to express dynamic column exists but cannot be represented as requested should work. The ORM

Re: [Maria-discuss] Serious problem with latest (10.0.16) Windows installer - destroys services.

Hi, Peter! On Jan 31, Peter Laursen wrote: 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

Re: [Maria-discuss] The future of Dynamic Columns

Hi, Tom! On Jan 27, Tom Worster wrote: 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. While I know

Re: [Maria-discuss] Inclusion of Mysql security fixes in MariaDB

Hi, Raina! On Jan 23, Raina Masand wrote: Hello, We recently were informed of some security fixes in Mysql 5.5.41: http://www.ubuntu.com/usn/usn-2480-1/ and are wondering whether there are plans to include these in an upcoming MariaDB release. Right now, we are running 10.0.13, so we're

Re: [Maria-discuss] build minimized MariaDB 10.0.x

Hi, Reindl! On Jan 19, Reindl Harald wrote: https://mariadb.atlassian.net/browse/MDEV-7076 well, in general i try to only have Aria/XtraDB/MyISAM -DWITH_XTRADB_STORAGE_ENGINE=ON \ -DWITH_PARTITION_STORAGE_ENGINE=ON \ -DWITH_ARCHIVE_STORAGE_ENGINE=OFF \

Re: [Maria-discuss] Spider - query end

Hi, Nicolas! On Dec 19, Nicolas Payart wrote: Hi list, I am using Spider Storage Engine for sharding data and remote access to some innodb tables on 3 different MariaDB 10.0.14 instances. It performs quite well in production except that sometimes, some queries (a minority of them

Re: [Maria-discuss] the future of --skip-innodb

Hi, Federico! On Dec 14, Federico Razzoli wrote: Hi. In MySQL 5.7 documentation: https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html I read: As of MySQL 5.7.5, the InnoDB storage engine can no longer be disabled, and the --innodb=OFF and --skip-innodb options are

Re: [Maria-discuss] mariadb 10 build/link ignores specified linker path to specified lib (pcre). correct method?

Hi! On Dec 10, grantksupp...@operamail.com wrote: building mariadb 10.0.15 on linux/64 i have a non-system instance of (lib)pcre, installed in /usr/local/test/pcre, that i need to build/link against ... cmake .. \ ... -DCMAKE_C_FLAGS=...

Re: [Maria-discuss] mariadb 10 build/link ignores specified linker path to specified lib (pcre). correct method?

Hi, grantksupport! On Dec 13, grantksupp...@operamail.com wrote: On Sat, Dec 13, 2014, at 12:45 PM, Sergei Golubchik wrote: Your command is almost correct. You only need to set CMAKE_EXE_LINKER_FLAGS, because CMAKE_SHARED_LINKER_FLAGS is used for linking shared libraries. Or you

Re: [Maria-discuss] R: Doubt about 'atomic' insert

Hi, Federico! On Dec 13, Federico Razzoli wrote: INSERT SELECT is not standard SQL. But there is no reason to have a duplicate value error. Why do you think it's not? Here, in sql:2003 standard, part 2: insert statement ::= INSERT INTO insertion target insert columns and source insert

Re: [Maria-discuss] Doubt about 'atomic' insert

Hi, Roberto! On Dec 13, Roberto Spadim wrote: Hi guys i'm with a doubt about the standard (sql standand?) error reporting , about INSERT SELECT... should this insert select return duplicate key? INSERT INTO errorsX (id) SELECT MAX(id)+1 FROM errorsX; considering: CREATE TABLE

Re: [Maria-discuss] MariaDB 10.0.15 now available

Hi, Peter! On Dec 09, Peter Laursen wrote: But most important TokuDB plugin does not load. This may because this is SuSE 12.3 (that may ship with another C-runtime etc. than what 12.1 and 12.2 did). INSTALL SONAME 'ha_tokudb'; -- Error Code: 1123 -- Can't initialize function 'TokuDB';

Re: [Maria-discuss] MariaDB 10.0.15 now available

Hi, Daniel! Perhaps we should put a note for every new platform that we add (was CentOS 7, now it's openSUSE) that this is a new platform, just added, a first release for it, so while binaries are same as everywhere and stable, the packaging (conflicts, dependencies) is new and might have some

Re: [Maria-discuss] MariaDB 10.0.15 now available

Hi, Peter! On Nov 26, Peter Laursen wrote: (and please add TokuDB and InfiniDB soon. ¨'playing around' with TokuDB was my primary motivation for all this) As far as I can see, tokudb is present in MariaDB-10.0.15-opensuse13_1-x86_64-server.rpm. Did you install the plugin? INSTALL SONAME

Re: [Maria-discuss] MariaDB 10.0.15 now available

Hi, Peter! On Nov 26, Peter Laursen wrote: NO.. I thought it would bea separate RPM (Like the OQGraph). I will check when I get time. it coudl take a day or two now. Sorry for false alarm. As a general rule we put in separage packages plugins that require additional dependencies. OQGraph

Re: [Maria-discuss] MariaDB 10.0.15 now available

Hi, Peter! On Nov 26, Peter Laursen wrote: If TokuDB has no dependencies, that the server does not have, why is it then not available on Windows? If it is, then Windows should be listed on same page. It doesn't compile on Windows, as far as I understand. Regards, Sergei

Re: [Maria-discuss] MariaDB 10.0.15 now available

, Sergei Golubchik s...@mariadb.org wrote: On Nov 26, Peter Laursen wrote: If TokuDB has no dependencies, that the server does not have, why is it then not available on Windows? If it is, then Windows should be listed on same page. It doesn't compile on Windows, as far as I understand

Re: [Maria-discuss] MariaDB for OpenSuSE 12.3

Hi, Peter! On Nov 24, Peter Laursen wrote: Thanks Elena. That even I can understand. But error on installation of server packet No packet found allowing for the action specified. I am simply launching YaST graphical interface from the context menu of the RPM file placed on my desktop

Re: [Maria-discuss] MariaDB for OpenSuSE 12.3

Hi, Peter! We've recently started building on SuSE: http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-opensuse13_1-x86_64 http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-opensuse13_1-x86 This is a new builder and we haven't made any releases of these binaries yet, as far as I

Re: [Maria-discuss] Excluding plugins when building MariaDB 10.1

Hi, Kolbe! On Sep 03, Kolbe Kegel wrote: Hi! I'm trying to build MariaDB 10.1 on OS X. cmake ../server/ -DBUILD_CONFIG=mysql_release -DWITH_SSL=system -DCMAKE_CXX_FLAGS:STRING='-stdlib=libstdc++' -DPLUGIN_TOKUDB=NO -DPLUGIN_OQGRAPH=NO -DWITH_EMBEDDED_SERVER:BOOL=OFF -DWITH_WSREP=OFF

Re: [Maria-discuss] Excluding plugins when building MariaDB 10.1

Hi, Kolbe! On Sep 04, Kolbe Kegel wrote: On Sep 3, 2014, at 11:20 PM, Sergei Golubchik s...@mariadb.org wrote: On Sep 03, Kolbe Kegel wrote: I'm trying to build MariaDB 10.1 on OS X. cmake ../server/ -DBUILD_CONFIG=mysql_release -DWITH_SSL=system -DCMAKE_CXX_FLAGS:STRING='-stdlib

Re: [Maria-discuss] Upgrade from 10.0.12 - 10.0.13 changes default config file location behavior; build-time -DDEFAULT_SYSCONFDIR= is now ignored ?

Hi, grantksupport! On Aug 12, grantksupp...@operamail.com wrote: 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 \

<    1   2   3   4   >