New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Missing index in mysql table piwik_options #1780
Comments
Is there a MySQL message? |
Nevermind. I found the setting: http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_log-queries-not-using-indexes matt: add an index for autoload, option name, or both? |
Well in this specific case i just checked with this one parameter autoload for selection and setting an additional indey for this column. |
the primary key is option name already. I think it makes sense to add an index on autoload, to help the query autoloading the core _option values. Given how _option is used in product, storing settings for websites and users, this suggestion makes sense. |
(In [3696]) Page titles report improvements fixes #1898
Performance improvements
Improvements to integration tests
|
Hey guys,
nothing to worry that bad about, nevertheless, in my mysql log the query
SELECT option_value, option_name FROM
piwik_option
WHERE autoload = 1;appeared. This query does not use an index on the column autoload. As it contains not that much stuff the performance issue is not that dramatic but it gives spaces for optimisation at this point.
Or have there been any special reasons which I did not consider, yet?
rgrds
Peter
The text was updated successfully, but these errors were encountered: