Re: Slow queries with large table

[Pablo Garin]

Thanks Rick, here my answsers:

innodb_buffer_pool_size es set to 3.5G

The other tables are not big. Only 100 rows.

I'am using version 5.5.

Maybe using indexes for Historico I will obtain better results. I will focus no that.

I have experienced that increasing innodb_buffer_pool_size it's a good choice. Before I have 1.5G for this variable, and when I incremented, I got better results, but I still have a performace problem.

Partition tables... Many friends told me that THIS is the solution... (using the DateTime field for the partition) I know, but I want a secondary solution (maybe not the best) without using partition. Mybe in the future, but I want an incremental solution.

Thanks Rick!