Daniel0 Posted October 30, 2008 Share Posted October 30, 2008 Does anyone have an idea of how you can get InnoDB to stop using an excessive amount of memory? I experience a difference of 120 MB RAM usage from when it's disabled and when it isn't. That's quite a lot considering my VPS has 384 MB available (plus double burst though). Quote Link to comment https://forums.phpfreaks.com/topic/130721-innodb-memory-usage/ Share on other sites More sharing options...
fenway Posted October 30, 2008 Share Posted October 30, 2008 Well, the namespace has to be loaded somewhere to deal with ACID transactions..... Quote Link to comment https://forums.phpfreaks.com/topic/130721-innodb-memory-usage/#findComment-678542 Share on other sites More sharing options...
Daniel0 Posted October 30, 2008 Author Share Posted October 30, 2008 Maybe it's just because I don't know what happens behind the scenes, but I just don't understand how it can spend 120 MB RAM doing absolutely nothing. As of right now there aren't even any InnoDB tables on the server. It's just the difference between enabling its usage or not. Quote Link to comment https://forums.phpfreaks.com/topic/130721-innodb-memory-usage/#findComment-678551 Share on other sites More sharing options...
Mchl Posted October 30, 2008 Share Posted October 30, 2008 On my machine it takes just 14MB of RAM with InnoDB and some 3MB without. And there are some InnoDB tables here. I guess your 120MB might be due to some additional setings. Quote Link to comment https://forums.phpfreaks.com/topic/130721-innodb-memory-usage/#findComment-678564 Share on other sites More sharing options...
Daniel0 Posted October 30, 2008 Author Share Posted October 30, 2008 It's just the default Gentoo config file: http://daniel0.net/my.cnf  I don't understand why it uses so much memory. On my Vista laptop mysqld-nt.exe takes up about 1 MB RAM (InnoDB enabled). On my Gentoo VPS it uses 31 MB (InnoDB disabled). Quote Link to comment https://forums.phpfreaks.com/topic/130721-innodb-memory-usage/#findComment-678619 Share on other sites More sharing options...
corbin Posted November 1, 2008 Share Posted November 1, 2008 Does it slowly grow to 120MB, quickly grow to 120MB, or does it start at 120MB? Quote Link to comment https://forums.phpfreaks.com/topic/130721-innodb-memory-usage/#findComment-679754 Share on other sites More sharing options...
Daniel0 Posted November 1, 2008 Author Share Posted November 1, 2008 It starts like that. Quote Link to comment https://forums.phpfreaks.com/topic/130721-innodb-memory-usage/#findComment-679767 Share on other sites More sharing options...
corbin Posted November 1, 2008 Share Posted November 1, 2008 Wow I have no idea then.... Â Â Jesus be hatin' is all I can think of. Quote Link to comment https://forums.phpfreaks.com/topic/130721-innodb-memory-usage/#findComment-680199 Share on other sites More sharing options...
fenway Posted November 3, 2008 Share Posted November 3, 2008 Find that strange.... it should be taking up at least ~20MB regardless because of buffer sizes in the my.cnf file. Â Try running this script and see what you get. Quote Link to comment https://forums.phpfreaks.com/topic/130721-innodb-memory-usage/#findComment-681446 Share on other sites More sharing options...
Daniel0 Posted November 3, 2008 Author Share Posted November 3, 2008 Here is the output of that script: http://daniel0.net/mysql_profile.txt Quote Link to comment https://forums.phpfreaks.com/topic/130721-innodb-memory-usage/#findComment-681487 Share on other sites More sharing options...
corbin Posted November 4, 2008 Share Posted November 4, 2008 Is it possible that it could be getting slammed by enough queries to make the memory usage grow that much instantly? Quote Link to comment https://forums.phpfreaks.com/topic/130721-innodb-memory-usage/#findComment-681657 Share on other sites More sharing options...
fenway Posted November 4, 2008 Share Posted November 4, 2008 Is it possible that it could be getting slammed by enough queries to make the memory usage grow that much instantly? Possibly... your key buffer is 16M, so if you have 25 threads using it at the same time..... Â Here is the output of that script: http://daniel0.net/mysql_profile.txt Why does it appear as though InnoDB is "disabled"? Quote Link to comment https://forums.phpfreaks.com/topic/130721-innodb-memory-usage/#findComment-681748 Share on other sites More sharing options...
Daniel0 Posted November 4, 2008 Author Share Posted November 4, 2008 Here is the output of that script: http://daniel0.net/mysql_profile.txt Why does it appear as though InnoDB is "disabled"? Â Ooops, sorry. I've updated the file with InnoDB enabled. Â Is it possible that it could be getting slammed by enough queries to make the memory usage grow that much instantly? Â I don't think that's the case. The server isn't used that much and there aren't even any InnoDB tables on the server. Quote Link to comment https://forums.phpfreaks.com/topic/130721-innodb-memory-usage/#findComment-681767 Share on other sites More sharing options...
fenway Posted November 4, 2008 Share Posted November 4, 2008 Seems ok... how big are the tables? Clustered keys can get pretty large when loaded into memory. Quote Link to comment https://forums.phpfreaks.com/topic/130721-innodb-memory-usage/#findComment-682106 Share on other sites More sharing options...
Daniel0 Posted November 4, 2008 Author Share Posted November 4, 2008 One wordpress install taking up 590.7 KiB where all tables are MyISAM. There are no other databases except for the standard mysql ones. I.e., the database is very small and that's why I'm wondering what it's using all that RAM for. Quote Link to comment https://forums.phpfreaks.com/topic/130721-innodb-memory-usage/#findComment-682116 Share on other sites More sharing options...
fenway Posted November 4, 2008 Share Posted November 4, 2008 Hmmm... streange... which version? Quote Link to comment https://forums.phpfreaks.com/topic/130721-innodb-memory-usage/#findComment-682173 Share on other sites More sharing options...
Daniel0 Posted November 4, 2008 Author Share Posted November 4, 2008 The version is 5.0.60-log Quote Link to comment https://forums.phpfreaks.com/topic/130721-innodb-memory-usage/#findComment-682184 Share on other sites More sharing options...
fenway Posted November 5, 2008 Share Posted November 5, 2008 Hmmm... max_allowed_packet is really big. Quote Link to comment https://forums.phpfreaks.com/topic/130721-innodb-memory-usage/#findComment-682965 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.