Skip to main content

MySQL is running out of memory in DigitalOcean

Hey, after update from MySQL 5.5 to 5.6, my life is getting worse. There are many 'Database connection error' when I try to open my website. And I even can not access to phpMyAdmin. What's happening.
OK, I turn on the SSH, connect to my server and BOOM, mysql is having 'Out of Memory' error, and everything crash.
That time, I need to restart mySQL:
$> sudo service mysql start

Next, I need to find out how much memory is being used, because Digital Ocean does not support this feature.
$> sudo apt-get install htop
$> htop
Now there is my memory usage:

Wow, mysqld service is consuming 48.9% memory, what!!!

There are 2 things I can do: Upgrade RAM (means upgrade Dropplet) or continue to check for another solution, my VPS is 1GB RAM.

Next, I check the log of mysql at /var/log/mysql: 
There are alot of errors:



There are some problems that we can find out:
+ InnoDB can not allocate memory 
+ InnoDB memory heap is disabled

Let's check the swap by this command:
$> free -m 


Swap = 0 means there is no swap setup. 

---> I need to setup the swap File by following steps:

https://www.digitalocean.com/community/tutorials/how-to-add-swap-on-ubuntu-14-04

There might be some errors when you try command in above pages, like:
sysctl: cannot stat /proc/sys/50: No such file or directory

What you need to do is to:
+  move to the /proc/sys/vm folder: $> cd /proc/sys/vm
Then type again

Now my system start using swap file and no out of memory error. However I always recommend you to upgrade RAM if possible because using swap file will degrade your performance.


Labels:

Comments

Post a Comment

Popular posts from this blog

Install Ruby on Rails on MAC

Hello, I am quite familliar with Apache's friend products like XAMPP, LAMPP... And this is the first time I try Ruby on Rails(RoR). I'm quite stuck on installing it. As a normal PHP guy, I first try install Rails, following this tutorial: http://installrails.com/ And the next thing I want to learn about is how RoR works with MySQL, PhpMyadmin. So I tried to make it connect to XAMPP's MySQL but it did not work at all. I found out that, using mySQL in XAMPP package is not a common method, what I should do is to install MySQL as a single service onto my MAC. So I did following: 1. Install MYSQL with HomeBrew Did you install HomeBrew, if not, please follow:  https://coolestguidesontheplanet.com/installing-homebrew-on-os-x-el-capitan-10-11-package-manager-for-unix-apps/ Next, type this command to install MySQL to your machine: $ brew install mysql This will install mysql to your computer, if the installation is success, you could try start using mySQL with this c...
1 comment
Read more

Install MySQL for python on Mac OS 10.9 with XAMPP

Assume that you already have Python installed. 1. Install XAMPP for MAC http://sourceforge.net/projects/xampp/files/ As it is a dmg file, it should be easy to be installed. 2. Now you need to install MySQLdb package for Python a. Download the lastest module of MySQLdb here : http://sourceforge.net/projects/mysql-python/files/latest/download b. Extract it to your prefered location. Notice: You might need to change site.cfg according to your mysql_config path. See the next step c. Setup your path Because you need to setup /bin and /lib folder of XAMPP's MySQL. So, let prepare your $PATH variable. > Edit your ~/.bash_profile ( or ~/.profile) by adding the following lines:  export DYLD_LIBRARY_PATH=/Applications/XAMPP/xamppfiles/lib export PATH=/Applications/XAMPP/xamppfiles/bin/:$PATH Notice: if you are not using XAMPP, you should edit above PATH by your mysql equivalent path. for example /usr/local/mysql/lib and /usr/local/mysql/bin Notice: About site.cfg(in y...
1 comment
Read more

Server-side HTML vs. JS Widgets vs. Single-Page Web Apps

When I was deciding which architecture could fit our start up service, I found that API-centric architecture is very efficient. However, it has disadvantages as well, so, finally I can find what should I depend on to choose. Here is the content of pamela fox's blog  At the recent  GOTO Chicago conference , I gave a talk on  "Frontend Architectures: from the prehistoric to the Post-modern."  In just my first 10 months at Coursera, I've experienced the joys and woes of many different frontend architectures, and I wanted to share what I learnt. I detail everything in  the slides , but I'll summarize my thoughts here as well. How do you pick an architecture? We could make our decision by just checking Twitter and seeing what all the cool kids are talking about, but uh, let's pretend that we're more scientific about it than that, and figure out whats important to us as web developers. To start off with, here are a few things that users care a ...
Post a Comment
Read more