Kloxo Optimiztion Techniques?

[pioneer_fawad]

hi,
Kloxo is indeed a free but its drawback is that it is not optimized. can Ay one here give a TuTs to optimize kloxo , so that it can use less ram and low processing .

Specially Mysql and httpd

It will be helpful for many around here thanx

Regards

 

[Lock Down]

Here is an execllent guide for kloxo optimization
Some of which are:

The optimizations are:

1) The my.cnf.lowmem file tweak the mysql config.

This will disable the storage system InnoDB engine(skip-innodb) in MySQL (which will in turn break the included webmail apps Roundcube and Horde - you will have to install something like squirrelmail - and some CMS and eCommerce apps like Magento). This change alone should save about 100 MB.

mv /etc/my.cnf /etc/my.cnf.backup

cp /usr/local/lxlabs/kloxo/file/lowmem/my.cnf.lowmem /etc/my.cnf

service mysqld restart

2) Stop the ClamAV (anti-virus) auto update process (useless if you did not enable it for e-mail scanning).

service freshclam stop

3) Change QPanel internals to be more resource conscious.

touch /usr/local/lxlabs/kloxo/etc/flag/lowmem.flag

Finally restart KLOXO for the changes take:

service kloxo restart

After these changes my memory usage went from 384 mb to 73 mb

 

[pioneer_fawad]

if i disable skip-bdb , is there any effect on Wp website ?

in /etc/my.cnf

 

[hover]

No, as wp doesn't use that storage engine.

 

[chems]

Is your mysql process loading too much memory? The following snippet will reduce it by almost half of the consumption done currently!

Goto "etc/my.cnf" of your server or from Kloxo (go to Server>Localhost>File Manager) and edit it to add these lines/snippet after [mysqld]

skip-external-locking
skip-slave-start
skip-bdb
skip-innodb
skip-name-resolve

# Global mem settings
key_buffer = 24M

max_connections = 200

# Per client mem settings

sort_buffer_size = 4M
read_buffer_size = 4M
binlog_cache_size = 2M

max_allowed_packet = 12M
thread_stack = 128K

table_cache = 128
thread_cache = 256
thread_concurrency = 4

myisam_sort_buffer_size = 1M
tmp_table_size = 12M
max_heap_table_size = 12M

wait_timeout = 200
interactive_timeout = 300
max_connect_errors = 10000

query_cache_type = 1
query_cache_limit = 1M
query_cache_size = 16M

[mysqldump]
quick
quote-names
max_allowed_packet = 16M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer = 16M

Restart your VPS, and you will notice significant decrease of ram usage in MySQL. I manage to reduce about 180MB(From 430MB to 240MB) ram after using this tweak. However there is downside as well, roundcube might encounter error, as mentioned in this thread.

Source:

http://calvinms.web.id/1720-reducing-ram-usage-in-vps-running-kloxo

 

[pioneer_fawad]

thanx , i am not using mail accounts for my website domain then there is no problem for me to disable it