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]
>
>
--
