mysql low memory config

sandoz

does anyone have a good 128mb LEB mysql cnf file?
i tried several online, but i cannot find a good one that really use low memory

mustafaramadhan

1. Make sure all databases/tables using myisam as storage engine.
2. Copy /usr/share/mysql/my-small.cnf to /etc/my.cnf
3. Add 'skip-innodb' under '[mysqld]' in /etc/my.cnf

salmon

I find performance_schema = off helps

ATHK

@mustafaramadhan said:
3. Add 'skip-innodb' under '[mysqld]' in /etc/my.cnf

skip-innodb never works for me, I have to use, INNODB=OFF

hostnoob

mv /etc/mysql/my.cnf /etc/mysql/my.cnf.bk && cp /usr/share/doc/mysql-server-5.5/examples/my-small.cnf /etc/mysql/my.cnf

4n0nx

i just apt-get install nginx php5-fpm php5-mysql mysql-server

60MB RAM usage with wordpress and the VPS also runs postfix and dovecot

bsdguy

Honestly? Kick out MySql and go for SQLite.

ATHK

@bsdguy said:
Honestly? Kick out MySql and go for SQLite.

Why? SQLite causes my I/O right?

bsdguy

Running on a 128MB VPS it seems reasonable to assume that we're not talking about any major numbers here (large DB, etc). MySql is a relatively heavy solution and you seem to simply not need that. Accordingly I suggest to go a much lighter way with SQLite.

Keith

Do not upgrade to mysql 5.6 when it becomes available, innodb cannot be disabled in 5.6.

Maller

You can disable innodb in mysql 5.6. You just need to specify another storage engine. Etc myisam or aria

Keith

@Maller It's 5.7 not 5.6, disabling innodb is on the way out. http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-21.html

However disabling innodb on 5.6 doesn't work if some of the system tables are innodb, actually using Percona 5.6.

sandoz

is sqlite compatible with mysql? I have several WP running, and i don't want to convert them to sqlite

jcaleb

how about the original lea mysql config_

bsdguy

@sandoz said:
is sqlite compatible with mysql? I have several WP running, and i don't want to convert them to sqlite

Depends on what you mean by "compatible". No, SQLite is not a 1:1 replacement in the sense of just changing the library and using the same (existing) database files. But yes, it's compatible in that it is about as ANSI compliant as MySql and should be able to provide the same service (on the same machine. Not remotely).

All in all - and I say that friendly, not cynical - if you have to ask such questions, you'd probably be well advised to just stay with what you have.

sandoz

anyone can share their my.cnf for lowend usage?

Abdussamad

ATHK said:

skip-innodb never works for me, I have to use, INNODB=OFF

Yes innodb off and set the default engine:

default-storage-engine=myisam

mustafaramadhan

@sandoz,

Did you tried my suggestion?.