MySQL kills long queries
mysql --login-path=root -e "SELECT CONCAT('kill ', ID, ';') FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'goyuninfo' AND TIME > 50 AND COMMAND = 'Query';" > kill_query.log
MongoDB stores documents in collections
Collections are analogous to tables in relational databases. If a collection does not exist, MongoDB creates the collection when you first store data for that collection.
Comments
Post a Comment