August 2016 - discuss - lists.mariadb.org

[Maria-discuss] optimize table wait table level lock in MairaDB 10.1.16 ?
by Ljr Yang 30 Aug '16

30 Aug '16

Hi, all Today, we use optimize table in MariaDB 10.1.16. Table test01 have about 2 millions records. session 1: optimize table test01; session 2: select count(*) from test01 ; when session 1 run, In processlist session 2 state: Waiting FOR TABLE LEVEL LOCK we had set innodb_defragment=1 in my.cnf ,but run optimize table still have table lock？ reference link: https://mariadb.com/kb/en/mariadb/defragmenting-innodb-tablespaces/ -- Ljr

2 1

[Maria-discuss] MariaDB 10.1.17 and MariaDB Galera Cluster 10.0.27 now available
by Daniel Bartholomew 30 Aug '16

30 Aug '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.17 and MariaDB Galera Cluster 10.0.27. These are both Stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.17 - Release Notes: https://mariadb.com/kb/en/mdb-10117-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10117-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.1.17 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.27 - Release Notes: https://mariadb.com/kb/en/mgc-10027-rn/ - Changelog: https://mariadb.com/kb/en/mgc-10027-cl/ - Downloads: https://downloads.mariadb.org/mariadb-galera/10.0.27/ 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] geo replication?
by l vic 29 Aug '16

29 Aug '16

Is replication between different data centers supported in MariaDB and is it supported in open source version, or in enterprise only? Thank you, -V

4 4

[Maria-discuss] Reg custom port for maxscale binlog router
by Karthick Subramanian 29 Aug '16

29 Aug '16

Hi all, When I try to configure maxscale for binlogrouter, I noticed that documentation examples using port as 5308. When I try to configure similarly, it says, 111 connection refused or unable to connect master from maxscale. I have enabled the port in centOs7 using firewalld on both master server as well maxscale server: firewall-cmd --add-port=5308/tcp But still,I couldn't able to establish connection from maxscale server to mariadb server(master): mysql -u maxscaleoper -h ip:ip:ip:ip --port 5308 -p ERROR 2003 (HY000): Can't connect to MySQL server on 'ip:ip:ip:ip' (111 "Connection refused") Can anyone please help me on how to resolve this error. Because of this error, I couldn't make maxscale up and running. Regards, Karthick S

2 2

Re: [Maria-discuss] Don't replicate procedures in the mysql database
by Federico Razzoli 29 Aug '16

29 Aug '16

You should keep those procedures in a different database, not mysql. Then you can avoid replication with replication filters: https://mariadb.com/kb/en/mariadb/selectively-skipping-replication-of-binlo… But first, be sure you understand what happens when you call the procedure on the master. Federico -------------------------------------------- Lun 29/8/16, Игорь Пашев <pashev.igor(a)gmail.com> ha scritto: Oggetto: Re: [Maria-discuss] Don't replicate procedures in the mysql database A: "Daniel Black" <daniel.black(a)au1.ibm.com> Cc: "MariaDB discuss" <maria-discuss(a)lists.launchpad.net> Data: Lunedì 29 agosto 2016, 15:44 2016-08-29 1:25 GMT+03:00 Daniel Black <daniel.black(a)au1.ibm.com>: > A question for you is why is it important not to have it on the slave? Because the slave already has this procedure with a slightly different implementation, and different owner (definer). > If the slave is a failover it should have the procedure. If I wanted a failover server I would not be fiddling with replication options and channels at all. >> When I execute `CREATE PROCEDURE mysql.bar` on the master, this >> procedure appears on the slave. > > Which is what replication is meant to do. This is not consistent with creating and modifying mysql users. That's why I'm asking. > Its probably also best not to populate the mysql database with your > stored procedures. It's totally fine for maintenance procedures. See for example http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.MySQL.SQLRef… > set session sql_log_bin=0; create procedure... This is not scalable and sometime impossible: for the SUPER privilege, at Amazon RDS, it could break other slaves. _______________________________________________ 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] howto get MariaDB T-Shirts and Hoodies?
by Lukas Lehner 29 Aug '16

29 Aug '16

Hi I have lots (> 10) of MongoDB T-Shirts, but I prefer to run MariaDB. Howto get cool MariaDB Shirts and Hoodies? Witch a search engine I found only "Support MariaDB" products (CafePress). That's not my taste :-( thanks Lukas

2 1

[Maria-discuss] When using the getGeneratedKeys() method the keys are returned, but in which order?
by Péter Éberhardt 26 Aug '16

26 Aug '16

Hi, I want to insert multiple records into a table using one statement like this through jdbc: INSERT INTO demo (name) VALUES ('Jeff'),('Jones'),('Agnes'),...,('Wolfgang'); Then I want to get the generated ids with the getGeneratedKeys() method and match them to the inserted records but how can I be sure the method gives the ids in the same order as I listed the records in the statement? I can't find any related information in the documentation just the fact the method gives back those ids. DDL: CREATE TABLE demo (id bigint primary key auto_increment , name text); If this information would put into the document also then I can go with my implementation on this way. Thanks, Peter

3 4

[Maria-discuss] New Question: Locking/deadlocking on temp tables?
by AskMonty KB 26 Aug '16

26 Aug '16

Hello, A new question has been asked in "MariaDB Knowledge Base" by WebtrendsData. Please answer it at http://mariadb.com/kb/en/lockingdeadlocking-on-temp-tables/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello - I am coming up to speed on MariaDB, I have a MS Sql Server and Hadoop background but we are starting to use MariaDB heavily. We have some queries that hit tables with mediumtext datatype columns. My understanding is these types of queries will always generate temp tables directly to disk (because of the text/blob types). I've confirmed our temp table engine is Aria. >From what I've read, in the mysql world, this situation would end up with a MyIsam table on disk, which does not have row locking, only table locking. I've tried looking for info on how Aria tables would handle this as I suspect we are getting deadlocks on these tables. Our application is reporting many database deadlocks, our entire database is all ExtraDB tables, yet SHOW ENGINE INNODB STATUS does not report any deadlocks, which leads me to think it is the temp tables. So I guess my question is, does the Aria engine do row locking? Is it possible to get a status similar to SHOW ENGINE INNODB STATUS? Please forgive me if this is painfully obvious or unclear (I'm still learning!), and thank you for your time. -Aaron -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/lockingdeadlocking-on-temp-tables/

5 7

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

26 Aug '16

Thanks for your armchair diagnosis, but I'm not "striking out" at anybody. I'm outraged by the behavior of MariaDB. I'm passionate about open source, since my whole life has been spent on it. I joined because the company is open source. What I found after I joined was a total lack of regard for it, and a lack of ethics. Would YOU knowingly ask a customer to install software with known vulnerabilities reported ten years ago? Would you ship open source that doesn't compile? Would you extort your current users of your product for bug fixes? If you answered yes to those questions then you don't have ethics either. --Justin Sent from my iPhone On Aug 25, 2016, at 1:15 AM, Jan Steinman <Jan(a)EcoReality.org> wrote: >> On 2016-08-24, at 06:22, Justin Swanhart <greenlion(a)gmail.com> wrote: >> >> I'm bipolar > > Seems more like Borderline to me. Bipolars generally don’t strike out at others as much as you are doing. > > Jan Steinman > EcoReality Co-op, http://www.EcoReality.org > 2152 Fulford-Ganges Road > Salt Spring Island, BC V8K 1Z7 CANADA > +1 250.653.2024 > > >

1 1

[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