- discuss - lists.mariadb.org

[Maria-discuss] New Question: Coding in MariaDB
by AskMonty KB 27 Apr '16

27 Apr '16

Hello, A new question has been asked in "MariaDB FAQ" by dbamaria. Please answer it at http://mariadb.com/kb/en/coding-in-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- hi, I have the following questions: -What is the language used for coding in MariaDB? -As the Oracle package doesn't exist, how MariaDB structure its code ? -Is there a plugin which can call a Java proc in MariaDB , other than the UDF function (as MariaDB cannot call directly a java proc)? Thanks -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/coding-in-mariadb/

1 0

[Maria-discuss] New Question: server do not permit root to log in
by AskMonty KB 27 Apr '16

27 Apr '16

Hello, A new question has been asked in "MariaDB Community" by xav795. Please answer it at http://mariadb.com/kb/en/server-do-not-permit-root-to-log-in/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi I am trying to start the db with mysqld command the server is getting ready for connections but i cant log in with root because access is denied. I tried to start the server with the skip-grant-access options, and i saw that root does not exist in mysql.USER table. I have many error message when the server starts : 2016-04-27 01:24:11 b7074740 InnoDB: Operating system error number 2 in a file operation. InnoDB: The error means the system cannot find the path specified. InnoDB: If you are installing InnoDB, remember that you must create InnoDB: directories yourself, InnoDB does not create them. 160427 1:24:11 [ERROR] InnoDB: Could not find a valid tablespace file for 'mysql/gtid_slave_pos'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue. 160427 1:24:11 [ERROR] InnoDB: Tablespace open failed for '"mysql"."gtid_slave_pos"', ignored. 2016-04-27 01:24:11 b7074740 InnoDB: Operating system error number 2 in a file operation. InnoDB: The error means the system cannot find the path specified. InnoDB: If you are installing InnoDB, remember that you must create InnoDB: directories yourself, InnoDB does not create them. 160427 1:24:11 [ERROR] InnoDB: Could not find a valid tablespace file for 'mysql/innodb_index_stats'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue. 160427 1:24:11 [ERROR] InnoDB: Tablespace open failed for '"mysql"."innodb_index_stats"', ignored. 160427 1:24:11 [Note] InnoDB: 128 rollback segment(s) are active. 160427 1:24:11 [Note] InnoDB: Waiting for purge to start 160427 1:24:12 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1729734 handlersocket: initialized 160427 1:24:12 server_audit: MariaDB Audit Plugin version 1.4.0 STARTED. 160427 1:24:12 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it 160427 1:24:12 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist Does anybody no what to do with this informations? Regards Xavier -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/server-do-not-permit-root-to-log-in/

1 0

[Maria-discuss] MariaDB Galera Cluster 5.5.49 and Connector updates now available
by Daniel Bartholomew 26 Apr '16

26 Apr '16

The MariaDB project is pleased to announce the immediate availability of: - MariaDB Galera Cluster 5.5.49 - MariaDB Connector/J 1.4.3 - MariaDB Connector/C 2.2.3 These are all Stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster 5.5.49 - Release Notes: https://mariadb.com/kb/en/mgc-5549-rn/ - Changelog: https://mariadb.com/kb/en/mgc-5549-cl/ - Downloads: https://downloads.mariadb.org/mariadb-galera/5.5.49 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 Connector/J 1.4.3 - Release Notes: https://mariadb.com/kb/en/mcj-143-rn/ - Changelog: https://mariadb.com/kb/en/mcj-143-cl/ - Downloads: https://downloads.mariadb.org/connector-java/1.4.3/ About MariaDB Connector/J: - https://mariadb.com/kb/en/about-mariadb-connector-j/ MariaDB Connector/C 2.2.3 - Release Notes: https://mariadb.com/kb/en/mcc-223-rn/ - Changelog: https://mariadb.com/kb/en/mcc-223-cl/ - Downloads: https://downloads.mariadb.org/connector-c/2.2.3/ About MariaDB Connector/J: - https://mariadb.com/kb/en/about-mariadb-connector-c/ - - 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/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: Error Starting service
by AskMonty KB 26 Apr '16

26 Apr '16

Hello, A new question has been asked in "MaxScale Getting Started" by cisaksen. Please answer it at http://mariadb.com/kb/en/error-starting-service/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Background: 3 Mariadb Galera servers - 'maxscaleuser'@'hostname%' configured as directed Maxscale 1.4 for SUSE 12 In the maxscale log I see the following errors: Failed to obtain address for host hostname%, Name or service not known. Failed to add user maxscaleuser@hostname% for service [galera service]. This user will be unavailable via maxscale. So I have my maxscaleuser account setup in mysql correctly but it appears that maxscale doesn't like the wildcard % ? is there a way to fix this ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/error-starting-service/

1 0

[Maria-discuss] MariaDB coding questions
by Ghazi Btissam 26 Apr '16

26 Apr '16

Hi, - As the Oracle package does'nt exist, how MariaDB structure its code ? - Is there a plugin which can call a Java proc in MariaDB , other than the UDF function (as MariaDB cannot call directly a java proc)? Thanks

1 0

[Maria-discuss] InnoDB fake changes
by Federico Razzoli 25 Apr '16

25 Apr '16

Hi all I see that 10.2 still has the innodb_fake_changes variable (OFF by default). That feature was stable in Percona Server 5.5, is beta in 5.6, and was removed in 5.7. Is it still there just for compatibility with old configuration files, or is there still a reason to use it? And in that case, is it stable or not? Regards, Federico

4 3

[Maria-discuss] New Question: Mariadb Columnstore on Windows
by AskMonty KB 25 Apr '16

25 Apr '16

Hello, A new question has been asked in "MariaDB Community" by brian_demilia_g. Please answer it at http://mariadb.com/kb/en/mariadb-columnstore-on-windows/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Does anyone know if the upcoming Columnstore storage engine will be usable on Windows? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-columnstore-on-windows/

1 0

[Maria-discuss] New Question: mysqld fills /tmp with file /tmp/#sql_26be_0.MAD
by AskMonty KB 22 Apr '16

22 Apr '16

Hello, A new question has been asked in "MariaDB Documentation" by aferrett. Please answer it at http://mariadb.com/kb/en/mysqld-fills-tmp-with-file-tmpsql_26be_0mad/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- We have MariaDB CE 10.1.11 running on RHEL. We were loading data and started getting this error in the mysqld.log: 2016-04-22 9:45:54 139696698296064 [Warning] mysqld: Disk is full writing '/tmp/#sql_26be_0.MAD' (Errcode: 28 "No space left on device"). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space) We moved the large file out of /tmp, but had to reboot in order to free up the /tmp. Restarted mysqld and it appears to be OK. Any information on what this might be and how to get to root cause will be appreciated. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mysqld-fills-tmp-with-file-tmpsql_26be_0mad/

1 0

[Maria-discuss] GTID replication and SST method
by Craig Bailey 22 Apr '16

22 Apr '16

Hi, I am attempting to get remote replication working from my MariaDB Galera Cluster in the following way: * MariaDB Galera Cluster replicates to a remote MariaDB DR node via standard master slave method using MariaDB GTID o Pick a master node from the cluster o Take a backup with xtrabackup-v2 o Apply backup to slave o Connect the slave to the master and replicate using MariaDB GTID o If master goes down, switch master to another node in the Galera Clutser However I am having problems keeping the GTID in step across all the nodes in the Galera cluster when joining new nodes or re-joining existing nodes. Using the latest version of xtrabackup-v2 the current GTID position is stored in a file as part of the backup, however it does not apply this value to the database when a node is brought into the cluster. A step by step example is below: * Cluster is running fine * Lots of transactions going through, enough that a new joiner would need an SST * Begin joining a new node to the cluster * SST via xtrabackup-v2 happens during this process * The GTID in the donor is 1-1-12345 * SST completes joiner is now part of the cluster * The GTID on the newly joined node is 1-1-1 * We now have an out of sync GTID meaning we cannot simply switch master if our current master goes down. I tried the same scenario using RSYNC as the transfer method and the GTID is replicated across to the joiner without issue. Ideally I would like continue using xtrabackup-V2 as my SST method because it does very little locking on a state transfer. That being the case are there any work arounds for this, such as a way to ensure the GTID is set on the joiner when the SST happens with xtrabackup-v2? On the MariaDB pages it does say "xtrabackup-v2 and xtrabackup SST methods currently do not support GTID" is this up-to-date information? https://mariadb.com/kb/en/mariadb/galera-cluster-system-variables/#wsrep_ss… Thanks, Craig Evertz UK cbailey(a)evertz.com<mailto:cbailey@evertz.com> www.evertz.com This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error please notify the sender (as shown above). Kindly do not reproduce, print or forward any material received in error, please delete it immediately. Evertz UK Limited (Company No. 3458137) is incorporated in England and Wales and has its registered office at 100 Berkshire Place, Wharfedale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5RD. Evertz Singapore Pte Limited (Company No. 200817005N) is incorporated in Singapore and has its registered office at One Marina Boulevard, #28-00. Singapore 018989.

3 4

[Maria-discuss] MariaDB 5.5.49 and updated connectors now available
by Daniel Bartholomew 22 Apr '16

22 Apr '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.49, MariaDB Connector/J 1.4.2, and MariaDB Connector/ODBC 2.0.10. These are all Stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.49 - Release Notes: https://mariadb.com/kb/en/mdb-5549-rn/ - Changelog: https://mariadb.com/kb/en/mdb-5549-cl/ - Downloads: https://downloads.mariadb.org/mariadb/5.5.49 About MariaDB 5.5: - https://mariadb.com/kb/en/what-is-mariadb-55/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB Connector/J 1.4.2 - Release Notes: https://mariadb.com/kb/en/mcj-142-rn/ - Changelog: https://mariadb.com/kb/en/mcj-142-cl/ - Downloads: https://downloads.mariadb.org/connector-java/1.4.2/ About MariaDB Connector/J: - https://mariadb.com/kb/en/about-mariadb-connector-j/ MariaDB Connector/ODBC 2.0.10 - Release Notes: https://mariadb.com/kb/en/mco-2010-rn/ - Changelog: https://mariadb.com/kb/en/mco-2010-cl/ - Downloads: https://downloads.mariadb.org/connector-odbc/2.0.10/ About MariaDB Connector/J: - https://mariadb.com/kb/en/about-mariadb-connector-odbc/ - - 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/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 Storage Engine
by AskMonty KB 21 Apr '16

21 Apr '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/mariadb-storage-engine/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is Cassandra storage engine available for mariadb-enterprise 10.1.13 tarball or rpm packages..as i was looking into tar.gz packages but couldn't find "ha_cassandra.so" plugin? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-storage-engine/

1 0

[Maria-discuss] Dynamically rewrite query
by Erik Cederstrand 21 Apr '16

21 Apr '16

