Re: [Maria-discuss] Internal tmp tables

2014-06-01 Thread s . kelly
Attached is a dump of show variables. Steve On Monday, June 2, 2014 2:56:48 PM UTC+10, Roberto Spadim wrote: > > Maybe a show variables could help via pastebin or something like it > > Em segunda-feira, 2 de junho de 2014, Steve Kelly < > s.k...@pivotaltechnologies.com.au > escreveu: > >> Hi Coli

Re: [Maria-discuss] Internal tmp tables

2014-06-01 Thread Roberto Spadim
Maybe a show variables could help via pastebin or something like it Em segunda-feira, 2 de junho de 2014, Steve Kelly < s.ke...@pivotaltechnologies.com.au> escreveu: > Hi Colin > > Thanks for the reply. The older version of mysql was: Ver 14.14 Distrib > 5.1.72 > > The only difference the join_ca

Re: [Maria-discuss] Internal tmp tables

2014-06-01 Thread Steve Kelly
Hi Colin Thanks for the reply. The older version of mysql was: Ver 14.14 Distrib 5.1.72 The only difference the join_cache_level seemed to make was when I looked at the Explain, it no longer stated it was using the join buffer. As far as execution time, it was identical. I don't really have

Re: [Maria-discuss] Internal tmp tables

2014-06-01 Thread Colin Charles
Hi! On 1 Jun 2014, at 17:37, s.ke...@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

Re: [Maria-discuss] query cache and galera

2014-06-01 Thread Elena Stepanova
Hi Roberto, On 27.05.2014 5:06, Roberto Spadim wrote: 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? See the discussion regarding the query cache on Codership mailing list: https://groups.google.com/forum/?hl=r