- discuss - lists.mariadb.org

[Maria-discuss] New Question: Wierd tables in mysql system database
by AskMonty KB 22 Feb '16

22 Feb '16

2 1

[Maria-discuss] New Question: "WITH" clause in "SELECT" statement?
by AskMonty KB 22 Feb '16

22 Feb '16

Hello, A new question has been asked in "Data Manipulation" by roblewis. Please answer it at http://mariadb.com/kb/en/with-clause-in-select-statement/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Some SQLs (e.g., SQLite) support a "WITH" clause introducing a SELECT statement, but it appears MariaDB doesn't. Can you discuss? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/with-clause-in-select-statement/

1 0

[Maria-discuss] Is there something like "best practices" to migrate from Paradox to MariaDB?
by Hugo Wau 21 Feb '16

21 Feb '16

Hello, I am new here. I will have to migrate some hundred Paradox Databases (on as many machines) to MariaDB. The best way to do so, would be something like a script. My OSs are Linux (Debian) and Win7. Is there some kind of documentation of the experience of someone, who has migrated from Paradox to MySQL/MariaDB before? (I have googled for days, but have not found such yet.) With kind regards Hugo

5 7

[Maria-discuss] New Question: Can't run C program using mariaDB on centOS
by AskMonty KB 21 Feb '16

21 Feb '16

Hello, A new question has been asked in "MariaDB FAQ" by grvsngh929. Please answer it at http://mariadb.com/kb/en/cant-run-c-program-using-mariadb-on-centos/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- here is link to my question (still unanswered): http://stackoverflow.com/questions/35531782/cant-run-c-program-using-mariad… -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/cant-run-c-program-using-mariadb-on-centos/

1 0

[Maria-discuss] New Question: Can't run C program using mariaDB on centOS
by AskMonty KB 21 Feb '16

21 Feb '16

Hello, A new question has been asked in "MariaDB FAQ" by grvsngh929. Please answer it at http://mariadb.com/kb/en/cant-run-c-program-using-mariadb-on-centos/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- here is link to my question (still unanswered): http://stackoverflow.com/questions/35531782/cant-run-c-program-using-mariad… -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/cant-run-c-program-using-mariadb-on-centos/

1 0

[Maria-discuss] MariaDB 10.0.24 now available
by Daniel Bartholomew 19 Feb '16

19 Feb '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.24. This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.24 - Release Notes: https://mariadb.com/kb/en/mdb-10024-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10024-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.0.24 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: Upgrading MariaDB 10.0.20 to 10.1.11 with bi-directional master-slave replication
by AskMonty KB 18 Feb '16

18 Feb '16

Hello, A new question has been asked in "Getting, Installing, and Upgrading MariaDB" by aferrett. Please answer it at http://mariadb.com/kb/en/upgrading-mariadb-10020-to-10111-with-bi-direction… as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have two Maria DB instances running 10.0.20 on RHEL. Each is database is a slave with the other database as a master. Is there a procedure documented to upgrade these to 10.1.11? I just need to know the steps associated with the replication. I've already tested the upgrade of a single instance without replication. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/upgrading-mariadb-10020-to-10111-with-bi-direction…

1 0

[Maria-discuss] New Question: Migrating mysql 5.5.19 to mariadb with encryption
by AskMonty KB 18 Feb '16

18 Feb '16

Hello, A new question has been asked in "Getting, Installing, and Upgrading MariaDB" by Christine.Ross. Please answer it at http://mariadb.com/kb/en/migrating-mysql-5519-to-mariadb-with-encryption/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I am currently running mysql 5.5.19 64bit, Innodb, on Sparc Solaris and looking to move to mariadb on linux. Our ultimate goal is to have encrypted data-at-rest. I have 2 questions please. 1) So from my research I see I should be able to install mariadb 10.0 and run mysql_upgrade. Since the database exists already, do you just specify the location of the database when you install and it will upgrade it to mysqldb 10.0 when I run mysql_upgrade? 2) To achieve encryption, do I just install 10.1.4 on the same machine and run mysql_upgrade after making the changes to my.cnf. I know there are other my.cnf options but will this encrypt all the tables and logs? Does it do system tables please? [mysqld] plugin-load-add=file_key_management.so file-key-management file-key-management-filename = /mount/usb1/keys.txt innodb-encrypt-tables innodb-encrypt-log innodb-encryption-threads=4 I have just started to research so I appreciate the help. Christine -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/migrating-mysql-5519-to-mariadb-with-encryption/

1 0

[Maria-discuss] New Question: Access + MariaDB connector problem
by AskMonty KB 18 Feb '16

18 Feb '16

Hello, A new question has been asked in "MariaDB Community" by a.mesquita_37041. Please answer it at http://mariadb.com/kb/en/access-mariadb-connector-problem/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi everyone, I have an issue while executing a query with an ORDER BY on a table linked through a MariaDB ODBC connector to a MS ACCESS 2013 database. I use the 1.0.5 version of MariaDB ODBC connector and the 10.1.1 version of MariaDB (I don’t want to use a MySQL ODBC connector). If I try only with a SELECT * it works but from the moment I use the ORDER BY Access freezes for a while and then stops running. The UPDATE queries work fine. Any help would be much appreciated, Aurélien MESQUITA. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/access-mariadb-connector-problem/

1 0

[Maria-discuss] Google Summer of Code 2016
by Colin Charles 18 Feb '16

18 Feb '16

Hi! Its that time of year again and I believe that we plan to participate in Google Summer of Code 2016 again (we did so in 2013, 2014, and 2015). We are of course waiting to get accepted (we will know on Feb 29 2016) but that should not stop you, a *potential mentor* from adding your idea to the idea’s list page: https://mariadb.com/kb/en/mariadb/google-summer-of-code-2016/ Potential mentors should also see if there are Jira tasks they’d like completed: https://mariadb.atlassian.net/issues/?jql=labels%3Dgsoc16 (add more by adding the gsoc16 label) *Students* — please note that we have *not* been accepted *yet*, so asking us if you can do a project now is not necessarily useful (once we are accepted, then yes, please propose your interest) Here’s to Google Summer of Code 2016! cheers, -colin -- Colin Charles, http://bytebot.net/blog/ twitter: @bytebot | skype: colincharles "First they ignore you, then they laugh at you, then they fight you, then you win." -- Mohandas Gandhi

1 0

[Maria-discuss] New Question: PORTING MYSQL V5.5.19 TO MARIADB MASTER-MASTER SETUP
by AskMonty KB 17 Feb '16

17 Feb '16

Hello, A new question has been asked in "Replication, Cluster, & Multi-Master" by Christine.Ross. Please answer it at http://mariadb.com/kb/en/porting-mysql-v5519-to-mariadb-master-master-setup/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- We currently have mysql v5.5.19 64bit on Sparc Sun Solaris, with an INNODB storage engine. I am researching porting to mariadb. Our primary servers function in a master-master configuration, with real-time updates when changes are made on either server. I see docs describing master-slave and some posts about master-master. Do I have to install the galera cluster to maintain this master-master setup please or can I just install mariadb on each server and set the my.cnf files as I currently have them with different server-IDs please? Thank you very much. Christine -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/porting-mysql-v5519-to-mariadb-master-master-setup/

1 0

[Maria-discuss] Performance issues after upgrading to 10.0
by azurit＠pobox.sk 15 Feb '16

15 Feb '16

Hi, we upgraded MariaDB 5.5 to 10.0 on one server last night and are now dealing with severe performance issues. Here is one case where it's notable: Query - SELECT b.*, p.category_id FROM brands b JOIN products p USING(brand_id) GROUP BY category_id, brand_id ORDER BY title ASC; Table structures: CREATE TABLE `brands` ( `brand_id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(50) NOT NULL, `slug` varchar(50) NOT NULL, `description` text NOT NULL, `discount_suv_1` float NOT NULL, `discount_suv_2` float NOT NULL, `discount_van_1` float NOT NULL, `discount_van_2` float NOT NULL, `discount_orp_1` float NOT NULL, `discount_orp_2` float NOT NULL, PRIMARY KEY (`brand_id`) ) ENGINE=InnoDB AUTO_INCREMENT=150 DEFAULT CHARSET=utf8 CREATE TABLE `products` ( `product_id` int(11) NOT NULL AUTO_INCREMENT, `category_id` int(11) DEFAULT NULL, `featured_image_id` int(11) DEFAULT NULL, `brand_id` int(11) DEFAULT NULL, `title` text NOT NULL, `slug` text NOT NULL, `price` float NOT NULL, `custom_price` float NOT NULL, `description` text NOT NULL, `hidden` tinyint(1) NOT NULL, `homepage` tinyint(1) NOT NULL, `sale` tinyint(1) NOT NULL, `width` float NOT NULL, `height` int(11) NOT NULL, `diameter` int(11) NOT NULL, `resistance` varchar(50) NOT NULL, `breaking_distance` varchar(50) NOT NULL, `noise` varchar(50) NOT NULL, `ean` varchar(50) NOT NULL, `availability` char(1) NOT NULL, `li` varchar(15) NOT NULL, `si` varchar(15) NOT NULL, `classes` varchar(5) NOT NULL, `all_year` tinyint(1) NOT NULL, `type` char(3) NOT NULL, `holes_count` float NOT NULL, `pitch` float NOT NULL, `et` float NOT NULL, `code` varchar(50) NOT NULL, `custom` tinyint(1) NOT NULL, `car_type` varchar(100) NOT NULL, `models` text NOT NULL, `imported` tinyint(1) NOT NULL, `is_runflat` tinyint(1) NOT NULL, `stock_count` int(11) NOT NULL, `parser` char(1) NOT NULL, PRIMARY KEY (`product_id`), KEY `category_id` (`category_id`), KEY `featured_image_id` (`featured_image_id`), KEY `brand_id` (`brand_id`), KEY `slug` (`slug`(100)), KEY `hidden` (`hidden`), CONSTRAINT `products_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`category_id`) ON DELETE SET NULL, CONSTRAINT `products_ibfk_4` FOREIGN KEY (`featured_image_id`) REFERENCES `product_images` (`product_image_id`) ON DELETE SET NULL, CONSTRAINT `products_ibfk_5` FOREIGN KEY (`brand_id`) REFERENCES `brands` (`brand_id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=63638 DEFAULT CHARSET=utf8 Table brands: 149 rows Table products: 62074 rows Query time on 5.5: about 0.2s Query time on 10.0: between 2 and 9s (if not cached) Explain on 5.5: http://watchdog.sk/5.5.png Explain on 10.0: http://watchdog.sk/10.png Any hints what's going on? What about the difference in the explain command? Thank you. azur

4 8

[Maria-discuss] New Question: unable to update MariaDB from 10.0 to 10.1, error indicating galera libboost dependencies issue
by AskMonty KB 15 Feb '16

15 Feb '16

Hello, A new question has been asked in "MariaDB Community" by cyberdome. Please answer it at http://mariadb.com/kb/en/unable-to-update-mariadb-from-100-to-101-error-ind… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello world, I am trying to update my database MariaDB from 10.0 to 10.1 and when I run the yum update command. I am getting this error message below: Any help is appreciated. Resolving Dependencies --> Running transaction check ---> Package galera.x86_64 0:25.3.9-1.rhel7.el7.centos will be updated ---> Package galera.x86_64 0:25.3.12-1.rhel7.el7.centos will be an update --> Processing Dependency: libboost_program_options.so.1.53.0()(64bit) for package: galera-25.3.12-1.rhel7.el7.centos.x86_64 ---> Package google-chrome-stable.x86_64 0:48.0.2564.97-1 will be updated ---> Package google-chrome-stable.x86_64 0:48.0.2564.109-1 will be an update --> Finished Dependency Resolution Error: Package: galera-25.3.12-1.rhel7.el7.centos.x86_64 (mariadb) Requires: libboost_program_options.so.1.53.0()(64bit) You could try using --skip-broken to work around the problem You could try running: rpm -Va --nofiles --nodigest Any suggestions would be helpful. I am stuck at this stage. I have no idea what to do next? Thanks __________________ Linux Newbie - Information is Power! Download Linux @ http://www.fedora.redhat.com/ May the Linux force be with you! Fedora 21 - MariaDB 10.0 -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/unable-to-update-mariadb-from-100-to-101-error-ind…

1 0

[Maria-discuss] New Question: Will Aria 2.0 have an option to stay crash-safe, but not have the performance penalties necessary for true transactionality?
by AskMonty KB 12 Feb '16

12 Feb '16

Hello, A new question has been asked in "Development" by Moscato. Please answer it at http://mariadb.com/kb/en/will-aria-20-have-an-option-to-stay-crash-safe-but… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Will Aria 2.0 have an option to stay crash-safe, but not have the performance penalties necessary for true transactionality? I love the speed and compactness of Aria (InnoDB tables are relatively huge), and I love that its crash-safe. I don't want to ever lose that crash-safe-ness, but I really don't care if my database goes back in time, and I lose data. Will there be a middle ground? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/will-aria-20-have-an-option-to-stay-crash-safe-but…

1 0

[Maria-discuss] New Question: COUNT not working on XAMPP
by AskMonty KB 12 Feb '16

12 Feb '16

Hello, A new question has been asked in "SQL Commands" by styxlawyer. Please answer it at http://mariadb.com/kb/en/count-not-working-on-xampp/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have just installed XAMPP version 7.0.2 which incorporates MariaDB. I have added a table called repairs to the test database and it works fine with various PHP pages I have written. However, when trying to use a simple query like: SELECT COUNT (*) FROM repairs I get the following error message: #1630 - FUNCTION test.COUNT does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual This happens in both phpMyadmin and in PHP pages which are accessing the database. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/count-not-working-on-xampp/

2 1

[Maria-discuss] MariaDB 5.5.48 and Connector/J 1.3.5 now available
by Daniel Bartholomew 11 Feb '16

