- discuss - lists.mariadb.org

[Maria-discuss] can I expect deb files of mariadb-galera soon?
by Jan Kirchhoff 12 Oct '12

12 Oct '12

Hi, We are currently using mariadb a lot over here with traditional replication and I'd like to test the galera alpha in the next weeks. I have two brand-new machines with plenty of SAS disks, some SSDs and 128GB of RAM over here with Ubuntu 12.10 alpha ready to do some testing with our real-world workloads. Before I start compiling myself or mess with binary tar.gz-releases: can I expect deb-releases within the next 2 weeks? That would make life much easier for me and I'd delay starting all the testing by a few days if I knew I would then have debs to start right away. regards Jan

2 3

[Maria-discuss] mariadb : possible copyright issues?
by Vineet Deodhar 03 Oct '12

03 Oct '12

I am using MySQL at present. I came across MariaDB, a drop-in replacement for MySQL. 2 simple questions-- 1) File names in MariaDB, in many cases, are same as those in MySQL. Wouldn't that attract objection from Oracle as 'breach of the copyright' ? 2) May I use MariaDB for commercial distribution (with or without using its source) ? Whether the license is similar to MIT license? Thanks, Vineet

3 2

[Maria-discuss] KB Question:Slow Performance for some queries
by Daniel Bartholomew 03 Oct '12

03 Oct '12

The following question has been posted to the Knowledgebase: https://kb.askmonty.org/en/slow-performance-for-some-queries/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Slow Performance for some queries Hi there, I have discovered some very low performing queries on our MariaDB version 5.3.7. The query shows up with "string results in query cache" The query: explain select distinct `config`.`agent_id` AS `agent_id`, `config`.`agent_name` AS `agent_name`, `agent`.`agent_version` AS `agent_version`, `config`.`agent_os` AS `agent_os`, `agent`.`agent_os_version` AS `agent_os_version`, `config`.`pconfig_line` AS `pconfig_line`, `config`.`appclass` AS `appclass`, `config`.`instance` AS `instance`, `config`.`parameter` AS `parameter`, `config`.`value` AS `value`, substring_index(substring_index(`config`.`variable`, '/', '4ö'), '/', -(1)) AS `NT_Drive`, `config`.`agent_config_date` AS `agent_config_date`, `config`.`rule_type_name` AS `rule_type_name` from (`agent_config_detail_view` `config` left join `agent` ON ((`agent`.`agent_id` = `config`.`agent_id`))) where (((`config`.`rule_type_id` = 'ccbe914e30c6ec6e3aa5c4780a3525d6') or (`config`.`rule_type_id` = '0091efee7f9b5f0e27211eb7226d0a23') or (`config`.`rule_type_id` = '6311ae17c1ee52b36e68aaf4ad066387')) and ((`config`.`variable` = '/AgentSetup/FILESYSTEM.filterList') or (`config`.`variable` = '/AgentSetup/FILESYSTEM.filterType') or (`config`.`variable` like '/AS/EVENTSPRING/PARAM_SETTINGS/THRESHOLDS/FILESYSTEM%') or (`config`.`variable` like '/RecoveryActions/NT_LOGICAL_DISKS/%/LDldFreeSpacePercent/Mode')) and (`config`.`agent_config_date` > ((select max(`s`.`agent_config_date`) from `agent_config` `s`) - interval 24 hour))) order by `config`.`agent_name` , `config`.`appclass` Here is the explain for the query in question: id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY a ALL PRIMARY NULL NULL NULL 7083 "Using temporary; Using filesort" 1 PRIMARY agent eq_ref PRIMARY PRIMARY 34 new_budm.a.agent_id 1 1 PRIMARY b ref PRIMARY,fk_agent_config_agent1,IX_agent_config_date fk_agent_config_agent1 34 new_budm.a.agent_id 3 "Using where" 1 PRIMARY c ref agent_config_rule_fk_agent_config_id,agent_config_rule_fk_rule_id agent_config_rule_fk_agent_config_id 34 new_budm.b.agent_config_id 947 1 PRIMARY d eq_ref PRIMARY,IX_rule_variable PRIMARY 34 new_budm.c.fk_rule_id 1 "Using where" 1 PRIMARY e ref fk_rule_rule_type_rule_type1,fk_rule_rule_type_rule fk_rule_rule_type_rule 34 new_budm.c.fk_rule_id 1 "Using where" 1 PRIMARY f eq_ref PRIMARY PRIMARY 34 new_budm.e.fk_rule_type_id 1 2 SUBQUERY NULL NULL NULL NULL NULL NULL NULL "Select tables optimized away" The query cache (innodb_buffer_pool_size) is set to 8192M. Other queries are running fine (perfomance can always be better). Thank you and regards, Patrick - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Thanks. -- Daniel Bartholomew Google+ - http://gplus.to/dbart Twitter - http://twitter.com/daniel_bart MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

1 0

[Maria-discuss] Json Explain
by Peter Laursen 30 Sep '12

30 Sep '12

