Active User's Tech blog by Long Nguyen

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 ...