Re: INNODB large database performance

[Paul Smith]

I will try changing the index and see what results I get. The worry I have is that I have 14 million records and am running into issues and could potentially have billions. A customer can have 10000 channels each writing data every 5 or 15 minutes to the data d table. :/

I already have summary tables which is what I use if the date range is greater than a month, then I use what I call a dailydata table which has a total for each channel each day. My clients wish to view anything less than. Month at a more granular level so I need the data table as its each reporting interval.

Maybe i can explain what i have planned for so far, Each customer will have their own database on a server which will have any number of customers. I have a master db and x number of slaves with different size customers on them. My thoughts behind merge tables was that they would be easier to manage than partitions? I don't have a massive amount of resource and the system is already live due to constraints on time out of my control so the easier the solution and the easier to manage the better.

Your suggestions are massively appreciated. I will post results once I change the index.

Many Thanks