11 Feb '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.48 and MariaDB Connector/J 1.3.5 These are both Stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.48 - Release Notes: https://mariadb.com/kb/en/mdb-5548-rn/ - Changelog: https://mariadb.com/kb/en/mdb-5548-cl/ - Downloads: https://downloads.mariadb.org/mariadb/5.5.48 About MariaDB 5.5: - https://mariadb.com/kb/en/what-is-mariadb-55/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB Connector/J 1.3.5 - Release Notes: https://mariadb.com/kb/en/mcj-135-rn/ - Changelog: https://mariadb.com/kb/en/mcj-135-cl/ - Downloads: https://downloads.mariadb.org/connector-java/1.3.5/ About MariaDB Connector/J: - https://mariadb.com/kb/en/about-mariadb-connector-j/ - - 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] JSON in MySQL and MariaDB
by Peter Laursen 11 Feb '16

11 Feb '16

I wonder if someone are able to summarize differences (and similarities - if any ;-) ) between MariaDB and MySQL as regards JSON. I a not really able to structure it myself. MySQL has introduced the JSON datatype https://dev.mysql.com/doc/refman/5.7/en/json.html. I don' tbelieve it is availale in MariaDB. The slides here http://www.slideshare.net/blueskarlsson/using-json-with-mariadb-and-mysql tell that dynamic columns should be used with JSON and MariaDB. Also how much do the functions in both servers for manipulating JSON differ? Are they just named diferently in some cases but doing basically the same? What manipultion options does one have that the other has not (and vice versa). Also :does MariaDB have any plans to move closer to MySQL in 10.2 (such as introducing the JSON datatype and related syntax and funtionalities, for instance)? We would like to add JSON handling capabilites in our (SQLyog) GUI client soon. But the 'uneven' implementation in MariaDB and MySQL is indeed a problem. I think the reply to questions above would be approproate for a Blog, BTW. (@Anders - something for you?) -- Peter Laursen -- Webyog

1 0

[Maria-discuss] New Question: my.cnf 128 GB RAM server
by AskMonty KB 11 Feb '16

11 Feb '16

Hello, A new question has been asked in "MariaDB Community" by wgn. Please answer it at http://mariadb.com/kb/en/mycnf-128-gb-ram-server/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- We are using /usr/share/lve/dbgovernor/db-select-mysql --mysql-version=mariadb101 Hello, As I see MySQL-governor and cl-MariaDB packages have already installed in your system. Could you please clarify what exactly doesn't work? Best regards, -- Anton Mashnin | L2 Technical Support Engineer CloudLinux.com | KernelCare.com [Free Trial] | KuberDock.com [Free Trial] It is work but make an issue ... we not know what is the best setting with our server 128GB RAM We use this http://www.gk-root.com/GK-Blog/optimize-mysql-apache-on-cpanelwhm-server/ Best config base on 8 core & 12GB memory (Shared server) MySQL 5.5: [mysqld] local-infile=0 max_connections = 600 max_user_connections=1000 key_buffer_size = 512M myisam_sort_buffer_size = 64M read_buffer_size = 1M table_open_cache = 5000 thread_cache_size = 384 wait_timeout = 20 connect_timeout = 10 tmp_table_size = 256M max_heap_table_size = 128M max_allowed_packet = 64M net_buffer_length = 16384 max_connect_errors = 10 concurrent_insert = 2 read_rnd_buffer_size = 786432 bulk_insert_buffer_size = 8M query_cache_limit = 5M query_cache_size = 128M query_cache_type = 1 query_prealloc_size = 262144 query_alloc_block_size = 65535 transaction_alloc_block_size = 8192 transaction_prealloc_size = 4096 max_write_lock_count = 8 slow_query_log log-error external-locking=FALSE open_files_limit=50000 [mysqld_safe] [mysqldump] quick max_allowed_packet = 16M [isamchk] key_buffer = 384M sort_buffer = 384M read_buffer = 256M write_buffer = 256M [myisamchk] key_buffer = 384M sort_buffer = 384M read_buffer = 256M write_buffer = 256M #### Per connection configuration #### sort_buffer_size = 1M join_buffer_size = 1M thread_stack = 192K -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mycnf-128-gb-ram-server/

1 0

[Maria-discuss] New Question: setNString method not implemented in PreparedStatement class
by AskMonty KB 11 Feb '16

11 Feb '16

Hello, A new question has been asked in "MariaDB Connector/J" by Sebastian_S. Please answer it at http://mariadb.com/kb/en/setnstring-method-not-implemented-in-preparedstate… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, I do not know if it proper place to ask something like that, but did not find better place. Recently I'd like to connect log4j2 to MariaDB database via MariaDB Connector/J (version 1.3.5, but tested each other). I could not do that and I found that reason is in connector - MariaDbServerPreparedStatement class does not implement method setNString and AbstractMariaDbPreparedStatement class throws exception "NStrings not supported". Why it is not supported. MariaDB does not support such type or it is just a bug? When I copied code form setString method to setNString then everything works properly. Regards, Sebastian -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/setnstring-method-not-implemented-in-preparedstate…

1 0

[Maria-discuss] New Question: MySQL connector bug with bulk insert ?
by AskMonty KB 10 Feb '16

10 Feb '16

Hello, A new question has been asked in "MariaDB Connector/J" by doortts. Please answer it at http://mariadb.com/kb/en/mysql-connector-bug-with-bulk-insert/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I'm new to MariaDB and testing with some applications. Yesterday I met a wired bug. When I using bulk insert with MariaDB connector 1.3.4, following errors occur. (Ubuntu 14.4 and MariaDB 10.1.11) When I replace the connector driver with 'MySQL connector', It works fine. The reference Q&A was http://stackoverflow.com/questions/18693800/mariadb-jdbc-connection-fails-d… The reason that I call this bug is wired was, with same mariadb connector I haven't met bug in any other systems, Mac/Centos 6. Even more another ubuntu system MariaDB 10.1.10 with same driver, no error occurs. works fine: Linux ubuntu 3.13.0-34-generic #60-Ubuntu SMP Wed Aug 13 15:45:27 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux Error occurred system: No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 14.04.3 LTS Release: 14.04 Codename: trusty Linux Yukino 3.16.0-57-generic #77~14.04.1-Ubuntu SMP Thu Dec 17 23:20:00 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux java version "1.8.0_66" Java(TM) SE Runtime Environment (build 1.8.0_66-b17) Java HotSpot(TM) 64-Bit Server VM (build 25.66-b17, mixed mode) Error message: ``` java.lang.NullPointerException at java.lang.String.getBytes(String.java:917) at org.mariadb.jdbc.internal.stream.PacketOutputStream.sendStream(PacketOutputStream.java:178) at org.mariadb.jdbc.internal.packet.dao.parameters.ReaderParameter.writeBinary(ReaderParameter.java:134) at org.mariadb.jdbc.internal.packet.send.SendPrepareParameterPacket.send(SendPrepareParameterPacket.java:93) at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executePreparedQuery(AbstractQueryProtocol.java:568) at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeBatch(MariaDbServerPreparedStatement.java:230) at com.jolbox.bonecp.StatementHandle.executeBatch(StatementHandle.java:424) at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:1005) at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:989) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:673) at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:989) at data.DefaultExchanger.batchUpdate(DefaultExchanger.java:319) at data.DefaultExchanger.importDataFromArray(DefaultExchanger.java:307) at data.DefaultExchanger.importData(DefaultExchanger.java:255) at data.DataService.importData(DataService.java:196) at controllers.SiteApp.importData(SiteApp.java:314) at Routes$$anonfun$routes$1$$anonfun$applyOrElse$54$$anonfun$apply$54.apply(routes_routing.scala:2058) at Routes$$anonfun$routes$1$$anonfun$applyOrElse$54$$anonfun$apply$54.apply(routes_routing.scala:2058) at play.core.Router$HandlerInvokerFactory$$anon$4.resultCall(Router.scala:264) at play.core.Router$HandlerInvokerFactory$JavaActionInvokerFactory$$anon$15$$anon$1.invocation(Router.scala:255) at play.core.j.JavaAction$$anon$1.call(JavaAction.scala:55) at Global$1.call(Global.java:190) at actions.AnonymousCheckAction.call(AnonymousCheckAction.java:57) at utils.SiteManagerAuthAction.call(SiteManagerAuthAction.java:39) at play.core.j.JavaAction$$anonfun$11.apply(JavaAction.scala:82) at play.core.j.JavaAction$$anonfun$11.apply(JavaAction.scala:82) at scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24) at scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24) at play.core.j.HttpExecutionContext$$anon$2.run(HttpExecutionContext.scala:40) at play.api.libs.iteratee.Execution$trampoline$.execute(Execution.scala:46) at play.core.j.HttpExecutionContext.execute(HttpExecutionContext.scala:32) at scala.concurrent.impl.Future$.apply(Future.scala:31) at scala.concurrent.Future$.apply(Future.scala:485) at play.core.j.JavaAction$class.apply(JavaAction.scala:82) at play.core.Router$HandlerInvokerFactory$JavaActionInvokerFactory$$anon$15$$anon$1.apply(Router.scala:252) at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4$$anonfun$apply$5.apply(Action.scala:130) at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4$$anonfun$apply$5.apply(Action.scala:130) at play.utils.Threads$.withContextClassLoader(Threads.scala:21) at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4.apply(Action.scala:129) at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4.apply(Action.scala:128) at scala.Option.map(Option.scala:145) at play.api.mvc.Action$$anonfun$apply$1.apply(Action.scala:128) at play.api.mvc.Action$$anonfun$apply$1.apply(Action.scala:121) at play.api.libs.iteratee.Iteratee$$anonfun$mapM$1.apply(Iteratee.scala:483) at play.api.libs.iteratee.Iteratee$$anonfun$mapM$1.apply(Iteratee.scala:483) at play.api.libs.iteratee.Iteratee$$anonfun$flatMapM$1.apply(Iteratee.scala:519) at play.api.libs.iteratee.Iteratee$$anonfun$flatMapM$1.apply(Iteratee.scala:519) at play.api.libs.iteratee.Iteratee$$anonfun$flatMap$1$$anonfun$apply$14.apply(Iteratee.scala:496) at play.api.libs.iteratee.Iteratee$$anonfun$flatMap$1$$anonfun$apply$14.apply(Iteratee.scala:496) at scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24) at scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24) at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:41) at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:393) at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107) org.springframework.transaction.TransactionSystemException: Could not roll back JDBC transaction; nested exception is java.sql.SQLNonTransientConnectionException: Could not send query: Last stream not finished at org.springframework.jdbc.datasource.DataSourceTransactionManager.doRollback(DataSourceTransactionManager.java:290) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:849) at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:826) at data.DefaultExchanger.importData(DefaultExchanger.java:266) at data.DataService.importData(DataService.java:196) at controllers.SiteApp.importData(SiteApp.java:314) at Routes$$anonfun$routes$1$$anonfun$applyOrElse$54$$anonfun$apply$54.apply(routes_routing.scala:2058) at Routes$$anonfun$routes$1$$anonfun$applyOrElse$54$$anonfun$apply$54.apply(routes_routing.scala:2058) at play.core.Router$HandlerInvokerFactory$$anon$4.resultCall(Router.scala:264) at play.core.Router$HandlerInvokerFactory$JavaActionInvokerFactory$$anon$15$$anon$1.invocation(Router.scala:255) at play.core.j.JavaAction$$anon$1.call(JavaAction.scala:55) at Global$1.call(Global.java:190) at actions.AnonymousCheckAction.call(AnonymousCheckAction.java:57) at utils.SiteManagerAuthAction.call(SiteManagerAuthAction.java:39) at play.core.j.JavaAction$$anonfun$11.apply(JavaAction.scala:82) at play.core.j.JavaAction$$anonfun$11.apply(JavaAction.scala:82) at scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24) at scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24) at play.core.j.HttpExecutionContext$$anon$2.run(HttpExecutionContext.scala:40) at play.api.libs.iteratee.Execution$trampoline$.execute(Execution.scala:46) at play.core.j.HttpExecutionContext.execute(HttpExecutionContext.scala:32) at scala.concurrent.impl.Future$.apply(Future.scala:31) at scala.concurrent.Future$.apply(Future.scala:485) at play.core.j.JavaAction$class.apply(JavaAction.scala:82) at play.core.Router$HandlerInvokerFactory$JavaActionInvokerFactory$$anon$15$$anon$1.apply(Router.scala:252) at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4$$anonfun$apply$5.apply(Action.scala:130) at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4$$anonfun$apply$5.apply(Action.scala:130) at play.utils.Threads$.withContextClassLoader(Threads.scala:21) at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4.apply(Action.scala:129) at play.api.mvc.Action$$anonfun$apply$1$$anonfun$apply$4.apply(Action.scala:128) at scala.Option.map(Option.scala:145) at play.api.mvc.Action$$anonfun$apply$1.apply(Action.scala:128) at play.api.mvc.Action$$anonfun$apply$1.apply(Action.scala:121) at play.api.libs.iteratee.Iteratee$$anonfun$mapM$1.apply(Iteratee.scala:483) at play.api.libs.iteratee.Iteratee$$anonfun$mapM$1.apply(Iteratee.scala:483) at play.api.libs.iteratee.Iteratee$$anonfun$flatMapM$1.apply(Iteratee.scala:519) at play.api.libs.iteratee.Iteratee$$anonfun$flatMapM$1.apply(Iteratee.scala:519) at play.api.libs.iteratee.Iteratee$$anonfun$flatMap$1$$anonfun$apply$14.apply(Iteratee.scala:496) at play.api.libs.iteratee.Iteratee$$anonfun$flatMap$1$$anonfun$apply$14.apply(Iteratee.scala:496) at scala.concurrent.impl.Future$PromiseCompletingRunnable.liftedTree1$1(Future.scala:24) at scala.concurrent.impl.Future$PromiseCompletingRunnable.run(Future.scala:24) at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:41) at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:393) at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107) Caused by: java.sql.SQLNonTransientConnectionException: Could not send query: Last stream not finished at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:123) at org.mariadb.jdbc.internal.util.ExceptionMapper.throwException(ExceptionMapper.java:69) at org.mariadb.jdbc.MariaDbStatement.executeQueryEpilog(MariaDbStatement.java:261) at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:290) at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:344) at org.mariadb.jdbc.MariaDbConnection.rollback(MariaDbConnection.java:532) at com.jolbox.bonecp.ConnectionHandle.rollback(ConnectionHandle.java:1272) at org.springframework.jdbc.datasource.DataSourceTransactionManager.doRollback(DataSourceTransactionManager.java:287) ... 46 more Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Could not send query: Last stream not finished at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.sendQuery(AbstractQueryProtocol. ``` -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mysql-connector-bug-with-bulk-insert/

