Poor MySQL Query performance
#26
(2018-03-21, 08:48)ventolin Wrote:
(2018-03-20, 23:44)marantz Wrote: just tested this on mariadb 10.2.13 and SET SESSION optimizer_switch = 'derived_merge=off'; had no effect on performance
 Good to know. I had bad (and similar) experiences when I switched to MariaDB and was met with very hostile answers along the lines of "mysql db backend is barely supported, mariadb definitely not" in #xbmc on freenode when I asked about it. 

I might give it another go this weekend just to see if things have improved with mariadb 10.1. Thanks! 
 Yes this is a running theme within the team as MYSQL support was added, when really the team wanted a full client to client approach in the long term. Nobody wrote that yet so, we are kind of stuck with the old style central server approach which nobody really supports.
Reply


Messages In This Thread
Poor MySQL Query performance - by ventolin - 2017-10-29, 14:22
RE: Poor MySQL Query performance - by marantz - 2017-11-01, 13:55
RE: Poor MySQL Query performance - by marantz - 2017-11-02, 14:09
RE: Poor MySQL Query performance - by marantz - 2018-03-20, 23:44
RE: Poor MySQL Query performance - by docwra - 2018-03-21, 14:36
Logout Mark Read Team Forum Stats Members Help
Poor MySQL Query performance0