Do you remember using any connection pooling for database connections? This kind of stuff usually makes a big performance difference and it's likely that you've lost it while migrating your system.
On Sun, Jan 25, 2004 at 10:47:56PM -0600, Greg Donald wrote: > > Over the weekend I reinstalled my web server. Previously it had RedHat8 > on it, and due to RedHat declaring end of life on my distro, my server > now has Gentoo on it. The install went off without a hitch and this > afternoon I proceeded in installing Apache2, mod_php, and MySQL, among > other things. The entire box overall is a little bit faster than it used > to be, except for MySQL. > > When I pull a webpage that does any sort of db connection, the page load > time is noticable slower than it used to be. When I pull a static page > that has no PHP or db code in it, the page flies, almost instantaneous > as it's always been previously. I used to run Apche 1.3.x and my MySQL > version is nearly the same as it used to be. So Apache2 is the only > significant version difference from what I used to run. > > So before I go to all the trouble of removing Apache2 and emerging > Apache1, mod_php, etc., I was wondering if anyone might know what I'm > doing wrong or might know something I need to reconfigure to fix the > slowness? I'm pretty sure I don't need all those "LoadModule" calls in > /etc/apache2/conf/apache2.conf, but could that seriously be causing the > slowness? > > Also, I think it's worth mentioning I replaced /etc/mysql/my.cnf with my > own settings from my old setup: > > > cat /etc/mysql/my.cnf > [mysqld] > query_cache_size=8M > max_connections=200 > datadir=/home/mysql > > I don't think anything there that would cause slowness and MySQL flies > when using the CLI MySQL client. It's only when I pull a webpage that I > see the MySQL slowness. > > I know all the reasons why Apache2 isn't really recommended for use, the > thread safeness and all. Is this _my_ issue here? > > TIA! > > > > -- > __ __ _ > ___/ /__ ___ / /_(_)__ ___ __ __ _______ __ _ > / _ / -_)_-</ __/ / _ \/ -_) // // __/ _ \/ ' \ > \_,_/\__/___/\__/_/_//_/\__/\_, (_)__/\___/_/_/_/ > (___/ [EMAIL PROTECTED] > BOFH Excuse #156: > Zombie processes haunting the computer > > -- > [EMAIL PROTECTED] mailing list -- - Andrey ~ In theory, practice and theory are the same, but in practice they are different (Larry McVoy) ~ -- [EMAIL PROTECTED] mailing list
