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). 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..... 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. 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. 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). 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? 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. 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. 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. 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 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? 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"? 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. 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. 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. 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? 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 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. Link to comment https://forums.phpfreaks.com/topic/130721-innodb-memory-usage/#findComment-682965 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.