1 0

[Maria-discuss] doubt how to create big query
by Roberto Spadim 10 Feb '16

10 Feb '16

hi guys i'm with a problem / possible feature request i have many tables with same structure (same fields) and i need to create a big query with all tables something like: select * from t1 union all select * from t2 union all select * from ..... ... union all select * from t99999 is there anyway to create a big query with some "template c++ like" feature? something like select * from <union all t1, t2, t3, t3, t4....> ? --- Roberto Spadim

2 4

[Maria-discuss] MariaDB/Galera Cluster with 3 nodes - Change ENGINE from MyISAM to InnoDB without crash
by Lukas Lehner 09 Feb '16

09 Feb '16

Hi http://dba.stackexchange.com/questions/128715/mariadb-galera-cluster-with-3… thanks Lukas

2 1

[Maria-discuss] New Question: How to change Innodb fileformat to Barracuda
by AskMonty KB 07 Feb '16

07 Feb '16

Hello, A new question has been asked in "XtraDB and InnoDB" by gijs. Please answer it at http://mariadb.com/kb/en/how-to-change-innodb-fileformat-to-barracuda/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I've attempted to change to the new barracuda file format. I'm using a Galera cluster (MariaDB 10.1.11) and have innodb_file_format=Barracuda set on all my servers, I've rebooted the servers and exported a database with phpmyadmin. After this I deleted the database and recreated it and then imported the previously exported .sql file with phpmyadmin. I checked the file format in INFORMATION_SCHEMA.INNODB_SYS_TABLES and found that it's still set as Antelope. Why is it not set to Barracuda? How can I change it to Barracuda? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-to-change-innodb-fileformat-to-barracuda/

1 0

[Maria-discuss] MariaDB JIRA is moving
by Rasmus Johansson 05 Feb '16

05 Feb '16

The MariaDB JIRA instance that currently is in use for project and issue tracking will change. The current instance is hosted in Atlassian's cloud and it has worked well, but we have hit the maximum user limit of 2000 users. It's fantastic to see how many of you actually report bugs and other issues in the MariaDB project! To hit that limit also means that we have to migrate over to a self-hosted instance of JIRA. Below are important details about that change. When will the switch happen: Sat 27th of Feb What is the impact for me as a user of MariaDB's JIRA: 1. URL change - The current instance is hosted in Atalassian's cloud and has the URL mariadb.atlassian.net. The new one will be found at jira.mariadb.org starting from 28th of Feb. 2. RSS feeds - If you have been using JIRA's RSS feeds, you'll need to set up them again since the URL is changing What will happen to old JIRA: The mariadb.atlassian.net JIRA instance will be put into read-only mode and a banner will be visible on each page telling the URL of the new MariaDB JIRA instance. It will remain this way for some time since it has been referenced quite heavily from other sites. source: https://mariadb.org/mariadb-jira-is-moving/ -- Rasmus Johansson, VP Engineering MariaDB | t: +358 50 499 9589 | Skype: ratzpo

1 0

[Maria-discuss] intentionally corrupting tables
by Federico Razzoli 02 Feb '16

02 Feb '16

Hi all I am looking for a way to intentionally corrupt a table in a "natural" way. Of course I can open a file with Vim and change random characters, but I would probably obtain a kind of corruption that never occurs in the real world. The purpose is testing recovery procedures. Thanks Federico

3 2

[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] New Question: Phenomenon of read-only queries performance
by AskMonty KB 02 Feb '16

02 Feb '16

Hello, A new question has been asked in "MariaDB Community" by knizhnik_g. Please answer it at http://mariadb.com/kb/en/phenomenon-of-read-only-queries-performance/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- We are evaluating Galera cluster with MariaDB and find out interesting phenomenon which we can not explain. We are using standard sysbench compex-OLAP, 10 million records. Performance of read-only queries is about 3k TPS and is quite stable. But then we run for a while read-write version and after it once again read-only version, then in this case performance starts to grow from 4k till 10k TPS. 10K TPS is reached after about 30 seconds of running benchmark and stays at this level. But if we stop benchmark and restart it, then once again speed falls down to 3k TPS. Data is located in temporary file system, so disk is not involved at all. We used recommended configuration settings for MariaDB and Galera. Also the same behavior is observed with standalone mysql without Galera: performance of read-only queries varies from 3k to 6k TPS (but high values are smaller than with Galera, although no load balancing was performed). Is there any explanation of such behavior and where we can look trying to understand the reason? Why performance of standalone mysql can be slower than on Galera cluster? How we can tune it? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/phenomenon-of-read-only-queries-performance/

1 0

