Re: Best Configuration on Production Server

2010-03-22 Thread Abdul Mohid Khan
No Gavin server is hardly having few records because it is not live we are just testing .. after all set we will make live. *Please note that system is having 8GB of RAM and 8 CPU* My.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql lower-case-table-name =1 key_bu

Re: Best Configuration on Production Server

2010-03-21 Thread Abdul Mohid Khan
Hi Gavin, Same setup i am using in both production server and test environment. But the Problem is in test environment one operation is taking 5ms ... but in production(better h/w configuration) 50 ms The Operation which i am talking about is consist of one select, 2 insertion (MyISM) a

RE: Best Configuration on Production Server

2010-03-19 Thread Gavin Towey
What changed between your test that took 5ms and the current production system? -Original Message- From: Abdul Mohid Khan [mailto:abdulmohid.k...@magnaquest.com] Sent: Friday, March 19, 2010 12:27 AM To: mysql@lists.mysql.com Cc: Abdul Mohid Khan Subject: Best Configuration on Production S