Here’s the scenario. You’ve got a dedicated server running windows in a server farm (generic dedicated server provider). You have mysql + asp or php app running all on the same server. Raid 1 mirroring and 2 GB of ram. You have to have windows, because your application supports it. Sound Familiar? It’s a problem…
Tag: mysql
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,…
Fixing Live WordPress Install without downtime [Solved – A Solution]
I love wordpress. It’s simple and very powerful. The only problem with it is the quality of the plugins and the constant upgrading. Like Microsoft Windows, sooner or later, something is going to break. Of course, I didn’t notice it until just recently. On my blog (This blog), the newsfeeds broke. I really don’t know…
Mysql Tuning for the Novice to Expert
Most people just install Mysql, use the defaults and call it a day. Unfortunately, for a select group of people with high traffic, this can cause problems. It all falls into the issue of performance. This can effect your website, applications, etc. I’ve seen this happen on numerous occasions, because people don’t bother to think…
Is your website slow? Fix It.
Today, almost everybody has a website. Many are run on a Webserver called Apache. It’s an amazing piece of software that is ironically free and incredibly secure (when configured properly). There are plenty of content management and publishing tools out there as well. WordPress (my personal favorite), Drupal, Movable Type just to name a few. …
centos 5 squirrelmail change sqlpass plugin
If you’ve had issues with getting the change_sqlpass plugin to work on squirrelmail, there are definitely quite a few mashinations of the system on how to get it to work on Centos 5.x So here’s how I got it to work. Please keep in mind that the following matters. Your SQL Mail Table called users…
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…
The Pitfalls of Yum Update and Postfix, MySQL, SASL, and TLS
While CentOS and Redhat have a wonderful update facility called Yum, there are some pitfalls to just randomly issuing a ‘yum update’ especially if you have very little experience with the intricacies of your configuration. Like any “techy” geek, I was bored and randomly decided to update my mailserver cluster last night. (yes, I have…
Updating Postfix on CentOS 5
Well, I decided today would be a good day to update the mailserver so I decided to do a yum -y all. Needless to say, it went well.. but dumbass me didn’t bother to check the mailserver. So.. needless to say, all day, I had my mailserver down due to the fact that the postfix…