This mysql database is refined.

du -sh  /var/lib/mysql/db_shop
188K    /var/lib/mysql/db_shop

this database is very small, only 188k.
every time I install it,
mysql-u root-p
use db_shop
my system crashes,

Please see which mysqld% mem is 86%.
Why?
I pack the database, less than 10k, put it up and load it into your own system.

https://pan.baidu.com/s/1m3Pa.

is there a virus?

Nov.01,2021

excessive memory usage is normally related to the configuration of my.cnf configuration file. You can provide the version number of mysql, my.cnf configuration file, and the total memory of the system (top-c)


cat my.cnf | grep buffer

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1bf452d-3173d.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1bf452d-3173d.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?