At 10:08 2002-10-31, Benji Spencer wrote:
fast ether has a *signalling rate* of 100MHz. Which means that 100Mbps is an absolute, theoretical maximum rate. Considering that some of those bits get used up in ethernet framing, others in IP headers, then more in TCP headers, and so on while You move up the OSI layers, You will *never* get a 12.5MBps. And that's not even considering timeouts/retransmissions, collisions, latency, and other reasons. From my experience one can (assuming good cabling and good hardware end-to-end, and the ends not too far apart) count on 60-65% of that rate being attainable. TokenRing was/is much better at it, but that's another matter. How about FDDI/CDDI? You can get CDDI NICs quite cheaply these days, and they would give You a full rate (well, close). Even then, You always *do* have other packets vying for that wire: arp, name resolution, router adverts, all kinds of broadcasts (especially if You have Windows somewhere), and so on...yes, 12.5 MBytes/s over the network. We know this is the max of the network. We will be teaming the two nics on the box on Monday which will give us 25 Mbytes/s. That will eliminate one possible problem. However, can MySQL (or MSSQL) push out 25 MBytes/s? (we will hit this limit in February with the current setup). Can MySQL (or MSSQL) push out 125 MBytes/s (1 GBit/s)? At what point do we reach the Application (or OS?) limit?Just a silly question: are you pushing those 12.5 Mbytes/s over the network ? If this is the case you have hit the limit of Fast Ethernet (12.5x8 = 100Mbits/s) and no database (not even MySQL ;) ) will be faster ! May be an upgrade to Gigabit Ethernet would help...
Just thought I'd throw that in - not that it has anything to do with MySQL, but I wouldn't want the fine software to be blamed for what will not be it's fault...
---------------------------------------------------------------------
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
