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…
Tag: applications
The most common mistake in Applications and Databases in general
So many programmers make this mistake because they don’t seem to get it. It’s not your fault as a programmer / developer. It’s just that you’re not a DBA. You need to implement Connection pooling. It makes such a huge difference in the way your DB performance and app works it’s amazing. So here are…
Smartphone Bloatware, the New Malware.
I like my smartphone. I use a Galaxy S II vs. the Galaxy S III. Why? I didn’t want to pay the $200.00 overhead for a phone that will be worth $300.00 less in 6 months. This doesn’t mean I don’t get the performance I need. All the carriers (T-Mobile, ATT, Verizon, Vodacom, Virgin, etc.)…
Increasing Mysql performance significantly
For those of you who run mysql, there’s an issue that you have to look at. Like file systems, database tables get fragmented over time. There’s a simple fix for it, but you will need to execute one command to do it. Of course, you will need to have root access to your Mysql server,…
The Apple iPhone vs. Android making the choice
So you’re in the market for a new mobile phone. The question is which do you go with? When I say which, I mean which platform. There are really 2 major choices today: 1. iPhone 2. Android So which do you go with and how should you make the decision. The reality is I go…
Backups: a bit of insight and perspective.
Many of us have backups. Many of us don’t. Here’s an interesting question though. Those of us that have backups. How many have actually tested them out to make sure they’re working? If you have, how often do you test them? Most people set up a backup solution and just let it run. They don’t…
So you don’t know your root password for mysql. Getting root control of your mysql server back without having to reset the password.
[singlepic id=57] This little tidbit is written for Redhat / CentOS, but with a little bit of work, the concepts and commands are easily modified for any flavor of linux. If you’re sitting on a LAMP stack and you’ve had a defection or just haven’t documented your passwords in a safe place, the easiest…