- discuss - lists.mariadb.org

[Maria-discuss] ibdata1 file grow quickly in MariaDB 10.1 ?
by Ljr Yang 25 Aug '16

25 Aug '16

Hi, All we use MariaDB 10.1.16 , about have 30 machines. Recently ,there one master and slave's ibdat1 growed to about 4GB, others machine are normal. mainly parameter in my.cnf : innodb_data_home_dir = /data/mysql/data innodb_data_file_path = ibdata1:2G:autoextend innodb_log_files_in_group=3 innodb_log_file_size = 1G innodb_undo_logs=128 innodb_undo_tablespaces=4 innodb_file_per_table= 1 ls -l /data/mysql/data -rw-r--r-- 1 mysql mysql 4429185024 Aug 25 21:38 ibdata1 -rw-r--r-- 1 mysql mysql 1073741824 Aug 25 21:38 ib_logfile0 -rw-r--r-- 1 mysql mysql 1073741824 Aug 25 21:38 ib_logfile1 -rw-r--r-- 1 mysql mysql 1073741824 Aug 25 20:13 ib_logfile2 -rw-r--r-- 1 mysql mysql 616562688 Aug 25 21:36 undo001 -rw-r--r-- 1 mysql mysql 411041792 Aug 25 21:27 undo002 -rw-r--r-- 1 mysql mysql 708837376 Aug 25 21:34 undo003 -rw-r--r-- 1 mysql mysql 981467136 Aug 25 21:34 undo004 Today, when found the problem, there are not some big transaction in show processlist. We guess ibdata1 had growed to 4GB in previous some time, but we want to know how confirm the cause and shrink ibdate1 file ? Thank . -- Ljr

2 1

[Maria-discuss] MariaDB 10.0.27 now available
by Daniel Bartholomew 25 Aug '16

25 Aug '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.27. This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.27 - Release Notes: https://mariadb.com/kb/en/mdb-10027-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10027-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.0.27 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: Maria DB Account Deletion
by AskMonty KB 25 Aug '16

25 Aug '16

Hello, A new question has been asked in "MariaDB Community" by tomibic. Please answer it at http://mariadb.com/kb/en/maria-db-account-deletion/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi there, Does anybody know how to delete one's MariaDB account? Help would be really appreaciated! -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/maria-db-account-deletion/

1 0

[Maria-discuss] Spider Engine
by Suresh Rajagopal 24 Aug '16

24 Aug '16

Hi, I am looking for some references for Spider Engine in production. Any known issues/recommendations for setup ? ThanksSuresh Rajagopal

2 2

[Maria-discuss] Backporting bug fixes to 1.0?
by Justin Swanhart 24 Aug '16

24 Aug '16

I have created a GitHub fork of MaxScale which does not include the 2.0 branch. The repository is called GPLScale. There is a big potential problem with this. Take for example the file server/core/utils.c, which now has a new license: https://github.com/mariadb-corporation/MaxScale/blob/2.0/server/core/utils.c This file WAS covered under GPL: https://github.com/mariadb-corporation/MaxScale/blob/cb3213af6382c380df9fc4… When there is a bugfix in 2.0 for server code that existed in 1.0, can that code be backported directly into GPLscale? a) util.c in 2.0 is clearly derivative of 1.0, and is therefore a derivative work of 1.0 and therefore still covered by GPL and b) there is a "violation" of GPL, because 1.0 GPL code is being linked against code covered by an incompatible license (other code in MaxScale). Almost all of the files in MaxScale 2.0 derive from 1.0 so this problem is not just in one file of course. The FSF says that the owner of the software can't legally violate the GPL they can morally violate the GPL. Will MariaDB commit to backporting all bugs in 1.0 code into the 1.0 branch?

2 4

Re: [Maria-discuss] Backporting bug fixes to 1.0?
by Federico Razzoli 24 Aug '16

24 Aug '16

