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

Zoph 0.7pre2 (Pre-release branch)

Zoph 0.7pre2 (Pre-release branch) - Screenshot There are many photo-gallery programs available. Zoph is different, as it concentrates on the management of large collection of photos instead of just showing them on the Web. It can store a lot of information about your photos, including the regular EXIF info, photographer, location, title, description, rating, and the people in the photo. Photos can appear in multiple albums and categories. Additional features include search, slideshows, lightboxes, email, access privileges, and multiple languages.
License: GNU General Public License (GPL)
Changes:
A few bugs have been solved and all translations have been updated. All duplicate and unused strings have been removed from the translation files. Dutch, German, Canadian English, French, Norwegian, and even Swedish Chef are completely up to date now. Danish, Italian, and Turkish are almost up to date.
[FreshMeat]
Read More

Drupal Day 1

So, this is what Day 1 is like. I have a nice theme that I got off the main Drupal site. As you can see its sleep and colorful but not overwhelming. Aside from messing with the general configuration of Drupal, there is a lot more you need to do to make it even remotely functional/organized. Lets take categories for instance. At first I didn't know exactly how these worked. However after some playing around, and further posting. I was able to separate my blog entries and the HOWTO's. I just create a new Category for each, and then provide terms to place them under which is a great feature.
Read More

Apple passes Amazon to become the #3 US music retailer

Apple passes Amazon to become the #3 US music retailer -

Filed under: ,


Things must seem pretty rosy in Cupertino -- just a week before the mega-hyped launch of you-know-what, market research group NPD's quarterly survey shows Apple has passed Amazon to become the third biggest music retailer in the US. This isn't the biggest of surprises, since Steve himself predicted that the iTunes Store would overtake Amazon at the Showtime event back in September, but the leap to #3 is a little unexpected, since Apple also outpaced Target last quarter. iTunes is now rocking a 10% market share, just behind Wal-Mart at 16% and Best Buy at 14%, and while we don't expect to see it pass those two giants anytime soon, we'd bet that uptick in DRM-free sales has got the iTMS crew at Apple licking their chops.

 

Read | Permalink | Email this | Comments


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

[EnGadget]
Read More