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

Western Digital developing 20,000RPM drives

That's right, this isn't a joke.
The new drive will be very similar to the recently-released VelociRaptor, in that it’ll be a 2.5in drive with a custom 3.5in housing built around it. Details are incredibly light at this stage, given that the product is still in development, and we don’t even have a release timeframe at the moment. However, our sources said that the drive will be ‘silent’ – that’s the last thing I would have expected from a drive with platters spinning at 20,000 RPM. Western Digital is apparently working on silencing the beast by improving the housing technology, which will now not just act as a heatsink, but also as a noise cancelling device. We’d also hope that the drive enclosure has some vibration dampening technology as well, because that’s also likely to be a problem given the high spindle speeds.
Now they just need push SATA 6.0Gbit/s onto motherboards http://en.wikipedia.org/wiki/SATA#SATA_6.0_Gbit.2Fs Full artile at bit-tech.net
Read More

Interpol Unscrambles Doctored Photo In Manhunt

  • by
  • October 9, 2007
This is a pretty crazy story about how Interpol within Paris reverted a doctored photo of a man who was sexually exploiting children, the photo was blur'd using photoshop and they somehow were able to remove the blur and actually reveal the mans face. They're not sharing what technique was used top remove the doctored portion of the photo.
Read More

Nokia N95 + RC plane = unlimited DIY aerial photography

  • by
  • June 23, 2007
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]
Read More

Insane Laptop: Alienware m9750

  • by
  • June 24, 2007
Insane Laptop: Alienware m9750 -

Looks like Alienware will never stop out-doing itself. This bad boy comes packed with up to two 512MB GeForce Go 7950’s using SLI and a slew of Core 2 Duos to pick from. Options include a pair of 200GB HDD’s in RAID 0 for a total of 400 gigs of media storing power. The 17″ 1920 x 1200 res LCD is also sure to impress. Integrated b/g/nwireless, Bluetooth 2.0, and 7.1 high def audio is definitely making a few mouths water at CrunchGear HQ.

Alienware Area 51 m9750

Click on for a few more pics (more…)

 [CrunchGear]
Read More

Microsoft Offers Further Open Source Patent Threats

  • by
  • October 9, 2007
Again Microsoft is trying to bully open source distributions and projects to buy into their patent protection that Novell has already sank money into.
Microsoft Offers Further Open Source Patent Threats - An anonymous reader writes "Via Groklaw comes comments from Microsoft's Steve Ballmer at a UK event, in which the company once again threatens Linux distributions that haven't signed up with their program. '"People who use Red Hat, at least with respect to our intellectual property, in a sense have an obligation to compensate us," Ballmer said last week ... Ballmer praised Novell at the UK event for valuing intellectual property, and suggested that open source vendors will be forced to strike similar deals with other patent holders. He predicted that firms like Eolas will soon come after open source vendors or users. Microsoft paid $521m to settle a patent claim by Eolas in August.'"

Read more of this story at Slashdot.

 [Slasdot]
Read More
UUncategorized

Bug Clean up for QuickPwn

Not too long after releasing and updated PwnageTool and Quickpwn, the iphone-dev.org team has released an update to QuickPwn.
We’ve had some issues with iPod touch devices and the latest version of PwnageTool for the Mac, in certain conditions incorrect permissions will be used and the keychain doesn’t save passwords. So hold on and wait for the next release, we’ll push out the updated version via Sparkle as soon as it is tested (it is being tested right now).
Read More