MySQL, Thread Caching, Linux and a busy site!

Heres an article that helped me with an issue over at a friends site http://www.ftatalk.com Their site was exploding and they need to tune out the current server as much as possible. One thing that I noticed was that MySQL wasn’t tuned properly. So After making some changes and finding out that there was no thread caching, I searched the web and found this article. Wow, it’s been a busy week. I was totally swamped for several days dealing with the remember.yahoo.com MySQL servers and related stuff. And then I used a day or two to recover (sleep, shower, etc). Anyway, I made some interesting discoveries along the way. The most surprising one had to do with thread caching on Linux when you have a busy MySQL server–busy in a particular way, mind you. Read the full article at jeremy.zawodny.com ***UPDATE*** I have moved ftatalk.com over to lighttpd and its doing wonders! You can also check out the ftatalk.com mirror at http://www.satfix.net I will also be writing an article about lighttpd and how it can help you get the most out of your hardware.

Heres an article that helped me with an issue over at a friends site http://www.ftatalk.com
Their site was exploding and they need to tune out the current server as much as possible. One thing that I noticed was that MySQL wasn’t tuned properly. So After making some changes and finding out that there was no thread caching, I searched the web and found this article.

Wow, it’s been a busy week. I was totally swamped for several days dealing with the remember.yahoo.com MySQL servers and related stuff. And then I used a day or two to recover (sleep, shower, etc).
Anyway, I made some interesting discoveries along the way. The most surprising one had to do with thread caching on Linux when you have a busy MySQL server–busy in a particular way, mind you.

Read the full article at jeremy.zawodny.com

***UPDATE*** I have moved ftatalk.com over to lighttpd and its doing wonders! You can also check out the ftatalk.com mirror at http://www.satfix.net
I will also be writing an article about lighttpd and how it can help you get the most out of your hardware.

0 Shares:
You May Also Like

Final Draft of GPLv3 Allows Novell-Microsoft Deal

Final Draft of GPLv3 Allows Novell-Microsoft Deal - famicommie writes "All of Novell's fingernail biting has been for naught. In a display of forgiveness and bridge building on behalf of the FSF, ZDNet reports that the final draft of the GPLv3 will close the infamous MS-Novell loophole while allowing deals made previously to continue. From the article: 'The final, last-call GPLv3 draft bans only future deals for what it described as tactical reasons in a 32-page explanation of changes. That means Novell doesn't have to worry about distributing software in SLES that's governed by the GPLv3 ... Drafting the new license has been a fractious process, but Eben Moglen, the Columbia University law school professor who has led much of the effort, believes consensus is forming. That agreement is particularly important in the open-source realm, where differing license requirements can erect barriers between different open-source projects.'"

Read more of this story at Slashdot.

[Slasdot]

AMD considering getting out of fabrication business

This is something I saw over at Ars Technica. This is a big and ugly move for AMD, no chip fabrication and just straight up design might put them in a hard place. Intel at the moment does both, and has many fabrication production facilities. Here are some facts about AMD:

AMD has planned expansions in their production capacity. In addition to the completion of Fab 36 in Dresden (300 mm 90 nmSOI), AMD is planning to upgrade Fab 30 (adjacent to Fab 36) in Dresden from 200 mm 90 nm process SOI to a 300 mm 65 nm process SOI facility and rename it Fab 38, and open a new facility at the Luther Park Technology Campus in Stillwater, New York (likely 300 mm 32 nm process SOI production) between years 2009 to 2010. process

And here is some information about Intel:

Intel currently operates four 300-mm fabs that provide the equivalent manufacturing capacity of about eight 200-mm factories. Those factories are located in Oregon, Ireland and New Mexico. The company also has an additional 300-mm fab currently under construction in Arizona (Fab 12) scheduled to begin operations later this year, and one expansion in Ireland (Fab 24-2) scheduled to begin operations in the first quarter of next year.

It was hard to find a lot of detail about Intels Facilities. Even WikiPedia and a 4 page google search turned up nothing.

AMD considering getting out of fabrication business -
Reports are surfacing that AMD is seriously considering a move out of the chip fabrication business, focusing its efforts entirely on chip design. It would be a risky move on AMD's part, even if it would ameliorate some of the company's cash flow problems.
Read More... [Ars Technica]