homepage Welcome to WebmasterWorld Guest from 54.234.60.133
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Pubcon Website
Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
Remote access of MySQL server extremly slow
But the querying machine is just one hop / 0.2 ms away...
OutdoorWebcams




msg:4028977
 7:54 pm on Nov 20, 2009 (gmt 0)

I'm really puzzled.

Last night my dedicated database server (MySQL) got rebooted (data center maintenance) and from then on database queries from my webserver, just 1 hop and 0.2 milliseconds (via traceroute) take ages. (Everything was fine before.)

An example query like 'SELECT this FROM that WHERE some_condition_met' from my webserver takes 10 seconds to execute, but the same query performed on the database server itself takes only 0.01 seconds (done via cli).

So it's not a query issue, it could be done much faster.

File transfers between the two hosts take place at 20-30 MB/sec, but the result set of this query is about 1 MB in size.

So it's not a bandwith issue, it could be done much faster.

Profiling shows that it's 'sending data' that takes 10 seconds, but why?
It should be done in 0.2 or 0.3 seconds, maybe 0.5.

I'm clueless right now and don't even know what to look for. No configuration changes, no different startup parameters, network connection just fine.

Does anybody have an idea what's going wrong here?

 

whoisgregg




msg:4045173
 12:13 am on Dec 18, 2009 (gmt 0)

I was hoping someone would chime in with a possible solution. This one has me stumped.

Did you ever discover the cause of the problem?

OutdoorWebcams




msg:4045316
 8:15 am on Dec 18, 2009 (gmt 0)

The server is currently off the net for a closer hardware inspection.
(Takes already some time, but the folks of the data center where this server is hosted are having some major scheduled modernization right now)

The support people say it must be a problem in the network hardware.
I thought about something like that also, because everything works fine when working on the machine locally without any net traffic involved.

So nothing new yet, I'll keep you informed.

seocracy




msg:4047076
 5:30 pm on Dec 21, 2009 (gmt 0)

did the mysql server shutdown gracefully when the reboot happen?

You might have some broken tables.

I run an analyze and optimize on all your tables.

Be careful when running the optimize, as it will lock the tables and if you have any active site accessing the database, it will be locked out for the duration of the optimize process.

let us know what happened in the end!

OutdoorWebcams




msg:4048539
 7:35 pm on Dec 23, 2009 (gmt 0)

It was a broken interface of the connecting switch which got replaced, everything is working fine now and obviously it wasn't a database issue at all.

So sorry for any inconvenience and thanks for your help!

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About
© Webmaster World 1996-2014 all rights reserved