Risharde's Blog

Maybe we, why don't we sit right here for half an hour?
We'll speak of what a waste I am, and how we missed your beat again!

I swear we need to find some comfort in this run down place
To bridge the gap of this conscious state that we live in
And I'm short of time

How could you trust it
(these fate trashed walls)
To fit the shape of what they tell you
Come on, move on, move on
But mostly what they show you
(Yeah, yeah)
Not this way
Not this way

I'm taking back all the things I said
Thinking back all the things I said

I was rather surprised to discover that it is so difficult to find a decent web control panel for Linux. After all, linux is king when it comes to open source / free software. What has been more amazing for me is that there ARE in fact, okayish control panels but most are VERY DIFFICULT to install. The question I asked was "Why is this so?".

So I began the google journey to discovery, in hope that some good soul would create a straight forward install.

I found 2 potential easy control panels that were fairly straightforward to install:
Webmin which does a more root/administrator side of the administratio
and low and behold, what I deem to be some sort of cursed control panel: Kloxo

Kloxo is the closest free web control panel I've seen that's similar to Cpanel but Kloxo has had its bad times. In fact, I am still scared of using it but for the price (FREE) and the inconclusive evidence in terms of flawed security, I'd run a VPS and test it.

Hey everyone, just an update, decided to test a new control panel so I moved over my blog to webserver2 - another spare VPS I have available. Please contact me if you find any bugs, thanks!

--Rish

Hey everyone, well lately, as you may have known, I've been working with MySQL more closely with respect to optimizing its performance both for work and for some of the websites I am running.

By default install, on CENTOS (and I assume most other linux distros), MySQL doesn't enable proper query caching. I suppose this is for simplicity sake. However, a lot of the times, your projects would perform better if you had it enabled.

So how do you do that?

Well, you need to edit the mysql main configuration file. This is normally found in /etc/my.cnf (I normally type nano /etc/my.cnf) to edit it. I HATE VI.

Anyways, moving along, you need to put the following in the [mysqld] section:

query-cache-type = 1
query-cache-size = 20M

The 1 means query cache enabled
the 20M is the amount of memory to be used for the cache - tune as you see fit

I'll be releasing more performance tuning options in the future :)

Good luck

--Rish

I thought it would be appropriate to take some time off to look back at the 26 years of life (on the eve of my birthday). I would not have been able to make it without the help of my family and friends and of course without God - so thank you. As I look back, I realize that while there have been some accomplishments, there is so much for me to still accomplish that it is overwhelming and sometime blinding. I have lost a few friends but definitely gained better ones. I've learnt valuable lessons and I'm trying harder to manage my time. I wish there was more time to spend on family, friends and honouring God. I've realized that a major part of life and humanity is helping others but even more importantly, helping those that are poor and without. I've learnt that hope and the ability to dream in many cases is what fuels our existance and having a strong reason to live.

I look back at people I've lost

Inevitably, it made me wonder, what really have I accomplished?

Reminder to write about Pricesmart. Coming soon.

Interesting enough, I can't blame you for believing that I am only or mostly destructive by my comments on this blog so I thought I'd try to attempt to show you the good side to me and let you guys know what I have been up to lately. Unfortunately since I doubt I can give out full details (not sure the legal aspects to disclosing work information), I've been busy at work trying to develop a system that can partially speed up the waiting times of patients and provide basic reports to staff. It's been done before but not quite like what I am doing and I've never heard of the technology been used in this way however it might have existed, who knows. It's undoubtedly left me with having to tune MySQL which I never really had to do so while I'm hopefully making positive waves - I'm also learning now how to tune MySQL with help from DBTuner.

If I get any tips out of this information, be sure you'll be the first to know right here on my blog :)

--Rish

Oh my friends, I came across this song on youtube and I really felt this song for some reason!

Did you know how much you meant to me, oh no.
Did you know i still carry the memories, oh no.
Did you know that for me,
letting go wasn't easy, oh no.
No you don't.

Do you still listen to our lullaby, oh no.
Does it help you get to sleep at night, oh no.
Are you sitting alone by the pale moon light, oh no.
No you don't.

I just need a bit more time,
to get you off my mind tonight,
i'm thinking of your bright blue eyes,