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

Comcast fires employees for talking about P2P filtering

  • by
  • October 29, 2007
It looks as though Comcast has fired a few employees for talking out of script.
In the wake of the discovery that Comcast is blocking some peer-to-peer traffic (and even blocking some Lotus Notes e-mails), the company is attempting to keep the PR machine well-oiled by giving customer tech support reps some talking points. And if they deviate from the script and admit that Comcast has been using Sandvine to send forged TCP reset packets, they're likely to lose their jobs.
Read More
UUncategorized

Error’d: Crashing Las Vegas

This is awesome. I recently took a trick to Las Vegas, and wondered about all of the the neat hardware that runs the screens and lights.
Error'd: Crashing Las Vegas -

Surely, you’ve seen the commercials and are familiar with Las Vegas’ First-Commandment / Clever-Marketing-Tagline: What Happens in Vegas, Stays in Vegas. I suppose we can bend that rule today and share a couple pictures that Christopher Kimbell snapped while he was walking down the strip…

… and later that day …

As for the rest of the pictures that Chris found on his camera after his vacation? I think we'll just leave those in Vegas…

[The Daily WTF]
Read More

Webroot Spy Sweeper 5.5.1 Build 3354

  • by
  • June 21, 2007
Webroot Spy Sweeper 5.5.1 Build 3354 - Spy Sweeper safeguards your identity and restores system performance through fast, smart and powerful anti-spyware protection. Spy Sweeper protects against all types of spyware, including system monitors, Trojan horses, and other threats like CoolWebSearch, Look2Me, and more. Spy Sweeper's advanced removal engine deletes the toughest spyware programs - even removing mutated or "rootkit" spies, some of the nastiest next-generation spyware threats - which are specifically designed to avoid detection and removal. This removal technology saves time and effort by eliminating these vicious threats in one sweep - requiring no need for multiple reboots. As soon as it's installed, Spy Sweeper with AntiVirus offers 360 degrees of protection against spyware and viruses and is now compatible with Windows Vista.

Product features include:

* Detect and disinfect viruses, spyware, Trojans and worms at the point of infection to keep your PC safe
* Your PC can be completely cleaned and disinfected in just a couple of mouse clicks - it's that easy.
* Protect your PC and your Internet activities without any cumbersome configuration using Spy Sweeper with AntiVirus software.

Read full story...

[NeoWin-Software]
Read More