- discuss - lists.mariadb.org

[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 07 Mar '16

07 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 04 Mar '16

04 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

[Maria-discuss] New Question: Wierd tables in mysql system database
by AskMonty KB 22 Feb '16

22 Feb '16

2 1

[Maria-discuss] New Question: "WITH" clause in "SELECT" statement?
by AskMonty KB 22 Feb '16

22 Feb '16

Hello, A new question has been asked in "Data Manipulation" by roblewis. Please answer it at http://mariadb.com/kb/en/with-clause-in-select-statement/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Some SQLs (e.g., SQLite) support a "WITH" clause introducing a SELECT statement, but it appears MariaDB doesn't. Can you discuss? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/with-clause-in-select-statement/

1 0

[Maria-discuss] Is there something like "best practices" to migrate from Paradox to MariaDB?
by Hugo Wau 21 Feb '16

21 Feb '16

Hello, I am new here. I will have to migrate some hundred Paradox Databases (on as many machines) to MariaDB. The best way to do so, would be something like a script. My OSs are Linux (Debian) and Win7. Is there some kind of documentation of the experience of someone, who has migrated from Paradox to MySQL/MariaDB before? (I have googled for days, but have not found such yet.) With kind regards Hugo

5 7

[Maria-discuss] New Question: Can't run C program using mariaDB on centOS
by AskMonty KB 21 Feb '16

21 Feb '16

Hello, A new question has been asked in "MariaDB FAQ" by grvsngh929. Please answer it at http://mariadb.com/kb/en/cant-run-c-program-using-mariadb-on-centos/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- here is link to my question (still unanswered): http://stackoverflow.com/questions/35531782/cant-run-c-program-using-mariad… -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/cant-run-c-program-using-mariadb-on-centos/

1 0

[Maria-discuss] New Question: Can't run C program using mariaDB on centOS
by AskMonty KB 21 Feb '16

21 Feb '16

Hello, A new question has been asked in "MariaDB FAQ" by grvsngh929. Please answer it at http://mariadb.com/kb/en/cant-run-c-program-using-mariadb-on-centos/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- here is link to my question (still unanswered): http://stackoverflow.com/questions/35531782/cant-run-c-program-using-mariad… -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/cant-run-c-program-using-mariadb-on-centos/

1 0

[Maria-discuss] MariaDB 10.0.24 now available
by Daniel Bartholomew 19 Feb '16

19 Feb '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.24. This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.24 - Release Notes: https://mariadb.com/kb/en/mdb-10024-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10024-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.0.24 About MariaDB 10.0: - https://mariadb.com/kb/en/what-is-mariadb-100/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/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: Upgrading MariaDB 10.0.20 to 10.1.11 with bi-directional master-slave replication
by AskMonty KB 18 Feb '16

18 Feb '16

Hello, A new question has been asked in "Getting, Installing, and Upgrading MariaDB" by aferrett. Please answer it at http://mariadb.com/kb/en/upgrading-mariadb-10020-to-10111-with-bi-direction… as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have two Maria DB instances running 10.0.20 on RHEL. Each is database is a slave with the other database as a master. Is there a procedure documented to upgrade these to 10.1.11? I just need to know the steps associated with the replication. I've already tested the upgrade of a single instance without replication. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/upgrading-mariadb-10020-to-10111-with-bi-direction…

1 0

[Maria-discuss] New Question: Migrating mysql 5.5.19 to mariadb with encryption
by AskMonty KB 18 Feb '16

18 Feb '16

Hello, A new question has been asked in "Getting, Installing, and Upgrading MariaDB" by Christine.Ross. Please answer it at http://mariadb.com/kb/en/migrating-mysql-5519-to-mariadb-with-encryption/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I am currently running mysql 5.5.19 64bit, Innodb, on Sparc Solaris and looking to move to mariadb on linux. Our ultimate goal is to have encrypted data-at-rest. I have 2 questions please. 1) So from my research I see I should be able to install mariadb 10.0 and run mysql_upgrade. Since the database exists already, do you just specify the location of the database when you install and it will upgrade it to mysqldb 10.0 when I run mysql_upgrade? 2) To achieve encryption, do I just install 10.1.4 on the same machine and run mysql_upgrade after making the changes to my.cnf. I know there are other my.cnf options but will this encrypt all the tables and logs? Does it do system tables please? [mysqld] plugin-load-add=file_key_management.so file-key-management file-key-management-filename = /mount/usb1/keys.txt innodb-encrypt-tables innodb-encrypt-log innodb-encryption-threads=4 I have just started to research so I appreciate the help. Christine -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/migrating-mysql-5519-to-mariadb-with-encryption/

1 0

[Maria-discuss] New Question: Access + MariaDB connector problem
by AskMonty KB 18 Feb '16

18 Feb '16

Hello, A new question has been asked in "MariaDB Community" by a.mesquita_37041. Please answer it at http://mariadb.com/kb/en/access-mariadb-connector-problem/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi everyone, I have an issue while executing a query with an ORDER BY on a table linked through a MariaDB ODBC connector to a MS ACCESS 2013 database. I use the 1.0.5 version of MariaDB ODBC connector and the 10.1.1 version of MariaDB (I don’t want to use a MySQL ODBC connector). If I try only with a SELECT * it works but from the moment I use the ORDER BY Access freezes for a while and then stops running. The UPDATE queries work fine. Any help would be much appreciated, Aurélien MESQUITA. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/access-mariadb-connector-problem/

1 0

[Maria-discuss] Google Summer of Code 2016
by Colin Charles 18 Feb '16

18 Feb '16

Hi! Its that time of year again and I believe that we plan to participate in Google Summer of Code 2016 again (we did so in 2013, 2014, and 2015). We are of course waiting to get accepted (we will know on Feb 29 2016) but that should not stop you, a *potential mentor* from adding your idea to the idea’s list page: https://mariadb.com/kb/en/mariadb/google-summer-of-code-2016/ Potential mentors should also see if there are Jira tasks they’d like completed: https://mariadb.atlassian.net/issues/?jql=labels%3Dgsoc16 (add more by adding the gsoc16 label) *Students* — please note that we have *not* been accepted *yet*, so asking us if you can do a project now is not necessarily useful (once we are accepted, then yes, please propose your interest) Here’s to Google Summer of Code 2016! 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

1 0

[Maria-discuss] New Question: PORTING MYSQL V5.5.19 TO MARIADB MASTER-MASTER SETUP
by AskMonty KB 17 Feb '16

17 Feb '16

Hello, A new question has been asked in "Replication, Cluster, & Multi-Master" by Christine.Ross. Please answer it at http://mariadb.com/kb/en/porting-mysql-v5519-to-mariadb-master-master-setup/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- We currently have mysql v5.5.19 64bit on Sparc Sun Solaris, with an INNODB storage engine. I am researching porting to mariadb. Our primary servers function in a master-master configuration, with real-time updates when changes are made on either server. I see docs describing master-slave and some posts about master-master. Do I have to install the galera cluster to maintain this master-master setup please or can I just install mariadb on each server and set the my.cnf files as I currently have them with different server-IDs please? Thank you very much. Christine -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/porting-mysql-v5519-to-mariadb-master-master-setup/

1 0

[Maria-discuss] Performance issues after upgrading to 10.0
by azurit＠pobox.sk 15 Feb '16

15 Feb '16

Hi, we upgraded MariaDB 5.5 to 10.0 on one server last night and are now dealing with severe performance issues. Here is one case where it's notable: Query - SELECT b.*, p.category_id FROM brands b JOIN products p USING(brand_id) GROUP BY category_id, brand_id ORDER BY title ASC; Table structures: CREATE TABLE `brands` ( `brand_id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(50) NOT NULL, `slug` varchar(50) NOT NULL, `description` text NOT NULL, `discount_suv_1` float NOT NULL, `discount_suv_2` float NOT NULL, `discount_van_1` float NOT NULL, `discount_van_2` float NOT NULL, `discount_orp_1` float NOT NULL, `discount_orp_2` float NOT NULL, PRIMARY KEY (`brand_id`) ) ENGINE=InnoDB AUTO_INCREMENT=150 DEFAULT CHARSET=utf8 CREATE TABLE `products` ( `product_id` int(11) NOT NULL AUTO_INCREMENT, `category_id` int(11) DEFAULT NULL, `featured_image_id` int(11) DEFAULT NULL, `brand_id` int(11) DEFAULT NULL, `title` text NOT NULL, `slug` text NOT NULL, `price` float NOT NULL, `custom_price` float NOT NULL, `description` text NOT NULL, `hidden` tinyint(1) NOT NULL, `homepage` tinyint(1) NOT NULL, `sale` tinyint(1) NOT NULL, `width` float NOT NULL, `height` int(11) NOT NULL, `diameter` int(11) NOT NULL, `resistance` varchar(50) NOT NULL, `breaking_distance` varchar(50) NOT NULL, `noise` varchar(50) NOT NULL, `ean` varchar(50) NOT NULL, `availability` char(1) NOT NULL, `li` varchar(15) NOT NULL, `si` varchar(15) NOT NULL, `classes` varchar(5) NOT NULL, `all_year` tinyint(1) NOT NULL, `type` char(3) NOT NULL, `holes_count` float NOT NULL, `pitch` float NOT NULL, `et` float NOT NULL, `code` varchar(50) NOT NULL, `custom` tinyint(1) NOT NULL, `car_type` varchar(100) NOT NULL, `models` text NOT NULL, `imported` tinyint(1) NOT NULL, `is_runflat` tinyint(1) NOT NULL, `stock_count` int(11) NOT NULL, `parser` char(1) NOT NULL, PRIMARY KEY (`product_id`), KEY `category_id` (`category_id`), KEY `featured_image_id` (`featured_image_id`), KEY `brand_id` (`brand_id`), KEY `slug` (`slug`(100)), KEY `hidden` (`hidden`), CONSTRAINT `products_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`category_id`) ON DELETE SET NULL, CONSTRAINT `products_ibfk_4` FOREIGN KEY (`featured_image_id`) REFERENCES `product_images` (`product_image_id`) ON DELETE SET NULL, CONSTRAINT `products_ibfk_5` FOREIGN KEY (`brand_id`) REFERENCES `brands` (`brand_id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=63638 DEFAULT CHARSET=utf8 Table brands: 149 rows Table products: 62074 rows Query time on 5.5: about 0.2s Query time on 10.0: between 2 and 9s (if not cached) Explain on 5.5: http://watchdog.sk/5.5.png Explain on 10.0: http://watchdog.sk/10.png Any hints what's going on? What about the difference in the explain command? Thank you. azur

4 8

[Maria-discuss] New Question: unable to update MariaDB from 10.0 to 10.1, error indicating galera libboost dependencies issue
by AskMonty KB 15 Feb '16

15 Feb '16

Hello, A new question has been asked in "MariaDB Community" by cyberdome. Please answer it at http://mariadb.com/kb/en/unable-to-update-mariadb-from-100-to-101-error-ind… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello world, I am trying to update my database MariaDB from 10.0 to 10.1 and when I run the yum update command. I am getting this error message below: Any help is appreciated. Resolving Dependencies --> Running transaction check ---> Package galera.x86_64 0:25.3.9-1.rhel7.el7.centos will be updated ---> Package galera.x86_64 0:25.3.12-1.rhel7.el7.centos will be an update --> Processing Dependency: libboost_program_options.so.1.53.0()(64bit) for package: galera-25.3.12-1.rhel7.el7.centos.x86_64 ---> Package google-chrome-stable.x86_64 0:48.0.2564.97-1 will be updated ---> Package google-chrome-stable.x86_64 0:48.0.2564.109-1 will be an update --> Finished Dependency Resolution Error: Package: galera-25.3.12-1.rhel7.el7.centos.x86_64 (mariadb) Requires: libboost_program_options.so.1.53.0()(64bit) You could try using --skip-broken to work around the problem You could try running: rpm -Va --nofiles --nodigest Any suggestions would be helpful. I am stuck at this stage. I have no idea what to do next? Thanks __________________ Linux Newbie - Information is Power! Download Linux @ http://www.fedora.redhat.com/ May the Linux force be with you! Fedora 21 - MariaDB 10.0 -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/unable-to-update-mariadb-from-100-to-101-error-ind…

1 0

[Maria-discuss] New Question: Will Aria 2.0 have an option to stay crash-safe, but not have the performance penalties necessary for true transactionality?
by AskMonty KB 12 Feb '16

12 Feb '16

Hello, A new question has been asked in "Development" by Moscato. Please answer it at http://mariadb.com/kb/en/will-aria-20-have-an-option-to-stay-crash-safe-but… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Will Aria 2.0 have an option to stay crash-safe, but not have the performance penalties necessary for true transactionality? I love the speed and compactness of Aria (InnoDB tables are relatively huge), and I love that its crash-safe. I don't want to ever lose that crash-safe-ness, but I really don't care if my database goes back in time, and I lose data. Will there be a middle ground? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/will-aria-20-have-an-option-to-stay-crash-safe-but…

1 0

[Maria-discuss] New Question: COUNT not working on XAMPP
by AskMonty KB 12 Feb '16

12 Feb '16

Hello, A new question has been asked in "SQL Commands" by styxlawyer. Please answer it at http://mariadb.com/kb/en/count-not-working-on-xampp/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have just installed XAMPP version 7.0.2 which incorporates MariaDB. I have added a table called repairs to the test database and it works fine with various PHP pages I have written. However, when trying to use a simple query like: SELECT COUNT (*) FROM repairs I get the following error message: #1630 - FUNCTION test.COUNT does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual This happens in both phpMyadmin and in PHP pages which are accessing the database. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/count-not-working-on-xampp/

2 1

[Maria-discuss] MariaDB 5.5.48 and Connector/J 1.3.5 now available
by Daniel Bartholomew 11 Feb '16

11 Feb '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.48 and MariaDB Connector/J 1.3.5 These are both Stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.48 - Release Notes: https://mariadb.com/kb/en/mdb-5548-rn/ - Changelog: https://mariadb.com/kb/en/mdb-5548-cl/ - Downloads: https://downloads.mariadb.org/mariadb/5.5.48 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.3.5 - Release Notes: https://mariadb.com/kb/en/mcj-135-rn/ - Changelog: https://mariadb.com/kb/en/mcj-135-cl/ - Downloads: https://downloads.mariadb.org/connector-java/1.3.5/ 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] JSON in MySQL and MariaDB
by Peter Laursen 11 Feb '16

11 Feb '16

I wonder if someone are able to summarize differences (and similarities - if any ;-) ) between MariaDB and MySQL as regards JSON. I a not really able to structure it myself. MySQL has introduced the JSON datatype https://dev.mysql.com/doc/refman/5.7/en/json.html. I don' tbelieve it is availale in MariaDB. The slides here http://www.slideshare.net/blueskarlsson/using-json-with-mariadb-and-mysql tell that dynamic columns should be used with JSON and MariaDB. Also how much do the functions in both servers for manipulating JSON differ? Are they just named diferently in some cases but doing basically the same? What manipultion options does one have that the other has not (and vice versa). Also :does MariaDB have any plans to move closer to MySQL in 10.2 (such as introducing the JSON datatype and related syntax and funtionalities, for instance)? We would like to add JSON handling capabilites in our (SQLyog) GUI client soon. But the 'uneven' implementation in MariaDB and MySQL is indeed a problem. I think the reply to questions above would be approproate for a Blog, BTW. (@Anders - something for you?) -- Peter Laursen -- Webyog

