MRatWork Forum by Mustafa Ramadhan

Sawo Project - Kloxo-MR Discussions => Kloxo-MR Technical Helps => Topic started by: prgs1971 on 2013-08-18, 17:49:15

Title: Optimize Mysql for performance
Post by: prgs1971 on 2013-08-18, 17:49:15

I use a Linode VPS with 1.5GB of memory and i want to optimize Mysql performance for it.

This VPS will host only e-commerce stores.

I need InnoBD enabled.

What will be the best setup for it?

Code: [Select]

[root@server]# sh /script/sysinfo

A. Kloxo-MR: 6.5.0.f-2013081304

B. OS: CentOS release 6.4 (Final) x86_64

C. Apps:
   1. MySQL: mysql-5.5.29-1.el6.x86_64
   2. PHP: php53u-5.3.27-1.ius.el6.x86_64
   3. Httpd: httpd-2.2.25-1.el6.x86_64
   4. Lighttpd: --uninstalled--
   5. Nginx: --uninstalled--
   6. Qmail: qmail-toaster-1.03-1.3.27.mr.el6.x86_64
      - with: courier-imap-toaster-4.1.2-1.3.14.mr.el6.x86_64
   7. Dns: bind-9.9.3-4.P2.el6.x86_64

D. Php-type (for Httpd/proxy):

E. Memory:
                total       used       free     shared    buffers     cached
   Mem:          1489       1244        244          0         88        554
   -/+ buffers/cache:        601        887
   Swap:          255          0        255

[root@server]#

Title: Re: Optimize Mysql for performance
Post by: MRatWork on 2013-08-18, 17:50:42

Run 'sh /script/mysql-convert --engine=innodb'.

Title: Re: Optimize Mysql for performance
Post by: prgs1971 on 2013-08-18, 18:20:09

So by default innodb is disabled in kloxo?

Title: Re: Optimize Mysql for performance
Post by: MRatWork on 2013-08-18, 18:22:15

For memory usage reason, mysql use 'myisam' as storage-engine and disable/skip innodb. If you have ram more then 1GB better select innodb. Or Aria if change mysql to mariadb.

Title: Re: Optimize Mysql for performance
Post by: prgs1971 on 2013-08-18, 18:54:07

I don't know Aria ....

Mariadb is not enabled by default?

What is the advantage of using Mariadb?

I am thinking in give a try to Perconna Mysql server ;)

Title: Re: Optimize Mysql for performance
Post by: MRatWork on 2013-08-18, 18:56:45

You must edit '/etc/yum.repos.d/kloxo-mr.repo' to make mariadb available.

Googling or use 'search' facility in this forum about mariadb.

Title: Re: Optimize Mysql for performance
Post by: prgs1971 on 2013-08-18, 19:17:42

Thanks for the tip ;)

First i will try to see what are the advantages of using Mariadb.

Title: Re: Optimize Mysql for performance
Post by: MRatWork on 2013-08-18, 19:21:32

If using Centos 6 better using mariadb from centalt (not from mariadb.org).

Title: Re: Optimize Mysql for performance
Post by: prgs1971 on 2013-08-18, 19:54:27

Tanks for your advice ;)