Hi all,
Connecting to mysql server (Production) is taking 5 to 6 seconds. Production
has 16Gb ram. Previously it was using only 6GB ram. The details are as
follows. DNS looks fine.
free -m
total used free shared buffers cached
Mem: 15899 15877 21 0 97 13913
-/+ buffers/cache: 1865 14033
Swap: 0 0 0
-----------------------
vmstat
procs -----------memory---------- ---swap-- -----io---- -system--
----cpu----
r b swpd free buff cache si so bi bo in cs us sy id
wa
0 0 0 26792 100600 14242868 0 0 89 150 0 0 7 1
92 0
1
-----------------------------------------
cat /proc/meminfo
MemTotal: 16281204 kB
MemFree: 26692 kB
Buffers: 100916 kB
Cached: 14243248 kB
SwapCached: 0 kB
Active: 8338968 kB
Inactive: 7679900 kB
HighTotal: 0 kB
HighFree: 0 kB
LowTotal: 16281204 kB
LowFree: 26692 kB
SwapTotal: 0 kB
SwapFree: 0 kB
Dirty: 224 kB
Writeback: 0 kB
AnonPages: 1674640 kB
Mapped: 11616 kB
Slab: 215140 kB
PageTables: 4232 kB
NFS_Unstable: 0 kB
Bounce: 0 kB
CommitLimit: 8140600 kB
Committed_AS: 2182136 kB
VmallocTotal: 34359738367 kB
VmallocUsed: 252 kB
VmallocChunk: 34359738043 kB
------------------------------------------------------
ps aux (The below process is only process using cpu and memory)
mysql 3963 10.6 10.2 2190136 1671816 ? Sl Mar28 21019:10
/usr/sbin/mysqld --basedir=/usr --datadir=/v
cpu usage 10.6
memory usage 10.2
Please tell how & what are the reasons and how can i solve this problem.
Krishna Chandra Prajapati
MySQL DBA,
