- discuss - lists.mariadb.org

[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