The biggest mistake you can make to cause problems with performance as a developer is to use joins. Inner or Outer Joins take up a lot of CPU. The transaction queries also take over 1000% time to complete in many cases. If you have to join tables, you need to revisit your DB architecture. The…
Category: MySql
A Perfect Example of Disaster Recovery in the Cloud
Netflix went down yesterday due to power problems at Amazon’s Virginia Datacenter. This of course caused an outage for some of Amazon’s EC2 customers. (Like Netflix). This is a perfect example of why Redundancy in the cloud is important. All of my customers (some of them at EC2 Virginia) stayed up and available. How? Redundancy….
Backing Down from WordPress 3.4 to 3.3.2 [solution]
This post assumes you’re running CentOS. So modify the commands accordingly. I also assume you have your wordpress install in /var/www/something.com After a bit of a while I finally decided to take the leap again to WordPress 3.4 from 3.3.2 only to be disappointed again. There are still some issues they need to work out….
What happened to “Human” in Humanity?
I really do need to ask this question. I appreciate my followers and yes, they’re a loyal bunch. I do need to EVERYBODY one question and everyone on the Internet. We all go about our lives. We see the homeless person at the exit ramp, on the sidewalk, etc. Granted a lot of them are…
Free Tech Support from me…
OK. I really believe in my project for helping the unemployed, so here’s what I propose. If you donate to my project and of course, get others to donate to my project, I will provide you with free tech support (my skills and advice) for a period of time. Donate: $25.00 you get 1 hour…
I guess this is a call out for help
I’m at the point where I can’t support this blog due to the traffic I’m getting. I really need some donations or something. I’m pushing about 5 GB of data a day and due to my divorce, I can’t afford to support this continually. I’m not asking for donations, although, they would help, but I…
Want a Free Server for a year? Here’s how to do it.
Amazon offers a free server for a year. If you sign up with me, I’ll set up your server in your free tier for $25.00. Just sign up with me and you’ll get a free server to do whatever you’d like for a year. This can be a webserver, mail-server, VPN server, or any combination…
Backups. Being prepared for the restore.
Backups are something that is so important in any system that one should look carefully at not just the backup solution they are using, but the restore solution they’re going to have. Here are my recommendations and views on Backups. 1. Don’t assume that just because you bought a backup package that it just “works”…
When was the last time you had a technology audit?
This is a message to everyone who runs any kind of technology in a business. The posting is directed towards everyone who has their own applications, servers, blogs, websites, etc. Special Note to CIOs/CTOs: I understand you run an organization that has many people under you. I understand that you feel you’ve got your resources…
Rewriting URLs using Apache and WordPress – Natural Partners
This post discusses how using .htaccess on Apache will actually help you avoid many 404s and also support multiple permalink structures in the process. .htaccess is very finicky and that in there lies the problem, but with this article, you should be able to solve a few problems (and even do some extreme customization). My…