An administrator believes that an attacker is overwhelming a database server by causing intensive queries to be run. Which log file should the administrator check first?

 

Last Updated on November 17, 2023 by InfraExam

An administrator believes that an attacker is overwhelming a database server by causing intensive queries to be run. Which log file should the administrator check first?

  • /var/log/mysql/mysql.log
  • /var/log/mysql/mysql_error.log
  • /var/log/mysql/mysql_warning.log
  • /var/log/mysql/mysql-slow.log
Explanation & Hint:

To check for intensive queries and performance-related issues on a MySQL database server, the administrator should check the /var/log/mysql/mysql-slow.log file. The mysql-slow.log contains records of slow queries, which can help identify and address performance problems caused by resource-intensive or inefficient queries running on the database server.

For more Questions and Answers:

Endpoints and Systems Post-Assessment | CBROPS

0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments