Tweaking mysql in Kloxo/LxAdmin

Tweaking a web server is very necessary, the less it will consume resource, the more stable it will be and the more website it will be able to handle. Kloxo/lxadmin is a free control panel, and has been working quite great but the problem with it is, it use alot of RAM though kloxo documentation claims that it only eat 33MB ram which is completely wrong in my experience.

There are few ways to tweak kloxo/lxadmin, I already wrote an article on how to replace apache with lighttpd. Lighttpd is much more lighter then apache, though it is bit different but there is an easy way to replace apache with lighttpd in kloxo. You can read

How to install Lighttpd in Kloxo (LXadmin)

Here I’m going to tell, how to tweak mysql in kloxo.

If you are running simple website or blogs, then you do not need innodb. innodb is a mysql storage system and do not require for simple websites. Therefore disabling innodb in kloxo will safe alot of RAM. Same with bdb, it is storage translator in kloxo.

  1. Login to server using ssh
  2. open /etc/my.cnf
  3. and add lines to disable innodb and bdb
  4. save and close file
  5. restart mysql, and you will see the huge decrease in RAM.

RAM usage before disabling innodb and bdb

Disabling innodb and bdb


Restart mysql

RAM usage after

You can clearly notice that ram usage is decreased from 256MB to 164MB after disabling innodb and bdbd.

Please follow and like us:
About shk

shk is a DevOps engineer with more than 12 years of experience in different organizations. He enthusiastic about learning new technologies and shares his knowledge through his blogs.

Comment Policy:

Your words are your own, so be nice and helpful if you can. Please, only use your real name, not your business name or keywords. Using business name or keywords instead of your real name will lead to the comment being deleted. Anonymous commenting is not allowed either. Limit the amount of links submitted in your comment. We accept clean XHTML in comments, but don't overdo it please.

Tell us what you're thinking...

All comments are moderated.

* Denotes required field.



Previous Post:
Next Post: