i didn't checked if it's a compile time configuration
but, reading manual probably yes, and it's readonly (sorry i didn't checked
before)
but, please check if it's possible to change to myisam and test recompiling
mariadb, i never tried this, maybe another guy here could help
https://mariadb.com/k
I did try that the other day thinking it could be the aria engine, problem
is I couldn't work out how to do it.
Putting aria_used_for_temp_tables=OFF in my.cnf yields this error: [ERROR]
/usr/sbin/mysqld: unknown variable 'aria_used_for_temp_tables=OFF'
Is there a way you can disable it?
On Tu
try changin aria_used_for_temp_tables ON, to OFF
just to check if the problem is aria engine or not
2014-06-02 2:24 GMT-03:00 :
> 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 past
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
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
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
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
7 matches
Mail list logo
