Which SQL Query takes more time? (MYSQL)

Question

How to check which sql query is taking more time? (MYSQL) Im using a dedicated Linux server and the website is consuming 1 GB of RAM, the company says its because of SQL queries (MYSQL). Can anybody tell me how to check which sql queries is taking more time and utilizing more resources?

Answer 1

You can use the Mysql Slow Query Log.