MySQL, Thread Caching, Linux and a busy site!

  • November 1, 2007
  • 1 minute read
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:
Share 0
Tweet 0
Share 0
Share 0
— Previous article

What to do when you need remote backups for Linux/Unix/Windows/Mac?

Next article —

Must have Thunderbird/Seamonkey Addons

You May Also Like

Auckland Security Consultant uses PS3 for Cryptography

  • by
  • November 29, 2007
As the title states, a Senior Security Consultant by the name of Nick Breese is using a PS3 to crack MD5 hashes. Aside from this article incorrectly stating that the security expert is stealing passwords, as of now he has only shown how fast the machines can process MD5 hashes. This is just a small glimpse of what the software and hardware can do, the article compares how many cycles can be completed using Vector Computing:
Read More

Sling Releases SlingPlayer Mobile For WM6

  • by
  • June 21, 2007
A slingplayer for your mobile device? This is insane. I still haven't gotten a slingbox yet, but after talking with many people. It looks like it would be a good investment.
Sling Releases SlingPlayer Mobile For WM6 -

Just a quick heads up to anyone with a new HTC Touch perhaps and a Slingbox. Sling Media released a new Windows Mobile 6 version of the popular SlingPlayer. You can now watch your favorite local TV while on a bus, train, or in your neighbor’s crack den. Lovely.

It’s $30 for an upgrade to the WM6 version but if you’ve been using the WM5 version for a while now, it’s a free upgrade for you.

Sling unpacks SlingPlayer Mobile for WM6 [Electronista]

 [CrunchGear]
Read More

iPhone v1.1.1 baseband downgrade released

  • by
  • October 12, 2007
The iPhone team has just released a method to downgrade the baseband firmware on the v1.1.1 iPhones. Which means that if you disabled/bricked this portion previously using anySIM or iUnlock during the upgrade, then you can restore the functionality.
Read More