I use MySQL for database-driven websites and a db-driven chat system that I am toying with. While the sites I have running are low-volume, I would note that I ran ApacheBench against one of them to see how well the system would hold up under load. I was surprised to find that when getting hammered with thousands of requests per minute, it was Apache that had problems. I was running top on a terminal session while the benchmark tool was running, and MySQL stayed at under 2% of the total, Apache was racking the processor utilization up tp 90+%.
Just my .02.
--
Shannon Neumann
Neumannweb Computers
www.neumannweb.net
Juan Nin wrote:
Hi, I'm about to make a kind of yahoogroups in PHP. It's for a University, so it will be used a lot. I'm considering using either MySQL or PostgreSQL...Which one would you recommend for this project? I've always heared that PostgreSQL is better for big databases with lots of records, where data integrity, etc is critical, and that MySQL is better for light web applications, and smaller databases where quickness is needed... but I've heared that the new MySQL 4.x branch changes this a bit, and that from MySQL 4.1 there are nested queries support, etc any recommendations? Thanks in advance, Juan
