Optimize MySQL for Low Memory Use
MySQL is a light database engine compared to many of it’s rivals, but for some reason the Debian MySQL-server package contains a setup that makes it very heavy and memory consuming. The Debian version of becomes memory consuming because it comes with config file where MySQL’s most memory consuming and seldom used storage engine InnoDB is enable. As result of this the MySQL server instance uses around 100MB of memory while almost idle.
And here comes the optimization tip.
Since the InnoDB storage engine is used very seldom it can be disable in most cases and let the server save almost about 100MB of memory.
To disable to InnoDB storage engine add this to my.cnf (the default MySQL configuration files) in /etc/mysql/
skip-innodb
More on MySQL and Apache optimization and here
Related posts:
- MySQL Optimization and Performance Tips
- Optimize MySQL Performance With MySQLTuner
- Howto: How to Reset the MySQL Root Password
- MDB Tools to export (migrate) from mdb (Microsoft Access format) to MySQL
- Slow Query Log Analyzes Tools
- Sun acquires MySQL
- WSJ: Sun to Use Flash Memory in Servers
- WSJ: Sun to Use Flash Memory in Servers
- MySQL Performance Monitoring and Optimization Tools
- Compressing mysqldump output – mysql, gzip, bzip2 and LZMA (7z)
Popular Related Items »
Incoming search terms
- mysql low memory
- mysql memory optimization
- low memory mysql
- reduce mysql memory usage
- mysql memory configuration
- mysql limit memory
- optimize mysql memory
- optimize mysql low memory
- mysql memory limit
- mysql reduce memory usage
- my cnf low memory
- reduce mysql memory
- mysql memory footprint
- optimize mysql memory usage
- mysql reduce memory
- mysql low ram
- ubuntu mysql memory
- optimize mysql for low memory
- mysql low memory configuration
- limit mysql memory usage
- mysql lower memory usage
- ubuntu mysql memory usage
- mysql optimize memory
- limit mysql memory
- mysql lower memory
- mysql limit memory usage
- mysql low memory config
- mysql low mem
- how to reduce MySQL Memory usage
- optimize mysql RAM
- mysql memory usage
- lower mysql memory usage
- optimizing mysql memory usage
- optimizing mysql memory
- debian mysql memory
- optimize debian server
- mysql memory usage optimization
- mysql optimize for low memory
- lowering mysql memory usage
- mysql memory usage linux
- debian mysql ram
- mysql save memory
- mysql optimization memory
- debian mysql save memory
- mysql config low memory
Michael said,
March 22, 2007 @ 20:40
Hello,
Thank you for a great tip
Michael said,
March 22, 2007 @ 21:13
It really works and saves a lot of my database server’s memory
Freddy Andersen said,
June 15, 2008 @ 7:23
“Since the InnoDB storage engine is used very seldom it can be disable in most cases and let the server save almost about 100MB of memory.”
I have NO! idea where you got that piece of information from?? What other enterprise/production ready storage engine would you use? MyISAM? I can see someone would want to disable Innodb if they have a very low memory footprint and that would be a good solution… but very seldom used engine!?!?
MyIsam, Innodb, Falcon, Memory and cluster(ndb) is the most used and Innodb is currently at the top of the list of most used engines.
Tuning MySQL for low memory: disable InnoDB « Cursing and Recursing said,
January 15, 2009 @ 22:09
[...] to .bootstrap for the [...]
????????MySQL | small finds said,
June 20, 2009 @ 22:46
[...] Optimize Mysql for Low Memory Use [...]