Optimize Mysql for performance

[prgs1971]

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]#

[MRatWork]

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

[prgs1971]

So by default innodb is disabled in kloxo?

[MRatWork]

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.

[prgs1971]

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

[MRatWork]

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

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

[prgs1971]

Thanks for the tip

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

[MRatWork]

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

[prgs1971]

Tanks for your advice