>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:37 Queries Total: 38,217,014 Avg/Sec: 89.86 Now/Sec: 131.80 Slow: 0 Threads Total: 1 Active: 1 Cached: 0 Key Efficiency: 99.98% Bytes in: 3,696,152,003 Bytes out: 4,006,033,106 +--------------------------+------------+ | Variable_name | Value | +--------------------------+------------+ | Handler_delete | 2056 | | Handler_read_first | 86116 | | Handler_read_key | 38126269 | | Handler_read_next | 66568466 | | Handler_read_prev | 0 | | Handler_read_rnd | 26653054 | | Handler_read_rnd_next | 4229676008 | | Handler_update | 12940207 | | Handler_write | 171166 | | Key_blocks_used | 15582 | | Key_read_requests | 77465425 | | Key_reads | 14742 | | Key_write_requests | 470685 | | Key_writes | 468967 | | Uptime | 425398 | +--------------------------+------------+ This is from a production server and isn't as efficient as the work in progress on development servers (note handler_read_rnd_next), but these are accurate enough for scaling. Note that many queries take place server-side in automatic calculations (cron). We're leaning towards a dual 1GHz (512k cache) box with 4GB memory and SCSI raid 1-0. Comparitively the figures above are from a dual 1GHz (256k cache) running both apache+mysql, with 1GB memory and SCSI also. As I mentioned before this will be our main DB. Do you think this the best move for our money? How do I calculate how many "Apache/MySQL Slave" sub-servers I can add before our master maxes out? This seems like a hit and miss way to scale, hardware wise. For a few thousand $$$ in new hardware expenses I'd much prefer a hit. Thanks, Jeremy _________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