Hello list, I'm administering a MariaDB (10.0.23) backend used by some proprietary software. I'm having trouble with one specific slow query. The tables look like this (simplified for clarity): 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; The problematic query is this: SELECT DISTINCT t2.i, t2.k, t1.j, t1.l, t1.m FROM t2 LEFT JOIN t1 ON t2.i=t1.i WHERE t2.k < 123; The query is slow because the DISTINCT clause forces the query to use a temporary table. Removing DISTINCT makes the query 100x faster. Now, since (t1.i, t1.j, t1.l, t1.m) are guaranteed to be unique (and also (t2.i, t2.k) on their own, if the left join doesn't match), I cannot see how "SELECT ..." and "SELECT DISTINCT ..." can possibly produce different output. So I mention that to the developers of said software, and they reply that they forgot why they added the DISTINCT but that they decided it's too risky to remove it (thereby admitting that they don't comment their code, and don't write unit tests for bugs they find, but I knew that already). I'm aware of "Garbage in, garbage out", but it could also be argued that MariaDB should be smart enough to detect that the DISTINCT is unnecessary and ignore it (should I create a bug report for that?). In the meantime, is there any way I can rewrite queries like this dynamically to remove the DISTINCT clause? MySQL 5.7 documentation mentions query rewrite plugins, but I don't see that mentioned in MariaDB documentation. Any other suggestions are welcome. Thanks, Erik

4 5

[Maria-discuss] New Question: Storage engine support and compatibility constraints
by AskMonty KB 20 Apr '16

20 Apr '16

Hello, A new question has been asked in "MariaDB FAQ" by dbamaria. Please answer it at http://mariadb.com/kb/en/storage-engine-support-and-compatibility-constrain… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, 1- As the storage engine are plugins: - Are there any compatibility constraints between them when they are implemented in the same instance ? - Is there a constraint compatibility with those plugins and the MariaDb core? (any kind of compatibility matrix is appreciated) 2-Who support the MariaDb plugins (storage engines, UDF libraries...)? Thanks and Regards -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/storage-engine-support-and-compatibility-constrain…

1 0

Re: [Maria-discuss] Mariadb 10.1.13 slow stored procedures
by Federico Razzoli 19 Apr '16

19 Apr '16

I don't think that this is a procedure performance problem. The problem seems to be character set conversion. 1) set correctly your server and databases default character set and collation (show variables like '%char', alter database) 2) if your connection uses utf8, and your query/procedures contains a 'string', MariaDB considers 'string' as a utf8 string. Make sure you're using latin1 (with the commant-line client it's the default) To check if the character set is latin1, you can query information_schema.ROUTINES table and check the fields CHARACTER_SET_CLIENT, COLLATION_CONNECTION, DATABASE_COLLATION (or SHOW CREATE PROCEDURE). Regards, Federico -------------------------------------------- Mar 19/4/16, Bruce Carlson <Bruce.Carlson(a)nepean.com> ha scritto: Oggetto: Re: [Maria-discuss] Mariadb 10.1.13 slow stored procedures A: "maria-discuss(a)lists.launchpad.net" <maria-discuss(a)lists.launchpad.net> Data: Martedì 19 Aprile 2016, 10:21 #yiv4011784495 #yiv4011784495 -- _filtered #yiv4011784495 {panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv4011784495 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} #yiv4011784495 #yiv4011784495 p.yiv4011784495MsoNormal, #yiv4011784495 li.yiv4011784495MsoNormal, #yiv4011784495 div.yiv4011784495MsoNormal {margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;} #yiv4011784495 a:link, #yiv4011784495 span.yiv4011784495MsoHyperlink {color:#0563C1;text-decoration:underline;} #yiv4011784495 a:visited, #yiv4011784495 span.yiv4011784495MsoHyperlinkFollowed {color:#954F72;text-decoration:underline;} #yiv4011784495 p.yiv4011784495MsoPlainText, #yiv4011784495 li.yiv4011784495MsoPlainText, #yiv4011784495 div.yiv4011784495MsoPlainText {margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;} #yiv4011784495 span.yiv4011784495PlainTextChar {} #yiv4011784495 .yiv4011784495MsoChpDefault {} _filtered #yiv4011784495 {margin:72.0pt 72.0pt 72.0pt 72.0pt;} #yiv4011784495 div.yiv4011784495WordSection1 {} #yiv4011784495 Thanks for that Federico, I read a little more on the net including the bug report you pointed me to however I did a little more digging and found the following:- Using one of the 476 stored procedures I have in my database, when the procedure passes the command string to the database it adds the following highlighted bits:- SELECT SUM(tblsub.fieldX-tblsub.fieldy) AS Bal FROM tblsub join tblmain on tblsub.keyfield=tblmain.keyfield WHERE tblsub.criteria1= NAME_CONST('refnum',_utf8'S000730128000' COLLATE 'utf8_general_ci') and tblmain.criteria2<5; ‘refnum’ is a passed in parameter. The procedeure is a function and returns a double. When I run this in a client (heidiSQL) it takes between 1 minute and 13 seconds (slowest) to 40.451 seconds (fastest) When I change the where clause to read:- WHERE tblsub.criteria1= NAME_CONST('refnum',_latin1'S000730128000' COLLATE 'latin1_swedish_ci') and tblmain.criteria2<5; The query takes 0.078 seconds (slowest) 0.045 (fastest) The following system character set variables are set to “latin1” but stored procedures still try and convert where criteria or passed in parameters to ‘utf8’ Character_set_client Character_set_connection Character_set_database Character_set_results Character_set_server All local tables are InnoDB with latin1_swedish_ci default collation therefore I assume they are stored using the latin1 character set. Is there any way to force MariaDB to use latin1 in stored procedures? Also I must point out that this is happening in MariaDB 10.1.7 and 10.1.13 that I’ve tested but does not happen in MariaDB 5.3.4 which has been my production version since 5.3.4 was released and I must add it has never failed. I’m trying to upgrade to 10.1.xxx to take advantage of the connect engine which I have tested for several months now and found to be extremely useful. However I can not put version 10.1.xxx into service until this issue is sorted. Kind Regards, Bruce Carlson -----Original Message----- From: Federico Razzoli [mailto:federico_raz@yahoo.it] Sent: Tuesday, 19 April 2016 10:41 AM To: maria-discuss(a)lists.launchpad.net; Bruce Carlson Subject: R: [Maria-discuss] Mariadb 10.1.13 slow stored procedures Stored procedures are slow in MariaDB and MySQL. I reported a bug for this, and Elena Stepanova's comment explains the reason, or maybe one of the reasons. The bug is: https://jira.mariadb.org/browse/MDEV-8254 MariaDB 10.1 is not slower than other versions. From my tests, MySQL 5.7 is almost thrice slower (wtf...), and in one case it caused the OOM to kill mysqld (wtf!?!?). Suggestion: try to avoid using @user_variables. Replace them with local_variables. NEW. and OLD. variables in triggers are ok. Queries are ok. I think that the only problem is access to variables. Regards, Federico -------------------------------------------- Mar 19/4/16, Bruce Carlson <Bruce.Carlson(a)nepean.com> ha scritto: Oggetto: [Maria-discuss] Mariadb 10.1.13 slow stored procedures A: "maria-discuss(a)lists.launchpad.net" <maria-discuss(a)lists.launchpad.net> Data: Martedì 19 Aprile 2016, 01:24 HI All, Just a quick question to start with, does anybody know why MariaDB 10.1.13 is extremely slow running stored procedures. I have searched for as much as I can find and have made sure the database and table character sets and compilation seta are identical but still stored procedures with lots of joins and internal variables is running hundreds of times slower than the old version 5.3. I have checked all system variables and they are identical in both systems (where they exist in both systems) Any assistance or advice would be greatly appreciated. If I need to supply more information please let me know. Both versions are running on windows server 2008 R2 Kind Regards, Bruce Carlson -----Segue allegato----- _______________________________________________ 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 -----Segue allegato----- _______________________________________________ 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] R: Mariadb 10.1.13 slow stored procedures
by Federico Razzoli 19 Apr '16

19 Apr '16

Stored procedures are slow in MariaDB and MySQL. I reported a bug for this, and Elena Stepanova's comment explains the reason, or maybe one of the reasons. The bug is: https://jira.mariadb.org/browse/MDEV-8254 MariaDB 10.1 is not slower than other versions. From my tests, MySQL 5.7 is almost thrice slower (wtf...), and in one case it caused the OOM to kill mysqld (wtf!?!?). Suggestion: try to avoid using @user_variables. Replace them with local_variables. NEW. and OLD. variables in triggers are ok. Queries are ok. I think that the only problem is access to variables. Regards, Federico -------------------------------------------- Mar 19/4/16, Bruce Carlson <Bruce.Carlson(a)nepean.com> ha scritto: Oggetto: [Maria-discuss] Mariadb 10.1.13 slow stored procedures A: "maria-discuss(a)lists.launchpad.net" <maria-discuss(a)lists.launchpad.net> Data: Martedì 19 Aprile 2016, 01:24 HI All, Just a quick question to start with, does anybody know why MariaDB 10.1.13 is extremely slow running stored procedures. I have searched for as much as I can find and have made sure the database and table character sets and compilation seta are identical but still stored procedures with lots of joins and internal variables is running hundreds of times slower than the old version 5.3. I have checked all system variables and they are identical in both systems (where they exist in both systems) Any assistance or advice would be greatly appreciated. If I need to supply more information please let me know. Both versions are running on windows server 2008 R2 Kind Regards, Bruce Carlson -----Segue allegato----- _______________________________________________ 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

2 1

[Maria-discuss] HikariCP + searching archives
by Stu Smith 19 Apr '16

19 Apr '16

Hello, I'm curious if there is a way to search the archives for this list - I couldn't find one, so I think I'm about to ask a simple question, but here goes: I noticed the MariaDB connector/J docs give an example using the HikariCP connection pool. Was there any reason for this? I saw they filed bugs in the mariadb jira, so they have put some effort into working with the community - and they have pretty graphs showing how fast they are. We're not really too worried about optimizing it yet - just adding a connection pool as a best practice kind of thing to a rest service hitting mariadb. Just wanted to make sure there weren't any caveats to using it with connector/J or if it was picked as the example for any particular reason. Also - any thoughts on pooling being a best practice to start off with or an optimization you should put in when you need it, and feel like tweaking pool lifetimes, etc... Thanks! Take care, -stu

4 4

[Maria-discuss] Mariadb 10.1.13 slow stored procedures
by Bruce Carlson 19 Apr '16

19 Apr '16

HI All, Just a quick question to start with, does anybody know why MariaDB 10.1.13 is extremely slow running stored procedures. I have searched for as much as I can find and have made sure the database and table character sets and compilation seta are identical but still stored procedures with lots of joins and internal variables is running hundreds of times slower than the old version 5.3. I have checked all system variables and they are identical in both systems (where they exist in both systems) Any assistance or advice would be greatly appreciated. If I need to supply more information please let me know. Both versions are running on windows server 2008 R2 Kind Regards, Bruce Carlson

1 0

[Maria-discuss] MariaDb Questions
by Ghazi Btissam 18 Apr '16

18 Apr '16

Hi , I have a lot of questions about MariaDb if you can help please: - - Comment on effectue le purge d’une table volumineuse (question partitionning à cause de ses contraintes) ? - - - How the purge is done under MariaDB for volumineous tables (as the partitionning has a big constraint: no foreign keys)? - Are there any compatibility constraints between the storage engine? - Did MariaDb insure the plugins support ( the storage engine pligins...)? - - Is there any equivalent to the AUDIT_POLICIES of Oracle ? - - TDE (Transparent data encryption) is there any equivalent or a plugin? - - How does MariaDb accept a givin plugin in database,what are the conditions? - - How does MariaDB accomplish the encryption? - - As the Oracle package does'nt exist, how MariaDB structure its code ? - - Is there a plugin which can call a Java proc in MariaDB , other than the UDF function (as MariaDB cannot call directly a java proc)? - - What is the usage of virtual column ? Many Thanks and Regards

1 0

[Maria-discuss] MariaDB 10.2.0 Alpha now available
by Daniel Bartholomew 18 Apr '16

18 Apr '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.2.0. This is an Alpha release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.2.0 - Release Notes: https://mariadb.com/kb/en/mdb-1020-rn/ - Changelog: https://mariadb.com/kb/en/mdb-1020-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.2.0 About MariaDB 10.2: - https://mariadb.com/kb/en/what-is-mariadb-102/ 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/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] MariaDb Entreprise edition (ColumnStore)
by Ghazi Btissam 18 Apr '16

18 Apr '16

Hi, 1- Is MariaDb Enterprise open source software (and all its components and modules? 2- Regarding the Spider engine: the feature allows 2 spider tables from different servers to share each of them partitions from a master spider which hold those partitions? please give some explainations Thanks

2 1

[Maria-discuss] MariaDb tablespaces?
by Ghazi Btissam 18 Apr '16

18 Apr '16

Hi, Is there tablespace in MariaDb like Oracle?if yes which storage engine use them and how? Thanks

2 1

[Maria-discuss] R: MariaDb tablespaces?
by Federico Razzoli 18 Apr '16

18 Apr '16

Hi, In current MariaDB versions, InnoDB has 2 types of tablespaces: * system tablespace * per-table tablespace There is a variable called innodb_file_per_table, you can change it at runtime. When a new table is created with innodb_file_per_table=1, the table has its own tablespace (an .ibd file in the database directory, which contains both data and indexes). When a table is created while innodb_file_per_table=0, it is written into the system tablespace. The system tablespace also contains other information, like the InnoDB data dictionary, un logs, etc. I see no particular advantage in creating new tables into the system tablespace - I consider it a feature inherited from old versions, when there were no alternatives. Remembers that the system tablespace never shrinks, even if you drop a table. Also, when using a dedicated tablespace, you can decide where the new table will be placed (see CREATE TABLE options). And you can backup only some tables, if you want to. This also enables table compression and encryption. In MySQL 5.7, you can group multiple tables into one tablespace - which means, not necessarily the system tablespace. From what I see in this page, I think (and hope) and this feature will also be in MariaDB 10.2: https://mariadb.com/kb/en/mariadb/plans-for-10x/ Other storage engines don't have tablespaces: a table is stored in a file (or in 2 files, if data and indexes are stored separately). Regards, Federico -------------------------------------------- Lun 18/4/16, Ghazi Btissam <btissam.ghazi(a)gmail.com> ha scritto: Oggetto: [Maria-discuss] MariaDb tablespaces? A: maria-discuss(a)lists.launchpad.net Data: Lunedì 18 Aprile 2016, 12:38 Hi, Is there tablespace in MariaDb like Oracle?if yes which storage engine use them and how? Thanks -----Segue allegato----- _______________________________________________ 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] New Question: when archive can support index to speed up select peformance?
by AskMonty KB 17 Apr '16

17 Apr '16

Hello, A new question has been asked in "Archive" by yixuan_huang. Please answer it at http://mariadb.com/kb/en/when-archive-can-support-index-to-speed-up-select-… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello, when i used innodb, w/o index it will cost 2 mins for select, w/ index (two columns), it only costs 20 secs. due to large size of innodb, i convert innodb to archive engine, it save space lots, but failed to create index. previously, i want to extend primary key with those two columns, but failed due to max length should be 8 bytes. any suggestions? thanks! -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/when-archive-can-support-index-to-speed-up-select-…

1 0

[Maria-discuss] mariadb and ssl setup, but how ?
by Benny Pedersen 16 Apr '16

16 Apr '16

i like to have ssl on mariadb in global not just pr user, but i dont find much dokumention on how to setup this using gentoo here, so if its covered somewhere let me know where i search future info on this

2 3

[Maria-discuss] Can't find log after Galera's SST
by Igor Mazur 14 Apr '16

14 Apr '16

Hi, Almost everytime when I join node to Galera cluster (MariaDB 10.1.13) I'm getting an error after SST: 2016-04-13 21:09:37 139932281419712 [Note] Recovering after a crash using /var/log/mysql/mariadb-bin 2016-04-13 21:09:37 139932281419712 [ERROR] Binlog file '/var/log/mysql/mariadb-bin.000023' not found in binlog index, needed for recovery. Aborting. 2016-04-13 21:09:37 139932281419712 [ERROR] Crash recovery failed. Either correct the problem (if it's, for example, out of memory error) and restart, or delete (or rename) binary log and start mysqld with --tc-heuristic-recover={commit|rollback} 2016-04-13 21:09:37 139932281419712 [ERROR] Can't init tc log 2016-04-13 21:09:37 139932281419712 [ERROR] Aborting As I see, almost every SST rotates a log file and downloads last (in example above I have mariadb-bin.000024), and not previous. But for recovering it needs previous. Sometimes I'm lucky and it restores. Anyone knows why it rotates a log and is it possible to force it to load more than last log file? Igor Mazur

2 4

[Maria-discuss] mariadb/contrib?
by Colin Charles 13 Apr '16

13 Apr '16

Hi, I was speaking to Hartmut a few days ago and he mentioned that he really did like the idea of postgresql’s /contrib feature. From postgresql/contrib: This subtree contains porting tools, analysis utilities, and plug-in features that are not part of the core PostgreSQL system, mainly because they address a limited audience or are too experimental to be part of the main source tree. This does not preclude their usefulness. (https://github.com/postgres/postgres/tree/master/contrib) Should we consider doing this for MariaDB Server? Have more tools that people might benefit from, but not spend much time on it? Just a thought cheers, -colin -- Colin Charles, http://bytebot.net/blog/ twitter: @bytebot | skype: colincharles "First they ignore you, then they laugh at you, then they fight you, then you win." -- Mohandas Gandhi

2 1

[Maria-discuss] New Question: MariaDB Hardware requirements
by AskMonty KB 13 Apr '16

13 Apr '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/mariadb-hardware-requirements/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is there any document which specifies the numeric values of minimal hardware requirements like the ram,minimum disk space occupied for tarball installation or yum installation for different mariadb products?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-hardware-requirements/

1 0

[Maria-discuss] Monitoring InnoDB tables?
by Erik Cederstrand 13 Apr '16

13 Apr '16

Hi list, I'm developing a fast data synchronization tool and need to monitor some tables in a customer's MariaDB (10.1) server for changes. I only have access to the server as a MariaDB client (no filesystem access). Ideally, I would keep a connection open and poll every few seconds - AFAIK, it's not possible for e.g. a stored procedure to notify a listener external to MariaDB. The tables have no 'timestamp' or other columns I can do MAX() on to check for updates. The database is used as a backend for some proprietary software, so I can't just ask the customer to add an autoincrement column. With MyISAM, I could look at UPDATE_TIME in information_schema.tables (and live with the full-second resolution) or ask the customer to "alter table t1 checksum=1;" so I can use "checksum table t1 quick;". None of these work with InnoDB, and "checksum table t1;" is too slow for large tables. I've seen suggestions to use NUM_ROWS and MODIFIED_COUNTER in information_schema.innodb_sys_tablestats, but it's unreliable for me in a number of cases, e.g. if the number of rows is the same but contents are different. Here's an example: MariaDB [test]> create table t1 (i int primary key, j int); Query OK, 0 rows affected (0.02 sec) MariaDB [test]> insert into t1 values (1, 2); Query OK, 1 row affected (0.00 sec) MariaDB [test]> select * from information_schema.innodb_sys_tablestats where name = 'test/t1'; +----------+---------+-------------------+----------+------------------+------------------+------------------+---------+-----------+ | TABLE_ID | NAME | STATS_INITIALIZED | NUM_ROWS | CLUST_INDEX_SIZE | OTHER_INDEX_SIZE | MODIFIED_COUNTER | AUTOINC | REF_COUNT | +----------+---------+-------------------+----------+------------------+------------------+------------------+---------+-----------+ | 15000 | test/t1 | Initialized | 1 | 1 | 0 | 1 | 0 | 1 | +----------+---------+-------------------+----------+------------------+------------------+------------------+---------+-----------+ 1 row in set (0.00 sec) MariaDB [test]> delete from t1; Query OK, 1 row affected (0.00 sec) MariaDB [test]> insert into t1 values (3, 4); Query OK, 1 row affected (0.00 sec) MariaDB [test]> select * from information_schema.innodb_sys_tablestats where name = 'test/t1'; +----------+---------+-------------------+----------+------------------+------------------+------------------+---------+-----------+ | TABLE_ID | NAME | STATS_INITIALIZED | NUM_ROWS | CLUST_INDEX_SIZE | OTHER_INDEX_SIZE | MODIFIED_COUNTER | AUTOINC | REF_COUNT | +----------+---------+-------------------+----------+------------------+------------------+------------------+---------+-----------+ | 15000 | test/t1 | Initialized | 1 | 1 | 0 | 1 | 0 | 1 | +----------+---------+-------------------+----------+------------------+------------------+------------------+---------+-----------+ 1 row in set (0.00 sec) How can I monitor an InnoDB table for changes efficiently? I could *possibly* convince the customer to monitor the binlog or full query log, but then I don't even know which database was changed. The server has hundreds of databases. Erik

3 4

[Maria-discuss] R: mariadb/contrib?
by Federico Razzoli 13 Apr '16

13 Apr '16

I would really appreciate. I believe that some great tools exist but are not used because are not in a default MariaDB/MySQL installation. A contrib directory could advertise good tools and encourage people to try them. Regards Federico -------------------------------------------- Mar 12/4/16, Colin Charles <byte(a)aeon.com.my> ha scritto: Oggetto: [Maria-discuss] mariadb/contrib? A: "Maria Discuss" <maria-discuss(a)lists.launchpad.net> Data: Martedì 12 Aprile 2016, 16:55 Hi, I was speaking to Hartmut a few days ago and he mentioned that he really did like the idea of postgresql’s /contrib feature. From postgresql/contrib: This subtree contains porting tools, analysis utilities, and plug-in features that are not part of the core PostgreSQL system, mainly because they address a limited audience or are too experimental to be part of the main source tree. This does not preclude their usefulness. (https://github.com/postgres/postgres/tree/master/contrib) Should we consider doing this for MariaDB Server? Have more tools that people might benefit from, but not spend much time on it? Just a thought cheers, -colin -- Colin Charles, http://bytebot.net/blog/ twitter: @bytebot | skype: colincharles "First they ignore you, then they laugh at you, then they fight you, then you win." -- Mohandas Gandhi -----Segue allegato----- _______________________________________________ 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] New Question: MariaDB Quarterly patch schedules with all Bug Fixes availability
by AskMonty KB 12 Apr '16

12 Apr '16

Hello, A new question has been asked in "MariaDB Community" by Nagaraj B. Please answer it at http://mariadb.com/kb/en/mariadb-quarterly-patch-schedules-with-all-bug-fix… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Will there be a Quarterly or half yearly release of Mariadb Patches, which includes all the fixes for a quarter. Is there a pre scheduled release dates for the same. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-quarterly-patch-schedules-with-all-bug-fix…

1 0

[Maria-discuss] New Question: Fresh Installation of Mariadb
by AskMonty KB 09 Apr '16

09 Apr '16

Hello, A new question has been asked in "MariaDB Binary Packages" by francis_adekunle_45706. Please answer it at http://mariadb.com/kb/en/fresh-installation-of-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- We are in the process of setting up our Developments env on Cloud Foundry and Mariadb is the DB of choice. I have Oracle background. I m trying to download and install the Mariadb software binaries as well as setup the database in our development environment. OS is RHEL 6.5 and I tried to use yum to install but got error message. I also obtain the tar.zip file and uncompressed the file on the linux server but most of the files are zero bytes.. Questions: a) What binaries do I need to download for Mariadb installation? b) What OS username and group id etc..would I be installing Mariadb as? c) Where do I get Mariadb files to download since I m having issue with yum.. I m trying to get a Maria db book but need the above basic info to get started. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/fresh-installation-of-mariadb/

1 0

[Maria-discuss] systemctl startup script gives “WSREP: Failed to recover position” - manual startup works
by Lukas Lehner 08 Apr '16

08 Apr '16

Hi please post your ideas http://dba.stackexchange.com/questions/134762/systemctl-startup-script-give… best Lukas

1 0

[Maria-discuss] New Question: Galera errors in mysqld.log but works OK
by AskMonty KB 08 Apr '16

08 Apr '16

Hello, A new question has been asked in "MariaDB Community" by aferrett. Please answer it at http://mariadb.com/kb/en/galera-errors-in-mysqldlog-but-works-ok/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have a 3 node Galera cluster that I am testing. It generally works OK, and I have been doing various failure / recovery tests as part of a certification project. I continuously get 3 error messages even though it is working OK. I'd like to eliminate any unnecessary error messages so that DBAs would not taking time to resolve this in a production situation. Here is a sampling of the three errors: I included a bit before and after the error for context: 2016-04-06 11:01:22 140287919777536 [Note] WSREP: Quorum results: version = 3, component = PRIMARY, conf_id = 26, members = 3/3 (joined/total), act_id = 8017357, last_appl. = 0, protocols = 0/7/3 (gcs/repl/appl), group UUID = db762c6b-e246-11e5-90df-4adee5e6b24e 2016-04-06 11:01:22 140287919777536 [Note] WSREP: Flow-control interval: [28, 28] 2016-04-06 11:01:22 140290187433728 [Note] WSREP: New cluster view: global state: db762c6b-e246-11e5-90df-4adee5e6b24e:8017357, view# 27: Primary, number of nodes: 3, my index: 2, protocol version 3 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 2016-04-06 11:01:22 140290187433728 [ERROR] WSREP: Process completed with error: /opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Synced --uuid db762c6b-e246-11e5-90df-4adee5e6b24e --primary yes --index 2 --members 06e16ae0-fb9b-11e5-8ae2-76e1f955bae1/zlx70604.vci.att.com/130.9.221.48:3306…: 1 (Operation not permitted) 2016-04-06 11:01:22 140290187433728 [ERROR] WSREP: Notification command failed: 1 (Operation not permitted): "/opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Synced --uuid db762c6b-e246-11e5-90df-4adee5e6b24e --primary yes --index 2 --members 06e16ae0-fb9b-11e5-8ae2-76e1f955bae1/zlx70604.vci.att.com/130.9.221.48:3306…" 2016-04-06 11:01:22 140290187433728 [Note] WSREP: REPL Protocols: 7 (3, 2) 2016-04-06 11:01:22 140287985837824 [Note] WSREP: Service thread queue flushed. 2016-04-06 11:01:22 140290187433728 [Note] WSREP: Assign initial position for certification: 8017357, protocol version: 3 2016-04-06 11:01:22 140287985837824 [Note] WSREP: Service thread queue flushed. 2016-04-06 16:18:22 140287930267392 [Note] WSREP: (8180e0ba, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://10.242.60.235:4567 I grepped for just one of the errors so you can get an idea of the frequency: 2016-04-06 1:58:15 140290151147264 [ERROR] WSREP: Notification command failed: 1 (Operation not permitted): "/opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Synced --uuid db762c6b-e246-11e5-90df-4adee5e6b24e --primary yes --index 1 --members 06e16ae0-fb9b-11e5-8ae2-76e1f955bae1/zlx70604.vci.att.com/130.9.221.48:3306…" 2016-04-06 2:15:49 140290151147264 [ERROR] WSREP: Notification command failed: 1 (Operation not permitted): "/opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Synced --uuid db762c6b-e246-11e5-90df-4adee5e6b24e --primary yes --index 2 --members 06e16ae0-fb9b-11e5-8ae2-76e1f955bae1/zlx70604.vci.att.com/130.9.221.48:3306…" 2016-04-06 2:15:49 140290151147264 [ERROR] WSREP: Notification command failed: 1 (Operation not permitted): "/opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Donor" 2016-04-06 3:40:41 140287908230912 [ERROR] WSREP: Notification command failed: 1 (Operation not permitted): "/opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Synced" 2016-04-06 9:28:48 140290187433728 [ERROR] WSREP: Notification command failed: 1 (Operation not permitted): "/opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Synced --uuid db762c6b-e246-11e5-90df-4adee5e6b24e --primary yes --index 1 --members 06e16ae0-fb9b-11e5-8ae2-76e1f955bae1/zlx70604.vci.att.com/130.9.221.48:3306…" 2016-04-06 9:29:00 140290187433728 [ERROR] WSREP: Notification command failed: 1 (Operation not permitted): "/opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Synced --uuid db762c6b-e246-11e5-90df-4adee5e6b24e --primary yes --index 2 --members 06e16ae0-fb9b-11e5-8ae2-76e1f955bae1/zlx70604.vci.att.com/130.9.221.48:3306…" 2016-04-06 10:05:09 140290187433728 [ERROR] WSREP: Notification command failed: 1 (Operation not permitted): "/opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Synced --uuid db762c6b-e246-11e5-90df-4adee5e6b24e --primary yes --index 1 --members 06e16ae0-fb9b-11e5-8ae2-76e1f955bae1/zlx70604.vci.att.com/130.9.221.48:3306…" 2016-04-06 10:07:34 140290187433728 [ERROR] WSREP: Notification command failed: 1 (Operation not permitted): "/opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Synced --uuid db762c6b-e246-11e5-90df-4adee5e6b24e --primary yes --index 2 --members 06e16ae0-fb9b-11e5-8ae2-76e1f955bae1/zlx70604.vci.att.com/130.9.221.48:3306…" 2016-04-06 11:01:10 140290187433728 [ERROR] WSREP: Notification command failed: 1 (Operation not permitted): "/opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Synced --uuid db762c6b-e246-11e5-90df-4adee5e6b24e --primary yes --index 1 --members 06e16ae0-fb9b-11e5-8ae2-76e1f955bae1/zlx70604.vci.att.com/130.9.221.48:3306…" 2016-04-06 11:01:22 140290187433728 [ERROR] WSREP: Notification command failed: 1 (Operation not permitted): "/opt/app/mysql/product/mariadb-10.1.12-linux-x86_64/support-files/wsrep_notify --status Synced --uuid db762c6b-e246-11e5-90df-4adee5e6b24e --primary yes --index 2 --members 06e16ae0-fb9b-11e5-8ae2-76e1f955bae1/zlx70604.vci.att.com/130.9.221.48:3306…" mysql@zlx70605 /opt/app/mysql -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/galera-errors-in-mysqldlog-but-works-ok/

1 0

[Maria-discuss] New Question: Java Client 1.4.0 Release Notes
by AskMonty KB 08 Apr '16

08 Apr '16

Hello, A new question has been asked in "MariaDB Connector/J" by Sebastian_S. Please answer it at http://mariadb.com/kb/en/java-client-140-release-notes/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, Why Jira CONJ-260: "Add jdbc nString, nCharacterStream, nClob implementation" (https://jira.mariadb.org/browse/CONJ-260) is on BugFix list of Java Client 1.4.0 Release Notes since it is not implemented and already moved to release 1.5.0? Sebastian Stroz -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/java-client-140-release-notes/

1 0

[Maria-discuss] expire_logs_days
by Reindl Harald 07 Apr '16

07 Apr '16

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 view hours and if it is longer sown it's just my problem to act http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_…

2 2

[Maria-discuss] First MariaDB Berlin Meetup
by Colin Charles 06 Apr '16

06 Apr '16

Hi! Many of the core server developers for MariaDB Server and MariaDB MaxScale will be having a meetup in Berlin, on April 12 2016 at Wikimedia’s offices. Feel free to drop by, have a drink, say hi, and listen to the upcoming plans http://www.meetup.com/MariaDB-Developers-Berlin-Meetup/events/230026151/ Looking forward to seeing you if you’re local to Berlin, and if you have friends that would be interested, please feel free to forward this note to them Thanks Kind Regards, Colin Charles -- Colin Charles, http://bytebot.net/blog/ twitter: @bytebot | skype: colincharles "First they ignore you, then they laugh at you, then they fight you, then you win." -- Mohandas Gandhi

1 0

[Maria-discuss] New Question: can maxscal support router like this?
by AskMonty KB 06 Apr '16

06 Apr '16

Hello, A new question has been asked in "MaxScale Routers" by hei_yingzi_(darkz)_g. Please answer it at http://mariadb.com/kb/en/can-maxscal-support-router-like-this/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have some server storage some records,like this server_id -> column value server1 -> s1 server2 -> s2 server3 -> s3 server4 -> s4 table table_name1 struce like column1,column2,sid a,1,s1 when I query select * from table_name1 where sid=s1, then route the query to server1 ... select * from table_name1 where sid=s2, then route the query to server2 -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/can-maxscal-support-router-like-this/

1 0

[Maria-discuss] New Question: MariaDB support
by AskMonty KB 05 Apr '16

05 Apr '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/mariadb-faq-mariadb-support/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is 32 bit linux client machines supported...if mariadb server is installed on 64bit machines only? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-faq-mariadb-support/

1 0

[Maria-discuss] New Question: MariaDB support
by AskMonty KB 05 Apr '16

05 Apr '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/mariadb-support/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- In the mariadb subscription packages Email and web support is provided. Is there any provision for phone support and any forum which is mainly for enterprises so that there bugs or issues can be resolved immediately?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-support/

1 0

[Maria-discuss] New Question: MariaDB Monitoring
by AskMonty KB 05 Apr '16

05 Apr '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/mariadb-monitoring/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- are there any other monitoring tools other than MONyog and Nagios?? like for eg cacti or any other ?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-monitoring/

1 0

[Maria-discuss] New Question: MariaDB third party tool support
by AskMonty KB 04 Apr '16

04 Apr '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/mariadb-third-party-tool-support/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- With mariaDB enterprise third party tools like SQLyog and Monyog (developed by webyog) are also shipped. Is support for these tools also provided by webyog or need to purchase seprate support package from webyog after buying support package with MariaDb corporation?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-third-party-tool-support/

1 0

[Maria-discuss] Link to Mariadb Jira on mariadb.com.invalid
by Peter Mclarty 04 Apr '16

04 Apr '16

Hi I just noticed the link on mariadb.com.still point to the old Atlassian site. I am sure it's on someone's todo list Cheers -- *Peter McLarty* *Data Analyst DBA* Compare The Market “Progress is impossible without change, and those who cannot change their minds cannot change anything.” - George Bernard Shaw -- Compare The Market is a brand and trading name of Compare The Market (Pty) Ltd (CTM). This email is for the intended addressee and is confidential and subject to copyright. If you are not the intended addressee, confidentiality has not been waived and any use, interference with, or disclosure of this email is unauthorised. If you are not the intended addressee please immediately notify CTM and then delete the email. CTM does not warrant that this email is error or virus free.

1 0

[Maria-discuss] New Question: mariadb support for 32 bit systems
by AskMonty KB 01 Apr '16

01 Apr '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/mariadb-support-for-32-bit-systems/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is support provided for 32 bit architecture systems(windows and linux) for MariaDB enterprise since the website http://learn.mariadb.com/enterprise/ doesnt list 32 bit architecture systems?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-support-for-32-bit-systems/

1 0

[Maria-discuss] Fwd: java.sql.Timestamp works in MySQL, fails in MariaDB
by Diego Dupin 31 Mar '16

31 Mar '16

---------- Forwarded message ---------- From: Diego Dupin <diego.dupin(a)mariadb.com> Date: Tue, Mar 29, 2016 at 10:15 PM Subject: java.sql.Timestamp works in MySQL, fails in MariaDB To: lyallex(a)gmail.com Hi, That must normally work, since the mysql connector use the same binary protocol. Could you send the exact connection string to know the options you use ? Diego Recently I changed servers, my old server was running MySQL and my > Java code worked perfectly. My new server is apparently running Ver 15 > 5.5.44-MariaDB, for Linux (x86 64) > The following code works and has worked perfectly well for the past 4 years > java.sql.Timestamp transactionTimestamp = new > java.sql.Timestamp(System.currentTimeMillis()); > PreparedStatement pstmt > ... > pstmt.setTimestamp(4, transactionTimestamp); > pstmt.executeUpdate(); // EPIC FAIL, writes all 0s to the database > I'm currently using mysql-connector-java-5.1.22-bin.jar in WEB-INF/lib > Can anyone throw any light on this please? > Many thanks > Lyallex

1 0

[Maria-discuss] New Question: tarball support
by AskMonty KB 30 Mar '16

30 Mar '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/tarball-support/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- MariaDB Enterprise provides only RPM packages to be downloaded and tarball packages are considered as non enterprise package..So is support from mariaDB corporation provided for tarball installation?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/tarball-support/

1 0

[Maria-discuss] New Question: mariadb os support
by AskMonty KB 30 Mar '16

30 Mar '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/mariadb-os-support/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- does mariadb client binary support both 64bit/32bit. or do u want to install seperate binaries -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-os-support/

1 0

[Maria-discuss] New Question: According to wikipedia link, MariaDB does not have Security Evaluation Assurance Level (EAL)
by AskMonty KB 30 Mar '16

30 Mar '16

Hello, A new question has been asked in "MariaDB Community" by aferrett. Please answer it at http://mariadb.com/kb/en/according-to-wikipedia-link-mariadb-does-not-have-… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Looking at the link below, MariaDB shows "No" for Security Certification. This is based on no Security Evaluation Assurance Level (EAL). https://en.wikipedia.org/wiki/Comparison_of_relational_database_management_… Does anyone have any information on whether this can be a problem? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/according-to-wikipedia-link-mariadb-does-not-have-…

1 0

[Maria-discuss] New Question: MariaDB migration
by AskMonty KB 29 Mar '16

29 Mar '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/mariadb-migration/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- how do i migrate MariaDB from windows to linux?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-migration/

1 0

[Maria-discuss] New Question: mysqli_connect didnot work
by AskMonty KB 29 Mar '16

29 Mar '16

Hello, A new question has been asked in "SQL Commands" by mifuji235_43584. Please answer it at http://mariadb.com/kb/en/mysqli_connect-didnot-work/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- i will try the make local database from csv File. but Sql didnot connect local Mysql server , why? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mysqli_connect-didnot-work/

1 0

[Maria-discuss] java.sql.Timestamp works in MySQL, fails in MariaDB
by Lyallex 28 Mar '16

28 Mar '16

Recently I changed servers, my old server was running MySQL and my Java code worked perfectly. My new server is apparently running Ver 15 5.5.44-MariaDB, for Linux (x86 64) The following code works and has worked perfectly well for the past 4 years java.sql.Timestamp transactionTimestamp = new java.sql.Timestamp(System.currentTimeMillis()); PreparedStatement pstmt ... pstmt.setTimestamp(4, transactionTimestamp); pstmt.executeUpdate(); // EPIC FAIL, writes all 0s to the database I'm currently using mysql-connector-java-5.1.22-bin.jar in WEB-INF/lib Can anyone throw any light on this please? Many thanks Lyallex

1 0

[Maria-discuss] MariaDB 10.1.13 and Connector/J 1.3.7 now available
by Daniel Bartholomew 25 Mar '16

25 Mar '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.13, and MariaDB Connector/J 1.3.7. These are both Stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.13 - Release Notes: https://mariadb.com/kb/en/mdb-10113-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10113-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.1.13 About MariaDB 10.1: - https://mariadb.com/kb/en/what-is-mariadb-101/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB Connector/J 1.3.7 - Release Notes: https://mariadb.com/kb/en/mcj-137-rn/ - Changelog: https://mariadb.com/kb/en/mcj-137-cl/ - Downloads: https://downloads.mariadb.org/connector-java/1.3.7 About MariaDB Connector/J: - https://mariadb.com/kb/en/about-mariadb-connector-j/ - - 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/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: Unsupported DBF type M (Memo)
by AskMonty KB 24 Mar '16

24 Mar '16

Hello, A new question has been asked in "CONNECT" by lucio.minetti_44167. Please answer it at http://mariadb.com/kb/en/unsupported-dbf-type-m-memo/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I'm using 10.0.22-MariaDB openSUSE package. I've received this "Unsupported DBF type M" for memo field. I think that memo filed datatype is not supported. Is it possible that this datatype is supported in any new MariaDB version ? If yes, from which version ? Thank you -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/unsupported-dbf-type-m-memo/

1 0

[Maria-discuss] New Question: Problem with stored procedures after migration from mysql to mariadb with jdbc driver from mariadb
by AskMonty KB 24 Mar '16

24 Mar '16

Hello, A new question has been asked in "Stored Procedures" by Andreas.duhamel_43935. Please answer it at http://mariadb.com/kb/en/problem-with-stored-procedures-after-migration-fro… as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have a problem with stored procedures after migration from mysql to mariadb 10.1. With the old jdbc driver from mysql mysql-connector-java-5.1.13-bin all is ok. If i change the driver to the mariadb driver mariadb-java-client-1.3.6 it's not ok. Here the queries.log: 2 Query set @_jdbc_var_1='Check',@_jdbc_var_2='',@_jdbc_var_3='Benutzer',@_jdbc_var_4='Aktuell',@_jdbc_var_5='Passwort',@_jdbc_var_6=NULL,@_jdbc_var_7=0,@_jdbc_var_8='Administrator',@_jdbc_var_9='7b7bc2512ee1fedcd76bdc68926d4f7b',@_jdbc_var_10=NULL,@_jdbc_var_11=NULL,@_jdbc_var_12=NULL,@_jdbc_var_13=0,@_jdbc_var_14=0,@_jdbc_var_15=0 2 Query call spmzBenutzer(@_jdbc_var_1,@_jdbc_var_2,@_jdbc_var_3,@_jdbc_var_4,@_jdbc_var_5,@_jdbc_var_6,@_jdbc_var_7,@_jdbc_var_8,@_jdbc_var_9,@_jdbc_var_10,@_jdbc_var_11,@_jdbc_var_12,@_jdbc_var_13,@_jdbc_var_14,@_jdbc_var_15) 2 Query SET @AKTIO NAME_CONST('p_AKTION',_utf8'Check' COLLATE 'utf8_general_ci')TION 2 Query SET @Sortierun NAME_CONST('p_Sortierung',_utf8'' COLLATE 'utf8_general_ci')rung 2 Query SET @MODU NAME_CONST('p_MODUS',_utf8'Benutzer' COLLATE 'utf8_general_ci')ODUS 2 Query SET @MODUS NAME_CONST('p_MODUS2',_utf8'Aktuell' COLLATE 'utf8_general_ci')DUS2 2 Query SET @MODUS NAME_CONST('p_MODUS3',_utf8'Passwort' COLLATE 'utf8_general_ci')DUS3 2 Query SET @IDBenutze NAME_CONST('p_IDBenutzer',0)tzer 2 Query SET @Benutze NAME_CONST('p_Benutzer',_utf8'Administrator' COLLATE 'utf8_general_ci')tzer 2 Query SET @Passwor NAME_CONST('p_Passwort',_utf8'7b7bc2512ee1fedcd76bdc68926d4f7b' COLLATE 'utf8_general_ci')wort 2 Query SET @Vornam NAME_CONST('p_Vorname',NULL)name 2 Query SET @Nachnam NAME_CONST('p_Nachname',NULL)name 2 Query SET @AnlegeDatu NAME_CONST('p_AnlegeDatum',NULL)atum 2 Query SET @Statu NAME_CONST('p_Status',0)atus 2 Query SET @IDRo NAME_CONST('p_IDRow',0)DRow 2 Query SET @IDGrupp NAME_CONST('p_IDGruppe',0)uppe 2 Query SELECT IDBenutzer into p_NeuerIdent FROM bvwbenutzer WHERE Benutzer = @Benutzer AND Passwort = @Passwort AND Status < 9 2 Query SELECT NULL,NULL,NULL,NULL,NULL,@_jdbc_var_6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL 2 Query ROLLBACK And here the jbossprotokol: 2016-03-24 11:02:55,313 ERROR [org.jboss.ejb.plugins.LogInterceptor] (WorkerThread#0[10.19.12.113:50404]) EJBException in method: public abstract java.lang.Integer mmts.benutzer.interfaces.BenutzerFacade.Pruefen_Benutzer_Passwort(java.lang.String,java.lang.String) throws java.rmi.RemoteException, causedBy: java.sql.SQLException: CallableStatement.executeQuery() did not return a resultset at org.mariadb.jdbc.MariaDbCallableStatement.executeQuery(MariaDbCallableStatement.java:1268) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342) at mmts.benutzer.ejb.BenutzerFacade.Pruefen_Benutzer_Passwort(BenutzerFacade.java:551) Who can help me? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/problem-with-stored-procedures-after-migration-fro…

1 0

[Maria-discuss] stream sql
by Roberto Spadim 23 Mar '16

23 Mar '16

hi guys, anyone know if there's a stream sql interface to mysql? something like pipelinedb with postgresql? -- Roberto Spadim SPAEmpresarial - Software ERP Eng. Automação e Controle

1 0

[Maria-discuss] New Question: Is MariaDB effected by the US trade sanctions?
by AskMonty KB 22 Mar '16

22 Mar '16

Hello, A new question has been asked in "Questions about licensing (MariaDB, plugins etc)" by tuomas_backman_g. Please answer it at http://mariadb.com/kb/en/is-mariadb-effected-by-the-us-trade-sanctions/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- My company is Finnish based company that was bought by US origin company. We are distributing an application running MariaDB under GPL to various countries including Iran. Since Mariadb foundation is registered to US, I wonder if US trade restrictions apply, ie. can't deliver MariaDB to Iran? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/is-mariadb-effected-by-the-us-trade-sanctions/

1 0

[Maria-discuss] New Question: mariaDB installation
by AskMonty KB 22 Mar '16

22 Mar '16

Hello, A new question has been asked in "Starting and Stopping MariaDB" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/starting-and-stopping-mariadb-mariadb-installation/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I want to install MariaDB in a directory which i have created and use it from there. Is there any way to do that? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/starting-and-stopping-mariadb-mariadb-installation/

1 0

[Maria-discuss] New Question: MariaDB Installation
by AskMonty KB 22 Mar '16

22 Mar '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/mariadb-faq-mariadb-installation/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is it possible to install MariaDB as a non root user?? If yes,please provide a way to do the same. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-faq-mariadb-installation/

1 0

[Maria-discuss] Collations, trailing spaces and unique indexes
by Binarus 21 Mar '16

21 Mar '16

Dear all, I already have done some MySQL development and now eventually would like to switch to MariaDB because I no longer can stand the following: "All MySQL collations are of type PADSPACE. This means that all CHAR, VARCHAR, and TEXT values in MySQL are compared without regard to any trailing spaces. “Comparison” in this context does not include the LIKE pattern-matching operator, for which trailing spaces are significant." "For those cases where trailing pad characters are stripped or comparisons ignore them, if a column has an index that requires unique values, inserting into the column values that differ only in number of trailing pad characters will result in a duplicate-key error. For example, if a table contains 'a', an attempt to store 'a ' causes a duplicate-key error." (taken from https://dev.mysql.com/doc/refman/5.5/en/char.html) I did not find any information whether the collations which MariaDB provides are of type PADSPACE as in MySQL (none of the collation tables from MariaDB's documentation does contain this information) or not. To make a long story short: I would like to have CHAR and VARCHAR fields with unique indexes which consider 'a' and 'a ' to be different values (which is the only reasonable point of view IMHO). This is not possible with MySQL. Is it possible with MariaDB? I am generally working with charset UTF8 and would be happy with a general solution, but also with a non-general solution which only works with UTF8. Since the index behaviour obviously depends on the collation, would building an own collation which does not PADSPACE be an option? I have read vague hints about that in MariaDB's documentation, but didn't try yet (before doing so, I would like to know if there is an easy, clean solution). Thank you very much for any ideas, Binarus

10 27

[Maria-discuss] New Question: netframework support
by AskMonty KB 21 Mar '16

21 Mar '16

Hello, A new question has been asked in "MariaDB Documentation" by juantoledo. Please answer it at http://mariadb.com/kb/en/netframework-support/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Do you plan to support connection for apps with Microsoft net framework? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/netframework-support/

1 0

[Maria-discuss] warning : bison executable not found in PATH
by Shubham Barai 18 Mar '16

18 Mar '16

Hello everyone, I was trying to build MariaDB from source on windows. I have already installed bison in the dir C:\GnuWin32\ but still I am getting this error bison executable not found in PATH Any help would be appreciated. Thanks, Shubham

2 1

[Maria-discuss] MariaDB CONNECT Storage Engine access to Oracle 11GR2
by Ghazi Btissam 16 Mar '16

16 Mar '16

Hi, I saw an article about the equivalent of the Oracle DbLink feature in MariaDb, I found that the connect engine with the ODBC table type can do an insert+select on an Oracle remote table ,but the *update *of the remote data is it possible? Thanks

2 1

[Maria-discuss] New Question: MariaDB Connector for Windows (1.05)
by AskMonty KB 15 Mar '16

15 Mar '16

Hello, A new question has been asked in "MariaDB Connector/ODBC" by fred_taylor_g. Please answer it at http://mariadb.com/kb/en/mariadb-connector-for-windows-105/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I'm trying to connect to a MariaDB 10 database using the MariaDB ODBC Connector 1.05 on a WIN7 32 bit machine, but I can't get connected using it as I get an "Connectivity Error: Unknown system variable 'max_allowed_packet_size'". I can create a DSN and the "test" says it works, but I get the same error trying to use that DSN from Visual FoxPro 9.0/SP2. It fails with the above error trying a connection string in VFP: SQLSTRINGCONNECT("Driver={MariaDB ODBC 1.0 Driver};Server=localhost;UID=myuser;PWD=mypwd;DB=test;Port=3306;") Any explanations,as I can't find anything on 'max_allowed_packet_size'? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-connector-for-windows-105/

1 0

[Maria-discuss] Partitionning question
by Ghazi Btissam 14 Mar '16

14 Mar '16

Hi, 1- Could a partitioned table contain, or be referenced by, foreign keys? 2- As I saw in MariaDb documentation ,the subpartitions may use either HASH or KEY partitioning. Does the LIST subpartitioning exists in MariaDb? Can we use : a composite partitionning : RANGE/LIST? Thanks

2 1

[Maria-discuss] New Question: How do I install the ODBC connector/driver on Linux Mint 17.3
by AskMonty KB 13 Mar '16

13 Mar '16

Hello, A new question has been asked in "MariaDB Connector/ODBC" by Redman Companies. Please answer it at http://mariadb.com/kb/en/how-do-i-install-the-odbc-connectordriver-on-linux… as the person asking the question may not be subscribed to the mailing list. -------------------------------- I can not find the installation procedure for the gzip or source packages anywhere. (1.0.5 or 2.0.9) Thanks in advance. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-do-i-install-the-odbc-connectordriver-on-linux…

1 0

[Maria-discuss] AUTO_INCREMENT and partitioning
by Ghazi Btissam 12 Mar '16

12 Mar '16

Hi, 1- I have a table with a unique key which is calculated by the AUTO_INCREMENT feature, and I need to range partition it using a date field , is it possible and/or how to do it? 2- Is there a way to implement sequences for the primary key (like it exists in Oracle) or the AUTO_INCREMENT is the only one in MariaDb? For example: CREATE TABLE new ( id INT NOT NULL AUTO_INCREMENT, name VARCHAR(50), added DATE, PRIMARY KEY (id), ) PARTITION BY RANGE( TO_DAYS(added) ) ( PARTITION p0 VALUES LESS THAN (1990), PARTITION p1 VALUES LESS THAN (2000), PARTITION p2 VALUES LESS THAN MAXVALUE ) ; Thanks

3 3

[Maria-discuss] Read/Write file
by Ghazi Btissam 12 Mar '16

12 Mar '16

Hi, How to read/write a text file from a MariaDb routine ? Is this possible only via tables (loading via Load data infile or using connect engine..)? Thanks

3 2

[Maria-discuss] MariaDB CONNECT Storage Engine access to Oracle 11GR2
by Ghazi Btissam 12 Mar '16

12 Mar '16

Hi, I saw an article about the equivalent of the Oracle DbLink feature in MariaDb, I found that the connect engine with the ODBC table type can do an insert+select on an Oracle remote table ,but the update of the remote data is it possible? Thanks

1 0

[Maria-discuss] New Question: mariadb 10.1.12 mysql_install_db aborts on unkown file 'test'
by AskMonty KB 11 Mar '16

11 Mar '16

Hello, A new question has been asked in "News and Information" by stuart_zurcher_g. Please answer it at http://mariadb.com/kb/en/mariadb-10112-mysql_install_db-aborts-on-unkown-fi… as the person asking the question may not be subscribed to the mailing list. -------------------------------- using Docker container with -v /data:/var/lib/mysql \\ xtrabackup-v2 (2.4) 999:docker /data \\ chown mysql:mysql /var/lib/mysql\\ Initializing\\ {{{ 2016-03-11 13:59:18 139887411787712 [Note] /usr/sbin/mysqld (mysqld 10.1.12-MariaDB-1~jessie) starting as process 54 ... 2016-03-11 13:59:18 139887411787712 [Note] WSREP: Read nil XID from storage engines, skipping position init 2016-03-11 13:59:18 139887411787712 [Note] WSREP: wsrep_load(): loading provider library 'none' 2016-03-11 13:59:18 139887411787712 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2016-03-11 13:59:18 139887411787712 [Note] InnoDB: The InnoDB memory heap is disabled 2016-03-11 13:59:18 139887411787712 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2016-03-11 13:59:18 139887411787712 [Note] InnoDB: Memory barrier is not used 2016-03-11 13:59:18 139887411787712 [Note] InnoDB: Compressed tables use zlib 1.2.8 2016-03-11 13:59:18 139887411787712 [Note] InnoDB: Using Linux native AIO 2016-03-11 13:59:18 139887411787712 [Note] InnoDB: Using SSE crc32 instructions 2016-03-11 13:59:18 139887411787712 [Note] InnoDB: Initializing buffer pool, size = 400.0M 2016-03-11 13:59:18 139887411787712 [Note] InnoDB: Completed initialization of buffer pool 2016-03-11 13:59:18 139887411787712 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created! 2016-03-11 13:59:18 139887411787712 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB 2016-03-11 13:59:18 139887411787712 [Note] InnoDB: Database physically writes the file full: wait... 2016-03-11 13:59:19 139887411787712 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 2016-03-11 13:59:25 139887411787712 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2016-03-11 13:59:27 139887411787712 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2016-03-11 13:59:27 139887411787712 [Warning] InnoDB: New log files created, LSN=45883 2016-03-11 13:59:27 139887411787712 [Note] InnoDB: Doublewrite buffer not found: creating new 2016-03-11 13:59:27 139887411787712 [Note] InnoDB: Doublewrite buffer created 2016-03-11 13:59:27 139887411787712 [Note] InnoDB: 128 rollback segment(s) are active. 2016-03-11 13:59:27 139887411787712 [Warning] InnoDB: Creating foreign key constraint system tables. 2016-03-11 13:59:27 139887411787712 [Note] InnoDB: Foreign key constraint system tables created 2016-03-11 13:59:27 139887411787712 [Note] InnoDB: Creating tablespace and datafile system tables. 2016-03-11 13:59:27 139887411787712 [Note] InnoDB: Tablespace and datafile system tables created. 2016-03-11 13:59:27 139887411787712 [Note] InnoDB: Waiting for purge to start 2016-03-11 13:59:27 139887411787712 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 0 2016-03-11 13:59:27 139886535374592 [Note] InnoDB: Dumping buffer pool(s) not yet started 2016-03-11 13:59:27 139887411550976 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist 2016-03-11 13:59:31 139640839899072 [Note] /usr/sbin/mysqld (mysqld 10.1.12-MariaDB-1~jessie) starting as process 83 ... 2016-03-11 13:59:31 139640839899072 [Note] WSREP: Read nil XID from storage engines, skipping position init 2016-03-11 13:59:31 139640839899072 [Note] WSREP: wsrep_load(): loading provider library 'none' 2016-03-11 13:59:31 139640839899072 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2016-03-11 13:59:31 139640839899072 [Note] InnoDB: The InnoDB memory heap is disabled 2016-03-11 13:59:31 139640839899072 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2016-03-11 13:59:31 139640839899072 [Note] InnoDB: Memory barrier is not used 2016-03-11 13:59:31 139640839899072 [Note] InnoDB: Compressed tables use zlib 1.2.8 2016-03-11 13:59:31 139640839899072 [Note] InnoDB: Using Linux native AIO 2016-03-11 13:59:31 139640839899072 [Note] InnoDB: Using SSE crc32 instructions 2016-03-11 13:59:31 139640839899072 [Note] InnoDB: Initializing buffer pool, size = 400.0M 2016-03-11 13:59:31 139640839899072 [Note] InnoDB: Completed initialization of buffer pool 2016-03-11 13:59:31 139640839899072 [Note] InnoDB: Highest supported file format is Barracuda. 2016-03-11 13:59:31 139640839899072 [Note] InnoDB: 128 rollback segment(s) are active. 2016-03-11 13:59:31 139640839899072 [Note] InnoDB: Waiting for purge to start 2016-03-11 13:59:31 139640839899072 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1616799 2016-03-11 13:59:31 139639968990976 [Note] InnoDB: Dumping buffer pool(s) not yet started 2016-03-11 13:59:34 140650620151744 [Note] /usr/sbin/mysqld (mysqld 10.1.12-MariaDB-1~jessie) starting as process 113 ... 2016-03-11 13:59:34 140650620151744 [Note] WSREP: Read nil XID from storage engines, skipping position init 2016-03-11 13:59:34 140650620151744 [Note] WSREP: wsrep_load(): loading provider library 'none' 2016-03-11 13:59:35 140650620151744 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2016-03-11 13:59:35 140650620151744 [Note] InnoDB: The InnoDB memory heap is disabled 2016-03-11 13:59:35 140650620151744 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2016-03-11 13:59:35 140650620151744 [Note] InnoDB: Memory barrier is not used 2016-03-11 13:59:35 140650620151744 [Note] InnoDB: Compressed tables use zlib 1.2.8 2016-03-11 13:59:35 140650620151744 [Note] InnoDB: Using Linux native AIO 2016-03-11 13:59:35 140650620151744 [Note] InnoDB: Using SSE crc32 instructions 2016-03-11 13:59:35 140650620151744 [Note] InnoDB: Initializing buffer pool, size = 400.0M 2016-03-11 13:59:35 140650620151744 [Note] InnoDB: Completed initialization of buffer pool 2016-03-11 13:59:35 140650620151744 [Note] InnoDB: Highest supported file format is Barracuda. 2016-03-11 13:59:35 140650620151744 [Note] InnoDB: 128 rollback segment(s) are active. 2016-03-11 13:59:35 140650620151744 [Note] InnoDB: Waiting for purge to start 2016-03-11 13:59:35 140650620151744 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1616809 2016-03-11 13:59:35 140649751873280 [Note] InnoDB: Dumping buffer pool(s) not yet started ERROR: 1049 Unknown database 'test' 2016-03-11 13:59:35 140650620151744 [ERROR] Aborting }}} \\ **my.cnf** {{{ mysqld] # # * Basic Settings # skip-host-cache skip-name-resolve bind-address = 0.0.0.0 port = 3306 # basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp socket =/var/run/mysqld/mysqld.sock user = mysql lc_messages_dir = /usr/share/mysql lc_messages = en_US skip-external-locking # # * Fine Tuning # max_connections = 100 connect_timeout = 5 wait_timeout = 600 max_allowed_packet = 16M thread_cache_size = 128 sort_buffer_size = 4M bulk_insert_buffer_size = 16M tmp_table_size = 32M max_heap_table_size = 32M # # * MyISAM # # This replaces the startup script and checks MyISAM tables if needed # the first time they are touched. On error, make copy and try a repair. myisam_recover_options = BACKUP key_buffer_size = 128M #open-files-limit = 2000 table_open_cache = 400 myisam_sort_buffer_size = 512M concurrent_insert = 2 read_buffer_size = 2M read_rnd_buffer_size = 1M # Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf. # # we do want to know about network errors and such log-error =/dev/stderr log_warnings = 3 # # Enable the slow query log to see queries with especially long duration #slow_query_log[={0|1}] slow_query_log_file = /var/log/mysql/mariadb-slow.log long_query_time = 10 expire_logs_days = 10 max_binlog_size = 100M # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/. # Read the manual for more InnoDB related options. There are many! default_storage_engine = InnoDB innodb_log_file_size = 48M innodb_log_buffer_size = 8M innodb_file_per_table = 1 innodb_buffer_pool_size = 400M innodb_open_files = 400 innodb_io_capacity = 400 innodb_flush_method = O_DIRECT innodb-doublewrite =1 innodb-autoinc-lock-mode=2 innodb-flush-log-at-trx-commit=0 innodb_data_file_path =ibdata1:12M:autoextend log-bin =ON binlog-format =ROW wsrep-provider =/usr/lib/galera/libgalera_smm.so wsrep-sst-method =xtrabackup-v2 wsrep_on =ON query-cache-size=0 query_cache_type=0 read_buffer_size=1G # following to be changed by docker-entrypoint.sh before mysql_install_db wsrep-node-address= wsrep-node-name= wsrep-cluster-name= wsrep-cluster-address= wsrep-sst-auth= wsrep-sst-donor= # xtrabackup Configuration [sst] progress=1 compressor="gzip" decompressor="gzip -dc" rebuild=ON compact=ON encrypt =0 }}} \\ mysql_install_db --user=mysql --datadir="$DATADIR" --rpm -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-10112-mysql_install_db-aborts-on-unkown-fi…

1 0

[Maria-discuss] MariaDB replication-manager 0.6.0 release
by Guillaume Lefranc 11 Mar '16

11 Mar '16

Hi, I just released the latest version of my replication manager utility for MariaDB. It has some tremendous improvements over the last version, so if you are using it please upgrade, or check it out at https://github.com/mariadb-corporation/replication-manager Main features: - Agentless utility - Works over standard mysql protocol - Easy to deploy: single binary for all 64-bit systems - Failover - Switchover - Pre and post scripts - Seamless interaction with Maxscale, HAProxy, ProxySQL... - Interactive and non-interactive modes - Designed to work with MariaDB GTID Not supported yet by this version, but might be in the future: - Clustering - Conf file - Semi sync support - Multi-master support - Positional replication - Multiple GTID domains Regards, Guillaume

1 0

[Maria-discuss] New Question: Will MariaDB add json components like MySQL recently announced
by AskMonty KB 11 Mar '16

11 Mar '16

Hello, A new question has been asked in "What is in the Different MariaDB Releases?" by patb(a)mindkicks.com. Please answer it at http://mariadb.com/kb/en/will-mariadb-add-json-components-like-mysql-recent… as the person asking the question may not be subscribed to the mailing list. -------------------------------- MySQL has released components specifically for json. As a web developer I need to know if MariaDB will also add features for json? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/will-mariadb-add-json-components-like-mysql-recent…

1 0

[Maria-discuss] The insert performance issue
by 林澤宇 11 Mar '16

11 Mar '16

Hi ALL , I test the MariaDB performance of insert command . I use a file include 100000 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 about 30 second to insert data . I execute the command " mysql -h db1 -utest -ptest -D IST < insert_file.sql" on local and remote servers . Why the MariaDB has about 10 second gap ? Maybe the network should to cause some latancy ,but the time should not have so long . What issue to cause the gap ?

7 9

Re: [Maria-discuss] The insert performance issue
by Federico Razzoli 11 Mar '16

11 Mar '16

That could be a problem if DNS is not reliable, but I never heard of a 10 seconds DNS request. I'd strongly recommend to assign more memory to the buffer pool. If InnoDB is the main storage engine you use, 1.5G should be ok. Swap is evil for a database, so you should make sure that loading a dump does not cause swapping. Federico -------------------------------------------- Gio 10/3/16, Jerry Lin <jerry08291021(a)gmail.com> ha scritto: Oggetto: Re: [Maria-discuss] The insert performance issue A: "Sergei Golubchik" <serg(a)mariadb.org> Cc: maria-discuss(a)lists.launchpad.net Data: Giovedì 10 marzo 2016, 11:20 Hi ,My MariaDB original setting has include "skip-name-resolve" . 2016-03-10 16:48 GMT+08:00 Sergei Golubchik <serg(a)mariadb.org>: Hi, 林澤宇! On Mar 10, 林澤宇 wrote: > Hi ALL , > > I test the MariaDB performance of insert command . > I use a file include 100000 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 about 30 second to insert data . > I execute the command " mysql -h db1 -utest -ptest -D IST < > insert_file.sql" on local and remote servers . > > Why the MariaDB has about 10 second gap ? > Maybe the network should to cause some latancy ,but the time should not > have so long . > > What issue to cause the gap ? May be hostname resolution? As far as I understand the default resolver timeout is 5 seconds (man resolv.conf) - two failed name lookups gives you exactly 10 seconds. Try --skip-name-resolve on the remote mariadb server and make sure you only use IP adresses when granting privileges and when connecting to the server. Regards, Sergei Chief Architect MariaDB and security(a)mariadb.org -----Segue allegato----- _______________________________________________ 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 2

[Maria-discuss] New Question: Table and Column
by AskMonty KB 10 Mar '16

10 Mar '16

Hello, A new question has been asked in "MariaDB Community" by Redman Companies. Please answer it at http://mariadb.com/kb/en/table-and-column/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have created a new table called 'B' using a table called 'A'. My question is, how do I create three new columns in table B and populate them with data from table A? Your help would be greatly appreciated. Thank you in advance. (See example below) Ex.tables--- A ------------ B columns a, a1, a2... b , b1, b2... c, c1, c2... x, y, z, a b c a1 b1 c1 a2 b2 c2 . . . a8 b8 c8 Put all of the data from a...a8 into column x line by line Put all of the data from b..b8. into column y line by line Put all of the data from c...c8 into column z line by line -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/table-and-column/

1 0

[Maria-discuss] R: The insert performance issue
by Federico Razzoli 10 Mar '16

10 Mar '16

林澤宇, there is clearly some difference between your servers. Same version? Same storage engine (InnoDB)? Same indexes? Memory is full, maybe swapping? If all these things are ok, check your settings (SHOW VARIABLES). Federico -------------------------------------------- Gio 10/3/16, 林澤宇 <jerry08291021(a)gmail.com> ha scritto: Oggetto: [Maria-discuss] The insert performance issue A: maria-discuss(a)lists.launchpad.net Data: Giovedì 10 marzo 2016, 04:52 Hi ALL , I test the MariaDB performance of insert command .I use a file include 100000 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 about 30 second to insert data .I execute the command " mysql -h db1 -utest -ptest -D IST < insert_file.sql" on local and remote servers . Why the MariaDB has about 10 second gap ?Maybe the network should to cause some latancy ,but the time should not have so long . What issue to cause the gap ? -----Segue allegato----- _______________________________________________ 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

2 1

[Maria-discuss] R: The insert performance issue
by Federico Razzoli 10 Mar '16

10 Mar '16

林澤宇, there is clearly some difference between your servers. Same version? Same storage engine (InnoDB)? Same indexes? Memory is full, maybe swapping? If all these things are ok, check your settings (SHOW VARIABLES). Federico -------------------------------------------- Gio 10/3/16, 林澤宇 <jerry08291021(a)gmail.com> ha scritto: Oggetto: [Maria-discuss] The insert performance issue A: maria-discuss(a)lists.launchpad.net Data: Giovedì 10 marzo 2016, 04:52 Hi ALL , I test the MariaDB performance of insert command .I use a file include 100000 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 about 30 second to insert data .I execute the command " mysql -h db1 -utest -ptest -D IST < insert_file.sql" on local and remote servers . Why the MariaDB has about 10 second gap ?Maybe the network should to cause some latancy ,but the time should not have so long . What issue to cause the gap ? -----Segue allegato----- _______________________________________________ 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] Question about MariaDB global reference In high complexity app and big DB Size
by Seung Hoon Yoo 09 Mar '16

09 Mar '16

hi I am some question, i want some opinion below question We planning ERP solution convert oracle to mariaDB so erp application pattern and BIG DB SIZING IS ISSUE. Our IT background & goal 1) Apppliciation Complexity & Pattern: ERP Level complexity (high , OLTP & many batch) 2) DB SIZE : 10 TB Over (Single DB , NO sharding) 3) replication Gap issue ** My Question ** 1) Any Global reference is in MariaDB (on ERP level complexity and application pattern) 2) Any some reference in BIG DATA SIZING ? (EX: 5TB DB Exists in XX COMPARY e-commerce soluntion..) IS Only solution is DB Sharding? no big data global reference ?? 3) Replication performance : Our test result 2MB/SEC binlog written in master , so slave node get replication lag glorwing. (in row binlog format) ( 1master - 1 slave ) Any Body have experience some reference max transaction in no replication gap ? ( ex : 20MB / SEC but no replication gap our application experience..) : parellel slave thread is good performance in single domain-id and ordered method replicaiton ? ( how much better performance in parallel replication? (ex single repliation 2MB/SEC BINLOG => Replication GAP GROW but, parellel replicaiton is good in 10MB/Sec binlog write Environment) thanks a lot. regards, seung hoon yoo.

3 6

[Maria-discuss] New Question: SST smethod: rsync_wan
by AskMonty KB 09 Mar '16

09 Mar '16

Hello, A new question has been asked in "MariaDB Galera Cluster" by gijs. Please answer it at http://mariadb.com/kb/en/sst-smethod-rsync_wan/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I'm looking for an option to make my SST faster. I tried using xtrabackup-v2 but this currently doesn't support GTID clusters. I read that there is a rsync SST method that is customized for WAN usage. It makes use of delta transfers to reduce the data that has to be send over the WAN. I've tried: wsrep_sst_method=rsync-wan wsrep_sst_method=rsync_wan But neither of them work, nor can I find any official documentation about this feature for MariaDB. I did find: http://galeracluster.com/documentation-webpages/statetransfer.html http://galeracluster.com/documentation-webpages/sst.html http://galeracluster.com/documentation-webpages/mysqlwsrepoptions.html#wsre… https://blog.adminfactory.net/mariadb-and-galera-on-aws-amazon-linux.html My question is how can I enable the delta transfer for rsync with MariaDB 10.1.12? If this is not possible with MariaDB I'd like to know if there are any plans to implement it and if there are any plans to make xtrabackup-v2 support GTID clusters. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/sst-smethod-rsync_wan/

1 0

[Maria-discuss] New Question: Is Aria a good choice in environments where power will often fail?
by AskMonty KB 08 Mar '16

08 Mar '16

Hello, A new question has been asked in "Aria" by thomas_gawehn. Please answer it at http://mariadb.com/kb/en/is-aria-a-good-choice-in-environments-where-power-… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi all, the Aria storage engine is described to be "crash safe". Would this mean that Aria is a good choice in production environments where the system power is expected to fail very often? Think about small embedded systems which are run without UPS? What will happen when power fails right whilst a record being updated or inserted and the corresponding I/O is right written to the disk at that moment? Would the database then come up corrupt after the next boot, with manuel assistance being neccessary -or- will the database be fine in general, and only the last record / the last change / last operation vanishes? Always presumed, the LOCK TABLES command is sent directly after each data manipulation command. What about possible operating system or hard disk "write behand" caches? Thanks and best regards Thomas -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/is-aria-a-good-choice-in-environments-where-power-…

1 0

[Maria-discuss] New Question: MariaDB SSL connection with Connector/J Setup help
by AskMonty KB 08 Mar '16

08 Mar '16

Hello, A new question has been asked in "SSL Connections" by og_116262525349832924122. Please answer it at http://mariadb.com/kb/en/mariadb-ssl-connection-with-connectorj-setup-help/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I just installed MariaDB 10.1.11 on Centos 7 and enabled SSL connections. I created the root CA, Server Cert/Key, & Client Cert/Key as spelled out in the instructions from this link http://xmodulo.com/enable-ssl-mysql-server-client.html (used -sha256 instead of -sha1) I added the variables in the [mysqld] section of the server.cnf file and restarted MariaDB I created a user and granted them privilages with a "require x509" suffix. I have 2 users created (nossluser, ssluser) grant all on *.* to nossluser; grant all on *.* to ssluser require X509; I can login from the command line using MySQL without any problems MySQL -u nossluser -p <--- works fine with the user that has no ssl requirement MySQL -u ssluser -p --ssl-cert client-cert.pem --ssl-key client-key.pem --ssl-ca ca-cert.pem <-- this works fine I can also connect from a remote client using MySQL workbench using the same ca-cert.pem, client-cert.pem, client-key.pem as I used on the command line. My problem is when I try to create a java client connection using the Mariadb connector/j I have tried issuing the connection using the useSSL=true, requireSSL=true, serverSslCert=server-cert.pem but it does not work. I get the: "Could not connect: Access denied for user 'ssluser'@192.168.1.9' (using password: YES)" error message I also enabled java.net.debug and I get a message in the log that says: "Warning:no suitable certificate found - continuing without client authentication" Now if I change the user to "require ssl" instead of "require x509" The connection works, but I still see the java net debug warning no suitable certificate found which I assume means that the SSL connection did not work but it allowed the connection anyway. Any Ideas on the correct connection settings for the connector/j Thanks, Willie -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-ssl-connection-with-connectorj-setup-help/

1 0

[Maria-discuss] New Question: CentOS v6 glibc 2.12 default but Tokudb need 2.14
by AskMonty KB 08 Mar '16

08 Mar '16

Hello, A new question has been asked in "TokuDB" by yngve.eriksson_39408. Please answer it at http://mariadb.com/kb/en/centos-v6-glibc-212-default-but-tokudb-need-214/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- What is the best way to install glibc 2.14 ? so many tell me not to mess with glibc version or CentosOS is unstable ..... is it included in CentOS 7 ? is that the way to go ? or how do I install glibc 2.14 ? Where do I get it from .... yum -UHv xxxxx_glibc-2.14.rpm ??? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/centos-v6-glibc-212-default-but-tokudb-need-214/

1 0

[Maria-discuss] New Question: Problem with the Galera wsrep_sst_method xtrabackup-v2
by AskMonty KB 05 Mar '16

05 Mar '16

Hello, A new question has been asked in "MariaDB Community" by aferrett. Please answer it at http://mariadb.com/kb/en/problem-with-the-galera-wsrep_sst_method-xtrabacku… as the person asking the question may not be subscribed to the mailing list. -------------------------------- We are trying to create a Galera cluster. We have our first node running. We want to use xtrabackup to initialize the 2nd cluster node. We are getting error: 2016-03-04 22:56:20 140441685063424 [ERROR] WSREP: Failed to read 'ready <addr>' from: wsrep_sst_xtrabackup-v2 --role 'joiner' --address '130.9.221.48' --datadir '//opt/app/mysql/data/' --parent '28544' --binlog '//opt/app/mysql/binlogs/mysql-bin' Read: '(null)' 2016-03-04 22:56:20 140441685063424 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup-v2 --role 'joiner' --address '130.9.221.48' --datadir '//opt/app/mysql/data/' --parent '28544' --binlog '//opt/app/mysql/binlogs/mysql-bin' : 1 (Operation not permitted) 2016-03-04 22:56:20 140441697642240 [ERROR] WSREP: Failed to prepare for 'xtrabackup-v2' SST. Unrecoverable. 2016-03-04 22:56:20 140441697642240 [ERROR] Aborting -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/problem-with-the-galera-wsrep_sst_method-xtrabacku…

1 0

[Maria-discuss] New Question: MariaDB Connector/J
by AskMonty KB 04 Mar '16

04 Mar '16

Hello, A new question has been asked in "MariaDB FAQ" by xviakoh_g. Please answer it at http://mariadb.com/kb/en/mariadb-faq-mariadb-connectorj/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, We are using MariaDB Connector/J against our production AWS Aurora RDS and noticed that default socketTimeout is set to 10 seconds against Aurora. Is there a reason behind this default value? Is there any implication of increasing timeout that I should be aware? We do have transaction layer that times out at 60 seconds. So was thinking to up it to match our higher layer timeout. any advice is greatly appreciated. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-faq-mariadb-connectorj/

1 0

[Maria-discuss] How to rollback XA Transactions
by Marc Schöchlin 04 Mar '16

04 Mar '16

Hi, i currently have the situation that i cannot modify tables/indices beaus of XA transactions which are in progress. mysql://root@localhost:/(none) - 11:37:55 > xa recover; +----------+--------------+--------------+------------------------------------------------------------------+ | formatID | gtrid_length | bqual_length | data | +----------+--------------+--------------+------------------------------------------------------------------+ | 4871251 | 35 | 29 | ^W<89>^B <E8>XF+foo-bar-de05,server,P4837foo-bar-de05,server,P4837,^A | | 4871251 | 35 | 29 | ^N<89>^B <E8>XF+foo-bar-de05,server,P4837foo-bar-de05,server,P4837,^A | +----------+--------------+--------------+------------------------------------------------------------------+ 2 rows in set (0.00 sec) The documentation (https://mariadb.com/kb/en/mariadb/xa-transactions/) suggests that xa transaction can be rolled back by using "xa rollback xid" but it seems that this is not possible because of the non-ascii characters. As you can see in the attached Innodb status, these transactions a active for a log time now and should not be relevant anymore. Naturally restarting the server should not help..... Do you have a suggestion how to prevent, solve or analyze this situation? Regards Marc ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ mysql://root@localhost:/(none) - 11:34:25 > SHOW ENGINE INNODB STATUS\G *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2016-02-20 11:34:50 7fba401d3700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 31 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 57 srv_active, 0 srv_shutdown, 171810 srv_idle srv_master_thread log flush and writes: 171823 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 2076 OS WAIT ARRAY INFO: signal count 2072 Mutex spin waits 339, rounds 174, OS waits 3 RW-shared spins 2133, rounds 63046, OS waits 2069 RW-excl spins 0, rounds 0, OS waits 0 Spin rounds per wait: 0.51 mutex, 29.56 RW-shared, 0.00 RW-excl ------------ TRANSACTIONS ------------ Trx id counter 1969875 Purge done for trx's n:o < 1965495 undo n:o < 0 state: running but idle History list length 316 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started MySQL thread id 4362, OS thread handle 0x7fba401d3700, query id 23179 localhost root init SHOW ENGINE INNODB STATUS ---TRANSACTION 1969667, not started MySQL thread id 1, OS thread handle 0x7fba41298700, query id 0 Waiting for background binlog tasks ---TRANSACTION 413370, ACTIVE (PREPARED) 172053 sec recovered trx , undo log entries 9 Trx #rec lock waits 0 #table lock waits 0 Trx total rec lock wait time 0 SEC Trx total table lock wait time 0 SEC ---TRANSACTION 413360, ACTIVE (PREPARED) 172053 sec recovered trx , undo log entries 11 Trx #rec lock waits 0 #table lock waits 0 Trx total rec lock wait time 0 SEC Trx total table lock wait time 0 SEC -------- FILE I/O -------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread) I/O thread 1 state: waiting for completed aio requests (log thread) I/O thread 2 state: waiting for completed aio requests (read thread) I/O thread 3 state: waiting for completed aio requests (read thread) I/O thread 4 state: waiting for completed aio requests (read thread) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (write thread) I/O thread 7 state: waiting for completed aio requests (write thread) I/O thread 8 state: waiting for completed aio requests (write thread) I/O thread 9 state: waiting for completed aio requests (write thread) 1 row in set (0.00 sec) Regards Marc -- GPG encryption available: 0x670DCBEC/pool.sks-keyservers.net (https://www.256bit.org/keys/mschoechlin.pub.asc)

3 6

[Maria-discuss] New Question: Aria System Variables: aria_block_size
by AskMonty KB 03 Mar '16

03 Mar '16

Hello, A new question has been asked in "Aria" by paul.pech_41353. Please answer it at http://mariadb.com/kb/en/aria-system-variables-aria_block_size/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi Are there any guidelines on how to decide what block sizes to use for Aria index pages? We've just switched from MySQL and MyISAM to MariaDB and Aria and noticed a significant drop in performance when full table scans are necessary. In our environment we have 10.000+ databases each with about 20 tables. Each database is usually smaller than 30 - 40 MB (90% of this is contained in roughly 3-4 tables, all other tables usually contain just a couple of rows). Am I correct in assuming that in this case (many comparatively small tables) a small block size (say 2048) could help to improve performance, while for huge tables a larger block size (the default value) is recommended? Any other tips on how to fine tune Aria in particular and MariaDB in general for our use case are highly appreciated. Thanks for a great product and a well written documentation! Yours Paul -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/aria-system-variables-aria_block_size/

1 0

[Maria-discuss] New Question: MariaDB removes all users on restart
by AskMonty KB 03 Mar '16

03 Mar '16

Hello, A new question has been asked in "MariaDB FAQ" by andrew_kilburn_g. Please answer it at http://mariadb.com/kb/en/mariadb-removes-all-users-on-restart/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I am new to MariaDB and have set 3 instances up on 3 different servers. I customised the variables using the MySQL MariaDB client and all was well with the world. However, when coming to restart the machine which the MariaDB databases are currently installed on, it set all the variables back to default values. This is very strange and I'm not sure why this has occurred. After some investigating I found that I can set the variables permanently by changing the My.config file. So this is what I did. My MariaDB instance had 2 users, the original root and the new user which I created. When I restarted the machine after changing the config file by only adding 3 variables, I found that it removed both users and I now cannot connect to MariaDB using any of the users which have been created. I've done this on two machines and now I only have access to one! Why is this? Is this some sort of bug? How am I supposed to get back in? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-removes-all-users-on-restart/

1 0

[Maria-discuss] question on semisync
by Qiang Tian 03 Mar '16

03 Mar '16

Hi guys, Do we have enhancement like mysql worklog 6630( http://dev.mysql.com/worklog/task/?id=6630) I did not see it in 10.1 release note.. thanks a lot! Qiang

1 0

[Maria-discuss] Galera crash - [ERROR] Slave SQL: Error 'Can't create table (errno: 150)' on query. Default database: . Query: 'CREATE TABLE'
by Lukas Lehner 02 Mar '16

02 Mar '16

Hi http://dba.stackexchange.com/questions/130307/galera-crash-error-slave-sql-… any idea? howto debug future crashes better? Lukas

4 4

[Maria-discuss] New Question: Error installing AUDIT Plugin in MySQL 5.7
by AskMonty KB 02 Mar '16

02 Mar '16

Hello, A new question has been asked in "MariaDB Community" by sanjaykumar.raghavendra. Please answer it at http://mariadb.com/kb/en/error-installing-audit-plugin-in-mysql-57/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I downloaded mariadb-10.1.11 for Linux x86-64 and copied the auth_pam.so to plugin directory under MySQL 5.7.10 Community Server home directory. When I attempt to install the plugin I get the following error mysql> install soname 'auth_pam'; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'soname 'auth_pam'' at line 1 Then I tried the following but no luck mysql> install plugin auth_pam_server soname 'auth_pam.so'; ERROR 1127 (HY000): Can't find symbol '_mysql_plugin_interface_version_' in library mysql> install plugin pam soname 'auth_pam.so'; ERROR 1127 (HY000): Can't find symbol '_mysql_plugin_interface_version_' in library Do I need to do anything additional for this to work? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/error-installing-audit-plugin-in-mysql-57/

1 0

[Maria-discuss] new jira: missing redirect
by Federico Razzoli 29 Feb '16

29 Feb '16

Hi! I see that MariaDB switched to the new JIRA. However this redirect has not been updated: http://mariadb.org/jira Regards Federico

1 0

[Maria-discuss] Fwd: New Question: Non-blocking calls from PHP
by Justin Swanhart 27 Feb '16

27 Feb '16

oops, didn't copy the list. ---------- Forwarded message ---------- From: Justin Swanhart <greenlion(a)gmail.com> Date: Wed, Feb 24, 2016 at 11:34 AM Subject: Re: [Maria-discuss] New Question: Non-blocking calls from PHP To: Federico Razzoli <federico_raz(a)yahoo.it> Hi, For now, if you want FIFO, just change the ORDER BY q_id DESC to ORDER BY q_id. The execution is parallel, it shouldn't starve queries. I will probably change this anyway by changing the structure of the `q` table to have a primary key that sorts by the completion status and a unique key for the auto_increment columns, then it can naturally be FIFO without causing lock contention due to locking scanned rows in InnoDB. The workaround for GET DIAGNOSTICS is to change it to not use that and just put a generic error in the table. You can't use conditional version syntax in stored procs, and I don't want to have two different versions of the script, since everyone really should be using 5.6+ or MariaDB 5.5+ IMHO. I will remove count_running_threads, it isn't really needed because the metadata locks held by the stored proc enforce that no more than 'thread_count' threads can run. I will remove that code shortly. I wasn't using metadata locks when I started writing the tool. This will remove the dependency on global variables and the processlist. It is version 1.0 and is still experimental :) Thank you for the feedback. --Justin On Wed, Feb 24, 2016 at 10:58 AM, Federico Razzoli <federico_raz(a)yahoo.it> wrote: > Yes, GET DIAGNOSTICS is in 5.5 (and anyway, a workaround for older > versions should be possible, correct?). > > Some comments: > > 1) The LIFO tables sounds to me a little dangerous. Of course > "asynchronous" means "asynchronous", but under certain circumstances some > queries could wait too much... don't you agree? Maybe the direction could > depend from an option... > > 2) SELECT queries are "materialized", which is cool. But I don't > understand how the user can associate an async query with the results table. > > 3) In MariaDB, the P_S is disabled by default, and a user can still > disable it in MySQL. Also, in MariaDB global_status is in I_S, while MySQL > has it in P_S (another funny incompatibility developed by Oracle). The > first problem can probably be addressed with CONNECT (SRCDEF='show > processlist') and the second with a view in async schema. Would you accept > a patch? > > Probably more comments/questions will come. In the meanwhile, thanks for > your work (again). > > bye > Federico > > > -------------------------------------------- > Mer 24/2/16, Justin Swanhart <greenlion(a)gmail.com> ha scritto: > > Oggetto: Re: [Maria-discuss] New Question: Non-blocking calls from PHP > A: "Federico Razzoli" <federico_raz(a)yahoo.it> > Cc: "Maria Discuss" <maria-discuss(a)lists.launchpad.net> > Data: Mercoledì 24 febbraio 2016, 16:04 > > Hi, > It is > completely native. It consists of a queue table, a thread > state table, a settings table, a stored procedure worker, an > event to execute the worker (more than one run in parallel) > and procs to drop off, check on, and get the results of a > SQL statement (which always waits if the SQL is not done > yet). > I don't know > if MariaDB 5.5 or 10 adds GET DIAGNOSTICS, but it will work > with any version that has it. You can comment that out and > just put a generic error into the table if it isn't > supported, and it will work with any version that has > SIGNAL. > --Justin > On Wed, Feb 24, 2016 at > 10:01 AM, Federico Razzoli <federico_raz(a)yahoo.it> > wrote: > Hi > Justin! > > The name reminds me a a fatal trap for developers and sys > admins (async npm module), but the tools sounds useful. > > Is it publicly available? Is it entirely implemented via > stored procedures + event scheduler? > > > > bye > > Federico > > > > > > -------------------------------------------- > > Mer 24/2/16, Justin Swanhart <greenlion(a)gmail.com> > ha scritto: > > > > Oggetto: Re: [Maria-discuss] New Question: Non-blocking > calls from PHP > > A: "AskMonty KB" <noreply(a)askmonty.org> > > Cc: "Maria Discuss" <maria-discuss(a)lists.launchpad.net> > > Data: Mercoledì 24 febbraio 2016, 15:32 > > > > Replying > > here in addition to the web page (ugh > Frankenstein's > > monster)... > > > > I just finished > > the first version of 'async' which runs queries > in > > the background (in parallel!) using a queue table, a > crafty > > stored procedure for a worker thread, and an event > which > > executes the workers. > > http://swanhart.livejournal.com/138754.html > > > > On Sun, Feb 21, 2016 at > > 8:55 AM, AskMonty KB <noreply(a)askmonty.org> > > wrote: > > Hello, > > > > > > > > A new question has been asked in " MariaDB > Connector/C > > API Functions" by shestero. Please answer it at > http://mariadb.com/kb/en/non-blocking-calls-from-php/ > > as the person asking the question may not be subscribed > to > > the mailing list. > > > > > > > > -------------------------------- > > > > I want to use non-blocking API ( > https://mariadb.com/kb/en/mariadb/non-blocking-api-reference > > ) from PHP. > > > > Is it possible now? > > > > If no, can anybody give me directions how to implement > my > > own PHP-extension in C (using Connector/C) or update > the > > existing module? I don't think it's very complex, > do > > I need to add just wraper-like implementations using > > blocking function as samples, don't I? > > > > -------------------------------- > > > > > > > > To view or answer this question please visit: > http://mariadb.com/kb/en/non-blocking-calls-from-php/ > > > > > > > > _______________________________________________ > > > > 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 > > > > > > > > -----Segue allegato----- > > > > _______________________________________________ > > 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 1

[Maria-discuss] MariaDB 10.1.12 and MariaDB Galera Cluster 10.0.24 & 5.5.48 now available
by Daniel Bartholomew 26 Feb '16

26 Feb '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.12, and MariaDB Galera Cluster 10.0.24 & 5.5.48. These are all Stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.12 - Release Notes: https://mariadb.com/kb/en/mdb-10112-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10112-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.1.12 About MariaDB 10.1: - https://mariadb.com/kb/en/what-is-mariadb-101/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB Galera Cluster 10.0.24 - Release Notes: https://mariadb.com/kb/en/mgc-10024-rn/ - Changelog: https://mariadb.com/kb/en/mgc-10024-cl/ - Downloads: https://downloads.mariadb.org/mariadb-galera/10.0.24 MariaDB Galera Cluster 5.5.48 - Release Notes: https://mariadb.com/kb/en/mgc-5548-rn/ - Changelog: https://mariadb.com/kb/en/mgc-5548-cl/ - Downloads: https://downloads.mariadb.org/mariadb-galera/5.5.48 About MariaDB Galera Cluster: - https://mariadb.com/kb/en/about-mariadb-galera-cluster/ - - 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/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] Question on RocksDB AMA, when will MyRocks be in a proper distribution?
by MARK CALLAGHAN 25 Feb '16

25 Feb '16

https://www.reddit.com/r/IAmA/comments/47k1si/we_are_rocksdb_developers_ask… -- Mark Callaghan mdcallag(a)gmail.com

1 0

[Maria-discuss] New Question: Audit parameters getting reset after MySQL DB restart
by AskMonty KB 24 Feb '16

24 Feb '16

Hello, A new question has been asked in "MariaDB Community" by sanjaykumar.raghavendra. Please answer it at http://mariadb.com/kb/en/audit-parameters-getting-reset-after-mysql-db-rest… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi I am working on automating the installation and configuration of MySQL for faster deployment. As part of this, I enable the Audit parameters dynamically which works fine. However after the instance restart, I noticed that the parameters are getting reset to their factory defaults which disables auditing. For instance, server_audit_logging gets reset to OFF. Has anyone come across this? How do I persist my settings across instance restarts? Thanks -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/audit-parameters-getting-reset-after-mysql-db-rest…

1 0

Re: [Maria-discuss] New Question: Non-blocking calls from PHP
by Federico Razzoli 24 Feb '16

24 Feb '16

Yes, GET DIAGNOSTICS is in 5.5 (and anyway, a workaround for older versions should be possible, correct?). Some comments: 1) The LIFO tables sounds to me a little dangerous. Of course "asynchronous" means "asynchronous", but under certain circumstances some queries could wait too much... don't you agree? Maybe the direction could depend from an option... 2) SELECT queries are "materialized", which is cool. But I don't understand how the user can associate an async query with the results table. 3) In MariaDB, the P_S is disabled by default, and a user can still disable it in MySQL. Also, in MariaDB global_status is in I_S, while MySQL has it in P_S (another funny incompatibility developed by Oracle). The first problem can probably be addressed with CONNECT (SRCDEF='show processlist') and the second with a view in async schema. Would you accept a patch? Probably more comments/questions will come. In the meanwhile, thanks for your work (again). bye Federico -------------------------------------------- Mer 24/2/16, Justin Swanhart <greenlion(a)gmail.com> ha scritto: Oggetto: Re: [Maria-discuss] New Question: Non-blocking calls from PHP A: "Federico Razzoli" <federico_raz(a)yahoo.it> Cc: "Maria Discuss" <maria-discuss(a)lists.launchpad.net> Data: Mercoledì 24 febbraio 2016, 16:04 Hi, It is completely native. It consists of a queue table, a thread state table, a settings table, a stored procedure worker, an event to execute the worker (more than one run in parallel) and procs to drop off, check on, and get the results of a SQL statement (which always waits if the SQL is not done yet). I don't know if MariaDB 5.5 or 10 adds GET DIAGNOSTICS, but it will work with any version that has it. You can comment that out and just put a generic error into the table if it isn't supported, and it will work with any version that has SIGNAL. --Justin On Wed, Feb 24, 2016 at 10:01 AM, Federico Razzoli <federico_raz(a)yahoo.it> wrote: Hi Justin! The name reminds me a a fatal trap for developers and sys admins (async npm module), but the tools sounds useful. Is it publicly available? Is it entirely implemented via stored procedures + event scheduler? bye Federico -------------------------------------------- Mer 24/2/16, Justin Swanhart <greenlion(a)gmail.com> ha scritto: Oggetto: Re: [Maria-discuss] New Question: Non-blocking calls from PHP A: "AskMonty KB" <noreply(a)askmonty.org> Cc: "Maria Discuss" <maria-discuss(a)lists.launchpad.net> Data: Mercoledì 24 febbraio 2016, 15:32 Replying here in addition to the web page (ugh Frankenstein's monster)... I just finished the first version of 'async' which runs queries in the background (in parallel!) using a queue table, a crafty stored procedure for a worker thread, and an event which executes the workers. http://swanhart.livejournal.com/138754.html On Sun, Feb 21, 2016 at 8:55 AM, AskMonty KB <noreply(a)askmonty.org> wrote: Hello, A new question has been asked in " MariaDB Connector/C API Functions" by shestero. Please answer it at http://mariadb.com/kb/en/non-blocking-calls-from-php/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I want to use non-blocking API ( https://mariadb.com/kb/en/mariadb/non-blocking-api-reference ) from PHP. Is it possible now? If no, can anybody give me directions how to implement my own PHP-extension in C (using Connector/C) or update the existing module? I don't think it's very complex, do I need to add just wraper-like implementations using blocking function as samples, don't I? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/non-blocking-calls-from-php/ _______________________________________________ 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 -----Segue allegato----- _______________________________________________ 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] New Question: Non-blocking calls from PHP
by Federico Razzoli 24 Feb '16

