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
- MDB Tools to export (migrate) from mdb (Microsoft Access format) to MySQL
- Howto: How to Reset the MySQL Root Password
- Monitor Configuration Files
- 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
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
- mysql memory limit
- optimize mysql memory
- optimize mysql low memory
- mysql reduce memory usage
- my cnf low memory
- reduce mysql memory
- optimize mysql memory usage
- mysql memory footprint
- mysql low ram
- mysql reduce memory
- optimize mysql for low memory
- ubuntu mysql memory
- mysql lower memory usage
- limit mysql memory usage
- mysql low memory configuration
- mysql low memory config
- mysql limit memory usage
- ubuntu mysql memory usage
- limit mysql memory
- mysql lower memory
- mysql optimize memory
- mysql memory usage
- debian mysql memory
- mysql low mem
- how to reduce MySQL Memory usage
- optimizing mysql memory usage
- optimize mysql RAM
- optimizing mysql memory
- lower mysql memory usage
- reduce memory usage mysql
- optimize debian server
- mysql optimize for low memory
- mysql save memory
- lowering mysql memory usage
- debian mysql ram
- mysql optimize memory usage
- mysql memory usage optimization
- mysql optimization memory
- mysql memory usage linux
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 [...]