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_buffer = 384M
query_cache_size = 128M
sort_buffer_size = 32M
myisam_sort_buffer_size = 32M
query_cache_limit = 4M
tmp_table_size = 128M
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
# Disabling symbolic-links is recommended to prevent assorted security
risks;
# to do so, uncomment this line:
# symbolic-links=0
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
On 3/22/2010 2:48 PM, John Daisley wrote:
Are you sure its not server load? We frequently have queries on our
DEV system running faster than LIVE simply because the LIVE
environment is getting hammered!
Can you post your my.cnf file?
On Mon, Mar 22, 2010 at 4:38 AM, Abdul Mohid Khan
<abdulmohid.k...@magnaquest.com
<mailto:abdulmohid.k...@magnaquest.com>> wrote:
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) and one update (InnoDB).
Thanks in Advance
