[mythtv-users] Bad mysql performance -- huge oldrecorded -- joins without index

[stinga]

On 08/06/16 14:10, Simon Hobson wrote:
>> Mysqltuner complains about "Joins performed without indexes", but I do
>> >not know enough mysql to start looking into that. Any hints ?
> Well that's a code thing - so without altering the code there's nothing you can do to optimise that aspect.
> But there is great scope for just tweaking the memory footprint for MySQL. Up to some point, basically the more RAM you allow it to use, the better it will perform - the defaults are "fairly conservative".
>
> Overall your values look reasonable - I assume you've already been tweaking them. But this one does stand out : "Query cache is disabled" - I assume that's not normal.
You can add an index if you want, no code changes required.

-- 
'ooroo

Stinga...(:)-)
---------------------------------------------------
Email: stinga+mythtv at wolf-rock.com  o
You need only two tools.        o /////
A hammer and duct tape. If it    /@   `\  /) ~
doesn't move and it should use  >  (O)  X<  ~  Fish!!
the hammer. If it moves and      `\___/'  \) ~
shouldn't, use the tape.           \\\
---------------------------------------------------