How to disable unused table types

[theScien]

I only use MyISAM for all my web applications, and that should suffice for years to come, so I'm wondering how to disable all other data types from the server, so it starts as only capable of dealing with MyISAM tables.

What other benefits there are in doing so, apart from perhaps a greater memory saving?

Sometime ago I thought of using/experiment with InnoDB type but it's initial 10MB footprint and all the changes in the existing code to make it transactional are too much perhaps. I also read somewhere InnoDB requires alot more memory than MyISAM, server only has 1GB.

 

[TonyGroves]

Open your my.cnf (or my.ini) file, and in the [mysqld] section, put the line "skip-innodb" (without quotes). You might as well also add "skip-bdb".

 

[theScien]

Thanks will do that, any more skips for the other types?

Do you think I will save that much memory when this types don't get loaded?

 

[TonyGroves]

All the options are described in the manual.

I've no idea how much memory you will save; you could check the memory usage before and after the change.

 

[theScien]

skip-innodb" is not even documented in the manual, let alone the other disabling commands, anyway, I will disable just this 2, that should do it for me, someone was also saying that by disabling innodb alone we get a small boost out of the server.

If I find the other commands I'll post them here to complete this thread and for future reference.

Yeah, I also thought about doing the memory comparason before/after as you said.

Thanks, that will do me for now.

 

[johnwm]

The 'Skip-innodb' was introduced in around mySQL 3.23 ...
just a moment while I look it up for you....
Ah Yes!:

http://dev.mysql.com/doc/refman/4.1/en/news-3-23-34.html

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller

 

[theScien]

Thanks, is it "skip-innodb" or "--skip-innodb" the command that goes in my.ini?

 

[TonyGroves]

skip-innodb" goes into my.cnf/my.ini . Alternatively, you can use "--skip-innodb" as an argument to the command that starts the server.