On Wed, Nov 7, 2012 at 2:16 PM, Raakesh kumar <[email protected]> wrote: > Dear All, > I am working on a project which is live for some gaming purpose. My problem > is, one of my table size has gone beyond my imagination and it records > nearly 1 lack per day which is making database searching very slow. We have > allocated a separate server for database. > Can anyone suggest me how to get rid of this. One simple solution that > comes into my mind is to use hadoop but any experienced help on this?
You can use a MySQL slave dedicated to search if you are using Full Text Search or use Apache Solr for searching instead of using MySQL. This seems like a good starting guide for HiveDB:- http://himanshubaweja.com/post/7529434265/analytics-reached-mysql-limit-lets-hive Ofcourse you need to add more processing power to get results in a reasonable amount of time. -Tarun _______________________________________________ Ilugd mailing list [email protected] http://frodo.hserus.net/mailman/listinfo/ilugd