[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

[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

[Maria-discuss] Select optimizations
by Roberto Spadim 20 Jan '16

20 Jan '16

Hi guys! There's a "easy/fast" way to rewrite a query from this: Select datetime,key,value from table where ... To this: Select datetime, value1 as key1, value2 as key2, .... From table where ... I don't remember the right name in R/python (pandas) language but it's something like vector/matrix merge The ideia is, instead of one line of date key vale, use a single date, and "put" values as columns, and the columns name is the key name The table structure is something like: Create table ( Datetime datetime not null, Key varchar(255) not null, Value double not null, Primary key(datetime,key) ) Any idea is wellcome I know there's many solutions, if i have >100 columns, if datetime is sparse (only one key have values per datetime value), etc etc -- Roberto Spadim SPAEmpresarial - Software ERP Eng. Automação e Controle

2 3

[Maria-discuss] New Question: Using BitNami WordPress with Amazon RDS MariaDB
by AskMonty KB 19 Jan '16

19 Jan '16

Hello, A new question has been asked in "MariaDB Community" by brasilmorar. Please answer it at http://mariadb.com/kb/en/using-bitnami-wordpress-with-amazon-rds-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Installed BitNami WordPress which is already configured and updated in an instance EC2 Amazon. Launched a database RDS MariaDB, efetuei up the MySQL database that is already inserted in BitNami stack and then sent the backup.sql for instance RDS MaridaDB. I changed the database access settings in wp-config.php file by inserting the data from the database RDS MariaDB created. Everything is working fine, but I have a doubt about the performance of the bank I have not deleted the Mysql the BitNami stack. If I'm using InnoDB tables and not the standard MariaDB tables. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/using-bitnami-wordpress-with-amazon-rds-mariadb/

1 0

[Maria-discuss] New Question: mysql_install_db
by AskMonty KB 14 Jan '16

14 Jan '16

Hello, A new question has been asked in "MariaDB Community" by skuns_35717. Please answer it at http://mariadb.com/kb/en/mariadb-community-mysql_install_db/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I'm new to maria, coming from mysql, and I'm trying to run the mysql_install_db program to create the new databases. This is what i'm executing as root: /usr/bin/mysql_install_db --user=mysql --datadir=/var/lib/mysql --basedir=/usr --force I've tried it with and without the force option. I always get the same error: ERROR: 1005 Can't create table `mysql`.`innodb_table_stats` (errno: 165 "Table is read only") 160114 11:35:10 [ERROR] Aborting Any help will be greatly appreciated. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-community-mysql_install_db/

1 0

[Maria-discuss] Are lock/unlock tables replicated in ROW / STATEMENT / MIXED r. mode
by pslawek83 13 Jan '16

13 Jan '16

Hi Guys, quick question about lock tables with replication... I basically use it to achieve atomicity of some database writes, but it seems that queries like LOCK TABLES ___tsc WRITE UNLOCK TABLES are not replicated to slave. Eg. i can lock table on master, for write, but still read from it on the slave, which could lead to issues... We're reading some data from slaves, and writing data to it atomically using LOCK TABLES, it seems that this way will lead to race conditions and inconsistent reads from the slave. Any way of having aria/myisam writes to be atomic on the slaves too? I thought to copy the table to random temporary name, do the changes and then rename... but it seems like not very optimal. Thanks.

3 2

[Maria-discuss] New Question: SQL Server replication to Maria DB
by AskMonty KB 13 Jan '16

13 Jan '16

Hello, A new question has been asked in "MariaDB Community" by zeeshan_amin. Please answer it at http://mariadb.com/kb/en/sql-server-replication-to-maria-db/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, I am new to Maria DB and have no past experience with MySQL. I am trying to create replication between SQL Server 2005 and Maria DB 10.0.14 Publication has 2 tables with close to 24 million rows, and taking a long time to load data into Maria DB. There is no other user connected to MariaDB, Looking at the workbench, i see InnoDB Buffer usage close to 87%, key Efficiency 100%, and Traffic 35KB/sec. as per current speed 2million rows an hour, its going to take 12 hours to load 24 million rows. Any help in making this load faster? Regards Zee -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/sql-server-replication-to-maria-db/

2 1

[Maria-discuss] New Question: PDF documentation going to be available anytime soon?
by AskMonty KB 12 Jan '16

12 Jan '16

Hello, A new question has been asked in "MariaDB Documentation" by dominic_baines. Please answer it at http://mariadb.com/kb/en/pdf-documentation-going-to-be-available-anytime-so… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Any update on the answer from a year ago ? Looking for mariadb documentation for offline use. The KB/documentation great IF you have internet access. Dom -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/pdf-documentation-going-to-be-available-anytime-so…

1 0

[Maria-discuss] New Question: Galera cluster fail during dump or optimize
by AskMonty KB 11 Jan '16

11 Jan '16

Hello, A new question has been asked in "MariaDB Galera Cluster" by gijs. Please answer it at http://mariadb.com/kb/en/galera-cluster-fail-during-dump-or-optimize/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I'm experiencing an issue with a MariaDB cluster when dumping or optimizing databases. When I run a a "mysqlcheck" or a "mysqldump" on my Mariadb 10.1.10 database server (which runs in a Galera cluster with two other servers) then the tasks stop after a short time and don't show any progress. The entire cluster seems to stall. For example the mysqldump stops after creating an 14,0 MB (14.760.912 bytes) dump file and doesn't proceed, even after several minutes nothing happens. The mysqlcheck to repair and optimize tables also hangs after checking a few tables. In both situations the cluster starts to have issues and the only way to get it to work normally again is by taking the server that executed the job offline and also taking another server offline. I then take them back online on by one and the cluster works normally again. I'm not sure what is causing these problems. I haven't found any errors in the syslog, although during the shutdown of the servers I noticed the following: Jan 10 20:43:46 france mysqld[1015]: 2016-01-10 20:43:46 140096330258176 [Warning] WSREP: TO isolation failed for: 3, schema: mysql, sql: OPTIMIZE TABLE proc. Check wsrep connection state and retry the query. Jan 10 21:58:47 france mysqld[1034]: 2016-01-10 21:58:47 139691511322368 [Warning] WSREP: TO isolation failed for: 3, schema: smf, sql: OPTIMIZE TABLE smf_categories. Check wsrep connection state and retry the query. Jan 10 21:58:47 france mysqld[1034]: 2016-01-10 21:58:47 139691511322368 [Warning] Aborted connection 24 to db: 'smf' user: 'maintenance' host: 'localhost' (Unknown error) Jan 10 21:58:47 france mysqld[1034]: 2016-01-10 21:58:47 139691509827328 [Warning] WSREP: TO isolation failed for: 3, schema: (null), sql: SELECT 1 FROM mysql.user LIMIT 1. Check wsrep connection state and retry the query. Any idea what could be the cause of this? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/galera-cluster-fail-during-dump-or-optimize/

1 0

[Maria-discuss] mariadb still uses indexes with high average value group size.
by dE 09 Jan '16

09 Jan '16

Hi! I was playing around with indexes after we faced problems with mariadb choosing the wrong index because of high average value group size. So I created a table with 4 text columns and indexed the 4th column with a prefix length of 1. Following are the stats in brief -- The index has 35 unique values There are around 1040000 rows in total. this will give an average value group size of 29714 Cardinality is calculated as <no. of records in the index>/<average size of value groups>, thus it's value must be 35 BUT from show indexes, it's value is shown as 72 (innodb_stats_persistent_sample_pages = 9999999).

3 4

[Maria-discuss] New Question: Connect DB2 table via ODBC with CLOB or Text datatype.
by AskMonty KB 08 Jan '16

08 Jan '16

Hello, A new question has been asked in "CONNECT" by mldudding. Please answer it at http://mariadb.com/kb/en/connect-db2-table-via-odbc-with-clob-or-text-datat… as the person asking the question may not be subscribed to the mailing list. -------------------------------- I am attempting to connect a DB2 table using the following command line: create table TASKS engine=connect table_type=ODBC block_size=1000 tabname='ISW.TASKS' connection='DSN=DB2_ODBC;UID=user;PWD=password;MODE=SHARE;DBALIAS=SCODS;'; and I receive the following error: ERROR 1105 (HY000): Unsupported SQL type -99 My belief is that because CONNECT is retrieving the table description using ODBC catalog functions and since the DB2 table contains a column that has a datatype of CLOB that Mariadb is throwing the above error. When I attempt to specify the column definitions for the DB2 table, and define the column as TEXT or BLOB, I receive the following error: SQL Error (1163): Storage engine CONNECT doesn't support BLOB/TEXT columns. Is there a way to CONNECT a DB2 table via ODBC or Direct Connection to a table that contains CLOB or Text defined columns? I do not have any issue connecting other tables from the DB2 database that do not contain CLOB datatypes. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/connect-db2-table-via-odbc-with-clob-or-text-datat…

1 0

[Maria-discuss] New Question: MariaDb vs Oracle
by AskMonty KB 06 Jan '16

06 Jan '16

Hello, A new question has been asked in "MariaDB Community" by dbamaria. Please answer it at http://mariadb.com/kb/en/mariadb-vs-oracle/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, I have to find out in MariaDb how to implement some features used in Oracle . I have : - Load a file: in Oracle I use the external table. Is there a way (fast and efficient one ) to load a file into a table . Has MariaDb a plugin which allows to load well a specific format of files? - In my existing Oracle code I used to developp a java wrap functions which allow those feature (is there a way in MariaDb to do this?), specifically : 1- Searching a files in an OS directory and insert them in a table, 2- send an SNMP trap 3- Send a mail via SMTP - Is there an equivalent to an Oracle job in Mariadb? - Is there an equivalent to Oracle TDE (Transparent data encryption) ? -Is there an equivalent to the VPD (virtual private policy)? Many Thanks and Best Regards -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-vs-oracle/

1 0

[Maria-discuss] Transportable (portable) tablespaces
by Colin Charles 05 Jan '16

05 Jan '16

Hi, I haven’t tested this yet (the joys of vacation that still keeps you coming back to the lists), but thought I’d approach this as a user searching the Knowledgebase :-) This is a feature from 5.6, and it has improved in 5.7. I saw https://mariadb.atlassian.net/browse/MDEV-4299 saying that it works (looks like Serg did the merge — http://bazaar.launchpad.net/~maria-captains/maria/10.0/revision/3965.1.18 for 10.0.8), but I couldn’t find any documentation suggesting that such a feature exists, eg. https://dev.mysql.com/doc/refman/5.7/en/innodb-transportable-tablespace-exa… One of the “improvements” that I guess we’ll be getting is, the ability to use the CREATE TABLESPACE command — https://dev.mysql.com/doc/refman/5.7/en/create-tablespace.html (vs. https://mariadb.com/kb/en/mariadb/create-tablespace/) Looking forward to more information/discussion, and also if this is a docs bug, I guess I CC’ed Ian cheers, -colin -- Colin Charles, http://bytebot.net/blog/ twitter: @bytebot | skype: colincharles "First they ignore you, then they laugh at you, then they fight you, then you win." -- Mohandas Gandhi

2 1

[Maria-discuss] New Question: start the first cluster node failed with libssl.so.6 problem
by AskMonty KB 04 Jan '16

04 Jan '16

Hello, A new question has been asked in "MariaDB Galera Cluster" by yu.d.sun_32615. Please answer it at http://mariadb.com/kb/en/start-the-first-cluster-node-failed-with-libsslso6… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, All Mariadb galera Version: 10.0.21 OS: Redhat 6 : 2.6.32-504.23.4.el6.x86_64 I installed the software from tarball. When i tried to start the first node with: ./bin/mysqld_safe --defaults-file=$MYSQL_HOME/my.cnf --wsrep-new-cluster & in error log: 160104 11:23:01 [Note] WSREP: wsrep_load(): loading provider library '/apps/opt/mysql/galera-10.0.21/lib/libgalera_smm.so' 160104 11:23:01 [ERROR] WSREP: wsrep_load(): dlopen(): libssl.so.6: cannot open shared object file: No such file or directory 160104 11:23:01 [ERROR] WSREP: wsrep_load(/apps/opt/mysql/galera-10.0.21/lib/libgalera_smm.so) failed: Invalid argument (22). Reverting to no provider. 160104 11:23:01 [Note] WSREP: Read nil XID from storage engines, skipping position init 160104 11:23:01 [Note] WSREP: wsrep_load(): loading provider library 'none' 160104 11:23:01 [ERROR] Aborting I guess this is sth related to openssl version: openssl-1.0.1e-30.el6_6.11.x86_64 I can install and configure 10.0.21 cluster without any problem in CentOS 5.5 Any suggestions on how to work around openssl problem? Downgrade openssl ? or If i compile the source in redhat OS 6,will that help? Anyone has installed any version of Mariadb Galera cluster in any version of Redhat/CentOS linux above 5? Denis -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/start-the-first-cluster-node-failed-with-libsslso6…

1 0

[Maria-discuss] mariadb prefers using indexes despite low cardinality
by dE 02 Jan '16

02 Jan '16

Hi! Taking the example as provided in my last mail: I created a table with 4 text columns and indexed the 4th column with a prefix length of 1. To trigger high no. of index scans I used the following where clause -- f4 like 'klas9dufa9us09df8a8%' Explain shows mariadb still chooses to use the index despite high no. of scans required.

1 0

[Maria-discuss] Syslog facility & IST receive address
by Bertrand Caplet 02 Jan '16

02 Jan '16

Hi all, I was wondering how can I change both change Mariadb and Galera (wsrep) syslog facility then make syslog logging in a separate logfile ? I've got another question, I have 3 galera nodes and one has local ip so it use NAT for communicating with other nodes. SST is alright because I set "wsrep_sst_receive_address" to public IP. But for IST it seems there is no parameters for that and I have some issues when nodes are transfering incremental snapshots in one way. How could I manage to do it ? Thanks in advance, Regards, -- CHUNKZ.NET - script kiddie and computer technician Bertrand Caplet, Flers (FR) Feel free to send encrypted/signed messages Key ID: 37F70C30 GPG FP: 134A 4027 518B 5F4D D409 558D BA9B 7BF0 37F7 0C30

1 0

[Maria-discuss] New Question: Why two versions (10.0 and 10.1)?
by AskMonty KB 01 Jan '16

01 Jan '16

Hello, A new question has been asked in "MariaDB Community" by HGP-IT. Please answer it at http://mariadb.com/kb/en/why-two-versions-100-and-101/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello, We run a number of MariaDB v10.0.x installations for in-house projects, and I have only just realized that there's a v10.1.x version. I have begun reading about the differences, and that there's an upgrade procedure. Forgive the (likely) newb question, but was it totally necessary to create a new version of MariaDB for these changes? I mean, when 10.2 is released (and 10.3, 10.4 etc), is it going to be another whole new release with separate upgrade/versioning paths? Surely from a development management perspective this creates resource overheads for you? Will v10.0 cease development in the near future, to be replaced by v10.1? I am trying to decide whether I just should upgrade our systems to v10.1. Just wondering :) Thank you! Elliot -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/why-two-versions-100-and-101/

1 0

[Maria-discuss] New Question: Upgrading from MariaDB 10.0 to 10.1 under Windows
by AskMonty KB 28 Dec '15

28 Dec '15

Hello, A new question has been asked in "Upgrading MariaDB" by wschwarz. Please answer it at http://mariadb.com/kb/en/upgrading-from-mariadb-100-to-101-under-windows/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Upgrading from MariaDB 10.0 to 10.1 on a Windows System. Must i do some especial thing with a master slave replication system? Which one must I update first master or slave? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/upgrading-from-mariadb-100-to-101-under-windows/

1 0

[Maria-discuss] MariaDB init.d Script Probable Bug in wait_for_ready()
by Joy Bhattacherjee 27 Dec '15

27 Dec '15

Hi, Context: ----------- Version: MariaDB 10.0 Repo: http://yum.mariadb.org/10.0/centos7-amd64 OS: CentOS Linux release 7.2.1511 Kernel: 3.10.0-229.7.2.el7.x86_64 Cloud Provider: Windows Azure I run a three-node MariaDB-Galera cluster on production for my company. With the custom config file at: */etc/my.cnf.d/server.cnf* My datadisk is mounted over a lvm2 partition over two physical volumes, mounted on the path. */datadrive/galera/mysql* The logical volume only takes up 50% of the volume group as I leave the empty space for snapshot operations. This is reflected in my configuration as: *[mysqld]* *datadir = /datadrive/galera/mysql * *socket = /datadrive/galera/mysql/mysql.sock * Issue: -------- Coming to the issue at hand; When starting the primary component through: *$ sudo service mysql bootstrap* or, *$ sudo service mysqld start --wsrep-new-cluster* ( Essentially same, as bootstrap differs to *start --wsrep_new_cluster *) The bootstrap sequence correctly calls mysqldsafe, as below */usr/bin/mysqld_safe --datadir=/datadrive/galera/mysql --pid-file=/datadrive/galera/mysql/ciq-test-db01.pid --wsrep-new-cluster* However, it then gets stuck in the *wait_for_ready() function of /etc/init.d/mysql* The sequence tries to ping mysqladmin through: * if $bindir/mysqladmin ping >/dev/null 2>&1; then* *log_success_msg* * return 0* *elif kill -0 $! 2>/dev/null ; then* * : # mysqld_safe is still running* *else* * # mysqld_safe is no longer running, abort the wait loop* * break* It gets stuck here as the test: * if $bindir/mysqladmin ping >/dev/null 2>&1; then* Always fails and the counter keeps increasing till 900 and Error's out with the *log_failure_msg* *return 1* Test: I tested that line from the console as: *$mysqladmin ping >dev/null 2>&1* and, was thrown the following error: *mysqladmin: connect to server at 'localhost' failed* *error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "**No such file or directory")'* *Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!* Obviously, '*/var/lib/mysql' *does not exist in my setup, and the socket file was at *'/datadrive/galera/mysql/mysql.sock'* But, my socket can be passed explicitly to *mysqladmin *by doing, *$mysqladmin --socket=**/datadrive/galera/mysql/mysql.sock ping* This actually worked as expected and I got the desired output, *mysqld is alive* Solution: ----------- What I surmised through my novice abilities was that the init script was not passing the variables it read from */etc/my.cnf.d/server.cnf to mysqladmin* So, for now I have done a hackjob by altering the init script function wait_for_ready() with the test: *if $bindir/mysqladmin --socket=/datadrive/galera/mysql/mysql.sock ping >/dev/null 2>&1; then* * log_success_msg* * return 0* And voila, *$ sudo service mysql start* *$ sudo service mysql start --wsrep-new-cluster* *$ sudo service mysql bootstrap* All above works. It is evident that I should be passing all the variables from */etc/my.cnf.d/server.cnf *that *mysqladmin *needs to set it's environement correctly. However I think that this could be / should be done on the pre-distributed init script itself rather than a user-side hack. While I have tried to be thorough in my inspection of the issue, I may have missed either something very basic or inherently complex that's currently is inherent to the process of initializing the mysql service. Please redirect me to a corrected course if that is the case. P.S. First time post in the list, I may have stated things unacceptably P.P.S. Merry Christmas to you all. Thanks and regards, Joy Bhattacherjee Mob: +91-9011235028

3 3

[Maria-discuss] Weighted Quorum for Three Nodes
by Tom Worster 27 Dec '15

27 Dec '15

In the Galera docs <http://galeracluster.com/documentation-webpages/weightedquorum.html#weighte d-quorum-for-three-nodes> I read > When configuring quorum weights for three nodes, use the following pattern: > node1: pc.weight = 2 > node2: pc.weight = 1 > node3: pc.weight = 0 > Under this pattern, killing node2 and node3 simultaneously preserves the > Primary Component > <http://galeracluster.com/documentation-webpages/glossary.html#term-primary-… > mponent> on node1. Killing node1 causes node2 and node3 to become > non-primary components. The wording makes it sound as though this is a general recommendation. But, iiuc, this cluster of 3 nodes has a single point of failure: node1. How is this desirable? Tom

2 1

[Maria-discuss] R: CONNECT storage engine
by Federico Razzoli 24 Dec '15

24 Dec '15

A new version of CONNECT package was released, but you have still 10.1.9. The packages don't conflict, but versions are incompatible. Just run apt-get upgrade and CONNECT will work. Regards Federico -------------------------------------------- Gio 24/12/15, Karol Krasňan <karol(a)krasnan.eu> ha scritto: Oggetto: [Maria-discuss] CONNECT storage engine A: maria-discuss(a)lists.launchpad.net Data: Giovedì 24 dicembre 2015, 14:44 #yiv1836587082 blockquote.yiv1836587082cite {margin-left:5px;margin-right:0px;padding-left:10px;padding-right:0px;border-left:1px solid #cccccc;} #yiv1836587082 blockquote.yiv1836587082cite2 {margin-left:5px;margin-right:0px;padding-left:10px;padding-right:0px;border-left:1px solid #cccccc;margin-top:3px;padding-top:0px;} #yiv1836587082 .yiv1836587082plain pre, #yiv1836587082 .yiv1836587082plain tt {font-family:monospace;font-size:100%;font-weight:normal;font-style:normal;white-space:pre-wrap;} #yiv1836587082 a img {border:0px;}#yiv1836587082 body {font-family:Tahoma;font-size:12pt;} #yiv1836587082 .yiv1836587082plain pre, #yiv1836587082 .yiv1836587082plain tt {font-family:Tahoma;font-size:12pt;} Hello all, I have problem with CONNECT storage engine. I am using MariaDB 10.1.9 on Debian Jessie, with actual version mariadb-connect-engine. But when ha_connect.so plugin is loaded, server show error and dont load engine. "Can't open shared library 'ha_connect.so' (errno: 8, API version for STORAGE ENGINE plugin CONNECT not supported by this version of the server)" I am not able find any solution of this problem. Thanks for help and Merry Christmas :) Karol -----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] CONNECT storage engine
by Karol Krasňan 24 Dec '15

24 Dec '15

Hello all, I have problem with CONNECT storage engine. I am using MariaDB 10.1.9 on Debian Jessie, with actual version mariadb-connect-engine. But when ha_connect.so plugin is loaded, server show error and dont load engine. "Can't open shared library 'ha_connect.so' (errno: 8, API version for STORAGE ENGINE plugin CONNECT not supported by this version of the server)" I am not able find any solution of this problem. Thanks for help and Merry Christmas :) Karol

1 0

[Maria-discuss] MariaDB 10.1.10 and MariaDB Galera Cluster 10.0.23 & 5.5.47 now available
by Daniel Bartholomew 24 Dec '15

24 Dec '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.10, MariaDB Galera Cluster 5.5.47, and MariaDB Galera Cluster 10.0.23. These are all Stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.10 - https://mariadb.com/kb/en/mdb-10110-rn/ - https://mariadb.com/kb/en/mdb-10110-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.1.10 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 5.5.47 - https://mariadb.com/kb/en/mgc-5547-rn/ - https://mariadb.com/kb/en/mgc-5547-cl/ - Downloads: https://downloads.mariadb.org/mariadb-galera/5.5.47 MariaDB Galera Cluster 10.0.23 - https://mariadb.com/kb/en/mgc-10023-rn/ - https://mariadb.com/kb/en/mgc-10023-cl/ - Downloads: https://downloads.mariadb.org/mariadb-galera/10.0.23 About MariaDB Galera Cluster: https://mariadb.com/kb/en/what-is-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/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

