on 05/19/2004 08:36 AM, Brent Baisley at [EMAIL PROTECTED] wrote: > I wouldn't upgrade until you know where the bottleneck is (CPU, disk, > network, or RAM). Since you are using "professional" software, I > wouldn't try to change the queries. Have you made changes to your > my.cnf file? Since you have enough ram to hold all the data, ram is > probably not your bottleneck. The question is whether you have your > system configured to use it. > I forget if phpbb and phpnuke use PEAR::DB to access the underlying > database. If they do, there is a certain amount of overhead involved > that you just can't get around without changing the database access > code to use "native" calls. Are your database and web server on the > same machine (a security no-no, but performance yes-yes)? If they are > on separate machines, make sure you have a fast connection between > them, at least 100MB and make sure it's full duplex.
PhpBB is just php access to mysql, no PEAR::DB involved. I can say from eperience, the phpBB code is kinda bad in regards to how it talks to mysql, on some pages it is not at all uncommon for there to be 10 or more complex querries. I would be willing to bet there are many installed "mods" on phpBB, they offer stuff like, "show all online users" which though a nice feature, is heavy on the DB. There are hundreds of these mods, people just copy and paste and install them, before they know it the database is taking 30 selects on every single page load, just so you can say "happy birthday to: someuser" on every page. -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