Is Explain output in Json format planned in MariaDB (refer http://glebshchepa.blogspot.in/2012/04/optimizer-new-explain-formatjson.html) ? If so when? and will the implementation details and output format be fully identical to Oracle/MySQL 5.6? (I did not find it mentioned here: http://monty-says.blogspot.dk/2012/09/now-is-good-time-to-be-part-of-future… http://blog.mariadb.org/mariadb-directions/ .. sorry if I overlooked it somewhere) -- Peter -- Webyog

4 8

[Maria-discuss] MariaDB 5.5.27 now available
by Daniel Bartholomew 10 Sep '12

10 Sep '12

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.27. This is a stable (GA) release. - - MariaDB 5.5 Links - - - - - - - - - - - - - - - - - - - - - - - - - Release Notes: http://kb.askmonty.org/en/mariadb-5527-release-notes Changelog: http://kb.askmonty.org/en/mariadb-5527-changelog Downloads: http://downloads.mariadb.org/mariadb/5.5.27 APT and YUM Repository Configuration Generator: http://downloads.mariadb.org/mariadb/repositories/ Overview of MariaDB 5.5: http://kb.askmonty.org/en/what-is-mariadb-55 - - 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 (my.ini on Windows) file! See http://kb.askmonty.org/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 We hope you enjoy MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

1 0

[Maria-discuss] MariaDB Galera Cluster 5.5.25 Alpha now available
by Daniel Bartholomew 06 Sep '12

06 Sep '12

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 5.5.25 Alpha. This is an Alpha release. What is it? * A straight merge of MariaDB 5.5.25 with Galera Cluster by Codership * An alpha release which should not be used in production environments * Using the Galera replication methodology, users get: * Synchronous, multi-master replication with guaranteed data consistency. * This solution provides both read & write scalability The links below have more information. Compatibility? MariaDB Galera Cluster is fully data-compatible with MariaDB or MySQL, as it will work with the standard databases created by these products. There are next to none or very minimal application changes that are required to make the solution work. Where can I get it? See the links below. What's next? The plan is for a rapid release cycle to heavily test the performance and usage of MariaDB Galera Cluster in different environments. Please file bugs at: https://mariadb.atlassian.net Quotes: Seppo Jaakola, CEO for Codership "It's great that we are working closely with an upstream provider of a MySQL-compatible binary, MariaDB. We no longer have to spend time coding against out-of-tree changes as we're part of MariaDB. The excellent MariaDB engineering team constantly releases new versions of MariaDB with high quality assurance (QA). Codership will continue to collaborate closely with the MariaDB engineering team to improve the product and make new versions of the MariaDB Galera Cluster available." Michael "Monty" Widenius, CEO for Monty Program Ab "We've received a significant amount of requests for a MariaDB based Galera cluster and today we're proud to deliver that. We're currently preparing ourselves and our partners for a rollout of the GA product and related professional services via SkySQL to run critical systems on top of MariaDB Galera Cluster." The MariaDB Team will together with Codership work on customer requests and demands in the areas of cluster and replication. Please contact us if you are interested in any services we can offer around Galera, MariaDB or MySQL. http://montyprogram.com/contact - - MariaDB Galera Cluster 5.5.25 Links - - - - - - - - - - - - - - - - Release Notes: http://kb.askmonty.org/en/mariadb-galera-5525-release-notes Changelog: http://kb.askmonty.org/en/mariadb-galera-5525-changelog Downloads: http://downloads.mariadb.org/mariadb-galera/5.5.25 YUM Repository Configuration Generator: http://downloads.mariadb.org/mariadb-galera/repositories (APT repositories are not available at this time.) Overview of MariaDB Galera Cluster 5.5: http://kb.askmonty.org/en/what-is-mariadb-galera-cluster More information: http://kb.askmonty.org/en/galera - - Where else to find us - - - - - - - - - - - - - - - - - - - - - - - http://mariadb.org We're also on: Facebook: http://fb.com/MariaDB.dbms Twitter: http://twitter.com/mariadb Google+: http://google.com/+mariadb Follow, friend, and add us to your circles to keep up to date with MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL

1 0

[Maria-discuss] KB entry on SQLyog and MONyog
by Peter Laursen 31 Aug '12

31 Aug '12

Hi! We would like to update the AskMonty Knowledgebase entry on MONyog and SQLyog appearing here: http://kb.askmonty.org/en/monyog-sqlyog/ It will not be an advertisement but a listing of 15-20 main features of each of the programs. We would have the same 'level of details' for both programs as HeidiSQL has currently. Maybe also it would be better to independent entries for each program? The question is: can we just go ahead and do ourselves or should we share content for discussion/approval here first? Regards Peter Laursen Webyog

3 2

[Maria-discuss] KB Question: Future of MariaDB?
by Daniel Bartholomew 28 Aug '12

28 Aug '12

The following question has been posted to the Knowledgebase: http://kb.askmonty.org/en/future-of-mariadb/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Future of MariaDB? Where I work, we depend heavily on MySQL. We were recently made aware that Oracle may be slowly closing the source of MySQL; though we are a Sun customer, we depend heavily (and prefer) open source. I mentioned this to my boss and his response was to ask of the future of MariaDB -- because if this project doesn't survive, we're stuck with having to find yet another DB -- in that case, we might have to drink the Oracle koolaid if it comes to that, or move to PostgreSQL (something I've never touched). Commentary on these topics would be interesting to hear. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Thanks. -- Daniel Bartholomew Google+ - http://gplus.to/dbart Twitter - http://twitter.com/daniel_bart MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://gplus.to/mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org Monty Program - http://montyprogram.com

2 1

[Maria-discuss] help tables are obsolete
by Federico Razzoli 18 Aug '12

18 Aug '12

Hello I suppose that you are not going to document MariaDB's features in the help tables. Thought, I think you don't know that the MariaDB 5.5.25 help tables still have MySQL 5.1 contents. This means that: * MySQL 5.5 features (like SIGNAL) are not documented * Existing contents point to MySQL 5.1 documentation. I hope that this feedback is useful. Best greetings, Federico Razzoli

2 1

[Maria-discuss] Debian Wheezy repo for MariaDB?
by Terry 15 Aug '12

15 Aug '12

Hi, Now that Debian Wheezy has gone into a freeze, are there any plans to package MariaDB for Wheezy in the near future? Thanks. -- Terry

2 1