- discuss - lists.mariadb.org

[Maria-discuss] newbie question
by Roberto Spadim 12 Jun '14

12 Jun '14

Guys, i'm with a "newbie" question I need to swap a primary key value, for example: create table test ( id int not null default 0, other varchar(255) not null default '', primary key(id) ); insert into test (1,'a'); insert into test (2,'b'); now i want that (2,'b') becomes (1,'b') and (1,'a') becomes (2,'a') the point is, how to do this, with only one UPDATE without duplicate column id value? and without delete values? -- Roberto Spadim

4 13

[Maria-discuss] MariaDB Galera Cluster 10.0.11 now available
by Daniel Bartholomew 12 Jun '14

12 Jun '14

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 10.0.11 This is a Beta release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster 10.0.11 - Release Notes: https://mariadb.com/kb/en/mariadb-galera-cluster-10011-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-galera-cluster-10011-changelog - Downloads: https://downloads.mariadb.org/mariadb-galera/10.0.11 About MariaDB Galera Cluster: - https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - SkySQL has held several MariaDB-focused Webinars recently which are available on an on-demand basis at: - http://www.skysql.com/why-skysql/webinars/ They are also planning several more MariaDB-focused webinars that will be held over the comming months. Details available at the above link. - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - The recently published MariaDB Cookbook contains nearly 100 recipes covering a variety of features in MariaDB. - http://www.packtpub.com/exclusive-and-unique-features-of-mariadb/book Another book, Getting Started with MariaDB is a how-to guide for beginners to help them get up to speed quickly with MariaDB. No prior database experience required. - http://www.packtpub.com/getting-started-with-mariadb/book - - 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/ - http://www.cafepress.com/mariadb 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] ncurses and mysql
by Roberto Spadim 11 Jun '14

11 Jun '14

Hi guys, i'm running slackware 14.1, i upgrade to slackware-current, and downloaded the mariadb-10.0.11 x64 with glibc 2.19 the point is... whern i run mysql, it requires a 'deprecated' library, libtinfo.so.5, this one was replaced by libncurses.so.5 there's something we could help here? today i execute a symlink to solve this problem, but since libtinfo is deprecated, should we update our compile line? -- Roberto Spadim SPAEmpresarial Eng. Automação e Controle

3 4

[Maria-discuss] MariaDB 5.5.38 now available
by Daniel Bartholomew 09 Jun '14

09 Jun '14

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.38 This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.38 - Release Notes: https://mariadb.com/kb/en/mariadb-5538-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-5538-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.5.38 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 Webinars - - - - - - - - - - - - - - - - - - - - - - - - - SkySQL has held several MariaDB-focused Webinars recently which are available on an on-demand basis at: - http://www.skysql.com/why-skysql/webinars/ They are also planning several more MariaDB-focused webinars that will be held over the comming months. Details available at the above link. - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - The recently published MariaDB Cookbook contains nearly 100 recipes covering a variety of features in MariaDB 10.0. - http://www.packtpub.com/exclusive-and-unique-features-of-mariadb/book Another book, Getting Started with MariaDB is a how-to guide for beginners to help them get up to speed quickly with MariaDB. No prior database experience required. - http://www.packtpub.com/getting-started-with-mariadb/book - - 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/ - http://www.cafepress.com/mariadb 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 encryption
by Jonas Oreland 06 Jun '14

06 Jun '14

Hi there, I read this blog post http://monty-says.blogspot.com/2014/05/for-your-eyes-only-or-adding-better.… and wanted to inform you that we at Google has developed on-disk/block-level encryption for Innodb, aria (as used by temporary tables), binlogs and temp-files. The code is not yet published, but we expect it to be within a few weeks or so. We (of course?) think that it would be better if you instead of developing new code spent the time testing/reviewing ours. I'm happy to answer questions on the topic, and will let you know once we've published it. /Jonas ps. Ian talked about this at percona, https://www.percona.com/live/mysql-conference-2014/sessions/privacy-and-sec…

4 6

[Maria-discuss] EXPLAIN and CONNECT
by Federico Razzoli 04 Jun '14

04 Jun '14

6 17

[Maria-discuss] New Question: Spider storage engine condition pushdown
by AskMonty KB 04 Jun '14

04 Jun '14

