October 2015 - 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] MariaDB 10.1.8 Stable (GA) now available
by Daniel Bartholomew 10 Dec '15

10 Dec '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.8. This is the first Stable (GA) release in the MariaDB 10.1 series. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.8 - Release Notes: https://mariadb.com/kb/en/mariadb-1018-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-1018-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.1.8 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/en/donate/ We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

6 9

[Maria-discuss] MariaDB 10.0.22 now available
by Daniel Bartholomew 16 Nov '15

16 Nov '15

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

5 8

[Maria-discuss] New Question: Spider
by AskMonty KB 30 Oct '15

30 Oct '15

Hello, A new question has been asked in "MariaDB Community" by siliconplains44. Please answer it at http://mariadb.com/kb/en/mariadb-community-spider/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, we are looking for scale up options for mariadb. We wanted to try spider out but there was not enough information on this site. Some of the questions I had were what is the maxiumum number of nodes you can have. Does the database balance the shards, etc.? I am looking to see how much storage we can get out of spider. Can anyone out there help us with this request? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-community-spider/

1 0

[Maria-discuss] Slave SQL: Fatal error: ... Slave SQL Thread stopped with incomplete event group having non-transactional changes
by Reindl Harald 29 Oct '15

29 Oct '15

* why does that happen at all instead finish whatever is not finished after get SIGTERM * "try to restart the slave with --slave-exec-mode=IDEMPOTENT" must be a joke when "slave-exec-mode = IDEMPOTENT" is part of my.cnf for years *because* of that failure happening randomly when stop a slave at a wrong moment 151029 9:15:44 [ERROR] Slave SQL: Fatal error: ... Slave SQL Thread stopped with incomplete event group having non-transactional changes. If the group consists solely of row-based events, you can try to restart the slave with --slave-exec-mode=IDEMPOTENT, which ignores duplicate key, key not found, and similar errors (see documentation for details). Gtid 0-1-2058483, Internal MariaDB error code: 1593

1 0

[Maria-discuss] New Question: Want to start contributing in MariaDB
by AskMonty KB 28 Oct '15

28 Oct '15

Hello, A new question has been asked in "MariaDB Community" by aman_var. Please answer it at http://mariadb.com/kb/en/want-to-start-contributing-in-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello all, I want to contribute to this project. I have ample knowledge of C,C++ and want to start my open source contribution. It would be great if i get some directions from you all guys as to where to start from. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/want-to-start-contributing-in-mariadb/

1 0

[Maria-discuss] New Question: Want to start contributing in MariaDB
by AskMonty KB 28 Oct '15

28 Oct '15

Hello, A new question has been asked in "MariaDB Community" by aman_var. Please answer it at http://mariadb.com/kb/en/want-to-start-contributing-in-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello all, I want to contribute to this project. I have ample knowledge of C,C++ and want to start my open source contribution. It would be great if i get some directions from you all guys as to where to start from. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/want-to-start-contributing-in-mariadb/

1 0

[Maria-discuss] New Question: MariaDB Error Code -> Windows ERRORLEVEL
by AskMonty KB 26 Oct '15

26 Oct '15

Hello, A new question has been asked in "Error Codes" by patkoshar. Please answer it at http://mariadb.com/kb/en/mariadb-error-code-windows-errorlevel/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello, Is there a known issue or problem with how/when MariaDB returns error codes from calling '--execute' on *.sql scripts in Windows? It seems like certain errors are detected and returned as such, and others are not. For example, a *.sql file of completely random bytes will set the Windows ERRORLEVEL=1 after failing, reporting the following error: ERROR: ASCII '\0' appeared in the statement... Another *.sql file that references an unknown database will set the Windows ERRORLEVEL=0, but still textually report an error after failing: ERROR 1049 (42000) at line 1 in file... Any ideas? Thank you! -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-error-code-windows-errorlevel/

1 0

[Maria-discuss] New Question: Converting unix timestamp stored as bigint to readable date time
by AskMonty KB 26 Oct '15

26 Oct '15

Hello, A new question has been asked in "MariaDB Documentation" by thanmaya. Please answer it at http://mariadb.com/kb/en/converting-unix-timestamp-stored-as-bigint-to-read… as the person asking the question may not be subscribed to the mailing list. -------------------------------- We are storing the timestamp as a bigint. In the SQL query trying to convert this timestamp to date time. have used the function FROM_UNIXTIME but it just returns a NULL value. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/converting-unix-timestamp-stored-as-bigint-to-read…

1 0

[Maria-discuss] MySQL Meetup NL slides
by Colin Charles 25 Oct '15

25 Oct '15

Hi! So we had many MariaDB Server and other developers speak at the MySQL Meetup NL in Amsterdam a week ago. The slides (except Otto’s — it’ll be added soon!) are all at: https://drive.google.com/folderview?id=0B7HE7L1OgKJFcXVrX05Ea25zb2c&usp=sha… I wrote a quick post with an index — http://www.bytebot.net/blog/archives/2015/10/24/mysql-nl-community-meetup-w… I think the attendees had a great time overall, and there was plenty of good conversation. Also, much thanks to eBay (venue, food, drink), Booking.com (Daniël van Eeden organised, and JF ensured we were all appropriately whipped to make this happen!), and all the speakers. cheers, -colin -- Colin Charles, Chief Evangelist, MariaDB Corporation blog: http://bytebot.net/blog/ | t: +1-347-903-3201 | Skype: colincharles | Twitter: @bytebot

3 3