Greetings all! I have built a new server with MySQL and have noticed that before even doing anything to it I found that the MySQL logins were much slower than the 4.0 server I used prior to it. After moving data over to it, the application, (JFFNMS) when it would login to it would take forever getting data from it. It would finally get to a point where MySQL would not respond to anything including MySQLAdministrator. So I removed the 4.1 version that came with CentOS 4, I downloaded and installed the latest 4.0 version from the MySQL website and installed it and it is very fast even after moving the data to it. The problem I have is that I need php-mysql and perl-DBD-MySQL and when I install these two rpms, it removes the MySQL-server and MySQL-client rpm's that I retrieved from the MySQL website. So I am at a loss of what to do. I would prefere to go with MySQL 4.1 just because that is what comes with CentOS 4, short of that I need php-mysql to work with 4.0. Databases and custome building of RPM's is beyond my capabilities. Any assistance will be GREATLY appreciated. Thanks Chris
Chris Hammond wrote:> Greetings all! > > I have built a new server with MySQL and have noticed that before even > doing anything > to it I found that the MySQL logins were much slower than the 4.0 server > I used prior to it.Just as a note, I have not noticed this problem at all -- my logins are just as fast/fine/snappy as always. Not sure what's wrong with your stuff..> I am at a loss of what to do. I would prefere to go with MySQL 4.1 just > because that is what > comes with CentOS 4, short of that I need php-mysql to work with 4.0. > Databases and > custome building of RPM's is beyond my capabilities.You can use the builtin 4.1 *client* binaries (which are what php and it's ilk are linked to), while using the 4.0 server binaries. All you need to do is uninstall "mysql-server" RPM, install your downloaded 4.0 binary package to /usr/local/mysql/ (eg), and run the server from there using it's custom initscript. Make sure the /etc/my.cnf is all configured nicely before bootstrapping the downloaded 4.0 install, and everything should just click (within reason). Most importantly, make sure the socket path and database path is set. -te -- Troy Engel | Systems Engineer Fluid, Inc | http://www.fluid.com
Some more information would be very helpful. My first questions are: have you looked at what else might be happening on the server? was this a remote access situation where the problem could be on the network connection? Were there any other processes that may have been eating up all your CPU? I have mysql 4.1.7 running without a problem, with a very large database. I also have the perl-DBD-mySQL module, etc. I'm happy to help any way I can. michael. -- Michael Weisman "chaos is merely a function of the granularity of the sample" On Friday 01 April 2005 12:55, Chris Hammond wrote:> Greetings all! > > I have built a new server with MySQL and have noticed that before even > doing anything > to it I found that the MySQL logins were much slower than the 4.0 server > I used prior to it. > After moving data over to it, the application, (JFFNMS) when it would > login to it would take > forever getting data from it. It would finally get to a point where > MySQL would not respond > to anything including MySQLAdministrator. So I removed the 4.1 version > that came with > CentOS 4, I downloaded and installed the latest 4.0 version from the > MySQL website and > installed it and it is very fast even after moving the data to it. The > problem I have is that I > need php-mysql and perl-DBD-MySQL and when I install these two rpms, it > removes the > MySQL-server and MySQL-client rpm's that I retrieved from the MySQL > website. So > I am at a loss of what to do. I would prefere to go with MySQL 4.1 just > because that is what > comes with CentOS 4, short of that I need php-mysql to work with 4.0. > Databases and > custome building of RPM's is beyond my capabilities. > > Any assistance will be GREATLY appreciated. > > Thanks > Chris > _______________________________________________ > CentOS mailing list > CentOS at centos.org > http://lists.centos.org/mailman/listinfo/centos