mysql indexes optimization

gde · Post by **gde** » Mon Jan 10, 2011 4:27 am

Hello,

I've found this bug report by reading different posts on optimizing cacti. Since it was marked as solved for cacti 0.8.8 I thought it wasn't a bad idea to implement it on one of the cactis I manage. After building them, I launched mysqltuner.pl. To my surprise, I get a warning joins are done without indexes:

[!!] Joins performed without indexes: 168525

I don't get this message on other cactis. I haven't read anything related to this issue. Have I been missing something ?

regards,
gde

Post by **gandalf** » Mon Jan 10, 2011 6:44 pm

Did you run this on 088 code?
R.

gde · Post by **gde** » Wed Jan 12, 2011 9:57 am

no, I did it on 087g code

gde

Post by **gandalf** » Wed Jan 12, 2011 3:24 pm

But why do you assume that the fixes made for 088 on using indexes should appear in 087 already?
If this is of importance, you may study the existing 088 upgrade file for additionally created indexes. You may create them on your current cacti. Please pay attention: every occurrence of "host" was changed to "device"
R.

gde · Post by **gde** » Thu Jan 13, 2011 11:39 am

Actually, the reason why I applied it was because it was advised here : http://forums.cacti.net/about29707.html.
It's not much of importance really, I'm just trying to find any optimizing leverage I can use.
I'll look into the 088 upgrade file…

thanks

Deviloper · Post by **Deviloper** » Fri Jan 14, 2011 1:12 pm

Think about horizontal split of tables to in proof io performance.

Post by **gandalf** » Sun Jan 16, 2011 2:09 pm

Deviloper wrote:Think about horizontal split of tables to in proof io performance.

Valid. Others are running the db in memory ...
R.

Cacti

mysql indexes optimization

mysql indexes optimization

Re: mysql indexes optimization

Re: mysql indexes optimization

Re: mysql indexes optimization

Re: mysql indexes optimization

Re: mysql indexes optimization

Re: mysql indexes optimization

Who is online