Pocketed a while ago on migrating from virtual host to an independent VPS，Maintenance of this all is my own。For performance，If your environment，Nature does not use the old configuration。
I use Ubuntu Server 16.04 + PHP 7.0 + Nginx + MySQL 5.7 In short，Stepped on a lot of holes。
Why MySQL is suddenly filling up memory
At first I thought it was a VPS under attack，But viewing card flow is not the only thing。First crash，I thought it was a configuration error，Added a bunch of cache，Reduced memory configuration, and so on。But not for long，Died again。
But why not to panic，This is a mystery。
In the repair table、Optimize MySQL configuration after a series of futile，Finally locate the problem：
This is in the 5.6 Version began a feature enabled by default，It will quietly 400M memory MySQL started to speed up MySQL Enterprise Server running--for nearly，May be nothing，But for us this cock wire small VPS (my 1GB independent memory is not bad)，Top day!
So，This is probably why my server crashed twice in a row recently。
To close the Performance Schema ，In your MySQL configuration file [mysqld] Field added in a sentence performance_schema = off
Such，My database is stable at around 300M。
Starting MySQL On Low Memory Virtual Machines
MySQL memory usage too high Analysis
Original article written by Gerber drop-off：R0uter's Blog » Solving MySQL suddenly occupy all memory problems
Reproduced Please keep the source and description link：https://www.logcg.com/archives/1757.html
My vest when compiling MySQL 5.7.13，Memory has exploded! Need to swap!
Have to swap
capricious i didn't?