Home > linux > Extremely slow MySQL performance after changing client server

Extremely slow MySQL performance after changing client server

August 31Hits:1

I have a Magento web server (CentOS) that uses a crossover cable to connect to a MySQL database server.

The other day, I upgraded the Magento server. I disconnected the crossover cable from the old Magento server and plugged it into the new one. I was able to connect to MySQL, but it took about 90 seconds. When I tried to open the webpage it timed out basically.

Why would this be so slow? What type of caches, etc do I need to clear? I restarted both servers completely just to make sure it wasn't some random service.


Are the ethernet ports on BOTH set to the same speed and duplexing? If not, you'd have incompatible and problematic transfers between the two systems on this cable. Another suggestion is to ensure that the cable type is appropriate to the transfer rate being used.

Related Articles

  • Extremely slow MySQL performance after changing client serverAugust 31

    I have a Magento web server (CentOS) that uses a crossover cable to connect to a MySQL database server. The other day, I upgraded the Magento server. I disconnected the crossover cable from the old Magento server and plugged it into the new one. I wa

  • Slow mysql performance between 2 serversMay 26

    I have 2 servers, both running Ubuntu server 11.10. The first server runs Apache and PHP and it connects to a Mysql database on the second server. The problem is slow mysql response on the second server.mysql logs does not show any errros other than:

  • Extremely Slow Javascript Performance Across Multiple BrowsersDecember 8

    I am experiencing extremely slow Javascript performance under CentOS across all browsers I have tried. It is to the point that for sites that make heavy use of javascript (such as this one) that my CPU is maxed out for several seconds, and I have to

  • Extremely slow mySql restoresMarch 8

    Please bear with me as I ask this question, which looks similar to questions already on [email protected] In the current configuration, we have a server (a Linux quadcore box with 4 GB RAM) - Both the Database and Application Server are hosted on this server.

  • MySQL connection errors when client server bandwidth is exhaustedJanuary 2

    I have several servers with a lot of outgoing traffic using nginx. When the bandwidth is exhausted (1Gbit), I have problems connecting to my mysql server from those servers. The connect always fails with the following message: mysql conneciton failed

  • Very slow MySQL performanceFebruary 16

    I have 4 million rows in MySQL. I have a count query to fetch from DB to Apache web server. The issue is first load (Count query) - when I click fetch button, it takes more than 5 mins. Second time when I click fetch button in web app i takes less th

  • Extreme slowness of "Waiting" time after changing server

    Extreme slowness of "Waiting" time after changing serverFebruary 20

    I just changed the dedicated server for my website. Since that my pages loads in much more time. With developers tools of chrome I can see this (): Dns Lookup: 1ms Connecting: 50ms Sending: 1ms Waiting: 4.57s (O_O) Receiving: 44ms The waiting time is

  • PL/SQL extremely slow FETCH performanceMay 16

    I have a stored procedure that includes (among many other things) a dynamic query with a LOOP and a FETCH. The fetch has to potential retrieve a large amount of data as one column contains spatial information. The problem I am having is that if this

  • Slow MYSQL performance due to sub queriesJanuary 20

    Here is my query: SELECT BAL,NAME, (SELECT SUM(DR) FROM transaction WHERE NAME=TNAME AND DATE < '2000-05-01') AS DR , (SELECT SUM(CR) FROM transaction WHERE NAME=TNAME AND DATE < '2000-05-01') AS CR FROM main GROUP BY MARK,NAME WITH ROLLUP This quer

  • Inserts/updates are extremely slow with Merge Replication in SQL Server 2008March 24

    I got hired into a new company and they had merge replication already in place. They have had issues with it to the point I have to evaluate whether to keep it or replace it. The main issue is it takes many hours (over 12 hours in some cases) to inse

  • High load and iowait on MySQL database server leads to slow MySQL INSERTS

    High load and iowait on MySQL database server leads to slow MySQL INSERTSJanuary 31

    I have a MySQL database server runnuing on Ubuntu 12.10 with 64GB RAM, 2x3 TB SATA 6 Gb/s HDD 7200 rpm and software RAID 1 and an Intel Core i7-3930K. The database server is accessed over a local network with a dedicated 1 GBit ethernet card. The dat

  • NFS writes to md-raid extremely slow with busy jbd2December 1

    As far as I can remember, this problem appeared after upgrade from Debian Squeeze to Wheezy. The symptom is extremely slow write performance on the server's dmraid exclusively if written via nfs shares from any client. The performance issue seems to

  • Why I Have Slow Laptop Performance Which Occurs Frequently?August 19

    Frequently I feel that my framerate of what I see on laptop's screen is slow. What I mean is if you have ever played games, you know that graphical performance is measured in FPS (framerates per second). So in my case, sometimes screen is going from

  • Extreme slowness after upgrade to Yosemite; is my specific problem happening to others or just for me?December 13

    Like many, my Mac (iMac) has become extremely slow when performing certain operations and it's making it nearly impossible to get work done. I've been paying close attention trying to find some specific reason and finally think I've identified one is

  • Slow graphic performanceNovember 10

    I'm new on ubuntu, and I have a problem with graphic, or graphic driver. Recently, I installed Steam (app, not steam os) on my ubuntu 14.04 machine, after downloading all of my games, I noticed that I can't play any game, because of extremely slow pc

  • Extreme fine tuning MySQL performance wise on a Linux serverFebruary 9

    I would like to know all of the key points where MySQL can be fine tuned performance wise on a Linux server through my.cnf or through other methods, libraries and tools. Tips and tricks and shady stuff welcome too. Since a target server architecture

  • Web server is extremely slowFebruary 9

    My web server is running on PHP 5 and MySQL 5.0. When I copied an application developed in CAKE PHP, the server is extremely slow. The organization who provides the files are running the same application without any problem. The versions deployed in

  • Connecting to MySQL from PHP is extremely slowJuly 17

    I just did a fresh install of XAMPP. When first opening PHPMyAdmin I noticed it was extremely slow. It didn't make sense that on localhost it should take almost 5 seconds for every page to open. I made a small test case to shift the blame off PHPMyAd

  • python mysql.connector fetchall() run extremely slowFebruary 5

    I have a simple sql query using python and mysql.connector query = 'SELECT age, score FROM patient' cursor.execute(query) dr = cursor.fetchall() or cursor.fetchone() print(dr) In phpmyadmin, this query is very fast (0.003s). It also runs fast in Pyth

  • Server is extremely slowNovember 30

    I came back from the weekend and this old IBM Netfinity 5100 server is extremely slow. It's running Windows 2003 standard, has been working great for years. Today it took about 4 hours to boot up. Once in Windows, it takes minutes to pull up menus. I

Copyright (C) 2017 ceus-now.com, All Rights Reserved. webmaster#ceus-now.com 14 q. 0.686 s.