It should be identical select statements which will improve performance and not the updates. Go through the below url for more information about optimization and performance http://dev.mysql.com/doc/refman/5.0/en/optimizing-the-server.html
On Thu, Jan 7, 2010 at 4:42 PM, F.A.I.Z.A.L <sac.fai...@gmail.com> wrote: > hi > > i can see many 'updates' is going every min. so is it good to increase this > query_cache_size ?.. > > what are the other action i can take to improve the performance of mysql > server > > environment > version : 5.0.22 > platform : redhat 5 > > > > Cheers > Faizal S > GSM : 9840118673 > Blog: http://oradbapro.blogspot.com > > > -- Thanks Suresh Kuna MySQL DBA