Skip to main content

Thread: Slow MySQL Remote Connection

-

i running ubuntu 10.04 web server (rackspace host). have cloned server running mysql locally. on new server changed php code connect original server through internal ip address.

pinging 1 server other through internal ip address less 1 ms. have 2 identical servers - 1 running mysql locally , other server connecting other run mysql queries.

adding around 8 seconds page load time.

original server (running mysql locally):
http://173.45.255.52/index.php?action=browse_members

cloned server (running mysql original):
http://bros4bros.com/index.php?action=browse_members

have added "skip-name-resolve" my.cnf, , did not improve performance @ all. date using "aptitude safe-upgrade".

have post on stackoverflow: http://stackoverflow.com/questions/1...ote-connection

waterfall shows waiting 8 seconds. i'm tearing hair out trying fixed. it's ridiculous it's sitting there 8 seconds when latency between 2 server less 1 ms.

cloned server waterfall:


live server waterfall:



Forum The Ubuntu Forum Community Ubuntu Official Flavours Support General Help [ubuntu] Slow MySQL Remote Connection


Ubuntu

Comments

Post a Comment

Popular posts from this blog

Adobe Acrobat Pro , Terminal Server Use

-
hello,   a fellow employee requires adobe acrobat pro installed use, , management me have sorted out. employee uses thin client connect terminal server of administration work.   i require single license adobe acrobat pro used single user.   will there license issues installing adobe acrobat pro on terminal server?   can install adobe acrobat pro on terminal server?   thanks, david hi david,   yes, can install acrobat terminal servers... !   the licensing terminal server considered normal licensing process, means need buy many number of licenses acrobat number of users accessing terminal server (like citrix) access software. eg if 10 users accessing citrix server @ particular time use acrobat software need 10 licenses same. More discussions in Installing, Updating, & Subscribing to Acrobat adobe
Read more

Thread: transmission-daemon isn't playing nice: "409: Conflict"

-
409: conflict request had invalid session-id header. fix this, follow these steps: when reading response, x-transmission-session-id header , remember it add updated header outgoing requests when 409 error message, resend request updated header requirement has been added prevent csrf attacks. error occurs when apache not running. i've tried zillion different proposed solutions involving rewriterules , proxypasses golly i'm clueless. me? following apache thing, y'know, in case. code: <virtualhost *:80> rewriteengine on documentroot /var/www <directory /> options followsymlinks allowoverride none </directory> <directory /var/www/> options indexes followsymlinks multiviews allowoverride none order allow,deny allow </directory> scriptalias /cgi-bin/ /usr/lib/cgi-bin/ <directory "/usr/lib/cgi-bin"> allowov...
Read more

Thread: gpg: Conflicting Commands

-
Image
hi, relatively new linux (have used many live disks) , have had install of ubuntu 12.04 few days now. part have found easy use , have been comfortable it. have first question can't resolve myself: adding googles repository list. when first ran command supplied google found did not have wget installed. used apt-get install it. worked fine (as far can tell) re-ran googles code : wget -q https://dl-ssl.google.com/linux/linux_signing_key.pub -o- | sudo apt-key add -deb http://dl.google.com/linux/deb/ stable non-free , message 'gpg: conflicting commands' tell me going wrong , how fix please new script : wget -q https://dl-ssl.google.com/linux/linux_signing_key.pub -o- | sudo apt-key add linux_signing_key.pub need edit /etc/apt/sources.list , add line @ end deb http://dl.google.com/linux/deb/ stable non-free end hope find usefull edit: need root or use sudo make changes /etc/apt/sour...
Read more