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.


Did you like this article?


0 Shares:
You May Also Like

Microsoft backports Vista features for new Windows XP SP3 beta

Microsoft knows that XP will still be alive on desktops for the next 2-3 years before hardware will be put in place to utilize Vista. Therefore they have made available some of the features within Vista, in a new service pack for XP. At this point, Vista is really buggy and crashes often. I've even reverted back to XP after continued nightmares with Vista. I hope the new service for Vista brings some stability to the operating system that was originally slated to replace XP, but hasn't done so quite yet.

pyctd 0.4.2 (pyctd branch)

This is a really neat application, however I was not able to get it to run on Debian Testing. I was getting a strange error message after installing "python-ctypes" "libnetfilter-conntrack1" through apt-get: Traceback (most recent call last): File "/usr/bin/pyctd", line 27, in ? import pyctd File "/usr/lib/python2.4/site-packages/pyctd/__init__.py", line 2, in ? from pyctd.conntracking import DataCollector File "/usr/lib/python2.4/site-packages/pyctd/conntracking.py", line 31, in ? import pynetfilter_conntrack as nfct File "build/bdist.linux-i686/egg/pynetfilter_conntrack/__init__.py", line 4, in ? File "build/bdist.linux-i686/egg/pynetfilter_conntrack/func.py", line 32, in ? File "/usr/lib/python2.4/site-packages/ctypes-1.0.2-py2.4-linux-i686.egg/ctypes/__init__.py", line 353, in __getattr__ func = self.__getitem__(name)

EA Games wants an Open and Single Platform

EA Games Head of International Distribution Florin, wants a single and open platform. Instead of having 3 or 4 different platforms for each game they release, they want to stream line it. He also goes on to talk about set top boxes and how they will be the next generation console.

DIY: Make a laptop sleeve with a FedEx envelope

DIY: Make a laptop sleeve with a FedEx envelope - diyfedexlapsleeve.jpg

DIY site Instructables posts a tutorial on making a laptop sleeve from FedEx envelopes:

I was looking for a strong and waterproof material to make my own sleeve from and remembered that FedEx and the US Postal Service both use Tyvek (or similar) material for their envelopes. My sleeve fits a MacBook, but the design is easily adaptable for other sized laptops.

The project requires 3-4 envelopes, some felt and some sewing, and the result is a pretty good camouflage for your lappie as well. Thanks, Annie!

[LifeHacker]