You should run into out of memory scenaria. OS is keeping to free some
memory that delay mysql connection.
On 8/13/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
> On Wed, Aug 13, 2008 at 1:30 PM, Doug Bridgens <[EMAIL PROTECTED]> wrote:
>
> > 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')?
>
>
> No
>
> >
> > 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?
> >
>
> mysql client 5.0.19
>
> >
> > When you are doing the above tests, do them with the server name and with
> > the IP address.
>
>
> Tried with both
>
> 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]
> >
> >
>
>
> --
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
