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.

0 Shares:
You May Also Like

Video of iPhone Sim Free Unbricking and Unlocking (Verdict: It Works)

A video of the jail breaking and installation of 3rd party applications, but nothing about the activation and if you can use non AT&T SIM's. Still a pretty neat video.
Video of iPhone Sim Free Unbricking and Unlocking (Verdict: It Works) - We have tested iPhone Sim Free claims and they work. It still not a process for the faint of heart, as it requires using command line-voodoo for the jailbreak and activation, but it works perfectly. Our iPhone is now completely unlocked and open for apps now under Apple's latest firmware.

MySQL and OpenSSL Replication what a mess!

Just a heads up, if you do decide to enable OpenSSL so you can do encrypted MySQL replication. There are two bugs that will affect replication and the mysqldump command. They're as follows: Bug #24148 regression tests hang with SSL enabled http://bugs.mysql.com/bug.php?id=24148 http://lists.mysql.com/commits/17286 Bug #27669 mysqldump: Got error: 2026: SSL connection error when trying to connect http://bugs.mysql.com/bug.php?id=27669 http://lists.mysql.com/commits/24329 This may cause lots of problems with MySQL and SSL Replication using OpenSSL. Cheers!

WWDC Leopard Beta Leaked Onto BitTorrent Site

I haven't seen this on any private trackers that I'm on. It looks like it hasn't fully been leaked. Either way, I want to install this and try it out. I am definitely liking OSX more and more as they keep adding features and GUI improvements.
WWDC Leopard Beta Leaked Onto BitTorrent Site -

leooinkleaked.jpg

It looks like the WWDC beta of Leopard was leaked onto the Oink BitTorrent Web site. (I’m not about to download it, though, that’s for sure.) Here’s a screen shot. And another. And another. That last one made me laugh. Oops!

Nobody’s completely downloaded the 6GB file yet, but the site’s forum is red hot with activity and the file already has 205 comments. Choice lines about the leak in recent days have included “this is f*#$ing ridiculous. i want leopard, and i want it now. hurry, before some heads start to roll” and “Please do not talk about this torrent file outside of OINK.”

Someone should notify Apple.

[CrunchGear]