24 Feb '16

Hi Justin! The name reminds me a a fatal trap for developers and sys admins (async npm module), but the tools sounds useful. Is it publicly available? Is it entirely implemented via stored procedures + event scheduler? bye Federico -------------------------------------------- Mer 24/2/16, Justin Swanhart <greenlion(a)gmail.com> ha scritto: Oggetto: Re: [Maria-discuss] New Question: Non-blocking calls from PHP A: "AskMonty KB" <noreply(a)askmonty.org> Cc: "Maria Discuss" <maria-discuss(a)lists.launchpad.net> Data: Mercoledì 24 febbraio 2016, 15:32 Replying here in addition to the web page (ugh Frankenstein's monster)... I just finished the first version of 'async' which runs queries in the background (in parallel!) using a queue table, a crafty stored procedure for a worker thread, and an event which executes the workers. http://swanhart.livejournal.com/138754.html On Sun, Feb 21, 2016 at 8:55 AM, AskMonty KB <noreply(a)askmonty.org> wrote: Hello, A new question has been asked in " MariaDB Connector/C API Functions" by shestero. Please answer it at http://mariadb.com/kb/en/non-blocking-calls-from-php/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I want to use non-blocking API ( https://mariadb.com/kb/en/mariadb/non-blocking-api-reference ) from PHP. Is it possible now? If no, can anybody give me directions how to implement my own PHP-extension in C (using Connector/C) or update the existing module? I don't think it's very complex, do I need to add just wraper-like implementations using blocking function as samples, don't I? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/non-blocking-calls-from-php/ _______________________________________________ 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 -----Segue allegato----- _______________________________________________ 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

2 2

[Maria-discuss] New Question: Non-blocking calls from PHP
by AskMonty KB 24 Feb '16

24 Feb '16

Hello, A new question has been asked in " MariaDB Connector/C API Functions" by shestero. Please answer it at http://mariadb.com/kb/en/non-blocking-calls-from-php/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I want to use non-blocking API ( https://mariadb.com/kb/en/mariadb/non-blocking-api-reference ) from PHP. Is it possible now? If no, can anybody give me directions how to implement my own PHP-extension in C (using Connector/C) or update the existing module? I don't think it's very complex, do I need to add just wraper-like implementations using blocking function as samples, don't I? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/non-blocking-calls-from-php/

2 1

[Maria-discuss] Help to size: Best configuration for a lot read and write
by Tristan Auriol 23 Feb '16

23 Feb '16

Hello everyone, I have some basics about SQL. But I need your help. I must set up a SQL servers for a new web application. This web application will make a lot of write and some reads the night and enormously read and some writing on the day. Here are my questions: - What is the best solution for performance and security? - On a cluster Master / Master (three node) can I write on the 3 master node simultaneously (with HAProxy or another product)? Thank you in advance for your help. Best Regards, Tristan

3 2

[Maria-discuss] New Question: MariaDB Audit plugin support for MySQL 5.7
by AskMonty KB 22 Feb '16

22 Feb '16

Hello, A new question has been asked in "SERVER_AUDIT — MariaDB Audit Plugin" by sanjaykumar.raghavendra. Please answer it at http://mariadb.com/kb/en/mariadb-audit-plugin-support-for-mysql-57/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is the Audit plugin available for MySQL 5.7 version of Community Edition? I have used the plugin against 5.6 however, it doesn't seem to work with 5.7. Can someone please tell me when the plugin will be made compatible with MySQL 5.7 Thanks -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-audit-plugin-support-for-mysql-57/

1 0

[Maria-discuss] kb login doesn't work!
by Justin Swanhart 22 Feb '16

22 Feb '16

Hi, I have tried logging in with google, with linkedin and with github. I always get a 500 error from mariadb. So this means I can't reply back to the F*CKING STUPID MAILS THAT COMES TO THIS LIST THAT REQUIRE A WEB REPLY. This has been going on years now, this stupid "have to use the web site" to reply to questions. WTF MariaDB? Seriously, WTF? This system is so broken it is laughable. --Justin

3 5

Re: [Maria-discuss] kb login doesn't work!
by Federico Razzoli 22 Feb '16

22 Feb '16

I never had the login problem described by Justin, so I tested the GitHub login just for curiosity. What happened seems to me weird: * I logged out * I logged in via GitHub for the first time. An email verification is required (why?) * I didn't verify the mail * I logged in with my email & password (no social networks) * Got this message: "The application has been authorized" So it seems that my GitHub account is now verified just because someone (me, fortunately) has logged in from my browser. Looks like a bug... Regards Federico -------------------------------------------- Lun 22/2/16, Sergei Golubchik <serg(a)mariadb.org> ha scritto: Oggetto: Re: [Maria-discuss] kb login doesn't work! A: "Justin Swanhart" <greenlion(a)gmail.com> Cc: "Maria Discuss" <maria-discuss(a)lists.launchpad.net> Data: Lunedì 22 febbraio 2016, 16:28 Hi, Justin! On Feb 22, Justin Swanhart wrote: > Hi, > > I have tried logging in with google, with linkedin and with github. I > always get a 500 error from mariadb. > > So this means I can't reply back to the F*CKING STUPID MAILS THAT COMES TO > THIS LIST THAT REQUIRE A WEB REPLY. > > This has been going on years now, this stupid "have to use the web site" to > reply to questions. > > WTF MariaDB? > > Seriously, WTF? This system is so broken it is laughable. What is it that doesn't work? I've just tried to log in with my github account and it worked just fine. Regards, Sergei Chief Architect MariaDB and security(a)mariadb.org _______________________________________________ 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