- discuss - lists.mariadb.org

[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

[Maria-discuss] Does the Cassandra storage engine support CQL3 created tables?
by Mohammed Guller 03 Jun '14

03 Jun '14

I am able to access a Cassandra column family created with COMPACT storage directive from MariaDB (v10.0.10). However, it does not seem to recognize regular CFs created using CQL3. I am not sure whether I am missing some configuration step in the Cassandra storage engine or it still does not support regular CQL3 CFs. Has anyone able to make Cassandra SE work with regular CQL3 CFs? Mohammed Applications Architect, Glassbeam Inc, www.glassbeam.com<http://www.glassbeam.com/>, 5201 Great America Parkway, Suite 360, Santa Clara, CA 95054 p: +1.408.740.4610<tel:%2B1.408.740.4615>, m: +1.925.786.7521<tel:%2B1.650.804.5065>, f: +1.408.740.4601<tel:%2B1.408.740.4601>

4 3

Re: [Maria-discuss] Internal tmp tables
by Colin Charles 02 Jun '14

02 Jun '14

4 6

[Maria-discuss] query cache and galera
by Roberto Spadim 02 Jun '14

02 Jun '14

Hi guys, i was testing mariadb-galera and checked that query cache is disabled with galera Is it ok or i'm doing something wrong? -- Roberto Spadim SPAEmpresarial Eng. Automação e Controle

2 1

[Maria-discuss] Are queries queued when locking a table?
by Jimmy Thrasibule 28 May '14

28 May '14

Hello, Some backup tools make use of table locking to ensure data consistency during the operation. I'm wondering about what happens to the incoming queries for the table being locked. Obviously, the request will be pending until the table is unlocked but this way some timeout value may be reached. Another option could be to accept and queue all requests and replay them once the table is unlocked. So can you tell me how MariaDB is handling such situation. Is the second option (asynchronous request), can be activated within MariaDB? Best, Jimmy

3 2

[Maria-discuss] kill query id
by Roberto Spadim 26 May '14

26 May '14

Hi guys, some time ago i reported a MDEV-4911 about kill a query by query_id I'm was a bit busy and i don't know if that mdev was merged to official release, does anyone know about it? -- Roberto Spadim SPAEmpresarial Eng. Automação e Controle

1 1

[Maria-discuss] Role template
by Jimmy Thrasibule 26 May '14

26 May '14

Hi, Roles [1] have been introduced with MariaDB 10.0.5. This feature is very interesting to group and standardize grants in one place. However roles are static, meaning that it is not possible to create a template to apply later on another database. I'm looking for something similar to a stored procedure: CREATE ROLE r1(db); GRANT ALL PRIVILEGES ON $(db).* TO r1; Here, the role takes a parameter we can use to make privileges a bit more dynamic. We can then apply this role on a dedicated database like: GRANT r1(mydb) TO 'myuser'@'localhost'; Can this already be done or do you think that's a feature that could come? [1]: https://mariadb.com/kb/en/roles-overview/ Regards, Jimmy

4 4

Re: [Maria-discuss] SPIDER Maria10 ->My55
by Federico Razzoli 25 May '14

25 May '14

Hi Kentoku I think you answered directly to my address by mistake, so I'm sending this reply to the list. I changed the values of those variables and now everything works. Thank you! Regards Federico -------------------------------------------- El dom, 25/5/14, kentoku <kentokushiba(a)gmail.com> escribió: Asunto: Re: [Maria-discuss] SPIDER Maria10 ->My55 Para: "Federico Razzoli" <federico_raz(a)yahoo.it> Fecha: domingo, 25 de mayo, 2014 20:02 Hi Federico, > Can a SPIDER table, on MariaDB 10.0, connect to a remote MySQL 5.5 table? I can't find this info. Yes, it can. > If it can, I have a problem I don't understand. I can create the table, but when I execute any query I get: > > ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation > > (which is misleading in any case, since I have SUPER) > > Nothing is written to the local error log (and I can't access the remote one). Normally, Spider sends "set sql_log_off" command to remote server after connecting, and this command needs SUPER privilege. For fixing this error, please perform one of the followings. - add SUPER privilege to user for Spider table on remote MySQL 5.5 server. - set Spider options "spider_internal_sql_log_off = 0" and "spider_remote_sql_log_off = 0" in configuration file. Thanks, Kentoku 2014-05-23 18:38 GMT+09:00 Federico Razzoli <federico_raz(a)yahoo.it>: > Hi all. > Can a SPIDER table, on MariaDB 10.0, connect to a remote MySQL 5.5 table? I can't find this info. > If it can, I have a problem I don't understand. I can create the table, but when I execute any query I get: > > ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation > > (which is misleading in any case, since I have SUPER) > > Nothing is written to the local error log (and I can't access the remote one). > > Federico > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-discuss > Post to : maria-discuss(a)lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp

1 0