1 0

[Maria-discuss] New Question: my.cnf 128 GB RAM server
by AskMonty KB 11 Feb '16

11 Feb '16

Hello, A new question has been asked in "MariaDB Community" by wgn. Please answer it at http://mariadb.com/kb/en/mycnf-128-gb-ram-server/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- We are using /usr/share/lve/dbgovernor/db-select-mysql --mysql-version=mariadb101 Hello, As I see MySQL-governor and cl-MariaDB packages have already installed in your system. Could you please clarify what exactly doesn't work? Best regards, -- Anton Mashnin | L2 Technical Support Engineer CloudLinux.com | KernelCare.com [Free Trial] | KuberDock.com [Free Trial] It is work but make an issue ... we not know what is the best setting with our server 128GB RAM We use this http://www.gk-root.com/GK-Blog/optimize-mysql-apache-on-cpanelwhm-server/ Best config base on 8 core & 12GB memory (Shared server) MySQL 5.5: [mysqld] local-infile=0 max_connections = 600 max_user_connections=1000 key_buffer_size = 512M myisam_sort_buffer_size = 64M read_buffer_size = 1M table_open_cache = 5000 thread_cache_size = 384 wait_timeout = 20 connect_timeout = 10 tmp_table_size = 256M max_heap_table_size = 128M max_allowed_packet = 64M net_buffer_length = 16384 max_connect_errors = 10 concurrent_insert = 2 read_rnd_buffer_size = 786432 bulk_insert_buffer_size = 8M query_cache_limit = 5M query_cache_size = 128M query_cache_type = 1 query_prealloc_size = 262144 query_alloc_block_size = 65535 transaction_alloc_block_size = 8192 transaction_prealloc_size = 4096 max_write_lock_count = 8 slow_query_log log-error external-locking=FALSE open_files_limit=50000 [mysqld_safe] [mysqldump] quick max_allowed_packet = 16M [isamchk] key_buffer = 384M sort_buffer = 384M read_buffer = 256M write_buffer = 256M [myisamchk] key_buffer = 384M sort_buffer = 384M read_buffer = 256M write_buffer = 256M #### Per connection configuration #### sort_buffer_size = 1M join_buffer_size = 1M thread_stack = 192K -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mycnf-128-gb-ram-server/

1 0

[Maria-discuss] New Question: setNString method not implemented in PreparedStatement class
by AskMonty KB 11 Feb '16

11 Feb '16

Hello, A new question has been asked in "MariaDB Connector/J" by Sebastian_S. Please answer it at http://mariadb.com/kb/en/setnstring-method-not-implemented-in-preparedstate… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, I do not know if it proper place to ask something like that, but did not find better place. Recently I'd like to connect log4j2 to MariaDB database via MariaDB Connector/J (version 1.3.5, but tested each other). I could not do that and I found that reason is in connector - MariaDbServerPreparedStatement class does not implement method setNString and AbstractMariaDbPreparedStatement class throws exception "NStrings not supported". Why it is not supported. MariaDB does not support such type or it is just a bug? When I copied code form setString method to setNString then everything works properly. Regards, Sebastian -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/setnstring-method-not-implemented-in-preparedstate…

1 0

[Maria-discuss] New Question: MySQL connector bug with bulk insert ?
by AskMonty KB 10 Feb '16

10 Feb '16

