LinuxQuestions.org
Share your knowledge at the LQ Wiki.
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 11-03-2005, 12:29 AM   #1
sarmadys
Member
 
Registered: Nov 2001
Distribution: Solaris, Redhat AS, SUSE
Posts: 47

Rep: Reputation: 15
Slow response from MySQL on other server


Hello,

I have a relatively big website so I am trying to serve web from one server and process MySQL on another server.

The problem is that when the website and database are on the same server , website pages are very fast but when I put the website on another server (both are dual xeons in ev1servers.net with the same apache configuration) it becomes very very slow (2 seconds when served in the same server in comparison to 8-12 seconds or slower on the other).

I have tested connection speed using FTP and I was able to transfer 15M Bits/s. Amount of data being transfered for each page is less than 20KBytes and website is not acive yet so this is the only data being transfered between two servers. (so why is it slow?!!!)

1- Would someone please advise if the problem is from connection speed between two servers?

2- Does a "Private Rack" service help with the problem? (as servers are on a dedicated high speed switch)

My MySQL config:

Code:
[mysqld]
connect_timeout=10
interactive_timeout=100
join_buffer_size=4M
key_buffer=156M
max_allowed_packet=16M
max_connections=300
max_connect_errors=10
myisam_sort_buffer_size=128M
read_buffer_size=1M
read_rnd_buffer_size=1024K
sort_buffer_size=3M
table_cache=1500
thread_cache_size=128
thread_concurrency=4
wait_timeout=300
query_cache_size=32M
query_cache_limit=4M
query_cache_type=1
skip-innodb
skip-locking
log_slow_queries=/home/clb/slow-queries.log
long_query_time=4
Regards,
Mac
 
Old 11-03-2005, 01:22 AM   #2
paulsm4
Guru
 
Registered: Mar 2004
Distribution: SusE 8.2
Posts: 5,863
Blog Entries: 1

Rep: Reputation: Disabled
You need to have a better idea where the bottleneck lies before you can even speculate about what might or might not help fix it.

The first place to look is in the application that uses mySQL.

Here's a link that might help:

http://linuxalpha1.eicn.ch/OReilly_b...hp/ch13_05.htm
 
Old 11-03-2005, 05:04 AM   #3
entropia
LQ Newbie
 
Registered: Nov 2005
Posts: 11

Rep: Reputation: 0
hi,
could be the kind of connection are you using in your webapplication.

are you sure are you using pconnect (if php) ? any way persistent connection ?
 
Old 11-03-2005, 11:12 AM   #4
paulsm4
Guru
 
Registered: Mar 2004
Distribution: SusE 8.2
Posts: 5,863
Blog Entries: 1

Rep: Reputation: Disabled
entropia is exactly right.

But that's just one of many, many possibilities (albeit a really excellent place to start looking ;-))

The point I was trying to make is that you really need to do some more analysis before you start throwing hardware at the problem.

IMHO .. PSM
 
  


Reply


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
squid slow response ilnli Linux - Software 10 10-16-2006 11:56 PM
Slow web server response for net IP, fast for 127.0.0.1 rpdillon Linux - Networking 1 03-09-2005 09:43 AM
Slow konsole response taarnak Linux - General 2 12-16-2003 05:43 PM
Slow response as ..... umok Linux - Newbie 4 07-11-2003 12:54 PM
Slow response on Mandrake 8.0 Droopy Linux - Networking 0 09-07-2001 09:16 PM


All times are GMT -5. The time now is 09:13 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