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
UUncategorized

Setting up daily, weekly and monthly MySQL Database Backups using AutoMySQLBackup

AutoMySQLBackup is a shell script that allows daily, weekly and monthly backups of your local and remote MySQL Databases. It's meant to run on Linux/Unix through a cron job. Its highly configurable, and easy to setup as I will show you today! First you will need to acquire the shell script and drop it on your server. You can download AutoMySQLBackup on their SourceForge Project Page
Read More

10 Really Useful Flickr Grease Monkey Userscripts.

  • by
  • October 23, 2007
I'm sure a lot of people are familiar with the FireFox extension called GreaseMonkey. The extension allows you to manipulate the JavaScript present on any website you visit. For instance, if you want to displaying text is a specific way, you can. You can also change the colour or look of site with your own custom JavaScript.
9. Flickr Follow Comments - This useful script helps you to view images that you have commented on - but only those that interest you. If you are writing lots of comments every day you know how hard it is not to get distracted by the overload of images when you click “Comments You’ve made”. With this userscript you have 4 different options to see only certain types of comments.
Read More

AMD price cuts

  • by
  • October 11, 2007
AMD had to cut some of its pricing for its processors, Intel right now is offering $300 CAD for the Core Duo E6850 3.0Ghz which is a dual core processor. Hopefully Intel will start slashing some of its prices come Q1 2008.
AMD price cuts - Digitimes reports that AMD has chopped prices by 5 to 28 percent [Digg Main]
Read More

iTouch/iPhone dev team decrypts ramdisks, gains access to secpacks!

  • by
  • October 11, 2007
A great step forward for the iTouch/iPhone Dev Team and owners of the iPhone and iTouch, hopefully something will be out this weekend or next week.
iTouch/iPhone dev team decrypts ramdisks, gains access to secpacks! - In a sudden boost of inspiration, the decryption keys for all iPhone/iPod touch ramdisks were found by the iTouch/iPhone dev team. This paves the way to unlocking iPhones on 1.1.1. In the statement made, the team assures users that hope _is_ on the horizon.
Read More