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 better at patching XP than Vista?

Microsoft better at patching XP than Vista? - A Microsoft security executive released data Thursday showing that, six months after shipping Windows Vista, his company has left more publicly disclosed Vista bugs unpatched than it did with Windows XP. In total, Microsoft has patched 12 out of 27 disclosed Vista vulnerabilities in the six months after it first shipped last November. During XP's first six months, Microsoft's security team patched 36 out of 39 known bugs. The data was published by Jeff Jones, a Microsoft security strategy director, who said that overall, Vista was doing better than XP. "Windows Vista continues to show a trend of fewer total and fewer high-severity vulnerabilities at the six month mark compared to its predecessor product, Windows XP," he wrote.

Jones didn't address the larger number of unpatched vulnerabilities, but he did note most of the unpatched Vista bugs were not critical. Microsoft had left only one high-severity Vista vulnerability unpatched during the period. At the end of XP's first six months, there were two high-severity bugs that were unpatched. Microsoft patched 23 high-severity XP bugs during its first six months, compared with only one high-severity Vista flaw. Jones argued that Vista had a lower number of vulnerabilities than competitive operating system products such as Red Hat Enterprise Linux and Mac OS X.

View: The full story
News source: InfoWorld

Read full story...

[NeoWin-Main]

Apple shipped 1,119,000 iPhones in Q4 2007

The following is straight from Apple's website, it includes the 2007 fourth quarter revenue and profit information. The article also provides information on how many units were sold, specifically how many computers, ipods and iphones sold.

Nokia N95 + RC plane = unlimited DIY aerial photography

Nokia N95 + RC plane = unlimited DIY aerial photography -

Filed under: ,


If you've found yourself tempted by other interesting DIY aerial photography rigs, but spent all your dough on the Nokia N95 instead, you may still be able to make a lifelong (or momentary) dream come true. A pioneering lad over at the N95 Blog has suggested that nearly unlimited high-resolution aerial photography can be yours if you're willing to strap your precious handset to an RC plane and get savvy with Pict'Earth software. The application allows users to create a theoretical Google Earth of their own if the existing imagery isn't up to snuff with their personal standards. Still, we'd have to mull this one over mighty hard before attaching such a valuable communicator to a potential death bed, but feel free to let us know how things go if you can muster the courage.

[Via AllAboutSymbian]

 

Read | Permalink | Email this | Comments


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

[EnGadget]