LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Networking
User Name
Password
Linux - Networking This forum is for any issue related to networks or networking.
Routing, network cards, OSI, etc. Anything is fair game.

Notices

Reply
 
Search this Thread
Old 06-01-2009, 01:52 PM   #1
ernesto_cgf
Member
 
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 linuxquestions.org 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.
 
  


Reply

Tags
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 08:26 AM
Debian 3.1r0a, Realtek RTL-8169 network controller slow on network mvr853 Linux - Networking 0 07-21-2006 08:20 PM
Slow machine; mysql ShuGos Linux - Software 0 06-15-2005 04:22 AM
Slow, slow KDE with network connected bglad Linux - Software 0 10-27-2004 10:54 AM
MySQL Slow... Wolverine Linux - General 0 04-05-2002 07:13 AM


All times are GMT -5. The time now is 05:07 AM.

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