Re: Sessio variables and Load Balancing

Daniel Beckham wrote: > Of course it's fast, but I'm not just talking about query speed, there is > more to it than that. Mysql (or Oracle) might be able to return results > blazingly fast, but it's going to use as much memory and processor time as > it can to do that. It is bearable. kk@wwwx ~ $ /usr/ucb/ps auxwww | grep mysqld root 1920 1.6 2.820352 3376 ? S 13:16:09 0:58 mysqld kk 5278 0.1 0.6 944 704 pts/1 S 17:25:52 0:00 grep mysqld kk@wwwx ~ $ mysqladmin status Uptime: 14987 Threads: 3 Questions: 11900 Slow queries: 0 Opens: 96 Flush tables: 1 Open tables: 38 kk@wwwx ~ $ /usr/ucb/ps auxwww | grep httpd| wc -l 22 That's a 143 MHz Ultra-1, 128 MB and with Solaris 7, running Apache and CGI PHP. The site delivers about 10 GB a month for http://phplib.netuse.de and http://www.kneschke.de. All pages are PHPLIB/PHP3 pages and dynamically generated. The machine is running the SQL server (3.5 MB real RAM, 20 MB virtual process size) and the httpd server processes as well. This is all very moderately sized and performs just fine. Kristian -- Kristian Köhntopp, NetUSE AG Siemenswall, D-24107 Kiel Tel: +49 431 386 436 00, Fax: +49 431 386 435 99 Using PHP3? See our web development library at http://phplib.netuse.de/