Possible to use MySQL's InnoDB engine on 128MB VPS?
Hello everyone! Long time no-see!
I have a problem for you. MySQL's InnoDB engine uses +80-110MB out-of-the-box. So I disable it and use MyISAM (which runs fine in 24MB or so). I also use PostgreSQL since it runs in 30-40MB.
However, since I'm not a DBA I've never really tried hard enough to figure out if there would be a way to get InnoDB functioning in 50MB or less. Can anyone verify if this is possible?
innodb_buffer_pool_size = 1M innodb_additional_mem_pool_size = 1M innodb_log_file_size = 1M innodb_log_buffer_size = 2M`