Posted on November 20th, 2007 by Elliot
We are looking at implementing memcached on our system because our server load is too high. The success stories are very compelling. Here’s what I’ve found so far:
vBulletin: Memcache Pooling & Automatic Failover
vBulletin Forums: Memcached How To (thread)
Performance Tuning MySQL (ProfitPapers)
Useful MySQL Stuff including graphing
Server Optimization Forum at vBulletin
MySQL Notes & Tips
How to Setup Memcached
Memcached [...]
Read More
Posted on November 15th, 2007 by Elliot
Learn how to remove a row in mySQL using the power of PHP.
The original page this is from was down at the time of this writing, so I want to mirror it here.
Here is an easy PHP script to delete any row from your Database. This tutorial goes along with several others that use the [...]
Read More
Posted on November 9th, 2007 by Elliot
I do internal testing of my PHP scripts before rolling them out publicly, so I needed to use local IPs for public domain names. The best way to do this is with Windows’s HOSTS file, and I wanted a good way to do this on Windows Vista. The answer is HostsMan, an excellent free program [...]
Read More
Posted on October 17th, 2007 by Elliot
I have a PHP/MySQL-powered website running on CentOS, which is some variation of Unix or Linux. Recently, we started getting this error…
Warning: mkdir(…) [function.mkdir]: Too many links in … on line …Â
(I replaced the paths and line number with …)
Here’s the only relevant and useful page I could find on the problem: ext3: too many [...]
Read More
Posted on October 2nd, 2007 by Elliot
I was trying to set up my new Mac to be like my Windows PC for testing, so I need to have a few custom host names resolve to local IP addresses. All I could find in Google kept telling me to use /etc/hosts, or NetInfo Manager. I tried both of these methods and neither [...]
Read More
Posted on September 29th, 2007 by Elliot
Sitemaps must have no more than 50,000 URLs and be less than 10 MB uncompressed. It was tricky for me to get gzip compression working in PHP, but I got it done and it works wonderfully. I had to piece it together with stuff from various sites, so I’ll sum it up here.
Before you start [...]
Read More
Posted on September 25th, 2007 by Elliot
XSS Woes! Seriously enlightening, especially that last bit about XSS in phpinfo().
Read More
Posted on September 21st, 2007 by Elliot
First, pick up PSFTP (an SFTP client, i.e. general file transfer sessions much like FTP) from here.
Note the following:
6.2.7 The cd and pwd commands: changing the remote working directory
PSFTP maintains a notion of your ‘working directory’ on the server. This is the default directory that other commands will operate on. For [...]
Read More
Posted on September 18th, 2007 by Elliot
Here’s an ad format I’ve never seen before. It’s actually pretty attractive. It definitely caught my attention for being so thin! What do you think?
In this screenshot, the ad is the HP bar in the middle. I’ve left some context above and below it so you can see what was around it and see its [...]
Read More
Posted on September 18th, 2007 by Elliot
It’s not a totally new idea, but it’s a very nice implementation and they’ve finally made it really easy. I’d like to see some ability to edit the appearance of the widget to fit the design of my site. I think a 160px-wide widget would be great, too, because it’ll line up much more nicely [...]
Read More