1 0

[Maria-discuss] New Question: Maria db with ssrs reports using Microsoft Report Builder
by AskMonty KB 23 Dec '15

23 Dec '15

Hello, A new question has been asked in "MariaDB FAQ" by abin. Please answer it at http://mariadb.com/kb/en/maria-db-with-ssrs-reports-using-microsoft-report-… as the person asking the question may not be subscribed to the mailing list. -------------------------------- I tried to use maria db with ssrs reports using ODBC in Microsoft sql report builder.I installed Mysql ODBC connector in my machine and was successful in connecting with maria db.But after saving the report and reopening the report in report builder ,its asking user login name and password. How can I remove the credentials, which is asked repeatedly while reopening the report? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/maria-db-with-ssrs-reports-using-microsoft-report-…

1 0

Re: [Maria-discuss] enforce_storage_engine galera cluster
by Federico Razzoli 22 Dec '15

22 Dec '15

I didn't suggest to use MyISAM :) Now I understand your purpose. If you use MaxScale, you can use a filter and replace MyISAM with InnoDB. Something like: /engine( )*=( *)myisam/i And you can use similar regexps for each storage engine. The filter that you need is this one: https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/F… Hope that this helps. Federico -------------------------------------------- Mar 22/12/15, Michele Tota <michele.tota(a)lnf.infn.it> ha scritto: Oggetto: Re: [Maria-discuss] enforce_storage_engine galera cluster A: maria-discuss(a)lists.launchpad.net Data: Martedì 22 dicembre 2015, 14:29 Thank you all, we're going to open a bug as soon as possible; @Federico: Thanks for the suggestion, but we are interested in forcing engine substitution, because this way a table creation made by a generic user can be issued using both InnoDB and MyISAM (users can't be always aware of which engine is actually reported in a scripted creation) can produce only InnoDB tables that can be actually replicated on other nodes (as you stated previously). Anyway, this bug seems to break our plans, so we should report the bug and find another way in the meanwhile....in addition, MyISAM replication is described as experimental and we don't want to use it in such early development phase. Thank you very much again for the support. On 22/12/2015 13:03, Roberto Spadim wrote: in my opnion, itś a bug, report to jira issue tracker 2015-12-22 10:00 GMT-02:00 Federico Razzoli <federico_raz(a)yahoo.it>: Sounds like a bug. But, bug or not bug, I suggest you set sql_mode = 'NO_ENGINE_SUBSTITUTION'. Changes to non-InnoDB tables are NOT replicated. (There seems to be a sort of support for MyISAM, but it's unreliable and needs to be manually enabled on all nodes) Federico -------------------------------------------- Mar 22/12/15, Michele Tota <michele.tota(a)lnf.infn.it> ha scritto: Oggetto: Re: [Maria-discuss] enforce_storage_engine galera cluster A: maria-discuss(a)lists.launchpad.net Data: Martedì 22 dicembre 2015, 12:22 Thanks guys, as Ian has pointed out, in recent releases sql_mode contains by default NO_ENGINE_SUBSTITUTION so in our deployment we set sql_mode to blank to gracefully use InnoDB when MyISAM table creation is issued. To be clearer on the problem we're experiencing, I'll paste some console output. On the first node we have: MariaDB [galera_test]> SHOW VARIABLES WHERE Variable_name='enforce_storage_engine' OR Variable_name='sql_mode'; +------------------------+--------+ | Variable_name | Value | +------------------------+--------+ | enforce_storage_engine | InnoDB | | sql_mode | | +------------------------+--------+ 2 rows in set (0.00 sec) MariaDB [galera_test]> CREATE TABLE table_1(id INTEGER) ENGINE=InnoDB; Query OK, 0 rows affected (0.01 sec) MariaDB [galera_test]> CREATE TABLE table_2(id INTEGER) ENGINE=MyISAM; Query OK, 0 rows affected, 1 warning (0.00 sec) MariaDB [galera_test]> SHOW WARNINGS; +-------+------+-------------------------------------------------+ | Level | Code | Message | +-------+------+-------------------------------------------------+ | Note | 1266 | Using storage engine InnoDB for table 'table_2' | +-------+------+-------------------------------------------------+ 1 row in set (0.00 sec) MariaDB [galera_test]> SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES where TABLE_SCHEMA = 'galera_test'; +------------+--------+ | TABLE_NAME | ENGINE | +------------+--------+ | table_1 | InnoDB | | table_2 | InnoDB | +------------+--------+ 2 rows in set (0.00 sec) Please note that in table_2 creation we obtain a warning (not an error), and table_2 is correctly created using InnoDB, and until this point, everything is working great. When we check the same table on another cluster node, we have: MariaDB [galera_test]> SHOW VARIABLES WHERE Variable_name='enforce_storage_engine' OR Variable_name='sql_mode'; +------------------------+--------+ | Variable_name | Value | +------------------------+--------+ | enforce_storage_engine | InnoDB | | sql_mode | | +------------------------+--------+ 2 rows in set (0.00 sec) MariaDB [galera_test]> SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES where TABLE_SCHEMA = 'galera_test'; +------------+--------+ | TABLE_NAME | ENGINE | +------------+--------+ | table_1 | InnoDB | | table_2 | MyISAM | +------------+--------+ 2 rows in set (0.00 sec) MariaDB [galera_test]> SHOW TABLE STATUS WHERE Name = 'table_2'; +---------+--------+---------+------------+------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +---------+--------+---------+------------+------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+ | table_2 | MyISAM | 10 | Fixed | 0 | 0 | 0 | 1970324836974591 | 1024 | 0 | NULL | 2015-12-22 11:08:34 | 2015-12-22 11:08:34 | NULL | latin1_swedish_ci | NULL | | | +---------+--------+---------+------------+------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+ 1 row in set (0.00 sec) As you can note, creating a MyISAM table (table_2) on the first node produces a correct InnoDB table, but replication of the same table on the other cluster nodes happens using MyISAM engine. It seems like engine enforcing is used during creation but not during replication.... On 21/12/2015 20:34, Ian Gilfillan wrote: On 21/12/2015 20:10, Nirbhay Choubey wrote: On Mon, Dec 21, 2015 at 12:47 PM, Michele Tota <michele.tota(a)lnf.infn.it> wrote: Hello Nirbhay, thanks for your reply. We have the 10.1.9 mariadb version; the bug that your refers is similar but in our case the enforcing works properly on the node used for the initial write, while replicated writes on other nodes generate tables using another engine. I tried the following on 10.1.9 : Version: Server version: 10.1.9-MariaDB-debug-log Source distribution Node 1: MariaDB [test]> SET @@enforce_storage_engine=INNODB; Query OK, 0 rows affected (0.01 sec) MariaDB [test]> CREATE TABLE t1(i INT) ENGINE=INNODB; Query OK, 0 rows affected (0.07 sec) MariaDB [test]> CREATE TABLE t2(i INT) ENGINE=MYISAM; ERROR 1286 (42000): Unknown storage engine 'MyISAM' Node 2: MariaDB [test]> SHOW TABLES; +----------------+ | Tables_in_test | +----------------+ | t1 | +----------------+ 1 row in set (0.00 sec) Do you get different results? Or your's is a different scenario altogether? Best, Nirbhay From the sounds of it, the sql_mode option NO_ENGINE_SUBSTITUTION is set differently in Nirbhay and Michele's scenarios, so the MyISAM table is converted to InnoDB with a warning in one, and fails in the other. _______________________________________________ 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 -----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 _______________________________________________ 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 -- Roberto Spadim SPAEmpresarial - Software ERP Eng. Automação e Controle _______________________________________________ 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 -----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

2 1

Re: [Maria-discuss] enforce_storage_engine galera cluster
by Federico Razzoli 22 Dec '15

22 Dec '15

Sounds like a bug. But, bug or not bug, I suggest you set sql_mode = 'NO_ENGINE_SUBSTITUTION'. Changes to non-InnoDB tables are NOT replicated. (There seems to be a sort of support for MyISAM, but it's unreliable and needs to be manually enabled on all nodes) Federico -------------------------------------------- Mar 22/12/15, Michele Tota <michele.tota(a)lnf.infn.it> ha scritto: Oggetto: Re: [Maria-discuss] enforce_storage_engine galera cluster A: maria-discuss(a)lists.launchpad.net Data: Martedì 22 dicembre 2015, 12:22 Thanks guys, as Ian has pointed out, in recent releases sql_mode contains by default NO_ENGINE_SUBSTITUTION so in our deployment we set sql_mode to blank to gracefully use InnoDB when MyISAM table creation is issued. To be clearer on the problem we're experiencing, I'll paste some console output. On the first node we have: MariaDB [galera_test]> SHOW VARIABLES WHERE Variable_name='enforce_storage_engine' OR Variable_name='sql_mode'; +------------------------+--------+ | Variable_name | Value | +------------------------+--------+ | enforce_storage_engine | InnoDB | | sql_mode | | +------------------------+--------+ 2 rows in set (0.00 sec) MariaDB [galera_test]> CREATE TABLE table_1(id INTEGER) ENGINE=InnoDB; Query OK, 0 rows affected (0.01 sec) MariaDB [galera_test]> CREATE TABLE table_2(id INTEGER) ENGINE=MyISAM; Query OK, 0 rows affected, 1 warning (0.00 sec) MariaDB [galera_test]> SHOW WARNINGS; +-------+------+-------------------------------------------------+ | Level | Code | Message | +-------+------+-------------------------------------------------+ | Note | 1266 | Using storage engine InnoDB for table 'table_2' | +-------+------+-------------------------------------------------+ 1 row in set (0.00 sec) MariaDB [galera_test]> SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES where TABLE_SCHEMA = 'galera_test'; +------------+--------+ | TABLE_NAME | ENGINE | +------------+--------+ | table_1 | InnoDB | | table_2 | InnoDB | +------------+--------+ 2 rows in set (0.00 sec) Please note that in table_2 creation we obtain a warning (not an error), and table_2 is correctly created using InnoDB, and until this point, everything is working great. When we check the same table on another cluster node, we have: MariaDB [galera_test]> SHOW VARIABLES WHERE Variable_name='enforce_storage_engine' OR Variable_name='sql_mode'; +------------------------+--------+ | Variable_name | Value | +------------------------+--------+ | enforce_storage_engine | InnoDB | | sql_mode | | +------------------------+--------+ 2 rows in set (0.00 sec) MariaDB [galera_test]> SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES where TABLE_SCHEMA = 'galera_test'; +------------+--------+ | TABLE_NAME | ENGINE | +------------+--------+ | table_1 | InnoDB | | table_2 | MyISAM | +------------+--------+ 2 rows in set (0.00 sec) MariaDB [galera_test]> SHOW TABLE STATUS WHERE Name = 'table_2'; +---------+--------+---------+------------+------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +---------+--------+---------+------------+------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+ | table_2 | MyISAM | 10 | Fixed | 0 | 0 | 0 | 1970324836974591 | 1024 | 0 | NULL | 2015-12-22 11:08:34 | 2015-12-22 11:08:34 | NULL | latin1_swedish_ci | NULL | | | +---------+--------+---------+------------+------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+ 1 row in set (0.00 sec) As you can note, creating a MyISAM table (table_2) on the first node produces a correct InnoDB table, but replication of the same table on the other cluster nodes happens using MyISAM engine. It seems like engine enforcing is used during creation but not during replication.... On 21/12/2015 20:34, Ian Gilfillan wrote: On 21/12/2015 20:10, Nirbhay Choubey wrote: On Mon, Dec 21, 2015 at 12:47 PM, Michele Tota <michele.tota(a)lnf.infn.it> wrote: Hello Nirbhay, thanks for your reply. We have the 10.1.9 mariadb version; the bug that your refers is similar but in our case the enforcing works properly on the node used for the initial write, while replicated writes on other nodes generate tables using another engine. I tried the following on 10.1.9 : Version: Server version: 10.1.9-MariaDB-debug-log Source distribution Node 1: MariaDB [test]> SET @@enforce_storage_engine=INNODB; Query OK, 0 rows affected (0.01 sec) MariaDB [test]> CREATE TABLE t1(i INT) ENGINE=INNODB; Query OK, 0 rows affected (0.07 sec) MariaDB [test]> CREATE TABLE t2(i INT) ENGINE=MYISAM; ERROR 1286 (42000): Unknown storage engine 'MyISAM' Node 2: MariaDB [test]> SHOW TABLES; +----------------+ | Tables_in_test | +----------------+ | t1 | +----------------+ 1 row in set (0.00 sec) Do you get different results? Or your's is a different scenario altogether? Best, Nirbhay From the sounds of it, the sql_mode option NO_ENGINE_SUBSTITUTION is set differently in Nirbhay and Michele's scenarios, so the MyISAM table is converted to InnoDB with a warning in one, and fails in the other. _______________________________________________ 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 -----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

3 2

[Maria-discuss] enforce_storage_engine galera cluster
by Michele Tota 22 Dec '15

22 Dec '15

Hi, we have a problem using enforce_storage_engine variable set to InnoDB. We have three servers in cluster (multi masters). When we issue create table with engine=MyISAM the engine is correctly enforced to InnoDB only on the node we are connected to. On the other nodes the replicated table is created as MyISAM. This is our servers configuration, the same on all nodes: ... enforce_storage_engine='InnoDB' wsrep_on=ON sql_mode='' ... How can we enforce InnoDB on all nodes? Thanks, Michele

3 5

[Maria-discuss] Announcing release for MariaDB 5.5 and 10.0 on CentOS Linux 6 and 7 x86_64 SCL
by Honza Horak 21 Dec '15

21 Dec '15

I am pleased to announce the immediate availability of versions 5.5 and 10.0 of the MariaDB server on CentOS Linux 6 and 7 x86_64, delivered via a Software Collection (SCL) built by the SCLo Special Interest Group (https://wiki.centos.org/SpecialInterestGroup/SCLo) QuickStart ---------- You can get started in three easy steps (example of MariaDB 10.0): $ sudo yum install centos-release-scl $ sudo yum install rh-mariadb100 $ scl enable rh-mariadb100 bash At this point you should be able to use MariaDB just as a normal application. An examples of commands run might be: $ service rh-mariadb100-mariadb start $ mysql In order to view the individual components included in this collection, including additional subpackages plugins, you can run: $ sudo yum list rh-mariadb100\* About Software Collections -------------------------- Software Collections give you the power to build, install, and use multiple versions of software on the same system, without affecting system-wide installed packages. Each collection is delivered as a group of RPMs, with the grouping being done using the name of the collection as a prefix of all packages that are part of the software collection. The collection rh-mariadb100 delivers version 10.0 of the MariaDB server (with daemon called rh-mariadb100-mariadb) and related client tools. The collection mariadb55 delivers version 5.5 of the MariaDB server (with daemon called mariadb55-mariadb) and related client tools. Both the collections include no client library libmysqlclient.so and client applications are advised to use the client library available in mysql-libs package from base system. For more on the MariaDB, see https://mariadb.org. The SCLo SIG in CentOS ---------------------- The Software Collections SIG group is an open community group co-ordinating the development of the SCL technology, and helping curate a reference set of collections. In addition to the MariaDB collections being released here, we also build and deliver other databases, web servers, and language stacks including multiple versions of MySQL, PostgreSQL, MongoDB Apache HTTP Server, NodeJS, Ruby, Python and others. Software Collections SIG release was announced at https://lists.centos.org/pipermail/centos-announce/2015-October/021446.html You can learn more about Software Collections concepts at: http://softwarecollections.org You can find information on the SIG at https://wiki.centos.org/SpecialInterestGroup/SCLo ; this includes howto get involved and help with the effort. We meet every second Wednesday at 16:00 UTC in #centos-devel (ref: https://www.centos.org/community/calendar) for an informal open forum open to anyone who might have comments, concerns or wants to get started with SCL's in CentOS. Enjoy! Honza SCLo SIG member

1 0

[Maria-discuss] MariaDB 10.0.23 now available
by Daniel Bartholomew 19 Dec '15

19 Dec '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.23. This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.23 - Release Notes: https://mariadb.com/kb/en/mdb-10023-rn - Changelog: https://mariadb.com/kb/en/mdb-10023-cl - Downloads: https://downloads.mariadb.org/mariadb/10.0.23 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

3 2

[Maria-discuss] New Question: Slow query log and long_query_time
by AskMonty KB 18 Dec '15

18 Dec '15

Hello, A new question has been asked in "Slow Query Log" by yu.d.sun_32615. Please answer it at http://mariadb.com/kb/en/slow-query-log-and-long_query_time/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- In my understanding if we enable slow query log, MySQL will capture all SQL statements that take more than long_query_time seconds to execute into the log. If so below testing puzzled me: Server version: 10.0.21-MariaDB-wsrep-log MariaDB Server, wsrep_25.10.r4144 === in the mysql CLI ================== ip-10-74-2-218$ root@localhost[galeratest] MYSQL> select now(); +---------------------+ | now() | +---------------------+ | 2015-12-18 11:12:50 | +---------------------+ 1 row in set (0.00 sec) ip-10-74-2-218$ root@localhost[galeratest] MYSQL> show variables like 'long%'; +-----------------+-----------+ | Variable_name | Value | +-----------------+-----------+ | long_query_time | 10.000000 | +-----------------+-----------+ 1 row in set (0.00 sec) ip-10-74-2-218$ root@localhost[galeratest] MYSQL> select count(*) from test_table; +----------+ | count(*) | +----------+ | 13 | +----------+ 1 row in set (0.00 sec) ip-10-74-2-218$ root@localhost[galeratest] MYSQL> select sleep(5); +----------+ | sleep(5) | +----------+ | 0 | +----------+ 1 row in set (5.00 sec) ip-10-74-2-218$ root@localhost[galeratest] MYSQL> select sleep(11); +-----------+ | sleep(11) | +-----------+ | 0 | +-----------+ 1 row in set (11.00 sec) ip-10-74-2-218$ root@localhost[galeratest] MYSQL> select count(*) from test_table; +----------+ | count(*) | +----------+ | 13 | +----------+ 1 row in set (0.00 sec) ip-10-74-2-218$ root@localhost[galeratest] MYSQL> ==== from the slow query log ================== # Time: 151218 11:13:12 # User@Host: root[root] @ localhost [] # Thread_id: 125 Schema: galeratest QC_hit: No # Query_time: 0.000163 Lock_time: 0.000075 Rows_sent: 1 Rows_examined: 13 SET timestamp=1450465992; select count(*) from test_table; # Time: 151218 11:13:48 # User@Host: root[root] @ localhost [] # Thread_id: 125 Schema: galeratest QC_hit: No # Query_time: 11.002494 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0 SET timestamp=1450466028; select sleep(11); # Time: 151218 11:14:10 # User@Host: root[root] @ localhost [] # Thread_id: 125 Schema: galeratest QC_hit: No # Query_time: 0.000159 Lock_time: 0.000073 Rows_sent: 1 Rows_examined: 13 SET timestamp=1450466050; select count(*) from test_table; ================ Question - why the 'select count(*) from test_table' statement is captured while it seems right that select sleep(11) got captured and sleep(5) did not? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/slow-query-log-and-long_query_time/

1 0

[Maria-discuss] New mariadb.org in the works
by Otto Kekäläinen 18 Dec '15

18 Dec '15

Hello! We are about to renew the mariadb.org website. The idea is to replace the current mariadb.org and blog.mariadb.org with one single site that includes both the basic information about the software project and the MariaDB Foundation, as well as the blog. Work in progress is visible at https://new.mariadb.org/ Please send us your feedback!

1 1

[Maria-discuss] Amazon Aurora: based on MySQL or MariaDB?
by Lukas Lehner 17 Dec '15

17 Dec '15

Hi https://aws.amazon.com/rds/aurora/ Did Amazon write everything on their own? Is it based on MySQL or MariaDB? Lukas

3 2

[Maria-discuss] CONNECT version maturity
by Federico Razzoli 17 Dec '15

17 Dec '15

Hi all In this page: https://mariadb.com/kb/en/mariadb/connect/ I see that CONNECT 1.03.0007 (that is in MariaDB 10.1.5) is gamma-quality, but 1.04.0003 (that is in 10.1.9) is beta. I am confused. Is this a documentation mistake? Or maybe many new bugs were found? Regards Federico

2 1

[Maria-discuss] New Question: Does MariaDB Galera Cluster 10.0.21 version support gmcast.segment?
by AskMonty KB 17 Dec '15

17 Dec '15

Hello, A new question has been asked in "MariaDB Galera Cluster" by yu.d.sun_32615. Please answer it at http://mariadb.com/kb/en/does-mariadb-galera-cluster-10021-version-support-… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, Server version: 10.0.21-MariaDB-wsrep-log MariaDB Server, wsrep_25.10.r4144 ip-10-74-2-218$ root@localhost[(none)] MYSQL> set global wsrep_provider_options="gmcast.segment=1"; ERROR 1210 (HY000): Incorrect arguments to SET I also tried to put wsrep_provider_options="gmcast.segment=1" in the my.cnf but cannot start the instance: 151217 7:59:58 [ERROR] WSREP: Unrecognized parameter '"gmcast.segment' 151217 7:59:58 [ERROR] WSREP: wsrep::init() failed: 7, must shutdown 151217 7:59:58 [ERROR] Aborting Denis -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/does-mariadb-galera-cluster-10021-version-support-…

1 0

[Maria-discuss] max key length in import
by Warren H. Prince 17 Dec '15

17 Dec '15

I’m considering moving from MySql to MariaDB so I did a dump today and attempted an import. It failed with the “Specified key was too long; max key length is 767 bytes” error. I dealt with this in MySql and knew to change file format to Barracuda. I zapped the partial import, did a fresh mysql_install_db, restarted the service and tried again to no avail. To confirm my settings immediately after the failure: MariaDB [(none)]> SHOW VARIABLES LIKE 'innodb_file_%'; +--------------------------+-----------+ | Variable_name | Value | +--------------------------+-----------+ | innodb_file_format | Barracuda | | innodb_file_format_check | ON | | innodb_file_format_max | Barracuda | | innodb_file_per_table | ON | +--------------------------+—————+ Does anyone have any suggestions? The dump is 795M compressed so it’s difficult to find the exact place where the problem is (I used zcat for the import). My distribution is: 10.0.22-MariaDB running on Ubuntu 15.04 Thanks in advance.

2 2

[Maria-discuss] New Question: Galera Cluster expire_logs_days
by AskMonty KB 16 Dec '15

16 Dec '15

Hello, A new question has been asked in "MariaDB Galera Cluster" by diego.carrera. Please answer it at http://mariadb.com/kb/en/galera-cluster-expire_logs_days/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is it safe to modify the "expire_logs_days" variable while the cluster is running? show variables like 'expire_log_days' is 14, I've not defined this under my.cnf or wsrep.cnf. What would be the proper procedure to reduce or increase binlog expiry? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/galera-cluster-expire_logs_days/

1 0

[Maria-discuss] Replication variables in my.cnf seem ignored if master connection does not exist
by Игорь Пашев 16 Dec '15

16 Dec '15

MariaDB 10.0.22 I saw weird things a couple of times: I start clean MariaDB with theses options in the configuration file: foo.replicate_wild_do_table = foo_live.% foo.replicate_ignore_table = foo_live.schema_updates Then I execute RESET SLAVE "foo" ALL just to be sure there is no such connection. Then I import the dump of master, and set master options like host, user, password, etc. Then I execute START SLAVE "foo" Then SHOW SLAVE "foo" reveals empty 'Replicate_Wild_Do_Table' and 'Replicate_Ignore_Table'. (And replication shortly breaks, because foo_live.schema_updates wasn't imported). I can fix this by restarting MariaDB. I'd expect the foo.replicate_* options are taking effect anytime. As a work-around I'd set those options dynamically after dump is imported. (I will fill MDEV in case it is confirmed as a bug)

1 1

[Maria-discuss] MariaDB Performance and Diagnostic Tools
by FERRETTI, ANDY 15 Dec '15

15 Dec '15

I'm looking for recommendations on MariaDB Performance Analysis tools. 1. I try MySQL workbench, but much of the capability is disabled. I get an error when I click on the Dashboard "This feature requires MySQL version 5.6.6 or newer". 2. I'm wondering if there are some good scripts to help identify key performance metrics from the performance_schema. I'd like to see a capability similar to an Oracle AWR report. I spent a fair amount of time doing google searches, and found some information on the performance_schema: https://php-built.com/enabling-performance-monitoring-for-mariadb-and-mysql/ , but I really think there should be something better. Thanks, Andy Ferretti Lead Principal-Technical Architect AT&T Technology Development - SD&E Cloud, Platform, Application and Data Layer Support (CPADS) Work: 205 989 0662 Cell: 205 478 9694 e-mail: andy.ferretti(a)att.com<mailto:andy.ferretti@att.com> This e-mail and any files transmitted with it are AT&T property, are confidential, and are intended solely for the use of the individual or entity to whom this emailis addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited.

5 4

[Maria-discuss] Galera Cluster: Cluster Blocked, when one node down?
by Benoit Panizzon 14 Dec '15

14 Dec '15

Hello We use MariaDB Galera Cluster for our email service platform. We decided to use Galera to create a high availability platform. After a year of operation, we start to relaize, that somehow Galera Failures seem to be the most common cause for outages we had in the past. So I wonder if others operating galera clusters also observe this situation: All our services using DB connections use a DNS round-robin name, to connect to one of our three galera instances. While testing this setup, we usualy killed one instance, or disconnected the node from the network to simulate an outage. In this situation, this works as expected. The client connect to the two remaining nodes, no service outage. When the node is re-started it is being re-synced quickly and service with three nodes is restored. Now we experienced a few galera cluster fails, which seem to happen this way: One of the nodes is getting a lot of load. DDOS Attacks, Memory Leaks or similar, which just renders the whole physical machine laggy for a short time. So the affected MariaDB node is being thrown out of the cluster by the two other nodes, probably for not syncing fast enough anymore. But as the node is not 'down' completely, it still accepts connections from the DB clients, but does not reply to them and seems to remain in a 'db locked' situation. Strangely this then also affects the two remaining nodes, who also go into 'locked' mode and do not reply to queries on the time expected by the application anymore. Of course this then causes more DB clients (IMAP, SMTP-Auth, etc) to spawn and to create DB connections worsening the whole situation. The situation seemingly can only be resolved by shuting down the MariaDB node that got thrown out of the cluster. Then the situations normalizes with the two remaining nodes and the third one can be restarted. Is this expected behaviour? Is there a way to tell a MariaDB node that got excluded from the cluster to shut himself down completely so it does NOT accept any more connections from clients, blocking the whole service? Regards -Benoît Panizzon- -- I m p r o W a r e A G - Leiter Commerce Kunden ______________________________________________________ Zurlindenstrasse 29 Tel +41 61 826 93 00 CH-4133 Pratteln Fax +41 61 826 93 01 Schweiz Web http://www.imp.ch ______________________________________________________

3 2

[Maria-discuss] New Question: I want to solve the error C1061 in visual studio.
by AskMonty KB 14 Dec '15

14 Dec '15

Hello, A new question has been asked in "MariaDB Documentation" by goodwill16. Please answer it at http://mariadb.com/kb/en/i-want-to-solve-the-error-c1061-in-visual-studio/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello all, I got error as C1061: compiler limit : blocks nested too deeply i am using below code Try { AAAAAA....... } Catch(Exception^ ex) { if(AAA....); elseif(AAA....); elseif(AAA...); } The problem is catch block has limit to execute if-else statements of 128.but in my program I have 700 if-else statements . so please tell me how to extend the limit of catch block. thankyou, mallika.shaik -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/i-want-to-solve-the-error-c1061-in-visual-studio/

1 0

[Maria-discuss] out of memory linux kill and mysqld_multi
by Roberto Spadim 11 Dec '15

11 Dec '15

Hi guys, could we include a configuration at mysqld_mult and mysqld_safe? at linux killing the mysqld process is a big problem, i prefer leave it as the last process to kill check this post : http://www.oracle.com/technetwork/articles/servers-storage-dev/oom-killer-1… in this case oracle is the last tprocess to kill they use the /proc kernel interface to set the oom_adj i don't read the mysqld_safe and mysqld_multi, but could we include this at my.cnf? my last crash was a big trouble, if kernel killed the others process before mysql maybe the mysqld couldn't be killed thanks guys i will create a MDEV about it -- Roberto Spadim

2 2

[Maria-discuss] Queries Not Completing After Backup
by Brad Jorgensen 11 Dec '15

11 Dec '15

We have a three node (db1, db2, db3) galera cluster with MariaDB 10.0.22 on CentOS 6.7. A couple days ago I upgraded to 10.1.9. Xtrabackup (2.3.2) is run every night on each node at 1am, 2am, and 3am respectively. Before the backup starts, the node is desynced. The first night after upgrading to 10.1.9, the problem began. All connections were going to db1 until the backup started when db1 was removed from the routing pool and new connections began going to db2. At that time there was little traffic aside from the backup; much of it is probably monitoring queries. Our monitoring shows that running threads went from about 2 just before the backup finished around 1:32am to about 150 just after. At the same time, the running threads on db2 went from 1 to 10. After the backup completed, all new connections were going to db1 again. The running threads on db1 continued to slowly grow until the queries that are stuck took up all of the server processes on our application servers and we were alerted around 3:50am. I checked the process list and almost all of the queries were in the "query end" state and I think they were all write queries. I tried to kill most of them but they just stayed in the same state. I restarted db2 to try to kick the cluster without losing data. I had to force the shutdown since three threads never ended after about 10 minutes of waiting. The running threads on db1 returned to normal. db2 had do do a full SST which took until 6:05 to complete. At that time, the running processes on db1 began to increase again. When db2 was back up I downgraded to 10.1.22 and rejoined it to the cluster. I tried to restart db1, but it needed a full SST so I left it down. A bit later I took down db3 to downgrade it, too at that went fine. The cluster was fine through the day during normal business operation. The next night only db2 and db3 were up and were running 10.0.22. What appears to be the same problem started at 3:31am, when xtrabackup paused galera ("Provider paused at 8c53b634-9514-11e4-b8bd-dab05673fb36:875650526") on db3 for the backup. At that time the running threads on db2 shot up and slowly increased until I shut it down at 6:28. I had to kill it again due to three threads on ending. db3 showed nothing unusual in the logs. I got the innodb engine status from db2 three times a few minutes apart before I restarted; they are attached. Additionally, I attached an excerpt from the logs on db2 and db3 during the second incident and the my.cnf from one of the servers, it's basically the same for the others. I'm working on getting a clean set of logs from the first incident, but from what I initially saw, they are basically the same as the second set of logs. I'm ready if the problem arises again and I'll try to get more information including SHOW GLOBAL STATUS. Our environment hasn't changed for at least a month and the issue first appeared after upgrading to 10.1.9, but since it didn't go away after downgrading, I'm not sure where the issue is. I found a few mentions of what might be the same problem: http://marialog.archivist.info/2015-04-03.txt https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1149755

2 1

[Maria-discuss] INNODB not loading
by Roberto Spadim 11 Dec '15

11 Dec '15

hi guys, i was using my database and it crashed, after restart innodb (Xtradb) don't start the log shows this: 151210 21:44:38 [Note] InnoDB: Using mutexes to ref count buffer pool pages 151210 21:44:38 [Note] InnoDB: The InnoDB memory heap is disabled 151210 21:44:38 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 151210 21:44:38 [Note] InnoDB: Memory barrier is not used 151210 21:44:38 [Note] InnoDB: Compressed tables use zlib 1.2.3 151210 21:44:38 [Note] InnoDB: Using CPU crc32 instructions 151210 21:44:38 [Note] InnoDB: Initializing buffer pool, size = 32.0G 151210 21:44:48 [Note] InnoDB: Completed initialization of buffer pool 151210 21:44:54 [Note] InnoDB: Highest supported file format is Barracuda. 151210 21:44:54 [Note] InnoDB: The log sequence numbers 8739254920 and 8739254920 in ibdata files do not match the log sequence number 98318151020 in the ib_logfiles! 151210 21:44:54 [Note] InnoDB: Database was not shutdown normally! 151210 21:44:54 [Note] InnoDB: Starting crash recovery. 151210 21:44:54 [Note] InnoDB: Reading tablespace information from the .ibd files... 151210 21:44:54 [Note] InnoDB: Restoring possible half-written data pages 151210 21:44:54 [Note] InnoDB: from the doublewrite buffer... 151210 21:44:57 [Note] InnoDB: 128 rollback segment(s) are active. 151210 21:44:57 [Note] InnoDB: Waiting for purge to start 151210 21:44:57 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.25-73.1 started; log sequence number 98318151020 151210 21:44:57 [Note] Plugin 'FEEDBACK' is disabled. 151210 21:44:57 [Note] Server socket created on IP: '::'. 151210 21:44:57 [Note] Event Scheduler: Loaded 0 events 2015-12-10 21:44:57 7fbfd435a700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 151210 21:44:57 [Note] /opt/mariadb/bin//mysqld: ready for connections. Version: '10.0.21-MariaDB-log' socket: '/tmp/mysql.BH.sock' port: 3307 MariaDB Server any idea what could be done to start recovery from innodb? -- Roberto Spadim

3 4

[Maria-discuss] MariaDB 5.5.47 and updated connectors now available
by Daniel Bartholomew 10 Dec '15

10 Dec '15

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.47, MariaDB Connector/C 2.2.2, and MariaDB Connector/J 1.3.3. These are all Stable (GA) releases. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.47 - Release Notes: https://mariadb.com/kb/en/mdb-5547-rn - Changelog: https://mariadb.com/kb/en/mdb-5547-cl - Downloads: https://downloads.mariadb.org/mariadb/5.5.47 About MariaDB 5.5: - https://mariadb.com/kb/en/what-is-mariadb-55/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB Connector/C 2.2.2 - Release Notes: https://mariadb.com/kb/en/mcc-222-rn - Changelog: https://mariadb.com/kb/en/mcc-222-cl - Downloads: https://downloads.mariadb.org/connector-c/2.2.2/ About MariaDB Connector/C : - https://mariadb.com/kb/en/about-mariadb-connector-c/ MariaDB Connector/J 1.3.3 - Release Notes: https://mariadb.com/kb/en/mcj-133-rn - Changelog: https://mariadb.com/kb/en/mcj-133-cl - Downloads: https://downloads.mariadb.org/connector-java/1.3.3/ About MariaDB Connector/J : - https://mariadb.com/kb/en/about-mariadb-connector-j/ - - 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

1 0

[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] SST xtrabackup-v2 and 10.1.9-MariaDB-1~trusty-log' (InnoDB version: '5.6.26-74.0')
by Engelmann Florian 08 Dec '15

08 Dec '15

Dear list, this is my 1st time testing Galera Cluster with MariaDB 10.1. With version 10.1.9 I get the following error using xtrabackup-v2 for SST: Dec 7 18:32:21 wsc-db01a-test mysqld: 2015-12-07 18:32:21 140026872588032 [Note] WSREP: Member 1.0 () requested state transfer from '*any*'. Selected 0.0 ()(SYNCED) as donor. Dec 7 18:32:21 wsc-db01a-test mysqld: 2015-12-07 18:32:21 140026872588032 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 0) Dec 7 18:32:21 wsc-db01a-test mysqld: 2015-12-07 18:32:21 140027564807936 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Dec 7 18:32:21 wsc-db01a-test mysqld: 2015-12-07 18:32:21 140026000176896 [Note] WSREP: Running: 'wsrep_sst_xtrabackup-v2 --role 'donor' --address '10.1.234.223:4444/xtrabackup_sst//1' --socket '/var/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/' --binlog '/var/log/mysql/mariadb-bin' --gtid 'd714578b-9d06-11e5-b89b-2b7551505c87:0' --gtid-domain-id '0'' Dec 7 18:32:21 wsc-db01a-test mysqld: 2015-12-07 18:32:21 140027564807936 [Note] WSREP: sst_donor_thread signaled with 0 Dec 7 18:32:22 wsc-db01a-test mysqld: WSREP_SST: [INFO] Logging all stderr of SST/Innobackupex to syslog (20151207 18:32:22.249) Dec 7 18:32:22 wsc-db01a-test -wsrep-sst-donor: Streaming with xbstream Dec 7 18:32:22 wsc-db01a-test -wsrep-sst-donor: Using socat as streamer Dec 7 18:32:22 wsc-db01a-test -wsrep-sst-donor: Using /tmp/tmp.l5q4N6ELOD as innobackupex temporary directory Dec 7 18:32:22 wsc-db01a-test -wsrep-sst-donor: Streaming GTID file before SST Dec 7 18:32:22 wsc-db01a-test -wsrep-sst-donor: Evaluating xbstream -c ${INFO_FILE} | socat -u stdio TCP:10.1.234.223:4444; RC=( ${PIPESTATUS[@]} ) Dec 7 18:32:22 wsc-db01a-test -wsrep-sst-donor: Sleeping before data transfer for SST Dec 7 18:32:23 wsc-db01a-test mysqld: 2015-12-07 18:32:23 140026880980736 [Note] WSREP: (6b6485fa, 'tcp://0.0.0.0:4567') turning message relay requesting off Dec 7 18:32:32 wsc-db01a-test -wsrep-sst-donor: Streaming the backup to joiner at 10.1.234.223 4444 Dec 7 18:32:32 wsc-db01a-test -wsrep-sst-donor: Evaluating innobackupex --no-version-check $tmpopts $INNOEXTRA --galera-info --stream=$sfmt $itmpdir 2> >(logger -p daemon.err -t -innobackupex-backup) | socat -u stdio TCP:10.1.234.223:4444; RC=( ${PIPESTATUS[@]} ) Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved. Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: This software is published under Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: the GNU GENERAL PUBLIC LICENSE Version 2, June 1991. Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: Get the latest version of Percona XtraBackup, documentation, and help resources: Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: http://www.percona.com/xb/ubuntu Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: 151207 18:32:32 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;mysql_socket=/var/run/mysqld/mysqld.sock' as 'sstuser' (using password: NO). Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: 151207 18:32:32 innobackupex: Connected to MySQL server Dec 7 18:32:32 wsc-db01a-test -innobackupex-backup: innobackupex: Error: Unsupported server version: '10.1.9-MariaDB-1~trusty-log' (InnoDB version: '5.6.26-74.0'). Please report a bug at https://bugs.launchpad.net/percona-xtrabackup Dec 7 18:32:32 wsc-db01a-test -wsrep-sst-donor: innobackupex finished with error: 1. Check /var/lib/mysql//innobackup.backup.log Dec 7 18:32:32 wsc-db01a-test -wsrep-sst-donor: Cleanup after exit with status:22 Dec 7 18:32:32 wsc-db01a-test -wsrep-sst-donor: Cleaning up temporary directories Dec 7 18:32:32 wsc-db01a-test mysqld: 2015-12-07 18:32:32 140026000176896 [ERROR] WSREP: Failed to read from: wsrep_sst_xtrabackup-v2 --role 'donor' --address '10.1.234.223:4444/xtrabackup_sst//1' --socket '/var/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/' --binlog '/var/log/mysql/mariadb-bin' --gtid 'd714578b-9d06-11e5-b89b-2b7551505c87:0' --gtid-domain-id '0' Dec 7 18:32:32 wsc-db01a-test mysqld: 2015-12-07 18:32:32 140026000176896 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup-v2 --role 'donor' --address '10.1.234.223:4444/xtrabackup_sst//1' --socket '/var/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/' --binlog '/var/log/mysql/mariadb-bin' --gtid 'd714578b-9d06-11e5-b89b-2b7551505c87:0' --gtid-domain-id '0': 22 (Invalid argument) Dec 7 18:32:32 wsc-db01a-test mysqld: 2015-12-07 18:32:32 140026000176896 [ERROR] WSREP: Command did not run: wsrep_sst_xtrabackup-v2 --role 'donor' --address '10.1.234.223:4444/xtrabackup_sst//1' --socket '/var/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/' --binlog '/var/log/mysql/mariadb-bin' --gtid 'd714578b-9d06-11e5-b89b-2b7551505c87:0' --gtid-domain-id '0' Dec 7 18:32:32 wsc-db01a-test mysqld: 2015-12-07 18:32:32 140026872588032 [Warning] WSREP: 0.0 (): State transfer to 1.0 () failed: -22 (Invalid argument) Dec 7 18:32:32 wsc-db01a-test mysqld: 2015-12-07 18:32:32 140026872588032 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 0) Dec 7 18:32:33 wsc-db01a-test mysqld: 2015-12-07 18:32:33 140026872588032 [Note] WSREP: Member 0.0 () synced with group. Dec 7 18:32:33 wsc-db01a-test mysqld: 2015-12-07 18:32:33 140026872588032 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0) My 90-galera.cnf looks like: [mysqld] query_cache_size = 0 binlog_format = ROW default_storage_engine = InnoDB innodb_autoinc_lock_mode = 2 innodb_doublewrite = 1 server_id = 100 innodb_flush_log_at_trx_commit = 0 wsrep_on = ON wsrep_provider_options = "gcache.size=512M;pc.recovery=TRUE" wsrep_cluster_address = "gcomm://10.1.234.222,10.1.234.223,10.1.234.224,10.1.234.225" wsrep_cluster_name = dba wsrep_sst_method = "xtrabackup-v2" #wsrep_sst_method = "rsync" wsrep_sst_auth = "sstuser:xxxxxxxxxxxxxxxxxxxxxxx" wsrep_provider = "/usr/lib/galera/libgalera_smm.so" wsrep_slave_threads = 4 wsrep_node_address = 10.1.234.221 wsrep_node_incoming_address = 10.0.234.221 With wsrep_sst_method = "rsync" SST works fine. Did I miss something? All the best, Florian

2 2

[Maria-discuss] New Question: Mysql database concept's information.
by AskMonty KB 08 Dec '15

08 Dec '15

Hello, A new question has been asked in "MariaDB Documentation" by goodwill16. Please answer it at http://mariadb.com/kb/en/mysql-database-concepts-information/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello all, I am studying about the MariaDB and MySql database and need few necessary details about it. I could not find the details while searching in google. I want to know what tools have been used while developing MySql database? Like the editor window output window tools, Parser, etc. Hope to get answer soon. Thanks and regards. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mysql-database-concepts-information/

1 0

[Maria-discuss] New Question: How to store the string in %s
by AskMonty KB 07 Dec '15

07 Dec '15

Hello, A new question has been asked in "MariaDB Documentation" by goodwill16. Please answer it at http://mariadb.com/kb/en/how-to-store-the-string-in-s/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello all, I am studying source code of MySQL.I noted that in error messages they are using %s,%d here %s is used to store the database name,table name which is chose by user,and %d for error number. I want to know how they store the string in %s.can you help me for that. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-to-store-the-string-in-s/

1 0

[Maria-discuss] New Question: How to create the line numbers in MySQL query window
by AskMonty KB 07 Dec '15

07 Dec '15

Hello, A new question has been asked in "MariaDB Documentation" by goodwill16. Please answer it at http://mariadb.com/kb/en/how-to-create-the-line-numbers-in-mysql-query-wind… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hello all, I want to create a query window as MySQL query window.for that I am using visual studios .can you say how can they create the line numbers. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-to-create-the-line-numbers-in-mysql-query-wind…

1 0

[Maria-discuss] Most reliable SST (or IST ?) method for MariaDB Cluster
by Bertrand Caplet 05 Dec '15

05 Dec '15

Hi all, I'm using MariaDB Cluster with 3 servers and I often have split brain because of network. When a network split brain happen, only one node is disconnected. What is for you the best choice for SST or maybe IST method for this configuration ? (N.B.: I already tried rsync method but i'm not really satisfied with it). I have another question, I tried xtrabackup-v2 but it seems this method can't be use for bootstrapping while database is on. Does xtrabackup method can do this ? Regards, -- CHUNKZ.NET - script kiddie and computer technician Bertrand Caplet, Flers (FR) Feel free to send encrypted/signed messages Key ID: 37F70C30 GPG FP: 134A 4027 518B 5F4D D409 558D BA9B 7BF0 37F7 0C30

3 4

[Maria-discuss] New Question: filter QLA
by AskMonty KB 03 Dec '15

03 Dec '15

Hello, A new question has been asked in "MaxScale Filters" by chris_jack_g. Please answer it at http://mariadb.com/kb/en/filter-qla/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is there a way to show in the query log the user in which the session originated? Here is my filter config, pretty straight forward: [qla] type=filter module=qlafilter options=/tmp/QueryLog -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/filter-qla/

1 0

[Maria-discuss] New Question: (Another) Install problem on Mac OSX 10.10.2
by AskMonty KB 03 Dec '15

03 Dec '15

Hello, A new question has been asked in "Getting, Installing, and Upgrading MariaDB" by 7stud. Please answer it at http://mariadb.com/kb/en/another-install-problem-on-mac-osx-10102/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- In am using the Generic Build instructions: https://mariadb.com/kb/en/mariadb/generic-build-instructions/ And here were my results trying to install: **MariaDB 10.1.8**\\ on **Mac OSX 10.10.2 **\\ with **Xcode 6.3.2**\\ {{{ $ cmake --version cmake version 3.4.0-rc3 CMake suite maintained and supported by Kitware (kitware.com/cmake) $ cmake . -DBUILD_CONFIG=mysql_release $ make --version GNU Make 3.81 Copyright (C) 2006 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. This program built for i386-apple-darwin11.3.0 $ make ... ... ~/Downloads/mariadb-10.1.9$ make ... ... ... Scanning dependencies of target install_tdb_h [ 71%] Generating db.h [ 71%] Built target install_tdb_h Scanning dependencies of target util_static [ 71%] Building CXX object storage/tokudb/ft-index/util/CMakeFiles/util_static.dir/context.cc.o In file included from /Users/7stud/Downloads/mariadb-10.1.9/storage/tokudb/ft-index/util/context.cc:94: In file included from /Users/7stud/Downloads/mariadb-10.1.9/storage/tokudb/ft-index/util/context.h:96: /Users/7stud/Downloads/mariadb-10.1.9/storage/tokudb/ft-index/buildheader/db.h:323:1: error: empty struct has size 0 in C, size 1 in C++ [-Werror,-Wextern-c-compat] struct __toku_db_lsn { ^ 1 error generated. make[2]: *** [storage/tokudb/ft-index/util/CMakeFiles/util_static.dir/context.cc.o] Error 1 make[1]: *** [storage/tokudb/ft-index/util/CMakeFiles/util_static.dir/all] Error 2 make: *** [all] Error 2 ~/Downloads/mariadb-10.1.9$ }}} -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/another-install-problem-on-mac-osx-10102/

1 0

[Maria-discuss] Voting for some MariaDB Server related submissions for Percona Live
by Colin Charles 03 Dec '15

03 Dec '15

Hi all, It turns out that what is considered to be the largest conference for those interested in the MySQL world, nowadays called the Percona Live Data Performance Conference, is requiring the community to vote on submissions that they would like to hear. Only after voting, will those with a certain threshold (not published) be sent to the next level for the program committee to vote on. Its clear that you *do not* have to be attending the event, but you do need to register to vote. I’m sure all of us would appreciate your votes. The people below offering talks are Sergei Golubchik, Sergei Petrunia, Michael “Monty” Widenius, Gerry Narvaja, Serge Frezefond, Anders Karlsson, and me, Colin Charles. Thanking you all in advance! cheers, -colin Using and Managing MariaDB https://www.percona.com/live/data-performance-conference-2016/sessions/comp… MariaDB 10.1 - What's New? (*** includes Monty himself! ***) https://www.percona.com/live/data-performance-conference-2016/sessions/mari… Databases in the Hosted Cloud https://www.percona.com/live/data-performance-conference-2016/sessions/data… Best Practices for MySQL High Availability https://www.percona.com/live/data-performance-conference-2016/sessions/best… Choosing a MySQL HA solution today https://www.percona.com/live/data-performance-conference-2016/sessions/choo… MariaDB/MySQL security essentials https://www.percona.com/live/data-performance-conference-2016/sessions/mari… The MySQL Server Ecosystem in 2016 https://www.percona.com/live/data-performance-conference-2016/sessions/mysq… MariaDB Connectors: Fast and Smart with the new protocol optimizations https://www.percona.com/live/data-performance-conference-2016/sessions/mari… MariaDB 10.1 Security: Validation, Authentication, Encryption https://www.percona.com/live/data-performance-conference-2016/sessions/mari… Window functions in MariaDB https://www.percona.com/live/data-performance-conference-2016/sessions/wind… Exploring MariaDB Query Optimizer with ANALYZE for statements https://www.percona.com/live/data-performance-conference-2016/sessions/expl… Window functions in MariaDB https://www.percona.com/live/data-performance-conference-2016/sessions/wind… Exploring MariaDB Query Optimizer with ANALYZE for statements https://www.percona.com/live/data-performance-conference-2016/sessions/expl… The MariaDB CONNECT Storage Engine to simplify heterogeneous data access https://www.percona.com/live/data-performance-conference-2016/sessions/mari… Low Impact Monitoring https://www.percona.com/live/data-performance-conference-2016/sessions/low-… MariaDB on Power8: https://www.percona.com/live/data-performance-conference-2016/sessions/ibm-… The good and bad on datatypes in different database systems: https://www.percona.com/live/data-performance-conference-2016/sessions/migr… Character sets and Collations explained: https://www.percona.com/live/data-performance-conference-2016/sessions/char… -- Colin Charles, http://bytebot.net/blog/ twitter: @bytebot | skype: colincharles "First they ignore you, then they laugh at you, then they fight you, then you win." -- Mohandas Gandhi

1 0

[Maria-discuss] New Question: Stored Procedures & Functions on nodes in a Galera Cluster
by AskMonty KB 03 Dec '15

03 Dec '15

Hello, A new question has been asked in "MariaDB Galera Cluster" by tim_peart_g. Please answer it at http://mariadb.com/kb/en/stored-procedures-functions-on-nodes-in-a-galera-c… as the person asking the question may not be subscribed to the mailing list. -------------------------------- I am at the planning stage of a new Galera/MariaDB cluster. I can find very little info on how Stored Procedures and Functions are handled across the cluster. Am I safe to assume that a Stored Procedure or Function which is defined on one cluster node is not automatically propagated to any of the other nodes in the cluster? If so, then what are the Best Practices regarding update of Stored Procedures and Functions across the Cluster? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/stored-procedures-functions-on-nodes-in-a-galera-c…

1 0

Re: [Maria-discuss] [Maria-docs] New mariadb.org in the works
by Otto Kekäläinen 01 Dec '15

01 Dec '15

(I am replying back to the list as the information might be useful to others too) 2015-12-01 2:54 GMT+02:00 Daniel Bartholomew <dbart(a)mariadb.com>: > On Mon, Nov 30, 2015 at 4:46 PM, Otto Kekäläinen <otto(a)seravo.fi> wrote: >> Work in progress is visible at https://new.mariadb.org/ >> >> Please send us your feedback! > > It's looking great! Awesome work. I really like the new look. > > I noticed a couple typos on one of the pages, whom should I send them to? You can log in as dbart at https://new.mariadb.org/wp-admin/ All the content from the old blog, including user accounts, has been migrated to the new site apart from the very latest blogs and comments. - Otto

1 0

[Maria-discuss] replicate_rewrite_db as a system variable
by Ian Gilfillan 27 Nov '15

27 Nov '15

Is there a reason replicate_rewrite_db is not available as a system variable, while other similar settings, such as replicate_do_db are?

2 1

[Maria-discuss] New Question: Moving from Oracle to MariaDB
by AskMonty KB 27 Nov '15

27 Nov '15

1 0

[Maria-discuss] New Question: How to install MariaDB Galera without internet connection( without YUM)?
by AskMonty KB 25 Nov '15

25 Nov '15

Hello, A new question has been asked in "MariaDB Galera Cluster" by pluto0327. Please answer it at http://mariadb.com/kb/en/how-to-install-mariadb-galera-without-internet-con… as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi guys, I want to install a HA ( high availability ) environment without internet, but I am a rookie. Most webs, I can't find relative information how to do this job. First, how to do with step by step instructions, please? Second, is it correct that I must have 4 PCs ( 3 cluster nodes and 1 HA proxy)? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-to-install-mariadb-galera-without-internet-con…

1 0

[Maria-discuss] MariaDB and Galera Support from Redhat (instead of MariaDB corp)
by Lukas Lehner 25 Nov '15

25 Nov '15

Hi we run DBaaS (Galera Cluster) with growing customer base. We also offer MongoDB, where we have commercial support from MongoDB (we can recommend it). MariaDB is included in RHEL, so Red Hat offers support. We anyway pay for Redhat support. So it means we don't need to buy support from MariaDB? Does Redhat employs MariaDB developers and have DBA/Expert know how? Lukas

2 2

[Maria-discuss] Creating MySQL .MYD, .MYI and .frm tables in Maria
by Carl Whalley 25 Nov '15

25 Nov '15

This is the final stage from my thread regarding a botched F22->23 upgrade which hosed bacula. I have been on to bacula support and they claim not to support Maria. Well, "not support" isn't right, just "not explicitly tested" - I know everything was ok under F22/Maria as I have another server to upgrade which runs fine now with this setup. It seems the MySQL tables were created when bacula was installed several iterations of Fedora ago, and at that time they were of the .MYD, .MYI style. Each time fedora was updated, these were carried forwards - possibly through the swap from when MySQL was native to it becoming Maria, as we see now. That's why all the existing ones are in the form with the extensions I mentioned. So, I'm now in a situation where it seems I have to create one last table ("Snapshot") and am having trouble because it somehow has been created but not in the .MYD, MYI style. The create table command is supplied already for me to enter - how can I remove the phantom one and create it again in the format the rest of the tables are in please?

2 1

[Maria-discuss] After Fedora 22->23 update maria db doesn't start
by Carl Whalley 24 Nov '15

24 Nov '15

>From the log after systemctl restart mariadb.service: InnoDB: wrong number of columns in SYS_INDEXES record 151124 9:51:40 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.25-73.1 started; log sequence number 583845802 151124 9:51:40 [Note] Plugin 'FEEDBACK' is disabled. InnoDB: wrong number of columns in SYS_INDEXES record 151124 9:51:40 [Warning] InnoDB: Cannot open table mysql/plugin from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem. 151124 9:51:40 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. InnoDB: wrong number of columns in SYS_INDEXES record 151124 9:51:40 [Warning] InnoDB: Cannot open table mysql/servers from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem. 151124 9:51:40 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist in engine 151124 9:51:40 [Note] Server socket created on IP: '::'. 151124 9:51:40 [ERROR] Fatal error: mysql.user table is damaged or in unsupported 3.20 format. 151124 09:51:40 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended Trying other things [root@tiger ~]# mysqld_safe -uroot 151124 10:24:03 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'. 151124 10:24:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 151124 10:24:03 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended [root@tiger ~]# mysql_upgrade Version check failed. Got the following error when calling the 'mysql' command line client ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory") FATAL ERROR: Upgrade failed [root@tiger ~]#

3 11

[Maria-discuss] New Question: Verifying Mariadb 10.1 encryption
by AskMonty KB 23 Nov '15

23 Nov '15

Hello, A new question has been asked in "MariaDB Community" by markroland_g. Please answer it at http://mariadb.com/kb/en/verifying-mariadb-101-encryption/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have set up table-level InnoDB database encryption on Maria DB 10.1.8 (https://mariadb.com/kb/en/mariadb/data-at-rest-encryption/) I'd like to know if there is any way to confirm that the data is truly encrypted. I've tried searching /var/lib/mysql/ibdata1 for sample data in the tables, but I don't know if that's a reliable test or not. * This is a re-post of a question I asked on Stack Overflow (http://stackoverflow.com/questions/33817877/verifying-mariadb-10-1-encrypti…) -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/verifying-mariadb-101-encryption/

1 0