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.


Did you like this article?


0 Shares:
You May Also Like

Microsoft flip-flops again: now no Vista Home on Macs

I can't believe this is happening, twice in a week two Microsoft proposed changes to allow more functionality and portability are squashed like a bug. This is not going to make consumers happy, and will drive some of them into Apple's arms, and possibly Ubuntu's.
Microsoft flip-flops again: now no Vista Home on Macs -

Filed under: ,

We've seen our fair share of flip-flopping in the past, and Microsoft is yet again adding its name to the frowned upon list by retracting previous intentions to allow Windows Vista Home and Home Premium operating systems to run under virtualization. After reportedly stating that it would "change the EULA after listening to customer feedback on the issue," it appears that the suits in Redmond have thought better of said decision. Now, the firm has "reassessed the Windows virtualization policy and decided that maintaining the original policy announced last Fall" would be best. Ben Rudolph, Parallels director of corporate communications, noted that he was "obviously disappointed" in Microsoft's change of heart, but if the two-faced Mac users out there can persuade Google to take their side, we're sure this little spat could be cleared up in no time.

[Image courtesy of ElliottBack]

 

Read | Permalink | Email this | Comments


Office Depot Featured Gadget: Xbox 360 Platinum System Packs the power to bring games to life!

[EnGadget]
Read More

Adobe says Acrobat, Reader vulnerable to hacks

This is a disturbing as most white pages and manuals ranging from automobiles and computer motherboards are in PDF format. Even eBooks could be an easy way for a hacker to gain access to your machine, illegal books put online could be a trap for unsuspecting downloaders.
Adobe says Acrobat, Reader vulnerable to hacks - BOSTON (Reuters) - Adobe Systems Inc, whose software is used by millions of people to read documents sent over the Internet, said on Wednesday some of its programs contain yet-to-be-fixed flaws that make computers vulnerable to attack. On October 5, Adobe posted a notice on its Web site that said it had unknowingly incorporated vulnerabilities into versions of Adobe Reader and Acrobat software that could allow malicious programs to get on to a PC without the user's knowledge.
Read More

EA Games wants an Open and Single Platform

EA Games Head of International Distribution Florin, wants a single and open platform. Instead of having 3 or 4 different platforms for each game they release, they want to stream line it. He also goes on to talk about set top boxes and how they will be the next generation console.
Read More