Hello, A new question has been asked in "Spider" by lokeshkumar-p-417: -------------------------------- Hi, We are using Spider storage engine for sharding with MariaDB. MariaDB version - 10.0.10 Spider version - 3.2 Platform - CentOs 6.5 Problem: ---------------- We have a simple scenario, where we have a table with Spider storage engine, which is list partitioned based on a column. Each partition is pointing to a shard. Whenever a query is fired from the Master database with a WHERE clause, the WHERE condition is not being pushed to the shard, instead all the data from shard is being transferred to the DB where Spider storage engine is present. I came to know that this issue has been fixed in the Spider storage engine, and also I verified the MariaDB 10.0.9-spider-3.2 source code and it has cond_push and cond_pop functions. Please let me know how else can I enable this condition pushdown. Regards, -Lokesh Kumar -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/spider-storage-engine-condition-pushdown/

1 0

[Maria-discuss] PERFORMANCE_SCHEMA to be disabled in 10.0 (10.0.12)
by Colin Charles 03 Jun '14

03 Jun '14

Hi all, Recently there was chat about how PERFORMANCE_SCHEMA was enabled by mistake and it should be disabled in the 10.0 series. I'm curious - how many of you are using PERFORMANCE_SCHEMA? Is it a problem to turn it on, if you use it? I'm referring to: https://mariadb.atlassian.net/browse/MDEV-6249 Looking from the webscalesql list, there are examples of performance degradation: https://groups.google.com/d/msg/webscalesql/B-4bPIb8mHI/eUNsl0lSfbMJ https://groups.google.com/d/msg/webscalesql/B-4bPIb8mHI/-YZMMCuPw3QJ quote: "Our perf testing agrees with your assessment (we see about a 5%-6% perf hit when it's included and on, and a 2%-3% hit when it's included but off)" Please discuss this, either here or on MDEV-6249 Thanks cheers, -colin -- Colin Charles, Chief Evangelist, SkySQL - The MariaDB Company blog: http://bytebot.net/blog/| t: +6-012-204-3201 | Skype: colincharles

8 12

[Maria-discuss] New Question: How much storage is available in the FREE versions of MariaDB 5.x and 10.x?
by AskMonty KB 03 Jun '14

03 Jun '14

Hello, A new question has been asked in "MariaDB community" by cyberdomecyberdome: -------------------------------- How much storage is available in the FREE versions of MariaDB 5.x and 10.x? I just want to know how much upto storage available in the MariaDB 5.0 and 10.0 free version? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-community-how-much-storage-is-available-in…

2 1

Re: [Maria-discuss] Fwd: Merging FusionIO changes to 10.0.12
by Honza Horak 03 Jun '14

03 Jun '14

On 06/03/2014 09:43 AM, Colin Charles wrote: > Hey Honza, > > It seems that you were silent on this - just wanted to know if Red Hat is OK with things Thanks for bringing it to my attention and sorry about being silent. I don't see any problem for RH/Fedora, feel free to include it and we're already looking forward to play with it. Regards, Honza > (others seemed to be quite relaxed about it) > > cheers, > -colin > > > Begin forwarded message: > >> From: Colin Charles <colin(a)mariadb.org> >> Subject: Merging FusionIO changes to 10.0.12 >> Date: 16 May 2014 17:28:27 GMT+8 >> To: MariaDB discuss <maria-discuss(a)lists.launchpad.net>, maria-developers(a)lists.launchpad.net >> >> Hi all, >> >> MariaDB has worked actively with Fusion-io, and we did release some improvements in a preview release a little over a month ago: https://blog.mariadb.org/significant-performance-boost-with-new-mariadb-pag… >> >> This was originally planned to be included into 10.0.10, but when we released the GA, we thought that the feature was not tested thoroughly. >> >> Now the code has proven stable we are thinking of merging this into 10.0.12. Yes, we know its already a GA, but this feature will be turned off by default, and the code is safely encapsulated. If you are not using Fusion-io or do not turn it on, there is no effect to you. To check, the changes are in the XtraDB and InnoDB that we ship (storage/xtradb & storage/innobase). >> >> Naturally, for those using Fusion-io devices, the benefits are clear - you will see significant improvements in speed and you will increase the lifetime of your cards. Think of this like adding drivers to the Linux kernel from time to time ;) >> >> What does everyone think? Package maintainers? >> >> Thanks! >> >> -- >> Colin Charles, Chief Evangelist, SkySQL - The MariaDB Company >> blog: http://bytebot.net/blog/| t: +6-012-204-3201 | Skype: colincharles >> > > -- > Colin Charles, Chief Evangelist, SkySQL - The MariaDB Company > blog: http://bytebot.net/blog/| t: +6-012-204-3201 | Skype: colincharles >

1 0