October 2012 - discuss - lists.mariadb.org

[Maria-discuss] Fwd: [debian-mysql] Bug#688505: MariaDB packaging.
by Colin Charles 19 Jan '13

19 Jan '13

A good wishlist. I think more should vote for this, quite clearly! cheers, -colin Begin forwarded message: > Resent-From: Robert de Bath <robert$(a)debath.co.uk> > From: Robert de Bath <robert$(a)debath.co.uk> > Subject: [debian-mysql] Bug#688505: MariaDB packaging. > Date: 23 September 2012 16:25:39 GMT+08:00 > Resent-To: debian-bugs-dist(a)lists.debian.org > To: submit(a)bugs.debian.org > Resent-Cc: Debian MySQL Maintainers <pkg-mysql-maint(a)lists.alioth.debian.org> > Reply-To: Robert de Bath <robert$(a)debath.co.uk>, 688505(a)bugs.debian.org > > Package: mysql-server > Version: 5.5.24+dfsg-8 > Severity: wishlist > > My very technically savvy webhost has recently switched from MySQL to > MariaDB and claim it's for both technical and political reasons. > > Both of these reasons (better performance and better licensing) appear > to be good reasons for the software to be packaged as a Debian package > and I expect it's getting to the point that someone will do it themselves. > > BUT the software is technically still not a forked variant of MySQL > but a patched version where the maintainers continually resync to the > Oracle releases. For this reason I would like to see it treated as just > a simple MySQL version within Debian. This way the users (ie: me) can > simply switch by prodding apt in the right way. > > For this to work seamlessly (unlike, for example, the recent multimedia > troubles) the MariaDB package should be packaged identically to MySQL, > which IMO is best done by the same Debian maintainers. > > So my request is that you package the MariaDB as a secondary version of > MySQL in such a way that the two packages can be seamlessly switched within the Debian system. > > -- > Rob. (Robert de Bath <robert$ @ debath.co.uk>) > <http://www.debath.co.uk/> > > _______________________________________________ > pkg-mysql-maint mailing list > pkg-mysql-maint(a)lists.alioth.debian.org > http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-mysql-maint -- Colin Charles, http://bytebot.net/blog/ | twitter: @bytebot | skype: colincharles MariaDB: Community developed. Feature enhanced. Backward compatible. Download it at: http://www.mariadb.org/ Open MariaDB/MySQL documentation at the Knowledgebase: http://kb.askmonty.org/

3 3

[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