Thank you for expressing your honest opinions about the MySQL/MariaDB ecosystem. Best wishes for your next job and your open source projects. Federico -------------------------------------------- Mer 24/8/16, Justin Swanhart <greenlion(a)gmail.com> ha scritto: Oggetto: Re: [Maria-discuss] Backporting bug fixes to 1.0? A: "Maria Discuss" <maria-discuss(a)lists.launchpad.net> Data: Mercoledì 24 agosto 2016, 14:21 I have been fired for speaking out about the GPL and MariaDB actions that have caused great harm to our ecosystem. It has been pointed out that I have a non-compete agreement. None of my tools compete with MariaDB and I have no non-public knowledge of MariaDB technology. GPLScale remains free software under the GNU GPL license and it is my right to fork a github repo. I am not paid to work on GPLScale and I don't intend to get paid to maintain it by anyone. All my projects are labors of love. Who wants to hire me? I'm dedicated, honest, open, and I have integrity. I'm willing to risk everything for what I believe in. Email me at:greenlion at gmail dot com ---- I have been a proponent of GPL for a long time, and I don't need publicity.http://swanhart.livejournal.com/128586r.html https://libraries.io/github/greenlion https://blog.jcole.us/2008/07/23/on-mysql-forks-and-mysqls-non-open-source-… Swanhart on July 23, 2008 at 12:09Brian, The “thing is” that we shouldn’t have to write it. MySQL may be ‘open source’, but it isn’t ‘open software’. With all the talk recently of proprietary extensions, the documentation licensing issues, the whole ‘enterprise’ vs ‘community’ debacle, well, MySQL has totally shown that they are not ‘Open Software’ company. WHEN I WAS SEVENTEEN I BROKE THE LAW AND DROVE FROM PITTSBURGH PA TO BOSTON MA FOR THE FIRST FREE SOFTWARE FOUNDATION CONFERENCE. I sat down and had breakfast with STALLMAN, TORVALDS, AND RAYMOND! My whole life is open source. I've made my living off it and I intend to make sure others have the same opportunities that I have. Sent from my iPhone On Aug 18, 2016, at 9:51 AM, Justin Swanhart <greenlion(a)gmail.com> wrote: I have created a GitHub fork of MaxScale which does not include the 2.0 branch. The repository is called GPLScale. There is a big potential problem with this. Take for example the file server/core/utils.c, which now has a new license: https://github.com/mariadb-corporation/MaxScale/blob/2.0/server/core/utils.c This file WAS covered under GPL: https://github.com/mariadb-corporation/MaxScale/blob/cb3213af6382c380df9fc4… When there is a bugfix in 2.0 for server code that existed in 1.0, can that code be backported directly into GPLscale? a) util.c in 2.0 is clearly derivative of 1.0, and is therefore a derivative work of 1.0 and therefore still covered by GPL and b) there is a "violation" of GPL, because 1.0 GPL code is being linked against code covered by an incompatible license (other code in MaxScale). Almost all of the files in MaxScale 2.0 derive from 1.0 so this problem is not just in one file of course. The FSF says that the owner of the software can't legally violate the GPL they can morally violate the GPL. Will MariaDB commit to backporting all bugs in 1.0 code into the 1.0 branch? -----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] New Question: Prepared statements support in MariaDB
by AskMonty KB 23 Aug '16

23 Aug '16

Hello, A new question has been asked in "Does MariaDB support..." by Sibin.. Please answer it at http://mariadb.com/kb/en/prepared-statements-support-in-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Can you please tell me if MariaDB supports Prepared statements (related instrumentation were added in MySQL-5.7.4)? If not, then please tell me in which MariaDB version support for prepared statements will be added ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/prepared-statements-support-in-mariadb/

1 0

[Maria-discuss] New Question: How to use Maxscale for maximum reliability?
by AskMonty KB 22 Aug '16

22 Aug '16

Hello, A new question has been asked in "MaxScale Routers" by patrik_63236. Please answer it at http://mariadb.com/kb/en/how-to-use-maxscale-for-maximum-reliability/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I'm trying to use Maxscale in front of a Galera cluster. Performance is not an issue. The reason I'm using it is so that I can take down a node for maintenance and upgrades without downtime. But I'm not sure how to achieve this. When I run m my tests I get failures. I suspect that the problem occurs when Maxscale writes to one node and then immidiately tries to read that data from another node. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-to-use-maxscale-for-maximum-reliability/

1 0

[Maria-discuss] New Question: Connectin Excel with MariaDB
by AskMonty KB 21 Aug '16

21 Aug '16

Hello, A new question has been asked in "MariaDB Connector/ODBC" by alejandro_reyna_g. Please answer it at http://mariadb.com/kb/en/connectin-excel-with-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello ! A Question from a begginer. I have been trying to connect Excel 2007 with MariaDB. 1) I downloaded the latest ODBC connector. 2) I created in Windows a new ODBC connection fron the control panel 3) From excel I created selected the connection and I can only see the TEST and PERFORMANCE_SCHEMA Databases. I don´t see any of my DataTables. What could be happening? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/connectin-excel-with-mariadb/

1 0

[Maria-discuss] New Question: MONyog ssh authentication using private key
by AskMonty KB 19 Aug '16

19 Aug '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/monyog-ssh-authentication-using-private-key/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- When we configure the ssh connection and we choose the key based authentication method we have to copy paste the private ssh keys...IS there any other way to get the private key or authenticate by giving the public key...something like that?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/monyog-ssh-authentication-using-private-key/

1 0