- discuss - lists.mariadb.org

[Maria-discuss] MariaDB 10.0.0 Alpha now available
by Daniel Bartholomew 12 Nov '12

12 Nov '12

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.0. This is an alpha release. MariaDB 10.0 is the development version of MariaDB. It is built on the MariaDB 5.5 series with backported features from MySQL 5.6 and entirely new features not found anywhere else. This is the first 10.0-based release, and we are releasing it now to get it into the hands of any who might want to test it. Not all features planned for the MariaDB 10.0 series are included in this release. Additional features will be pushed in future releases. Do not use alpha releases on production systems. - - MariaDB 10.0 Links - - - - - - - - - - - - - - - - - - - - - - - - - Release Notes: http://kb.askmonty.org/en/mariadb-1000-release-notes Changelog: http://kb.askmonty.org/en/mariadb-1000-changelog Downloads: http://downloads.mariadb.org/mariadb/10.0.0 APT and YUM Repository Configuration Generator: http://downloads.mariadb.org/mariadb/repositories/ Overview of MariaDB 10.0: http://kb.askmonty.org/en/what-is-mariadb-100 - - 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 - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - We've created a CafePress store which offers an exclusive t-shirt or other item in return for a donation to the MariaDB project: - http://www.cafepress.com/mariadb Please check it out and let us know what you think! All proceeds go directly to support MariaDB development, so don't think of it as purchasing a t-shirt, think of it as donating to support a worthy project and awesome product... and you get a t-shirt as a nice bonus! If you would like to contribute to MariaDB in other ways, please see our "contributing" and "donations" pages in the Knowledgebase: - https://kb.askmonty.org/en/contributing - https://kb.askmonty.org/en/donations 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] TRUNCATE TABLE becomes hang sometimes
by Haseena L. 10 Nov '12

10 Nov '12

Hi, Now Iam trying to migrate from MySQL to MariaDB. Why does the TRUNCATE TABLE statement hang sometimes? What are the reasons for this type of issue? This problem doesn't happen with MySQL, only with MariaDB. The hanging statement is simply: TRUNCATE TABLE sampledb.datatable; What can cause this to happen, and how could I fix it? Another one observation is if the table have some data, may be one or two rows, then the truncate query works successfully. Else the table have a lot of data, query becomes hang. If the same table have more than one connetion, then the truncate table query hangs. How I fix it??? Now Iam blocking. Engine I selected is MyISAM. Thanks and Regards, Haseena ***** Confidentiality Statement/Disclaimer ***** This message and any attachments is intended for the sole use of the intended recipient. It may contain confidential information. Any unauthorized use, dissemination or modification is strictly prohibited. If you are not the intended recipient, please notify the sender immediately then delete it from all your systems, and do not copy, use or print. Internet communications are not secure and it is the responsibility of the recipient to make sure that it is virus/malicious code exempt. The company/sender cannot be responsible for any unauthorized alterations or modifications made to the contents. If you require any form of confirmation of the contents, please contact the company/sender. The company/sender is not liable for any errors or omissions in the content of this message.

2 1

[Maria-discuss] TRUNCATE TABLE becomes hang sometimes
by Haseena L. 06 Nov '12

06 Nov '12

Hi, Now Iam trying to migrate from MySQL to MariaDB. Why does the TRUNCATE TABLE statement hang sometimes? What are the reasons for this type of issue? This problem doesn't happen with MySQL, only with MariaDB. The hanging statement is simply: TRUNCATE TABLE sampledb.datatable; What can cause this to happen, and how could I fix it? Another one observation is if the table have some data, may be one or two rows, then the truncate query works successfully. Else the table have a lot of data, query becomes hang. If the same table have more than one connetion, then the truncate table query hangs. How I fix it??? Now Iam blocking. Engine I selected is MyISAM. Thanks and Regards, Haseena ***** Confidentiality Statement/Disclaimer ***** This message and any attachments is intended for the sole use of the intended recipient. It may contain confidential information. Any unauthorized use, dissemination or modification is strictly prohibited. If you are not the intended recipient, please notify the sender immediately then delete it from all your systems, and do not copy, use or print. Internet communications are not secure and it is the responsibility of the recipient to make sure that it is virus/malicious code exempt. The company/sender cannot be responsible for any unauthorized alterations or modifications made to the contents. If you require any form of confirmation of the contents, please contact the company/sender. The company/sender is not liable for any errors or omissions in the content of this message.

1 0

[Maria-discuss] MariaDB 5.5.28 now available
by Daniel Bartholomew 22 Oct '12

22 Oct '12

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.28. This is a stable (GA) release. - - MariaDB 5.5 Links - - - - - - - - - - - - - - - - - - - - - - - - - Release Notes: http://kb.askmonty.org/en/mariadb-5528-release-notes Changelog: http://kb.askmonty.org/en/mariadb-5528-changelog Downloads: http://downloads.mariadb.org/mariadb/5.5.28 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 - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - We've created a CafePress store which offers an exclusive t-shirt or other item in return for a donation to the MariaDB project: - http://www.cafepress.com/mariadb Please check it out and let us know what you think! All proceeds go directly to support MariaDB development, so don't think of it as purchasing a t-shirt, think of it as donating to support a worthy project and awesome product... and you get a t-shirt as a nice bonus! If you would like to contribute to MariaDB in other ways, please see our "contributing" and "donations" pages in the Knowledgebase: - https://kb.askmonty.org/en/contributing - https://kb.askmonty.org/en/donations 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] 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