Do you have any other services running on the server, such as mail or
web? How long does it take to connect to those services ('telnet
<server> 25', or telnet <server> 80')?
What are you using to connect to mysql? how long does 'telnet
<server> 3306' take (assuming you are on the default port and have
firewall access)? How long does it take to connect from a local
server session?
When you are doing the above tests, do them with the server name and
with the IP address.
The above should let you rule out your client, and any server related
issues such as DNS or firewall. So you will know if it is a mysql
problem or not.
cheers,
Doug
On 13 Aug 2008, at 05:39, Krishna Chandra Prajapati wrote:
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,
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
