Topic on Project:Support desk

Hi there, I noticed my media wiki is absorbing a lot of memory especially mysqld.bin.I am not sure why. I have 2gb ram and 1 cpu allocated to the VM for my mediawiki. At the same time, the nodejs has 4 workers. I am not sure why either. the only thing using the nodejs i though would be the parser.

The installed software i am using are: MediaWiki 1.25.1 PHP 5.5.25 (fpm-fcgi) MySQL 5.6.23

The only extensions i have are: Admin Links category Tree launchExternal ParserFunctions DiscussionThreading Universal LanguageSelector VisualEditor WikiEditor

I have a snapshot of the top: http://ctrlv.in/609700

Hope to hear from someone.

mysqld is the Mysql database server, not MediaWiki (MediaWiki is handled by php and your webserver). You may need to configure mysql server properly according to your available memory.

Note that databse servers usually need to consume more memory to buffer query results and data that's accessed more frequently, so retrieving that data doesn't require to fetch it from the disk (which would be slow). Reducing the available memory for the database may make database access slower.

I guess what configuration should I setup for mysql? Or how can I limit it to 1gb? Rather than dynamically expanding?

You should probably document yourself about those settings, but there's http://www.mysqlcalculator.com/ (not sure how accurate is it).