MySql InnoDB engine on Link-3

[johnmathe]

Hi all,
Is it possible to set up mysql to use the default engine on the Link-3 hosting plan? (i.e. 256 Mb garunteed RAM)

Here is a sample /etc/mysql/my.cnf that I modified for a smaller footprint

# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
# You might want to disable InnoDB to shrink the mysqld process by circa 100MB.

#skip-innodb
#
# Set buffer pool size to 50-80% of your computer's memory
innodb_buffer_pool_size=128M
innodb_additional_mem_pool_size=20M
#
# Set the log file size to about 25% of the buffer pool size
innodb_log_file_size=32M
innodb_log_buffer_size=8M
#
innodb_flush_log_at_trx_commit=1

Any help to make Innodb work on the Link 3 or modification of the config file will be appreciated

Thanks in advance
-john

[johnmathe]

i found some nice HowTos about low memory MySql on this site sorry for not looking around
(i'm not allowed to post the link but its in the HowTos wiki)

[DanL@VPSLink]

Tested on a Link-4 OpenVZ VPS without any other significant running processes:

Default MySQL Configuration

# free -m
             total       used       free     shared    buffers     cached
Mem:           500        151        348          0          0          0
-/+ buffers/cache:        151        348
Swap:            0          0          0

Posted MySQL Configuration

# free -m
             total       used       free     shared    buffers     cached
Mem:           500        270        229          0          0          0
-/+ buffers/cache:        270        229
Swap:            0          0          0

For testing purposes, I tweaked the configuration which you presented, reducing all of the memory values by 75% - here is the result:

# free -m
             total       used       free     shared    buffers     cached
Mem:           500        147        352          0          0          0
-/+ buffers/cache:        147        352
Swap:            0          0          0

It looks as though you will want to revisit your configuration - I would recommend decrementing the values significantly and then experimenting with increased values.