Hello, A new question has been asked in "MariaDB Connector/J" by doortts. Please answer it at http://mariadb.com/kb/en/mysql-connector-bug-with-bulk-insert/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I'm new to MariaDB and testing with some applications. Yesterday I met a wired bug. When I using bulk insert with MariaDB connector 1.3.4, following errors occur. (Ubuntu 14.4 and MariaDB 10.1.11) When I replace the connector driver with 'MySQL connector', It works fine. The reference Q&A was http://stackoverflow.com/questions/18693800/mariadb-jdbc-connection-fails-d… The reason that I call this bug is wired was, with same mariadb connector I haven't met bug in any other systems, Mac/Centos 6. Even more another ubuntu system MariaDB 10.1.10 with same driver, no error occurs. works fine: Linux ubuntu 3.13.0-34-generic #60-Ubuntu SMP Wed Aug 13 15:45:27 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux Error occurred system: No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 14.04.3 LTS Release: 14.04 Codename: trusty Linux Yukino 3.16.0-57-generic #77~14.04.1-Ubuntu SMP Thu Dec 17 23:20:00 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux java version "1.8.0_66" Java(TM) SE Runtime Environment (build 1.8.0_66-b17) Java HotSpot(TM) 64-Bit Server VM (build 25.66-b17, mixed mode) Error message: ``` java.lang.NullPointerException at java.lang.String.getBytes(String.java:917) at org.mariadb.jdbc.internal.stream.PacketOutputStream.sendStream(PacketOutputStream.java:178) at org.mariadb.jdbc.internal.packet.dao.parameters.ReaderParameter.writeBinary(ReaderParameter.java:134) at org.mariadb.jdbc.internal.packet.send.SendPrepareParameterPacket.send(SendPrepareParameterPacket.java:93) at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executePreparedQuery(AbstractQueryProtocol.java:568) at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeBatch(MariaDbServerPreparedStatement.java:230) at com.jolbox.bonecp.StatementHandle.executeBatch(StatementHandle.java:424) at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:1005) at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:989) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:673) at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:989) at data.DefaultExchanger.batchUpdate(DefaultExchanger.java:319) at data.DefaultExchanger.importDataFromArray(DefaultExchanger.java:307) at data.DefaultExchanger.importData(DefaultExchanger.java:255) at data.DataService.importData(DataService.java:196) at controllers.SiteApp.importData(SiteApp.java:314) at Routes$$anonfun$routes$1$$anonfun$applyOrElse$54$$anonfun$apply$54.apply(routes_routing.scala:2058) at Routes$$anonfun$routes$1$$anonfun$applyOrElse$54$$anonfun$apply$54.apply(routes_routing.scala:2058) at play.core.Router$HandlerInvokerFactory$$anon$4.resultCall(Router.scala:264) at play.core.Router$HandlerInvokerFactory$JavaActionInvokerFactory$$anon$15$$anon$1.invocation(Router.scala:255) at play.core.j.JavaAction$$anon$1.call(JavaAction.scala:55) at Global$1.call(Global.java:190) at actions.AnonymousCheckAction.call(AnonymousCheckAction.java:57) at utils.SiteManagerAuthAction.call(SiteManagerAuthAction.java:39) at play.core.j.JavaAction$$anonfun$11.apply(JavaAction.scala:82) at play.core.j.JavaAction$$anonfun$11.apply(JavaAction.scala:82) at scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24) at scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24) at play.core.j.HttpExecutionContext$$anon$2.run(HttpExecutionContext.scala:40) at play.api.libs.iteratee.Execution$trampoline$.execute(Execution.scala:46) at play.core.j.HttpExecutionContext.execute(HttpExecutionContext.scala:32) at scala.concurrent.impl.Future$.apply(Future.scala:31) at scala.concurrent.Future$.apply(Future.scala:485) at play.core.j.JavaAction$class.apply(JavaAction.scala:82) at play.core.Router$HandlerInvokerFactory$JavaActionInvokerFactory$$anon$15$$anon$1.apply(Router.scala:252) at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4$$anonfun$apply$5.apply(Action.scala:130) at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4$$anonfun$apply$5.apply(Action.scala:130) at play.utils.Threads$.withContextClassLoader(Threads.scala:21) at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4.apply(Action.scala:129) at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4.apply(Action.scala:128) at scala.Option.map(Option.scala:145) at play.api.mvc.Action$$anonfun$apply$1.apply(Action.scala:128) at play.api.mvc.Action$$anonfun$apply$1.apply(Action.scala:121) at play.api.libs.iteratee.Iteratee$$anonfun$mapM$1.apply(Iteratee.scala:483) at play.api.libs.iteratee.Iteratee$$anonfun$mapM$1.apply(Iteratee.scala:483) at play.api.libs.iteratee.Iteratee$$anonfun$flatMapM$1.apply(Iteratee.scala:519) at play.api.libs.iteratee.Iteratee$$anonfun$flatMapM$1.apply(Iteratee.scala:519) at play.api.libs.iteratee.Iteratee$$anonfun$flatMap$1$$anonfun$apply$14.apply(Iteratee.scala:496) at play.api.libs.iteratee.Iteratee$$anonfun$flatMap$1$$anonfun$apply$14.apply(Iteratee.scala:496) at scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24) at scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24) at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:41) at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:393) at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107) org.springframework.transaction.TransactionSystemException: Could not roll back JDBC transaction; nested exception is java.sql.SQLNonTransientConnectionException: Could not send query: Last stream not finished at org.springframework.jdbc.datasource.DataSourceTransactionManager.doRollback(DataSourceTransactionManager.java:290) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:849) at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:826) at data.DefaultExchanger.importData(DefaultExchanger.java:266) at data.DataService.importData(DataService.java:196) at controllers.SiteApp.importData(SiteApp.java:314) at Routes$$anonfun$routes$1$$anonfun$applyOrElse$54$$anonfun$apply$54.apply(routes_routing.scala:2058) at Routes$$anonfun$routes$1$$anonfun$applyOrElse$54$$anonfun$apply$54.apply(routes_routing.scala:2058) at play.core.Router$HandlerInvokerFactory$$anon$4.resultCall(Router.scala:264) at play.core.Router$HandlerInvokerFactory$JavaActionInvokerFactory$$anon$15$$anon$1.invocation(Router.scala:255) at play.core.j.JavaAction$$anon$1.call(JavaAction.scala:55) at Global$1.call(Global.java:190) at actions.AnonymousCheckAction.call(AnonymousCheckAction.java:57) at utils.SiteManagerAuthAction.call(SiteManagerAuthAction.java:39) at play.core.j.JavaAction$$anonfun$11.apply(JavaAction.scala:82) at play.core.j.JavaAction$$anonfun$11.apply(JavaAction.scala:82) at scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24) at scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24) at play.core.j.HttpExecutionContext$$anon$2.run(HttpExecutionContext.scala:40) at play.api.libs.iteratee.Execution$trampoline$.execute(Execution.scala:46) at play.core.j.HttpExecutionContext.execute(HttpExecutionContext.scala:32) at scala.concurrent.impl.Future$.apply(Future.scala:31) at scala.concurrent.Future$.apply(Future.scala:485) at play.core.j.JavaAction$class.apply(JavaAction.scala:82) at play.core.Router$HandlerInvokerFactory$JavaActionInvokerFactory$$anon$15$$anon$1.apply(Router.scala:252) at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4$$anonfun$apply$5.apply(Action.scala:130) at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4$$anonfun$apply$5.apply(Action.scala:130) at play.utils.Threads$.withContextClassLoader(Threads.scala:21) at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4.apply(Action.scala:129) at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4.apply(Action.scala:128) at scala.Option.map(Option.scala:145) at play.api.mvc.Action$$anonfun$apply$1.apply(Action.scala:128) at play.api.mvc.Action$$anonfun$apply$1.apply(Action.scala:121) at play.api.libs.iteratee.Iteratee$$anonfun$mapM$1.apply(Iteratee.scala:483) at play.api.libs.iteratee.Iteratee$$anonfun$mapM$1.apply(Iteratee.scala:483) at play.api.libs.iteratee.Iteratee$$anonfun$flatMapM$1.apply(Iteratee.scala:519) at play.api.libs.iteratee.Iteratee$$anonfun$flatMapM$1.apply(Iteratee.scala:519) at play.api.libs.iteratee.Iteratee$$anonfun$flatMap$1$$anonfun$apply$14.apply(Iteratee.scala:496) at play.api.libs.iteratee.Iteratee$$anonfun$flatMap$1$$anonfun$apply$14.apply(Iteratee.scala:496) at scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24) at scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24) at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:41) at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:393) at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107) Caused by: java.sql.SQLNonTransientConnectionException: Could not send query: Last stream not finished at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:123) at org.mariadb.jdbc.internal.util.ExceptionMapper.throwException(ExceptionMapper.java:69) at org.mariadb.jdbc.MariaDbStatement.executeQueryEpilog(MariaDbStatement.java:261) at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:290) at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:344) at org.mariadb.jdbc.MariaDbConnection.rollback(MariaDbConnection.java:532) at com.jolbox.bonecp.ConnectionHandle.rollback(ConnectionHandle.java:1272) at org.springframework.jdbc.datasource.DataSourceTransactionManager.doRollback(DataSourceTransactionManager.java:287) ... 46 more Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Could not send query: Last stream not finished at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.sendQuery(AbstractQueryProtocol. ``` -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mysql-connector-bug-with-bulk-insert/

1 0

[Maria-discuss] doubt how to create big query
by Roberto Spadim 09 Feb '16

09 Feb '16

hi guys i'm with a problem / possible feature request i have many tables with same structure (same fields) and i need to create a big query with all tables something like: select * from t1 union all select * from t2 union all select * from ..... ... union all select * from t99999 is there anyway to create a big query with some "template c++ like" feature? something like select * from <union all t1, t2, t3, t3, t4....> ? --- Roberto Spadim

2 4

[Maria-discuss] MariaDB/Galera Cluster with 3 nodes - Change ENGINE from MyISAM to InnoDB without crash
by Lukas Lehner 09 Feb '16

09 Feb '16

Hi http://dba.stackexchange.com/questions/128715/mariadb-galera-cluster-with-3… thanks Lukas

2 1

[Maria-discuss] New Question: How to change Innodb fileformat to Barracuda
by AskMonty KB 07 Feb '16

07 Feb '16

Hello, A new question has been asked in "XtraDB and InnoDB" by gijs. Please answer it at http://mariadb.com/kb/en/how-to-change-innodb-fileformat-to-barracuda/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I've attempted to change to the new barracuda file format. I'm using a Galera cluster (MariaDB 10.1.11) and have innodb_file_format=Barracuda set on all my servers, I've rebooted the servers and exported a database with phpmyadmin. After this I deleted the database and recreated it and then imported the previously exported .sql file with phpmyadmin. I checked the file format in INFORMATION_SCHEMA.INNODB_SYS_TABLES and found that it's still set as Antelope. Why is it not set to Barracuda? How can I change it to Barracuda? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-to-change-innodb-fileformat-to-barracuda/

1 0

[Maria-discuss] MariaDB JIRA is moving
by Rasmus Johansson 05 Feb '16

05 Feb '16

The MariaDB JIRA instance that currently is in use for project and issue tracking will change. The current instance is hosted in Atlassian's cloud and it has worked well, but we have hit the maximum user limit of 2000 users. It's fantastic to see how many of you actually report bugs and other issues in the MariaDB project! To hit that limit also means that we have to migrate over to a self-hosted instance of JIRA. Below are important details about that change. When will the switch happen: Sat 27th of Feb What is the impact for me as a user of MariaDB's JIRA: 1. URL change - The current instance is hosted in Atalassian's cloud and has the URL mariadb.atlassian.net. The new one will be found at jira.mariadb.org starting from 28th of Feb. 2. RSS feeds - If you have been using JIRA's RSS feeds, you'll need to set up them again since the URL is changing What will happen to old JIRA: The mariadb.atlassian.net JIRA instance will be put into read-only mode and a banner will be visible on each page telling the URL of the new MariaDB JIRA instance. It will remain this way for some time since it has been referenced quite heavily from other sites. source: https://mariadb.org/mariadb-jira-is-moving/ -- Rasmus Johansson, VP Engineering MariaDB | t: +358 50 499 9589 | Skype: ratzpo

1 0

[Maria-discuss] intentionally corrupting tables
by Federico Razzoli 02 Feb '16

02 Feb '16

Hi all I am looking for a way to intentionally corrupt a table in a "natural" way. Of course I can open a file with Vim and change random characters, but I would probably obtain a kind of corruption that never occurs in the real world. The purpose is testing recovery procedures. Thanks Federico

3 2

[Maria-discuss] Adding timestamp column to a system
by Peter Mclarty 02 Feb '16

02 Feb '16

Hi All Running Mariadb 10.0.16 and need to add a timestamp column to a table with has around 60m rows Testing on lesser hardware instances suggest around 40 minutes to make this change on the production system. To reduce the down time I was planning to alter the slave and role swap the slave to become the master I have added the column to a test slave and notice it alway populates as Unix_epoch 0 ie no current timestamp date | timestamp 2016-01-29 | 0000-00-00 00:00:00 This sounds about right, but to confirm it's not a bug. Other than the timestamp value not being correct up to that time of making any changes, which is acceptable for why it is being added, like the role swap, is there any things to be concerned about if I follow that as an approach? The role swap was needing to be done soon anyway so that in itself isn't a stumpling block I know Percona has their tools that allow online schema changes, I have never used it in anger to achieve this sort of change. Would I be better off using that. Cheers -- *Peter McLarty* * DBA* -- 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.

2 1

[Maria-discuss] New Question: Phenomenon of read-only queries performance
by AskMonty KB 02 Feb '16

02 Feb '16

Hello, A new question has been asked in "MariaDB Community" by knizhnik_g. Please answer it at http://mariadb.com/kb/en/phenomenon-of-read-only-queries-performance/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- We are evaluating Galera cluster with MariaDB and find out interesting phenomenon which we can not explain. We are using standard sysbench compex-OLAP, 10 million records. Performance of read-only queries is about 3k TPS and is quite stable. But then we run for a while read-write version and after it once again read-only version, then in this case performance starts to grow from 4k till 10k TPS. 10K TPS is reached after about 30 seconds of running benchmark and stays at this level. But if we stop benchmark and restart it, then once again speed falls down to 3k TPS. Data is located in temporary file system, so disk is not involved at all. We used recommended configuration settings for MariaDB and Galera. Also the same behavior is observed with standalone mysql without Galera: performance of read-only queries varies from 3k to 6k TPS (but high values are smaller than with Galera, although no load balancing was performed). Is there any explanation of such behavior and where we can look trying to understand the reason? Why performance of standalone mysql can be slower than on Galera cluster? How we can tune it? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/phenomenon-of-read-only-queries-performance/

1 0

[Maria-discuss] Performace issue with insert
by walter harms 01 Feb '16

01 Feb '16

