- 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