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
- Sun acquires MySQL
- Slow Query Log Analyzes Tools
- 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
- reduce mysql memory usage
- low memory mysql
- mysql memory limit
- mysql memory configuration
- optimize mysql low memory
- mysql limit memory
- optimize mysql memory
- mysql reduce memory usage
- my cnf low memory
- optimize mysql memory usage
- mysql limit memory usage
- limit mysql memory usage
- mysql low ram
- mysql low memory configuration
- ubuntu mysql memory
- mysql reduce memory
- reduce mysql memory
- mysql memory footprint
- debian mysql memory
- optimize mysql for low memory
- mysql lower memory usage
- lower mysql memory usage
- mysql low memory config
- optimizing mysql memory
- mysql lower memory
- limit mysql memory
- mysql optimize memory
- ubuntu mysql memory usage
- mysql memory usage
- lower mysql ram usage
- optimize mysql RAM
- mysql save memory
- mysql memory
- mysql low mem
- how to reduce MySQL Memory usage
- optimizing mysql memory usage
- mysql optimize memory usage
- reduce memory mysql
- reduce memory usage mysql
- mysql optimize for low memory
- lowering mysql memory usage
- optimize debian server
- low ram mysql
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 [...]