Hello list, i have a strange problem with inserts. The tables is large (time series data) and has a lot of partitions, engine is IMMODB. We have notice that the write performance decreases with time, start of the month good, end of the month bad. The same behavier is the lasted version of mariadb. But when i replace mariadb with mysql the problems vanishes (so its not a hardware issue). I suspect that it is a caching problem but a comparison of the configs did not give a hint. Anyone an idea what may cause the effect ? re, wh

8 16

[Maria-discuss] MariaDB 10.1.11 now available
by Daniel Bartholomew 30 Jan '16

30 Jan '16

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

2 1

[Maria-discuss] New Question: MariaDB Power7 support
by AskMonty KB 29 Jan '16

29 Jan '16

Hello, A new question has been asked in "Getting Started" by dtomko_34748. Please answer it at http://mariadb.com/kb/en/mariadb-power7-support/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello MariaDB, searching through site I didn't find following information: do you support IBM Power 7 systems for MariaDB/MariaDB Enterprise, not just Power8? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-power7-support/

1 0

[Maria-discuss] How to translate between MariaDB 5.5 and 10.X
by Marco Nicosia 28 Jan '16

28 Jan '16

Hi! I noticed that wsrep_load_data_splitting has been introduced as a configuration variable. Cool! I had missed this. I can see that a fix for it was shipped in MariaDB 10.0.23 <https://mariadb.com/kb/en/mariadb/mariadb-galera-cluster-10023-release-note…> but how can I tell when the variable was introduced? When I look at the doc <https://mariadb.com/kb/en/mariadb/galera-cluster-system-variables/#wsrep_lo…>, I only see that it was introduced in MariaDB Galera 5.5.32. Is there a translation table or operation I can perform? -- Marco Nicosia Product Manager Pivotal Software, Inc.

2 1

[Maria-discuss] Fwd: Re: Performace issue with insert
by walter harms 27 Jan '16

27 Jan '16

