- discuss - lists.mariadb.org

[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