udovdh at xs4all
Jun 22, 2010, 9:56 AM
Post #1 of 1
(131 views)
Permalink
|
|
Adding indexes? (You have had 2980 queries where a join could not use an index properly)
|
|
Hello,
I am running 0.23-fixes.
The tuning-primer shell script says something like:
JOINS
Current join_buffer_size = 8.00 M
You have had 2980 queries where a join could not use an index properly
join_buffer_size >= 4 M
This is not advised
You should enable "log-queries-not-using-indexes"
Then look for non indexed joins in the slow query log.
So what/where are the typical indexes that I could add that are already
known to be missing somewhat?
Could anybody of the mythtv/MySQL guru's here educate me on this?
Kind regards,
Udo
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
|