Am 27.01.2016 11:33, schrieb Peter Laursen: > "We have notice that the write performance decreases with > time, start of the month good, end of the month bad." > > Do you happen to partition BY MONTH? if so it looks like the more the > latest partition grows the slower it becomes.I am no expert in this but I > think you should post the CREATE TABLE for this table. You should also tell > the exact MariaDB and MySQL versions you have tried ("SELECT version();"). yes, sorry the partitons are by month the mariadb version we tried were 5.1.62 and 10.1.10 compared with mysql 5.1.53 I do not think that will be helpful since the table is simple and exactly equal in both cases: 2 primaries + ~30 Entries Partition are created like this: ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci /*!50100 PARTITION BY RANGE (TO_DAYS(time_stamp)) (PARTITION im1_199801 VALUES LESS THAN (729786) ENGINE = MyISAM, PARTITION im1_199802 VALUES LESS THAN (729814) ENGINE = MyISAM, PARTITION im1_199803 VALUES LESS THAN (729845) ENGINE = MyISAM, PARTITION im1_199804 VALUES LESS THAN (729875) ENGINE = MyISAM, PARTITION im1_199805 VALUES LESS THAN (729906) ENGINE = MyISAM, PARTITION im1_199806 VALUES LESS THAN (729936) ENGINE = MyISAM, and many more ... my guess: The difference is considerable. I suspect that mysql does cache a number of inserts while maria is writing every entry, something on that line. re, wh > > -- Peter > -- not a MariaDB person > > On Wed, Jan 27, 2016 at 11:27 AM, walter harms <wharms(a)bfs.de> wrote: > >> Hello list, >> i have a strange problem with inserts. >> The tables is large (time series data) and has a >> lot of partitions, engine is IMMODB. >> We have notice that the write performance decreases with >> time, start of the month good, end of the month bad. >> >> The same behavier is the lasted version of mariadb. >> But when i replace mariadb with mysql the problems vanishes >> (so its not a hardware issue). I suspect that it is a caching >> problem but a comparison of the configs did not give a hint. >> Anyone an idea what may cause the effect ? >> >> >> re, >> wh >> >> _______________________________________________ >> 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] New Question: maxscale fee filter error
by AskMonty KB 26 Jan '16

26 Jan '16

Hello, A new question has been asked in "MaxScale Filters" by 이상봉_g. Please answer it at http://mariadb.com/kb/en/maxscale-fee-filter-error/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I am trying to setup maxscale tee filter in order to duplicate every requests from clients to 2 other mariadb servers. [/etc/maxscale.cnf ] [DataMartFilter] type=filter module=tee match=* service=Data Service [server1] type=server address=192.168.27.137 port=3306 protocol=MySQLBackend [server2] type=server address=192.168.27.142 port=3306 protocol=MySQLBackend [Data Service] type=service router=readwritesplit servers=server1,server2 user=root passwd=pwd filters=DataMartFilter [DataMart Listener] type=listener service=Data Service protocol=MySQLClient port=4012 [error log] MariaDB Corporation MaxScale /var/log/maxscale/error1.log Tue Jan 26 00:50:07 2016 ----------------------------------------------------------------------- --- Logging is enabled. 2016-01-26 00:50:07 Error : Unable to find library for module: readconnrouter. Module dir: /usr/lib64/maxscale 2016-01-26 00:50:07 Error : Unable to load Router module "readconnrouter". Ensure that libreadconnrouter.so exists in one of the following directories : - /usr/lib64/maxscale - :/usr/lib64/maxscale/maxscale 2016-01-26 00:50:07 Error : Reading configuration for router service 'Data Service' failed. Router Data Service is not loaded. 2016-01-26 00:50:07 Error : Failed to start any MaxScale services. Exiting. 2016-01-26 00:50:07 MaxScale is shut down. ----------------------------------------------------------------------- Did I miss something in cnf file? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/maxscale-fee-filter-error/

1 0

[Maria-discuss] More contributors welcome to MariaDB packaging in Debian
by Otto Kekäläinen 24 Jan '16

24 Jan '16

Hello! Do you want to improve MariaDB in Debian? Do you want to contribute to Debian packaging using modern git-buildpackage tools and state of the art QA tools? Do you want to see the result of your work in the hands of numerous of Linux users who run Debian and MariaDB? I am happy to mentor anybody who want's to start contributing to Debian packaging of MariaDB. I have created some items with priority "wishlist" and title prepended with "TODO" visible at https://bugs.debian.org/cgi-bin/pkgreport.cgi?src=mariadb-10.0#_0_6_4 These are all farily easy tasks that anybody interested in contributing could pick up and and start working on. If you want to contribute, please subscribe to the packaging teams list and show your interest there / ask questions to get directions and more help: http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/ I promise to quickly review and respond to questions so that contributors feel welcomed! - Otto

3 4

[Maria-discuss] mariadb on freebsd: spinlocks or mutex?
by Federico Razzoli 24 Jan '16

24 Jan '16

While compiling MariaDB on FreeBSD, I've noted that it can optionally be compiled with spinlocks instead of mutexes. What's the best choice? Any experience? Regards Federico

2 1

[Maria-discuss] New Question: Can't optimize database in cluster?
by AskMonty KB 23 Jan '16

23 Jan '16

Hello, A new question has been asked in "MariaDB Galera Cluster" by gijs. Please answer it at http://mariadb.com/kb/en/cant-optimize-database-in-cluster/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I'm using a cluster of 3 MariaDB 10.1.10 servers on Ubuntu. The servers are located in different datacenters and have a network latency of ~6 ms. Previously I found that I couldn't do a database dump or optimize, because the job would hang and took the cluster down with it. This issue was caused by flow control, it has been fixed by increasing the gcs.fc_limit. I currently have the problem that I can't run a optimize job for databases. For example: mysqlcheck --auto-repair --optimize --databases joomla The optimize job runs fine on the server I execute the job on and finishes in about 10 seconds. Let's call the server that executes this job the "master server". According to syslog the job runs on the other servers as well, I see entries like: Jan 23 16:01:32 Netherlands mysqld[1064]: 2016-01-23 16:01:32 140116180166400 [Note] InnoDB: Online DDL : Start reading clustered index of the table and create temporary files Jan 23 16:01:32 Netherlands mysqld[1064]: 2016-01-23 16:01:32 140116180166400 [Note] InnoDB: Online DDL : End of reading clustered index of the table and create temporary files Jan 23 16:01:32 Netherlands mysqld[1064]: 2016-01-23 16:01:32 140116180166400 [Note] InnoDB: Online DDL : Start merge-sorting index `PRIMARY` (1 / 3), estimated cost : 10.0000 Jan 23 16:01:32 Netherlands mysqld[1064]: 2016-01-23 16:01:32 140116180166400 [Note] InnoDB: Online DDL : End of merge-sorting index `PRIMARY` (1 / 3) Jan 23 16:01:32 Netherlands mysqld[1064]: 2016-01-23 16:01:32 140116180166400 [Note] InnoDB: Online DDL : Start building index `PRIMARY` (1 / 3), estimated cost : 15.0000 Jan 23 16:01:32 Netherlands mysqld[1064]: 2016-01-23 16:01:32 140116180166400 [Note] InnoDB: Online DDL : End of building index `PRIMARY` (1 / 3) Jan 23 16:01:32 Netherlands mysqld[1064]: 2016-01-23 16:01:32 140116180166400 [Note] InnoDB: Online DDL : Completed These other servers go down silently, they stop responding to query's from the users/applications any more but there are no error messages in the syslog. This doesn't happen on the "master" server, which continues to work like nothing happened. I've found that this issue doesn't happen when I run a optimize job for one single table. I believe the issue is that the operation for a entire database is to resource intensive or takes to long to finish. I use the following wsrep_provider_options = gcache.size = 32G;evs.keepalive_period = PT3S;evs.suspect_timeout = PT30S;evs.inactive_timeout = PT1M;evs.install_timeout = PT1M;evs.send_window = 512;evs.user_send_window = 512;gcs.fc_limit=2048 ;gcs.fc_master_slave=YES; gcs.fc_factor=1.0 -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/cant-optimize-database-in-cluster/

1 0

[Maria-discuss] New Question: Use of UPDATE & SELECT operators
by AskMonty KB 22 Jan '16

22 Jan '16

Hello, A new question has been asked in "MariaDB Documentation" by jon_lethbridge_g. Please answer it at http://mariadb.com/kb/en/use-of-update-select-operators/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi - I'm sure this has been asked before but I've tried looking! It's been 20 years since I last used SQL (DB2 and an IBM Mainframe), but all I'm trying to do is change a string of text within a cell. Background - I'm just changing URL address on a wordpress related DB. So in MYSQL it's UPDATE wp_posts SET post_content = replace(post_content, 'http://www.example.com', 'http://localhost/test-site'); Using MariaDB syntax I've tried: UPDATE `wp_posts` SET `post_content`= REPLACE (`post_content`,'http://www.holidaycottagesloirevalley.com','http://localhost/hclv'); and after some reading I've tried REPLACE INTO `wp_posts` VALUE ('http://www.holidaycottagesloirevalley.com','http://localhost/hclv'); No joy and I've run out of ideas (strength!) Can anyone point me in the right direction please? Thanks in advance, Jon. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/use-of-update-select-operators/

1 0

[Maria-discuss] New Question: Request details about MariaDB Cluster behaviour in certain situations
by AskMonty KB 22 Jan '16

22 Jan '16

Hello, A new question has been asked in "MariaDB Community" by noghan_odedra_g. Please answer it at http://mariadb.com/kb/en/request-details-about-mariadb-cluster-behaviour-in… as the person asking the question may not be subscribed to the mailing list. -------------------------------- We are evaluating different database cluster solutions. We would like to get information on some of situations. Assumption: We have 2 sites with cluster each running 3 nodes as master-master. Synchronous replication is configured between clusters. So all the nodes in both clusters remains in sync. There are multiple applications running on both sites and uses their site cluster continuously. Meaning that continuous read/write is perform. 1. When one node reboots in one of the cluster, what would be the order of operations, data sync -> replication or replication -> data sync ? 2. When network connectivity of one of the node of the cluster is lost, when network connectivity is restored, will data sync happen correctly ? 3. As replication is configured in both clusters and they replicate to each other, is there any chance of getting stuck in indefinite replication ? I mean cluster1 replicates to cluster2 and cluster2 replicates to cluster1. 4. In case link between cluster goes down for days, when link is restored, will the data sync happened correctly ? 5. In case one of the node goes into split-brain, will it be recovered correctly ? -noghan -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/request-details-about-mariadb-cluster-behaviour-in…

1 0

[Maria-discuss] C header files in binary distribution on Windows
by Peter Laursen 21 Jan '16

21 Jan '16

I have an almost fresh Win10 installation with MariaDB 10.1.9 installed with .msi installer from this link (I believe) https://downloads.mariadb.org/interstitial/mariadb-10.0.21/win32-packages/m…. No older version has been installed on this system ever. The folder C:\Program Files\MariaDB 10.1\include\mysql and its subfolders have a large number of ".h" files. Isn't this a build script bug? -- Peter -- Webyog

2 3

[Maria-discuss] Fromdual training review
by Lukas Lehner 21 Jan '16

21 Jan '16

Hi I am searching class room training (Galera, Advanced DBA topics) in Europe and found: http://www.fromdual.com/mysql-mariadb-training-modules Anyone can give a short review of their training offering? Feedback? Is Fromdual trust worthy? Lukas

2 1

[Maria-discuss] Select optimizations
by Roberto Spadim 20 Jan '16

20 Jan '16

Hi guys! There's a "easy/fast" way to rewrite a query from this: Select datetime,key,value from table where ... To this: Select datetime, value1 as key1, value2 as key2, .... From table where ... I don't remember the right name in R/python (pandas) language but it's something like vector/matrix merge The ideia is, instead of one line of date key vale, use a single date, and "put" values as columns, and the columns name is the key name The table structure is something like: Create table ( Datetime datetime not null, Key varchar(255) not null, Value double not null, Primary key(datetime,key) ) Any idea is wellcome I know there's many solutions, if i have >100 columns, if datetime is sparse (only one key have values per datetime value), etc etc -- Roberto Spadim SPAEmpresarial - Software ERP Eng. Automação e Controle

2 3

[Maria-discuss] New Question: Using BitNami WordPress with Amazon RDS MariaDB
by AskMonty KB 19 Jan '16

19 Jan '16

Hello, A new question has been asked in "MariaDB Community" by brasilmorar. Please answer it at http://mariadb.com/kb/en/using-bitnami-wordpress-with-amazon-rds-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Installed BitNami WordPress which is already configured and updated in an instance EC2 Amazon. Launched a database RDS MariaDB, efetuei up the MySQL database that is already inserted in BitNami stack and then sent the backup.sql for instance RDS MaridaDB. I changed the database access settings in wp-config.php file by inserting the data from the database RDS MariaDB created. Everything is working fine, but I have a doubt about the performance of the bank I have not deleted the Mysql the BitNami stack. If I'm using InnoDB tables and not the standard MariaDB tables. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/using-bitnami-wordpress-with-amazon-rds-mariadb/

1 0

[Maria-discuss] New Question: mysql_install_db
by AskMonty KB 14 Jan '16

14 Jan '16

Hello, A new question has been asked in "MariaDB Community" by skuns_35717. Please answer it at http://mariadb.com/kb/en/mariadb-community-mysql_install_db/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I'm new to maria, coming from mysql, and I'm trying to run the mysql_install_db program to create the new databases. This is what i'm executing as root: /usr/bin/mysql_install_db --user=mysql --datadir=/var/lib/mysql --basedir=/usr --force I've tried it with and without the force option. I always get the same error: ERROR: 1005 Can't create table `mysql`.`innodb_table_stats` (errno: 165 "Table is read only") 160114 11:35:10 [ERROR] Aborting Any help will be greatly appreciated. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-community-mysql_install_db/

1 0

[Maria-discuss] Are lock/unlock tables replicated in ROW / STATEMENT / MIXED r. mode
by pslawek83 13 Jan '16

13 Jan '16

Hi Guys, quick question about lock tables with replication... I basically use it to achieve atomicity of some database writes, but it seems that queries like LOCK TABLES ___tsc WRITE UNLOCK TABLES are not replicated to slave. Eg. i can lock table on master, for write, but still read from it on the slave, which could lead to issues... We're reading some data from slaves, and writing data to it atomically using LOCK TABLES, it seems that this way will lead to race conditions and inconsistent reads from the slave. Any way of having aria/myisam writes to be atomic on the slaves too? I thought to copy the table to random temporary name, do the changes and then rename... but it seems like not very optimal. Thanks.

3 2

[Maria-discuss] New Question: SQL Server replication to Maria DB
by AskMonty KB 13 Jan '16

13 Jan '16

Hello, A new question has been asked in "MariaDB Community" by zeeshan_amin. Please answer it at http://mariadb.com/kb/en/sql-server-replication-to-maria-db/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, I am new to Maria DB and have no past experience with MySQL. I am trying to create replication between SQL Server 2005 and Maria DB 10.0.14 Publication has 2 tables with close to 24 million rows, and taking a long time to load data into Maria DB. There is no other user connected to MariaDB, Looking at the workbench, i see InnoDB Buffer usage close to 87%, key Efficiency 100%, and Traffic 35KB/sec. as per current speed 2million rows an hour, its going to take 12 hours to load 24 million rows. Any help in making this load faster? Regards Zee -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/sql-server-replication-to-maria-db/

2 1

[Maria-discuss] New Question: PDF documentation going to be available anytime soon?
by AskMonty KB 12 Jan '16

12 Jan '16

Hello, A new question has been asked in "MariaDB Documentation" by dominic_baines. Please answer it at http://mariadb.com/kb/en/pdf-documentation-going-to-be-available-anytime-so… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Any update on the answer from a year ago ? Looking for mariadb documentation for offline use. The KB/documentation great IF you have internet access. Dom -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/pdf-documentation-going-to-be-available-anytime-so…

1 0

[Maria-discuss] New Question: Galera cluster fail during dump or optimize
by AskMonty KB 11 Jan '16

11 Jan '16

Hello, A new question has been asked in "MariaDB Galera Cluster" by gijs. Please answer it at http://mariadb.com/kb/en/galera-cluster-fail-during-dump-or-optimize/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I'm experiencing an issue with a MariaDB cluster when dumping or optimizing databases. When I run a a "mysqlcheck" or a "mysqldump" on my Mariadb 10.1.10 database server (which runs in a Galera cluster with two other servers) then the tasks stop after a short time and don't show any progress. The entire cluster seems to stall. For example the mysqldump stops after creating an 14,0 MB (14.760.912 bytes) dump file and doesn't proceed, even after several minutes nothing happens. The mysqlcheck to repair and optimize tables also hangs after checking a few tables. In both situations the cluster starts to have issues and the only way to get it to work normally again is by taking the server that executed the job offline and also taking another server offline. I then take them back online on by one and the cluster works normally again. I'm not sure what is causing these problems. I haven't found any errors in the syslog, although during the shutdown of the servers I noticed the following: Jan 10 20:43:46 france mysqld[1015]: 2016-01-10 20:43:46 140096330258176 [Warning] WSREP: TO isolation failed for: 3, schema: mysql, sql: OPTIMIZE TABLE proc. Check wsrep connection state and retry the query. Jan 10 21:58:47 france mysqld[1034]: 2016-01-10 21:58:47 139691511322368 [Warning] WSREP: TO isolation failed for: 3, schema: smf, sql: OPTIMIZE TABLE smf_categories. Check wsrep connection state and retry the query. Jan 10 21:58:47 france mysqld[1034]: 2016-01-10 21:58:47 139691511322368 [Warning] Aborted connection 24 to db: 'smf' user: 'maintenance' host: 'localhost' (Unknown error) Jan 10 21:58:47 france mysqld[1034]: 2016-01-10 21:58:47 139691509827328 [Warning] WSREP: TO isolation failed for: 3, schema: (null), sql: SELECT 1 FROM mysql.user LIMIT 1. Check wsrep connection state and retry the query. Any idea what could be the cause of this? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/galera-cluster-fail-during-dump-or-optimize/

1 0

[Maria-discuss] mariadb still uses indexes with high average value group size.
by dE 09 Jan '16

09 Jan '16

Hi! I was playing around with indexes after we faced problems with mariadb choosing the wrong index because of high average value group size. So I created a table with 4 text columns and indexed the 4th column with a prefix length of 1. Following are the stats in brief -- The index has 35 unique values There are around 1040000 rows in total. this will give an average value group size of 29714 Cardinality is calculated as <no. of records in the index>/<average size of value groups>, thus it's value must be 35 BUT from show indexes, it's value is shown as 72 (innodb_stats_persistent_sample_pages = 9999999).

3 4

[Maria-discuss] New Question: Connect DB2 table via ODBC with CLOB or Text datatype.
by AskMonty KB 08 Jan '16

08 Jan '16

Hello, A new question has been asked in "CONNECT" by mldudding. Please answer it at http://mariadb.com/kb/en/connect-db2-table-via-odbc-with-clob-or-text-datat… as the person asking the question may not be subscribed to the mailing list. -------------------------------- I am attempting to connect a DB2 table using the following command line: create table TASKS engine=connect table_type=ODBC block_size=1000 tabname='ISW.TASKS' connection='DSN=DB2_ODBC;UID=user;PWD=password;MODE=SHARE;DBALIAS=SCODS;'; and I receive the following error: ERROR 1105 (HY000): Unsupported SQL type -99 My belief is that because CONNECT is retrieving the table description using ODBC catalog functions and since the DB2 table contains a column that has a datatype of CLOB that Mariadb is throwing the above error. When I attempt to specify the column definitions for the DB2 table, and define the column as TEXT or BLOB, I receive the following error: SQL Error (1163): Storage engine CONNECT doesn't support BLOB/TEXT columns. Is there a way to CONNECT a DB2 table via ODBC or Direct Connection to a table that contains CLOB or Text defined columns? I do not have any issue connecting other tables from the DB2 database that do not contain CLOB datatypes. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/connect-db2-table-via-odbc-with-clob-or-text-datat…

1 0

[Maria-discuss] New Question: MariaDb vs Oracle
by AskMonty KB 06 Jan '16

06 Jan '16

Hello, A new question has been asked in "MariaDB Community" by dbamaria. Please answer it at http://mariadb.com/kb/en/mariadb-vs-oracle/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, I have to find out in MariaDb how to implement some features used in Oracle . I have : - Load a file: in Oracle I use the external table. Is there a way (fast and efficient one ) to load a file into a table . Has MariaDb a plugin which allows to load well a specific format of files? - In my existing Oracle code I used to developp a java wrap functions which allow those feature (is there a way in MariaDb to do this?), specifically : 1- Searching a files in an OS directory and insert them in a table, 2- send an SNMP trap 3- Send a mail via SMTP - Is there an equivalent to an Oracle job in Mariadb? - Is there an equivalent to Oracle TDE (Transparent data encryption) ? -Is there an equivalent to the VPD (virtual private policy)? Many Thanks and Best Regards -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-vs-oracle/

1 0

[Maria-discuss] Transportable (portable) tablespaces
by Colin Charles 05 Jan '16

05 Jan '16

Hi, I haven’t tested this yet (the joys of vacation that still keeps you coming back to the lists), but thought I’d approach this as a user searching the Knowledgebase :-) This is a feature from 5.6, and it has improved in 5.7. I saw https://mariadb.atlassian.net/browse/MDEV-4299 saying that it works (looks like Serg did the merge — http://bazaar.launchpad.net/~maria-captains/maria/10.0/revision/3965.1.18 for 10.0.8), but I couldn’t find any documentation suggesting that such a feature exists, eg. https://dev.mysql.com/doc/refman/5.7/en/innodb-transportable-tablespace-exa… One of the “improvements” that I guess we’ll be getting is, the ability to use the CREATE TABLESPACE command — https://dev.mysql.com/doc/refman/5.7/en/create-tablespace.html (vs. https://mariadb.com/kb/en/mariadb/create-tablespace/) Looking forward to more information/discussion, and also if this is a docs bug, I guess I CC’ed Ian 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: start the first cluster node failed with libssl.so.6 problem
by AskMonty KB 04 Jan '16

04 Jan '16

Hello, A new question has been asked in "MariaDB Galera Cluster" by yu.d.sun_32615. Please answer it at http://mariadb.com/kb/en/start-the-first-cluster-node-failed-with-libsslso6… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, All Mariadb galera Version: 10.0.21 OS: Redhat 6 : 2.6.32-504.23.4.el6.x86_64 I installed the software from tarball. When i tried to start the first node with: ./bin/mysqld_safe --defaults-file=$MYSQL_HOME/my.cnf --wsrep-new-cluster & in error log: 160104 11:23:01 [Note] WSREP: wsrep_load(): loading provider library '/apps/opt/mysql/galera-10.0.21/lib/libgalera_smm.so' 160104 11:23:01 [ERROR] WSREP: wsrep_load(): dlopen(): libssl.so.6: cannot open shared object file: No such file or directory 160104 11:23:01 [ERROR] WSREP: wsrep_load(/apps/opt/mysql/galera-10.0.21/lib/libgalera_smm.so) failed: Invalid argument (22). Reverting to no provider. 160104 11:23:01 [Note] WSREP: Read nil XID from storage engines, skipping position init 160104 11:23:01 [Note] WSREP: wsrep_load(): loading provider library 'none' 160104 11:23:01 [ERROR] Aborting I guess this is sth related to openssl version: openssl-1.0.1e-30.el6_6.11.x86_64 I can install and configure 10.0.21 cluster without any problem in CentOS 5.5 Any suggestions on how to work around openssl problem? Downgrade openssl ? or If i compile the source in redhat OS 6,will that help? Anyone has installed any version of Mariadb Galera cluster in any version of Redhat/CentOS linux above 5? Denis -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/start-the-first-cluster-node-failed-with-libsslso6…

1 0

[Maria-discuss] mariadb prefers using indexes despite low cardinality
by dE 02 Jan '16

02 Jan '16

Hi! Taking the example as provided in my last mail: I created a table with 4 text columns and indexed the 4th column with a prefix length of 1. To trigger high no. of index scans I used the following where clause -- f4 like 'klas9dufa9us09df8a8%' Explain shows mariadb still chooses to use the index despite high no. of scans required.

1 0

[Maria-discuss] Syslog facility & IST receive address
by Bertrand Caplet 01 Jan '16

01 Jan '16

Hi all, I was wondering how can I change both change Mariadb and Galera (wsrep) syslog facility then make syslog logging in a separate logfile ? I've got another question, I have 3 galera nodes and one has local ip so it use NAT for communicating with other nodes. SST is alright because I set "wsrep_sst_receive_address" to public IP. But for IST it seems there is no parameters for that and I have some issues when nodes are transfering incremental snapshots in one way. How could I manage to do it ? Thanks in advance, Regards, -- CHUNKZ.NET - script kiddie and computer technician Bertrand Caplet, Flers (FR) Feel free to send encrypted/signed messages Key ID: 37F70C30 GPG FP: 134A 4027 518B 5F4D D409 558D BA9B 7BF0 37F7 0C30

1 0

[Maria-discuss] New Question: Why two versions (10.0 and 10.1)?
by AskMonty KB 01 Jan '16

01 Jan '16

Hello, A new question has been asked in "MariaDB Community" by HGP-IT. Please answer it at http://mariadb.com/kb/en/why-two-versions-100-and-101/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello, We run a number of MariaDB v10.0.x installations for in-house projects, and I have only just realized that there's a v10.1.x version. I have begun reading about the differences, and that there's an upgrade procedure. Forgive the (likely) newb question, but was it totally necessary to create a new version of MariaDB for these changes? I mean, when 10.2 is released (and 10.3, 10.4 etc), is it going to be another whole new release with separate upgrade/versioning paths? Surely from a development management perspective this creates resource overheads for you? Will v10.0 cease development in the near future, to be replaced by v10.1? I am trying to decide whether I just should upgrade our systems to v10.1. Just wondering :) Thank you! Elliot -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/why-two-versions-100-and-101/

1 0

[Maria-discuss] New Question: Upgrading from MariaDB 10.0 to 10.1 under Windows
by AskMonty KB 28 Dec '15

28 Dec '15

Hello, A new question has been asked in "Upgrading MariaDB" by wschwarz. Please answer it at http://mariadb.com/kb/en/upgrading-from-mariadb-100-to-101-under-windows/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Upgrading from MariaDB 10.0 to 10.1 on a Windows System. Must i do some especial thing with a master slave replication system? Which one must I update first master or slave? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/upgrading-from-mariadb-100-to-101-under-windows/

1 0

[Maria-discuss] MariaDB init.d Script Probable Bug in wait_for_ready()
by Joy Bhattacherjee 27 Dec '15

27 Dec '15

Hi, Context: ----------- Version: MariaDB 10.0 Repo: http://yum.mariadb.org/10.0/centos7-amd64 OS: CentOS Linux release 7.2.1511 Kernel: 3.10.0-229.7.2.el7.x86_64 Cloud Provider: Windows Azure I run a three-node MariaDB-Galera cluster on production for my company. With the custom config file at: */etc/my.cnf.d/server.cnf* My datadisk is mounted over a lvm2 partition over two physical volumes, mounted on the path. */datadrive/galera/mysql* The logical volume only takes up 50% of the volume group as I leave the empty space for snapshot operations. This is reflected in my configuration as: *[mysqld]* *datadir = /datadrive/galera/mysql * *socket = /datadrive/galera/mysql/mysql.sock * Issue: -------- Coming to the issue at hand; When starting the primary component through: *$ sudo service mysql bootstrap* or, *$ sudo service mysqld start --wsrep-new-cluster* ( Essentially same, as bootstrap differs to *start --wsrep_new_cluster *) The bootstrap sequence correctly calls mysqldsafe, as below */usr/bin/mysqld_safe --datadir=/datadrive/galera/mysql --pid-file=/datadrive/galera/mysql/ciq-test-db01.pid --wsrep-new-cluster* However, it then gets stuck in the *wait_for_ready() function of /etc/init.d/mysql* The sequence tries to ping mysqladmin through: * if $bindir/mysqladmin ping >/dev/null 2>&1; then* *log_success_msg* * return 0* *elif kill -0 $! 2>/dev/null ; then* * : # mysqld_safe is still running* *else* * # mysqld_safe is no longer running, abort the wait loop* * break* It gets stuck here as the test: * if $bindir/mysqladmin ping >/dev/null 2>&1; then* Always fails and the counter keeps increasing till 900 and Error's out with the *log_failure_msg* *return 1* Test: I tested that line from the console as: *$mysqladmin ping >dev/null 2>&1* and, was thrown the following error: *mysqladmin: connect to server at 'localhost' failed* *error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "**No such file or directory")'* *Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!* Obviously, '*/var/lib/mysql' *does not exist in my setup, and the socket file was at *'/datadrive/galera/mysql/mysql.sock'* But, my socket can be passed explicitly to *mysqladmin *by doing, *$mysqladmin --socket=**/datadrive/galera/mysql/mysql.sock ping* This actually worked as expected and I got the desired output, *mysqld is alive* Solution: ----------- What I surmised through my novice abilities was that the init script was not passing the variables it read from */etc/my.cnf.d/server.cnf to mysqladmin* So, for now I have done a hackjob by altering the init script function wait_for_ready() with the test: *if $bindir/mysqladmin --socket=/datadrive/galera/mysql/mysql.sock ping >/dev/null 2>&1; then* * log_success_msg* * return 0* And voila, *$ sudo service mysql start* *$ sudo service mysql start --wsrep-new-cluster* *$ sudo service mysql bootstrap* All above works. It is evident that I should be passing all the variables from */etc/my.cnf.d/server.cnf *that *mysqladmin *needs to set it's environement correctly. However I think that this could be / should be done on the pre-distributed init script itself rather than a user-side hack. While I have tried to be thorough in my inspection of the issue, I may have missed either something very basic or inherently complex that's currently is inherent to the process of initializing the mysql service. Please redirect me to a corrected course if that is the case. P.S. First time post in the list, I may have stated things unacceptably P.P.S. Merry Christmas to you all. Thanks and regards, Joy Bhattacherjee Mob: +91-9011235028

