What kind of queries is this table serving? 8GB is not a huge amount of data at all and IMO it's not enough to warrant sharding.
On Thu, May 15, 2014 at 1:26 PM, Antonio Fernández Pérez < antoniofernan...@fabergroup.es> wrote: > > > > Hi, > > I have in my server database some tables that are too much big and produce > some slow query, even with correct indexes created. > > For my application, it's necessary to have all the data because we make an > authentication process with RADIUS users (AAA protocol) to determine if one > user can or not navigate in Internet (Depending on the time of all his > sessions). > > So, with 8GB of data in one table, what are your advices to follow? > Fragmentation and sharding discarted because we are working with disk > arrays, so not apply. Another option is to delete rows, but in this case, I > can't. For the other hand, maybe de only possible solution is increase the > resources (RAM). > > Any ideas? > > Thanks in advance. > > Regards, > > Antonio. >