discuss

Thread Start a new thread

discuss@lists.mariadb.org

June 2014

27 participants
33 discussions

[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

Hi! On 1 Jun 2014, at 17:37, s.kelly(a)pivotaltechnologies.com.au wrote: > I have recently moved from an older version of Mysql to MariaDB, I have a few queries which use internal tmp tables (according to EXPLAIN) and the performance is almost un-usable on MariaDB for some reason. > Is there anything different in MariaDB that would be causing this issue. The version I am using is: Ver 15.1 Distrib 10.0.10-MariaDB. > What are your aria engine settings in my.cnf out of curiosity? Try setting join_cache_level = 0 Please also provide @@optimizer_switch output Thanks P/S: what was the older version of mysql that you're referring to? > Here is the explain from the query: > +------+-------------+-------+-------+---------------+----------+---------+------+------+-------------------------------------------------------------------------------+ > | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | > +------+-------------+-------+-------+---------------+----------+---------+------+------+-------------------------------------------------------------------------------+ > | 1 | SIMPLE | plots | range | plot_IDX | plot_IDX | 4 | NULL | 2939 | Using index condition; Using temporary; Using filesort | > | 1 | SIMPLE | plots | range | plot_IDX | plot_IDX | 4 | NULL | 2939 | Using index condition; Using where; Using join buffer (flat, BNL join) | > | 1 | SIMPLE | plots | range | plot_IDX | plot_IDX | 4 | NULL | 2939 | Using index condition; Using where; Using join buffer (incremental, BNL join) | > | 1 | SIMPLE | plots | range | plot_IDX | plot_IDX | 4 | NULL | 2939 | Using index condition; Using where; Using join buffer (incremental, BNL join) | > | 1 | SIMPLE | plots | range | plot_IDX | plot_IDX | 4 | NULL | 2939 | Using index condition; Using where; Using join buffer (incremental, BNL join) | > | 1 | SIMPLE | plots | range | plot_IDX | plot_IDX | 4 | NULL | 2939 | Using index condition; Using where; Using join buffer (incremental, BNL join) | > +------+-------------+-------+-------+---------------+----------+---------+------+------+-------------------------------------------------------------------------------+ > > To give you an idea, the exact same query on the old version of mysql took about 1 second, this version of MariaDB is taking 1min 48secs on the same hardware. > Any help would be appreciated. > > Thanks Steve. > > -- > You received this message because you are subscribed to the Google Groups "MariaDB-Manager" group. > To unsubscribe from this group and stop receiving emails from it, send an email to mariadbmanager+unsubscribe(a)googlegroups.com. > For more options, visit https://groups.google.com/d/optout. -- Colin Charles, Chief Evangelist, SkySQL - The MariaDB Company blog: http://bytebot.net/blog/| t: +6-012-204-3201 | Skype: colincharles

4 6

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

01 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