3 3

[Maria-discuss] Weighted Quorum for Three Nodes
by Tom Worster 27 Dec '15

27 Dec '15

In the Galera docs <http://galeracluster.com/documentation-webpages/weightedquorum.html#weighte d-quorum-for-three-nodes> I read > When configuring quorum weights for three nodes, use the following pattern: > node1: pc.weight = 2 > node2: pc.weight = 1 > node3: pc.weight = 0 > Under this pattern, killing node2 and node3 simultaneously preserves the > Primary Component > <http://galeracluster.com/documentation-webpages/glossary.html#term-primary-… > mponent> on node1. Killing node1 causes node2 and node3 to become > non-primary components. The wording makes it sound as though this is a general recommendation. But, iiuc, this cluster of 3 nodes has a single point of failure: node1. How is this desirable? Tom

2 1

[Maria-discuss] R: CONNECT storage engine
by Federico Razzoli 24 Dec '15

24 Dec '15

A new version of CONNECT package was released, but you have still 10.1.9. The packages don't conflict, but versions are incompatible. Just run apt-get upgrade and CONNECT will work. Regards Federico -------------------------------------------- Gio 24/12/15, Karol Krasňan <karol(a)krasnan.eu> ha scritto: Oggetto: [Maria-discuss] CONNECT storage engine A: maria-discuss(a)lists.launchpad.net Data: Giovedì 24 dicembre 2015, 14:44 #yiv1836587082 blockquote.yiv1836587082cite {margin-left:5px;margin-right:0px;padding-left:10px;padding-right:0px;border-left:1px solid #cccccc;} #yiv1836587082 blockquote.yiv1836587082cite2 {margin-left:5px;margin-right:0px;padding-left:10px;padding-right:0px;border-left:1px solid #cccccc;margin-top:3px;padding-top:0px;} #yiv1836587082 .yiv1836587082plain pre, #yiv1836587082 .yiv1836587082plain tt {font-family:monospace;font-size:100%;font-weight:normal;font-style:normal;white-space:pre-wrap;} #yiv1836587082 a img {border:0px;}#yiv1836587082 body {font-family:Tahoma;font-size:12pt;} #yiv1836587082 .yiv1836587082plain pre, #yiv1836587082 .yiv1836587082plain tt {font-family:Tahoma;font-size:12pt;} Hello all, I have problem with CONNECT storage engine. I am using MariaDB 10.1.9 on Debian Jessie, with actual version mariadb-connect-engine. But when ha_connect.so plugin is loaded, server show error and dont load engine. "Can't open shared library 'ha_connect.so' (errno: 8, API version for STORAGE ENGINE plugin CONNECT not supported by this version of the server)" I am not able find any solution of this problem. Thanks for help and Merry Christmas :) Karol -----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] CONNECT storage engine
by Karol Krasňan 24 Dec '15

