LinuxQuestions.org
Visit the LQ Articles and Editorials section
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-21-2007, 01:13 PM   #1
ernesto_cgf
Member
 
Registered: Nov 2003
Location: Havana, Cuba
Distribution: Ubuntu 9.04 "Jaunty Jackalope"
Posts: 153

Rep: Reputation: 30
mysql and ssh connection delays


I have a ubuntu dapper server, serving http, ssh and mysql. It is mainly used as a web server. I am a web developer so I have my own apache on my ubuntu feisty workstation to serve my projects locally while I develop. Projects (web apps) are only passed to the server for deployment when they're ready to use. But I do not have another mysql server locally. I use hte server's mysql instance as the database backend for the local applications in my workstation.

Then I have this web app that I am working on right now. The app works fine when served completely from the web server (that is, both the web pages and the database are in the web server.) But when I serve the pages from my local apache, but connecting internally through the network to the mysql backed on the server, the database response time is awfull. I know is the database because I am using ajax and the pages load fast, but ajax responses that connect to the db are awfully slow (20+ seconds the first time, and never less than 5 seconds).

Also, I've noticed that when I type 'ssh username@webserver' to login through ssh into it, it takes between 10 to 20 seconds for it to show me the line "username@webserver's password" asking me for the password. This also happens when I type username@172.16.5.5 instead of the server's name. So it shouldn't be a DNS problem.

I do not know if the two delayed connections are related, but the most important for me to solve is the mysql connection. I can wait for ssh to ask me the password, as I hardly ever go into the server through ssh, but I have to work on my apps daily and every ajax request takes soooooo long.

Any ideas?
 
  


Reply

Tags
connection, mysql, ssh


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
ssh: connection to host port: 22: Connection timed out lost connection cucolin@ Linux - Server 4 11-22-2011 06:15 AM
Mysql and mysql java connector, connection refused arubin Slackware 3 03-29-2008 01:41 AM
SSH with mysql shof515 Linux - Networking 0 11-28-2005 05:54 PM
SSH delays sachinh Linux - General 1 08-17-2005 10:00 AM
Mysql Error: Lost Connection to Mysql during query ramnath Programming 5 11-18-2003 12:27 PM


All times are GMT -5. The time now is 09:27 PM.

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