Indexes on tables

[tukak]

Hello,
it seems that the database on vicidial is not indexed by default and I found out that there are quite a lot of queries, which could (probably) profit from adding some indexed. First of all, is there any reason why not to add these indexes? And then, did someone already tried to analyze this and has a list of indexes to be made?

Mysql variables, which are too high on our server :

Handler_read_rnd
Handler_read_rnd_next
Select_full_join

Thanks, Lukas

[mflorell]

There are some indexes already, but we have avoided adding too many because too many indexes can lead to slowing of your system.

I would love for someone to do an analysis of the database and come up with some indexes that we can add to make the system run more efficiently.