24 Dec '15

Hello all, I have problem with CONNECT storage engine. I am using MariaDB 10.1.9 on Debian Jessie, with actual version mariadb-connect-engine. But when ha_connect.so plugin is loaded, server show error and dont load engine. "Can't open shared library 'ha_connect.so' (errno: 8, API version for STORAGE ENGINE plugin CONNECT not supported by this version of the server)" I am not able find any solution of this problem. Thanks for help and Merry Christmas :) Karol

1 0

[Maria-discuss] MariaDB 10.1.10 and MariaDB Galera Cluster 10.0.23 & 5.5.47 now available
by Daniel Bartholomew 24 Dec '15

24 Dec '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.10, MariaDB Galera Cluster 5.5.47, and MariaDB Galera Cluster 10.0.23. These are all Stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.10 - https://mariadb.com/kb/en/mdb-10110-rn/ - https://mariadb.com/kb/en/mdb-10110-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.1.10 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 5.5.47 - https://mariadb.com/kb/en/mgc-5547-rn/ - https://mariadb.com/kb/en/mgc-5547-cl/ - Downloads: https://downloads.mariadb.org/mariadb-galera/5.5.47 MariaDB Galera Cluster 10.0.23 - https://mariadb.com/kb/en/mgc-10023-rn/ - https://mariadb.com/kb/en/mgc-10023-cl/ - Downloads: https://downloads.mariadb.org/mariadb-galera/10.0.23 About MariaDB Galera Cluster: https://mariadb.com/kb/en/what-is-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/en/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: Maria db with ssrs reports using Microsoft Report Builder
by AskMonty KB 23 Dec '15

23 Dec '15

Hello, A new question has been asked in "MariaDB FAQ" by abin. Please answer it at http://mariadb.com/kb/en/maria-db-with-ssrs-reports-using-microsoft-report-… as the person asking the question may not be subscribed to the mailing list. -------------------------------- I tried to use maria db with ssrs reports using ODBC in Microsoft sql report builder.I installed Mysql ODBC connector in my machine and was successful in connecting with maria db.But after saving the report and reopening the report in report builder ,its asking user login name and password. How can I remove the credentials, which is asked repeatedly while reopening the report? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/maria-db-with-ssrs-reports-using-microsoft-report-…

1 0

Re: [Maria-discuss] enforce_storage_engine galera cluster
by Federico Razzoli 22 Dec '15

22 Dec '15

