On Thu, Jun 27, 2002 at 05:27:29PM +0930, G r e g L a w r i e wrote: > Jeremy, > > Would you mind sharing how many machines 'half your servers' might > be, what type of work are they doing and how long have they been up > for / how stable would you consider them to be?
Half of "my" server is, uhm, 3 right now. We're planning to do some upgrades and machine swaps on the east cost shortly. After that happens, we'll have couple more. (Once we've proven it in our group, I know of many others that will probably follow suit within a couple months.) So far, I'm only upgrading the slaves, but I expect to do the master in a month or so. Probably after the Open Source Convention. If I upgrade it and then leave town, it *will* break. Here's a mytop snipit from one of the boxes: MySQL on db3.finance.sc5 (4.0.2-alpha-log) up 5+16:21:27 [01:11:10] Queries Total: 41,747,472 Avg/Sec: 85.04 Slow: 8 Threads Total: 1 Active: 1 Cached: 0 Key Efficiency: 99.43% Bytes in: 1,710,858,529 Bytes out: 495,705,494 It has been up for 5 days because I recently updated the code. I wanted to put a newer 4.0.2-alpha snapshot on it. Before that it had been up for a few weeks and had probably run 150-200 million queries. It's pretty lightly loaded now. But it'll become our new master in a month or so. Other than the InnoDB bug we discovered, stability is not an issue. That was fixed within 36 hours of the diagnosis. I should point out that we're really not using any of the whiz-bang new 4.0.x features (other than the revamped replication). But for 3.23.xx style work, it has treated us well so far. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.51: up 28 days, processed 614,127,052 queries (250/sec. avg) --------------------------------------------------------------------- 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