Quote:
Originally Posted by Agrouf
It has something to do with php.
look at access_log to see which page was last accessed.
|
Thank for ur reply.We have found the problem.The problem is 15 days back to tweak mysql perfomance we have made changes in my.cnf to allocate more memory to mysql and restarted mysql.we didnt restart httpd that time.
When we restarted httpd last week the problem started.There is memory allocation for apache.
when we restored with old mysql configuration my.cnf the problem stopped happening.
Server IBM x3400 with 2gb memory.30- 40 concurrent users accessing the server(Hospital Management System Application).
database details:
456K marthasbloodbankv2
2.2G marthasfacontrollerv3
111M marthasfav
19M marthaspayrollv31
161M marthaspharmacyv2
241M marthaspharmacyv22008
948K marthasstoresv2
37M marthasultrasoundv2
863M marthasv2
3.2M marthasxrayv2
Present my.cnf
-------------
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
# ganesh begin
port = 3306
key_buffer_size=32M
max_allowed_packet=10M
#table_cache=127
max_connections=310
max_user_connections=300
wait_timeout=120
flush_time=300
query_cache_type = 1
query_cache_size = 16M
innodb_data_home_dir =
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_file_size=20M
innodb_additional_mem_pool_size=10M
innodb_buffer_pool_size=64M
innodb_lock_wait_timeout=120
# ganesh end
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
tried my.cnf
-----------
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
# ganesh begin
port = 3306
key_buffer_size=64M
max_allowed_packet=10M
table_cache=256
thread_cache_size=16
max_connections=310
max_user_connections=300
wait_timeout=600
sort_buffer_size=4M
join_buffer_size =4M
read_buffer_size=4M
read_rnd_buffer_size = 16M
myisam_sort_buffer_size = 64M
flush_time=300
long_query_time=15
tmp_table_size=32M
query_cache_type = 1
query_cache_limit= 2M
query_cache_size = 32M
innodb_data_home_dir =
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_file_size=20M
innodb_additional_mem_pool_size=10M
innodb_buffer_pool_size=64M
innodb_lock_wait_timeout=120
# ganesh end
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
log-error=/var/log/mysqld.log
Can you give me some suggestion to increase the perfomance of the server.
Thanks and regards,
Pawan Ganesh