I didn't suggest to use MyISAM :) Now I understand your purpose. If you use MaxScale, you can use a filter and replace MyISAM with InnoDB. Something like: /engine( )*=( *)myisam/i And you can use similar regexps for each storage engine. The filter that you need is this one: https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/F… Hope that this helps. Federico -------------------------------------------- Mar 22/12/15, Michele Tota <michele.tota(a)lnf.infn.it> ha scritto: Oggetto: Re: [Maria-discuss] enforce_storage_engine galera cluster A: maria-discuss(a)lists.launchpad.net Data: Martedì 22 dicembre 2015, 14:29 Thank you all, we're going to open a bug as soon as possible; @Federico: Thanks for the suggestion, but we are interested in forcing engine substitution, because this way a table creation made by a generic user can be issued using both InnoDB and MyISAM (users can't be always aware of which engine is actually reported in a scripted creation) can produce only InnoDB tables that can be actually replicated on other nodes (as you stated previously). Anyway, this bug seems to break our plans, so we should report the bug and find another way in the meanwhile....in addition, MyISAM replication is described as experimental and we don't want to use it in such early development phase. Thank you very much again for the support. On 22/12/2015 13:03, Roberto Spadim wrote: in my opnion, itś a bug, report to jira issue tracker 2015-12-22 10:00 GMT-02:00 Federico Razzoli <federico_raz(a)yahoo.it>: Sounds like a bug. But, bug or not bug, I suggest you set sql_mode = 'NO_ENGINE_SUBSTITUTION'. Changes to non-InnoDB tables are NOT replicated. (There seems to be a sort of support for MyISAM, but it's unreliable and needs to be manually enabled on all nodes) Federico -------------------------------------------- Mar 22/12/15, Michele Tota <michele.tota(a)lnf.infn.it> ha scritto: Oggetto: Re: [Maria-discuss] enforce_storage_engine galera cluster A: maria-discuss(a)lists.launchpad.net Data: Martedì 22 dicembre 2015, 12:22 Thanks guys, as Ian has pointed out, in recent releases sql_mode contains by default NO_ENGINE_SUBSTITUTION so in our deployment we set sql_mode to blank to gracefully use InnoDB when MyISAM table creation is issued. To be clearer on the problem we're experiencing, I'll paste some console output. On the first node we have: MariaDB [galera_test]> SHOW VARIABLES WHERE Variable_name='enforce_storage_engine' OR Variable_name='sql_mode'; +------------------------+--------+ | Variable_name | Value | +------------------------+--------+ | enforce_storage_engine | InnoDB | | sql_mode | | +------------------------+--------+ 2 rows in set (0.00 sec) MariaDB [galera_test]> CREATE TABLE table_1(id INTEGER) ENGINE=InnoDB; Query OK, 0 rows affected (0.01 sec) MariaDB [galera_test]> CREATE TABLE table_2(id INTEGER) ENGINE=MyISAM; Query OK, 0 rows affected, 1 warning (0.00 sec) MariaDB [galera_test]> SHOW WARNINGS; +-------+------+-------------------------------------------------+ | Level | Code | Message | +-------+------+-------------------------------------------------+ | Note | 1266 | Using storage engine InnoDB for table 'table_2' | +-------+------+-------------------------------------------------+ 1 row in set (0.00 sec) MariaDB [galera_test]> SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES where TABLE_SCHEMA = 'galera_test'; +------------+--------+ | TABLE_NAME | ENGINE | +------------+--------+ | table_1 | InnoDB | | table_2 | InnoDB | +------------+--------+ 2 rows in set (0.00 sec) Please note that in table_2 creation we obtain a warning (not an error), and table_2 is correctly created using InnoDB, and until this point, everything is working great. When we check the same table on another cluster node, we have: MariaDB [galera_test]> SHOW VARIABLES WHERE Variable_name='enforce_storage_engine' OR Variable_name='sql_mode'; +------------------------+--------+ | Variable_name | Value | +------------------------+--------+ | enforce_storage_engine | InnoDB | | sql_mode | | +------------------------+--------+ 2 rows in set (0.00 sec) MariaDB [galera_test]> SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES where TABLE_SCHEMA = 'galera_test'; +------------+--------+ | TABLE_NAME | ENGINE | +------------+--------+ | table_1 | InnoDB | | table_2 | MyISAM | +------------+--------+ 2 rows in set (0.00 sec) MariaDB [galera_test]> SHOW TABLE STATUS WHERE Name = 'table_2'; +---------+--------+---------+------------+------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +---------+--------+---------+------------+------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+ | table_2 | MyISAM | 10 | Fixed | 0 | 0 | 0 | 1970324836974591 | 1024 | 0 | NULL | 2015-12-22 11:08:34 | 2015-12-22 11:08:34 | NULL | latin1_swedish_ci | NULL | | | +---------+--------+---------+------------+------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+ 1 row in set (0.00 sec) As you can note, creating a MyISAM table (table_2) on the first node produces a correct InnoDB table, but replication of the same table on the other cluster nodes happens using MyISAM engine. It seems like engine enforcing is used during creation but not during replication.... On 21/12/2015 20:34, Ian Gilfillan wrote: On 21/12/2015 20:10, Nirbhay Choubey wrote: On Mon, Dec 21, 2015 at 12:47 PM, Michele Tota <michele.tota(a)lnf.infn.it> wrote: Hello Nirbhay, thanks for your reply. We have the 10.1.9 mariadb version; the bug that your refers is similar but in our case the enforcing works properly on the node used for the initial write, while replicated writes on other nodes generate tables using another engine. I tried the following on 10.1.9 : Version: Server version: 10.1.9-MariaDB-debug-log Source distribution Node 1: MariaDB [test]> SET @@enforce_storage_engine=INNODB; Query OK, 0 rows affected (0.01 sec) MariaDB [test]> CREATE TABLE t1(i INT) ENGINE=INNODB; Query OK, 0 rows affected (0.07 sec) MariaDB [test]> CREATE TABLE t2(i INT) ENGINE=MYISAM; ERROR 1286 (42000): Unknown storage engine 'MyISAM' Node 2: MariaDB [test]> SHOW TABLES; +----------------+ | Tables_in_test | +----------------+ | t1 | +----------------+ 1 row in set (0.00 sec) Do you get different results? Or your's is a different scenario altogether? Best, Nirbhay From the sounds of it, the sql_mode option NO_ENGINE_SUBSTITUTION is set differently in Nirbhay and Michele's scenarios, so the MyISAM table is converted to InnoDB with a warning in one, and fails in the other. _______________________________________________ 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 _______________________________________________ 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 -- Roberto Spadim SPAEmpresarial - Software ERP Eng. Automação e Controle _______________________________________________ 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 1

Re: [Maria-discuss] enforce_storage_engine galera cluster
by Federico Razzoli 22 Dec '15

22 Dec '15

Sounds like a bug. But, bug or not bug, I suggest you set sql_mode = 'NO_ENGINE_SUBSTITUTION'. Changes to non-InnoDB tables are NOT replicated. (There seems to be a sort of support for MyISAM, but it's unreliable and needs to be manually enabled on all nodes) Federico -------------------------------------------- Mar 22/12/15, Michele Tota <michele.tota(a)lnf.infn.it> ha scritto: Oggetto: Re: [Maria-discuss] enforce_storage_engine galera cluster A: maria-discuss(a)lists.launchpad.net Data: Martedì 22 dicembre 2015, 12:22 Thanks guys, as Ian has pointed out, in recent releases sql_mode contains by default NO_ENGINE_SUBSTITUTION so in our deployment we set sql_mode to blank to gracefully use InnoDB when MyISAM table creation is issued. To be clearer on the problem we're experiencing, I'll paste some console output. On the first node we have: MariaDB [galera_test]> SHOW VARIABLES WHERE Variable_name='enforce_storage_engine' OR Variable_name='sql_mode'; +------------------------+--------+ | Variable_name | Value | +------------------------+--------+ | enforce_storage_engine | InnoDB | | sql_mode | | +------------------------+--------+ 2 rows in set (0.00 sec) MariaDB [galera_test]> CREATE TABLE table_1(id INTEGER) ENGINE=InnoDB; Query OK, 0 rows affected (0.01 sec) MariaDB [galera_test]> CREATE TABLE table_2(id INTEGER) ENGINE=MyISAM; Query OK, 0 rows affected, 1 warning (0.00 sec) MariaDB [galera_test]> SHOW WARNINGS; +-------+------+-------------------------------------------------+ | Level | Code | Message | +-------+------+-------------------------------------------------+ | Note | 1266 | Using storage engine InnoDB for table 'table_2' | +-------+------+-------------------------------------------------+ 1 row in set (0.00 sec) MariaDB [galera_test]> SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES where TABLE_SCHEMA = 'galera_test'; +------------+--------+ | TABLE_NAME | ENGINE | +------------+--------+ | table_1 | InnoDB | | table_2 | InnoDB | +------------+--------+ 2 rows in set (0.00 sec) Please note that in table_2 creation we obtain a warning (not an error), and table_2 is correctly created using InnoDB, and until this point, everything is working great. When we check the same table on another cluster node, we have: MariaDB [galera_test]> SHOW VARIABLES WHERE Variable_name='enforce_storage_engine' OR Variable_name='sql_mode'; +------------------------+--------+ | Variable_name | Value | +------------------------+--------+ | enforce_storage_engine | InnoDB | | sql_mode | | +------------------------+--------+ 2 rows in set (0.00 sec) MariaDB [galera_test]> SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES where TABLE_SCHEMA = 'galera_test'; +------------+--------+ | TABLE_NAME | ENGINE | +------------+--------+ | table_1 | InnoDB | | table_2 | MyISAM | +------------+--------+ 2 rows in set (0.00 sec) MariaDB [galera_test]> SHOW TABLE STATUS WHERE Name = 'table_2'; +---------+--------+---------+------------+------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +---------+--------+---------+------------+------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+ | table_2 | MyISAM | 10 | Fixed | 0 | 0 | 0 | 1970324836974591 | 1024 | 0 | NULL | 2015-12-22 11:08:34 | 2015-12-22 11:08:34 | NULL | latin1_swedish_ci | NULL | | | +---------+--------+---------+------------+------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+ 1 row in set (0.00 sec) As you can note, creating a MyISAM table (table_2) on the first node produces a correct InnoDB table, but replication of the same table on the other cluster nodes happens using MyISAM engine. It seems like engine enforcing is used during creation but not during replication.... On 21/12/2015 20:34, Ian Gilfillan wrote: On 21/12/2015 20:10, Nirbhay Choubey wrote: On Mon, Dec 21, 2015 at 12:47 PM, Michele Tota <michele.tota(a)lnf.infn.it> wrote: Hello Nirbhay, thanks for your reply. We have the 10.1.9 mariadb version; the bug that your refers is similar but in our case the enforcing works properly on the node used for the initial write, while replicated writes on other nodes generate tables using another engine. I tried the following on 10.1.9 : Version: Server version: 10.1.9-MariaDB-debug-log Source distribution Node 1: MariaDB [test]> SET @@enforce_storage_engine=INNODB; Query OK, 0 rows affected (0.01 sec) MariaDB [test]> CREATE TABLE t1(i INT) ENGINE=INNODB; Query OK, 0 rows affected (0.07 sec) MariaDB [test]> CREATE TABLE t2(i INT) ENGINE=MYISAM; ERROR 1286 (42000): Unknown storage engine 'MyISAM' Node 2: MariaDB [test]> SHOW TABLES; +----------------+ | Tables_in_test | +----------------+ | t1 | +----------------+ 1 row in set (0.00 sec) Do you get different results? Or your's is a different scenario altogether? Best, Nirbhay From the sounds of it, the sql_mode option NO_ENGINE_SUBSTITUTION is set differently in Nirbhay and Michele's scenarios, so the MyISAM table is converted to InnoDB with a warning in one, and fails in the other. _______________________________________________ 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

3 2

[Maria-discuss] enforce_storage_engine galera cluster
by Michele Tota 22 Dec '15

22 Dec '15

Hi, we have a problem using enforce_storage_engine variable set to InnoDB. We have three servers in cluster (multi masters). When we issue create table with engine=MyISAM the engine is correctly enforced to InnoDB only on the node we are connected to. On the other nodes the replicated table is created as MyISAM. This is our servers configuration, the same on all nodes: ... enforce_storage_engine='InnoDB' wsrep_on=ON sql_mode='' ... How can we enforce InnoDB on all nodes? Thanks, Michele

3 5

[Maria-discuss] Announcing release for MariaDB 5.5 and 10.0 on CentOS Linux 6 and 7 x86_64 SCL
by Honza Horak 21 Dec '15

21 Dec '15

I am pleased to announce the immediate availability of versions 5.5 and 10.0 of the MariaDB server on CentOS Linux 6 and 7 x86_64, delivered via a Software Collection (SCL) built by the SCLo Special Interest Group (https://wiki.centos.org/SpecialInterestGroup/SCLo) QuickStart ---------- You can get started in three easy steps (example of MariaDB 10.0): $ sudo yum install centos-release-scl $ sudo yum install rh-mariadb100 $ scl enable rh-mariadb100 bash At this point you should be able to use MariaDB just as a normal application. An examples of commands run might be: $ service rh-mariadb100-mariadb start $ mysql In order to view the individual components included in this collection, including additional subpackages plugins, you can run: $ sudo yum list rh-mariadb100\* About Software Collections -------------------------- Software Collections give you the power to build, install, and use multiple versions of software on the same system, without affecting system-wide installed packages. Each collection is delivered as a group of RPMs, with the grouping being done using the name of the collection as a prefix of all packages that are part of the software collection. The collection rh-mariadb100 delivers version 10.0 of the MariaDB server (with daemon called rh-mariadb100-mariadb) and related client tools. The collection mariadb55 delivers version 5.5 of the MariaDB server (with daemon called mariadb55-mariadb) and related client tools. Both the collections include no client library libmysqlclient.so and client applications are advised to use the client library available in mysql-libs package from base system. For more on the MariaDB, see https://mariadb.org. The SCLo SIG in CentOS ---------------------- The Software Collections SIG group is an open community group co-ordinating the development of the SCL technology, and helping curate a reference set of collections. In addition to the MariaDB collections being released here, we also build and deliver other databases, web servers, and language stacks including multiple versions of MySQL, PostgreSQL, MongoDB Apache HTTP Server, NodeJS, Ruby, Python and others. Software Collections SIG release was announced at https://lists.centos.org/pipermail/centos-announce/2015-October/021446.html You can learn more about Software Collections concepts at: http://softwarecollections.org You can find information on the SIG at https://wiki.centos.org/SpecialInterestGroup/SCLo ; this includes howto get involved and help with the effort. We meet every second Wednesday at 16:00 UTC in #centos-devel (ref: https://www.centos.org/community/calendar) for an informal open forum open to anyone who might have comments, concerns or wants to get started with SCL's in CentOS. Enjoy! Honza SCLo SIG member

1 0

[Maria-discuss] MariaDB 10.0.23 now available
by Daniel Bartholomew 19 Dec '15

19 Dec '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.23. This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.23 - Release Notes: https://mariadb.com/kb/en/mdb-10023-rn - Changelog: https://mariadb.com/kb/en/mdb-10023-cl - Downloads: https://downloads.mariadb.org/mariadb/10.0.23 About MariaDB 10.0: - https://mariadb.com/kb/en/what-is-mariadb-100/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/en/donate/ 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

3 2

[Maria-discuss] New Question: Slow query log and long_query_time
by AskMonty KB 18 Dec '15

18 Dec '15

Hello, A new question has been asked in "Slow Query Log" by yu.d.sun_32615. Please answer it at http://mariadb.com/kb/en/slow-query-log-and-long_query_time/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- In my understanding if we enable slow query log, MySQL will capture all SQL statements that take more than long_query_time seconds to execute into the log. If so below testing puzzled me: Server version: 10.0.21-MariaDB-wsrep-log MariaDB Server, wsrep_25.10.r4144 === in the mysql CLI ================== ip-10-74-2-218$ root@localhost[galeratest] MYSQL> select now(); +---------------------+ | now() | +---------------------+ | 2015-12-18 11:12:50 | +---------------------+ 1 row in set (0.00 sec) ip-10-74-2-218$ root@localhost[galeratest] MYSQL> show variables like 'long%'; +-----------------+-----------+ | Variable_name | Value | +-----------------+-----------+ | long_query_time | 10.000000 | +-----------------+-----------+ 1 row in set (0.00 sec) ip-10-74-2-218$ root@localhost[galeratest] MYSQL> select count(*) from test_table; +----------+ | count(*) | +----------+ | 13 | +----------+ 1 row in set (0.00 sec) ip-10-74-2-218$ root@localhost[galeratest] MYSQL> select sleep(5); +----------+ | sleep(5) | +----------+ | 0 | +----------+ 1 row in set (5.00 sec) ip-10-74-2-218$ root@localhost[galeratest] MYSQL> select sleep(11); +-----------+ | sleep(11) | +-----------+ | 0 | +-----------+ 1 row in set (11.00 sec) ip-10-74-2-218$ root@localhost[galeratest] MYSQL> select count(*) from test_table; +----------+ | count(*) | +----------+ | 13 | +----------+ 1 row in set (0.00 sec) ip-10-74-2-218$ root@localhost[galeratest] MYSQL> ==== from the slow query log ================== # Time: 151218 11:13:12 # User@Host: root[root] @ localhost [] # Thread_id: 125 Schema: galeratest QC_hit: No # Query_time: 0.000163 Lock_time: 0.000075 Rows_sent: 1 Rows_examined: 13 SET timestamp=1450465992; select count(*) from test_table; # Time: 151218 11:13:48 # User@Host: root[root] @ localhost [] # Thread_id: 125 Schema: galeratest QC_hit: No # Query_time: 11.002494 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0 SET timestamp=1450466028; select sleep(11); # Time: 151218 11:14:10 # User@Host: root[root] @ localhost [] # Thread_id: 125 Schema: galeratest QC_hit: No # Query_time: 0.000159 Lock_time: 0.000073 Rows_sent: 1 Rows_examined: 13 SET timestamp=1450466050; select count(*) from test_table; ================ Question - why the 'select count(*) from test_table' statement is captured while it seems right that select sleep(11) got captured and sleep(5) did not? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/slow-query-log-and-long_query_time/

1 0

[Maria-discuss] New mariadb.org in the works
by Otto Kekäläinen 18 Dec '15

18 Dec '15

Hello! We are about to renew the mariadb.org website. The idea is to replace the current mariadb.org and blog.mariadb.org with one single site that includes both the basic information about the software project and the MariaDB Foundation, as well as the blog. Work in progress is visible at https://new.mariadb.org/ Please send us your feedback!

1 1