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 Anyway,Stepped on a lot of holes。
From now on,To record
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:
Performance Schema
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。
Reference
Starting MySQL On Low Memory Virtual Machines
MySQL memory usage too high Analysis
Original article written by LogStudio: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?