Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back > Forums > Linux Forums > Linux - Networking
User Name
Linux - Networking This forum is for any issue related to networks or networking.
Routing, network cards, OSI, etc. Anything is fair game.


  Search this Thread
Old 06-01-2009, 02:52 PM   #1
Registered: Nov 2003
Location: Havana, Cuba
Distribution: Ubuntu 9.04 "Jaunty Jackalope"
Posts: 153

Rep: Reputation: 30
mysql notably slow over the network

I have a web server in my intranet which has ssh, apache and mysql services running (among other services). The server is running Ubuntu Hardy 8.04 LTS Server Edition.

Recently I started to notice a great delay in mysql connections. When I tried to connect locally, from the console with "mysql -u root -p" it worked as fast as usual, not only the connection itself, but any basic query such as "SELECT * FROM table_name".

But when I try to do the same from my personal computer (or any other computer on the network) it is very slow to even connect, and once connected, any query takes several seconds, even a basic select from a table with less than a hundred records. Those same queries are fast when executed from a local connection, so it should not be a problem with mysql data processing.

This server has two network interfaces, one of which connects it with the intranet network. The other one connects it to our ICP (Mitel 3300) and it is only used to read the phone-call logs to make reports out of it. I initially thought it could be a network issue, but web browsing of web sites hosted in this server works as fast as usual, and this goes over the network too, so that should not be the explanation.

Is there something I can do to debug and diagnose this situation? Or perhaps someone reading this already has an idea of could be going on? I search in google and for "mysql slow over the network" but all I could get was solutions related to DNS and the like. This is not the case here, since I tried external connections both with the server name and the IP address. And also because the only service I see affected is mysql.

Thanks in advance for any help.


mysql, network, remote

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql response slow ayush1440 Linux - Server 5 02-26-2009 09:26 AM
Debian 3.1r0a, Realtek RTL-8169 network controller slow on network mvr853 Linux - Networking 0 07-21-2006 09:20 PM
Slow machine; mysql ShuGos Linux - Software 0 06-15-2005 05:22 AM
Slow, slow KDE with network connected bglad Linux - Software 0 10-27-2004 11:54 AM
MySQL Slow... Wolverine Linux - General 0 04-05-2002 08:13 AM > Forums > Linux Forums > Linux - Networking

All times are GMT -5. The time now is 02:50 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration