Re:How does Yahoo! Finance use MySQL?
on
High Performance MySQL
·
· Score: 3, Insightful
One of our servers handled over a quarter of a billion queries in a month-and-a-half, and it still has capacity to spare.
OK, that explains a lot. 250 mil. queries in 45 days is normal for a small company like us and definetely peanuts for Yahoo - i.e. I'd say that this allows the conclusion that nothing particularly important or demanding (i.e. heavily used compared to Yahoo's overall traffic) is built using MySQL at Yahoo. Just to put this into perspective, a little dual Xeon box here does more than 5 million *INSERTs* every day and a large number of SELECTs (we update each of our currently 2.4 million product prices at between 1 and 20 times per day - the exact number of INSERTs per day is currently unknown to me). We use PostgreSQL 7.4.5 though, so we don't consider this a particularly impressive feat;-)
Yet another company to boycott because of their immoral practices. Seems like they had to resort to such practices because they couldn't figure out how to earn a profit with their crappy products anyway:-/.
one of my biggest gripes is the lack of a good font renderer - X absolutely needs good subpixel rendering and antialiasing and those common (lucida?) fonts look far too wide for my taste...
In only a couple of months' time, you'll be able to put 8 Opteron cores (4 dual core CPUs) in a desktop-size case - and this is a rather reliable information. It is also very likely that similarly sized boxes with 8 CPU sockets (and thus possibly 16 cores) will appear next year: infoworld.com article.
Passwords are expected to be complemented by biometric methods soon, since the recent political developments everywhere will result in widespread use of biometric passports and other methods of identification. Once everyone has become accustomed to this process, it'll be a natural step to use these methods for a little bit of extra security...
And who will do it? How is it possible that we can read almost daily about new trivial patents with no innovation value and plenty of prior art and nobody can do anything about it?
How can anybody still take the US Patent Office and those patents in general seriously?
Such a system has a fundamental problem: it will motivate people to act purely out of greed, with no further interest in helping to avoid spam. They will therefore concentrate on reporting "easy targets" and perhaps even report people who aren't actually spammers and can't prove it. The whole idea is rather cynical and smells of defeatism (the law won't help => hire bounty hunters acting outside of the law).
I had the pleasure to attend one of his guest lectures here in Vienna and can confirm that he's a really entertaining narrator who can present a (seemingly) boring and unspectacular topic in a fascinating way.
It is also noteworthy that his contributions aren't solely in the field of mathematics - he has contributed some groundbreaking work in the area of compiler research, such as this paper.
If this is a matter of advancements in technology, we should have had free food for decades.;-)
More seriously, I think that Sun wants to downplay the significance of its getting out of the CPU business (as it seems). IMHO, hardware will not be free, but very cheap and there will be lots of reasons to buy your own gear even if you're a totally non-tech-savvy company that just wants a hassle-free mail-/file-/db-server (just ask any MS-dependent company with no tech skills how smoothly everything works with a standard Exchange server and regular service packs - which is today's equivalent of the subscription-based setups the article talks about). Not to mention that this model isn't going to work for people who use Free Software. Or for people, who don't want to depend on a single closed-source vendor...
the good part: the winner will be very much in demand (as a SEO consultant)
the bad part: there will be even more crappy Google results (we should give Teoma a chance, since it can't be spammed as easily using links on irrelevant pages)
The big point here for the author is "it's fast enough".
Fast enough for what? For an amateur programmer coding for himself, in the language he likes best. I certainly wouldn't buy a code library written by that guy;-)
(disclaimer: I'm a "1985 cycle counting programmer")
1. Mozilla Firefox 2. Mozilla Thunderbird 3. IrfanView 4. putty 5. OpenOffice 6. one of the free zip utilities 7. one of the open source IRC clients (XChat for Windows, Xircon etc.) 8. Spybot S&D 9. winamp 10. Adobe Acrobat Reader
You must be blind. The first thing you see when you start the "psql" command-line utility is:
Welcome to psql 7.4.1, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit
So, try out the \? command and you'll be presented with all the useful commands...
So, unlike the last time that SCO was trading as a penny stock, it might be possible for some enterprising company to just buy a controlling share for 60 million and be done with it.
Depends on which side that company is on... What if Microsoft decides that SCO can't survive like this and buys it to put a bit more muscle behind SCO's case?
The Aspire 1703/1705 models weigh exactly the same (7.1Kg or 15.06lbs), see them here or here. They're desktop replacement "notebooks" and Acer calls them "transportable" rather than "mobile".;-)
Indeed - we'll probably switch to booting over the 'net when we have more boxes or need to try out kernel patches. Right now we boot each node from its 3,5" HDD, the USB stick was/is used for the installation only...
> i'd assume your board has bios support for booting on usb?
Yes, I guess that most current BIOSes of the newer boards do, especially the consumer-ish stuff. We just used the stock Shuttle XPC with its FlexATX-board.
Oh, I forgot: each of these boxes contains a 2,8GHz P4 Northwood CPU (200/800MHz FSB), 1GB RAM. The Shuttle barebone used is the S75G2 and one of the reasons we chose it was that it has an on-board gigabit ethernet adapter. The CPU cooler that came with it is also very interesting - it uses a rather unique design with a heatpipe...
This rocks - we were considering something similar for our clustering-R&D needs (for trying out new network file systems, failover solutions etc.), but we decided to go with plain P4 barebones instead. They can be stacked nicely, are relatively quiet and the fast CPUs with HT come in handy when you want good latencies at CPU-intensive tasks (dynamic websites etc.).
Here's a picture of our first 4 boxes. The USB stick seen sticking out from one of the boxes is bootable and an excellent replacement for floppy disks...
Online retailing has been about price for a long time in many parts of the world. Google will have to sabotage (i.e. suppress their hits in the google index) price comparison web sites in order to gain market share - and if it continues to evolve as it has for the last couple of months, it most likely will.
Microsoft intended to replace the ctrl-alt-delete combination with dedicated "Windows" keys, but one of the marketing guys thought it was a bad idea, so they decided to use those new keys for other, less frequently used functions.
Slashdot Mirror
OK, that explains a lot. 250 mil. queries in 45 days is normal for a small company like us and definetely peanuts for Yahoo - i.e. I'd say that this allows the conclusion that nothing particularly important or demanding (i.e. heavily used compared to Yahoo's overall traffic) is built using MySQL at Yahoo. Just to put this into perspective, a little dual Xeon box here does more than 5 million *INSERTs* every day and a large number of SELECTs (we update each of our currently 2.4 million product prices at between 1 and 20 times per day - the exact number of INSERTs per day is currently unknown to me). We use PostgreSQL 7.4.5 though, so we don't consider this a particularly impressive feat ;-)
Yet another company to boycott because of their immoral practices. Seems like they had to resort to such practices because they couldn't figure out how to earn a profit with their crappy products anyway :-/.
In only a couple of months' time, you'll be able to put 8 Opteron cores (4 dual core CPUs) in a desktop-size case - and this is a rather reliable information. It is also very likely that similarly sized boxes with 8 CPU sockets (and thus possibly 16 cores) will appear next year: infoworld.com article.
Passwords are expected to be complemented by biometric methods soon, since the recent political developments everywhere will result in widespread use of biometric passports and other methods of identification. Once everyone has become accustomed to this process, it'll be a natural step to use these methods for a little bit of extra security...
... now if only someone would build broadband adapters for the DC - it's really hard to get one and they're pretty expensive.
Sure. PostgreSQL for example supports PL/Perl, PL/Tcl and PL/Python. Look here.
How can anybody still take the US Patent Office and those patents in general seriously?
Such a system has a fundamental problem: it will motivate people to act purely out of greed, with no further interest in helping to avoid spam. They will therefore concentrate on reporting "easy targets" and perhaps even report people who aren't actually spammers and can't prove it. The whole idea is rather cynical and smells of defeatism (the law won't help => hire bounty hunters acting outside of the law).
It is also noteworthy that his contributions aren't solely in the field of mathematics - he has contributed some groundbreaking work in the area of compiler research, such as this paper.
More seriously, I think that Sun wants to downplay the significance of its getting out of the CPU business (as it seems). IMHO, hardware will not be free, but very cheap and there will be lots of reasons to buy your own gear even if you're a totally non-tech-savvy company that just wants a hassle-free mail-/file-/db-server (just ask any MS-dependent company with no tech skills how smoothly everything works with a standard Exchange server and regular service packs - which is today's equivalent of the subscription-based setups the article talks about). Not to mention that this model isn't going to work for people who use Free Software. Or for people, who don't want to depend on a single closed-source vendor ...
Last time I checked, wavelet compression methods were burdened by many patents: google search. What does that mean for users of the codec?
the bad part: there will be even more crappy Google results (we should give Teoma a chance, since it can't be spammed as easily using links on irrelevant pages)
Fast enough for what? For an amateur programmer coding for himself, in the language he likes best. I certainly wouldn't buy a code library written by that guy ;-)
(disclaimer: I'm a "1985 cycle counting programmer")
1. Mozilla Firefox
2. Mozilla Thunderbird
3. IrfanView
4. putty
5. OpenOffice
6. one of the free zip utilities
7. one of the open source IRC clients (XChat for Windows, Xircon etc.)
8. Spybot S&D
9. winamp
10. Adobe Acrobat Reader
You must be blind. The first thing you see when you start the "psql" command-line utility is:
So, try out the \? command and you'll be presented with all the useful commands ...
Depends on which side that company is on ... What if Microsoft decides that SCO can't survive like this and buys it to put a bit more muscle behind SCO's case?
The Aspire 1703/1705 models weigh exactly the same (7.1Kg or 15.06lbs), see them here or here. They're desktop replacement "notebooks" and Acer calls them "transportable" rather than "mobile". ;-)
Indeed - we'll probably switch to booting over the 'net when we have more boxes or need to try out kernel patches. Right now we boot each node from its 3,5" HDD, the USB stick was/is used for the installation only...
Yes, I guess that most current BIOSes of the newer boards do, especially the consumer-ish stuff. We just used the stock Shuttle XPC with its FlexATX-board.
Oh, I forgot: each of these boxes contains a 2,8GHz P4 Northwood CPU (200/800MHz FSB), 1GB RAM. The Shuttle barebone used is the S75G2 and one of the reasons we chose it was that it has an on-board gigabit ethernet adapter. The CPU cooler that came with it is also very interesting - it uses a rather unique design with a heatpipe ...
Here's a picture of our first 4 boxes. The USB stick seen sticking out from one of the boxes is bootable and an excellent replacement for floppy disks...
Online retailing has been about price for a long time in many parts of the world. Google will have to sabotage (i.e. suppress their hits in the google index) price comparison web sites in order to gain market share - and if it continues to evolve as it has for the last couple of months, it most likely will.
Microsoft intended to replace the ctrl-alt-delete combination with dedicated "Windows" keys, but one of the marketing guys thought it was a bad idea, so they decided to use those new keys for other, less frequently used functions.