January 2016 - discuss - lists.mariadb.org

[Maria-discuss] why stdout? -> [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 115096
by Reindl Harald 05 Jul '20

05 Jul '20

Aug 6 12:24:24 testserver mysqld: 150806 12:24:24 [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 115096 ... why is this now stdout instead mysql logs? on systemd based distributions that spits now to the global syslog and finally on machines restarting 2 instances every hour for backup reasons it annoys until 10.0.19 or 10.0.20 that was not this way

5 13

[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] 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 29 Jan '16

29 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