mysql update

I have the following update procedure that update mySQL DB over the
internet between source Linux Centos (local machine on my net behind a
DMZ with real IP A.B.C.D) and target Linux fedora (web server
www.myweb.com) every day on a specific time 18:00 through a crontab on
my source linux server

server(source) ---DMZ---ASA---Router-----Internet----HostingCompany---Myweb (target)
[root@source]# mysql -u updatex -p -h www.myweb.com test < sample.SQL


[root@source]$ mysql -u updatex -p -h www.myweb.com test < sample.SQL
Enter password: *****
CURTIME()
19:41:44
CURTIME()
19:50:09

[root@source]$ mysql -u updatex -p -h www.myweb.com test < sample.SQL
Enter password:*****
CURTIME()
08:26:08
CURTIME()
08:26:34

I did the above procedure multiple times in different times in the
day. the duration of this procedure takes from 22sec to 10min
see above...., before a while it was running constant with duration of
30sec. I checked with my ISP, hosting company and network nothing been
changed from the structure/configuration.....

[root@source]# lsof -i -P | grep 3306
mysqld 3806 mysql 11u IPv4 10926 TCP *:3306 (LISTEN)
mysql 15150 user 3u IPv4 297528 TCP
192.168.10.5:8376->www.myweb.com:3306 (ESTABLISHED)

[root@target]# netstat -a |grep mysql
tcp 0 0 *:mysql *:*
LISTEN
tcp 0 0 www.myweb.:mysql A.B.C.D:8366 TIME_WAIT
tcp 0 11 www.myweb.:mysql A.B.C.D:8372 ESTABLISHED
also i attached tcp connection between the nodes as above from source
and target,
can any one help why i have this behavior and how can i fix the delay,
thinking doing QoS or clean up and remoteexcution at that time ...

Thanks in advance

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: mysql update

--00504502b4439ec318047dbe293b
Content-Type: text/plain; charset=ISO-8859-1

Did you check the server load when it took 10 min.
Check the query log, number of connections and the number of queries in
query log at that time.
We need to analyze the system with the collected data what we have for
monitoring.

Thanks
Suresh Kuna

On Fri, Jan 22, 2010 at 12:25 PM, madunix wrote:

> I have the following update procedure that update mySQL DB over the
> internet between source Linux Centos (local machine on my net behind a
> DMZ with real IP A.B.C.D) and target Linux fedora (web server
> www.myweb.com) every day on a specific time 18:00 through a crontab on
> my source linux server
>
> server(source)
> ---DMZ---ASA---Router-----Internet----HostingCompany---Myweb (target)
> [root@source]# mysql -u updatex -p -h www.myweb.com test < sample.SQL
>
>
> [root@source]$ mysql -u updatex -p -h www.myweb.com test < sample.SQL
> Enter password: *****
> CURTIME()
> 19:41:44
> CURTIME()
> 19:50:09
>
> [root@source]$ mysql -u updatex -p -h www.myweb.com test < sample.SQL
> Enter password:*****
> CURTIME()
> 08:26:08
> CURTIME()
> 08:26:34
>
> I did the above procedure multiple times in different times in the
> day. the duration of this procedure takes from 22sec to 10min
> see above...., before a while it was running constant with duration of
> 30sec. I checked with my ISP, hosting company and network nothing been
> changed from the structure/configuration.....
>
> [root@source]# lsof -i -P | grep 3306
> mysqld 3806 mysql 11u IPv4 10926 TCP *:3306 (LISTEN)
> mysql 15150 user 3u IPv4 297528 TCP
> 192.168.10.5:8376->www.myweb.com:3306 (ESTABLISHED)
>
> [root@target]# netstat -a |grep mysql
> tcp 0 0 *:mysql *:*
> LISTEN
> tcp 0 0 www.myweb.:mysql A.B.C.D:8366 TIME_WAIT
> tcp 0 11 www.myweb.:mysql A.B.C.D:8372 ESTABLISHED
> also i attached tcp connection between the nodes as above from source
> and target,
> can any one help why i have this behavior and how can i fix the delay,
> thinking doing QoS or clean up and remoteexcution at that time ...
>
> Thanks in advance
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=sureshkumarilu@gmail.com
>
>


--
Thanks
Suresh Kuna
MySQL DBA

--00504502b4439ec318047dbe293b--

Re: mysql update

--001636b2b64a1c65ba047dbe7a17
Content-Type: text/plain; charset=ISO-8859-1

Hi,

How big is sample.sql dump ?

there are many different things, might taking the time. dns resolve issue,
network issue

tcp 0 0 www.myweb.:mysql A.B.C.D:8366 *TIME_WAIT* (It should
established)

load on the server, check mysql processlist (any wrong query is there)

Thanks,
Krishna

On Fri, Jan 22, 2010 at 12:25 PM, madunix wrote:

> I have the following update procedure that update mySQL DB over the
> internet between source Linux Centos (local machine on my net behind a
> DMZ with real IP A.B.C.D) and target Linux fedora (web server
> www.myweb.com) every day on a specific time 18:00 through a crontab on
> my source linux server
>
> server(source)
> ---DMZ---ASA---Router-----Internet----HostingCompany---Myweb (target)
> [root@source]# mysql -u updatex -p -h www.myweb.com test < sample.SQL
>
>
> [root@source]$ mysql -u updatex -p -h www.myweb.com test < sample.SQL
> Enter password: *****
> CURTIME()
> 19:41:44
> CURTIME()
> 19:50:09
>
> [root@source]$ mysql -u updatex -p -h www.myweb.com test < sample.SQL
> Enter password:*****
> CURTIME()
> 08:26:08
> CURTIME()
> 08:26:34
>
> I did the above procedure multiple times in different times in the
> day. the duration of this procedure takes from 22sec to 10min
> see above...., before a while it was running constant with duration of
> 30sec. I checked with my ISP, hosting company and network nothing been
> changed from the structure/configuration.....
>
> [root@source]# lsof -i -P | grep 3306
> mysqld 3806 mysql 11u IPv4 10926 TCP *:3306 (LISTEN)
> mysql 15150 user 3u IPv4 297528 TCP
> 192.168.10.5:8376->www.myweb.com:3306 (ESTABLISHED)
>
> [root@target]# netstat -a |grep mysql
> tcp 0 0 *:mysql *:*
> LISTEN
> tcp 0 0 www.myweb.:mysql A.B.C.D:8366 TIME_WAIT
> tcp 0 11 www.myweb.:mysql A.B.C.D:8372 ESTABLISHED
> also i attached tcp connection between the nodes as above from source
> and target,
> can any one help why i have this behavior and how can i fix the delay,
> thinking doing QoS or clean up and remoteexcution at that time ...
>
> Thanks in advance
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=prajapatikc@gmail.com
>
>

--001636b2b64a1c65ba047dbe7a17--