Re: MySQL hardware concerns

2002-07-29 Thread Jeremy Hiatt
>Can you translate 100,000 users into database numbers? How many SELECTs >per second, UPDATEs per second, and so on? That'd help a lot. I believe roughly 70% of our queries are SELECTs, 29% UPDATEs, and less than a percent for both INSERTs and DELETEs. MySQL on localhost (3.23.46) up 4+22:08

MySQL hardware concerns

2002-07-29 Thread Jeremy Hiatt
mixed opinions about a performance loss with >2 Xeon processors-- can anyone confirm this? Thanks in advance, Jeremy Hiatt -- _ Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.