Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Which SQL Query takes more time? (MYSQL)

Tags:

mysql

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?

like image 282
fawad Avatar asked Jun 06 '11 16:06

fawad

1 Answers

You can use the Mysql Slow Query Log.

like image 83
Cyril N. Avatar answered Oct 18 '22 02:10

Cyril N.
Sign in to Comment

Related questions

PHP better practice to build a multi language site
MySQL/PDO::quote(), Putting single quotes around integers
Query to check if field exists and then return the result set
How would you save a contenteditable div's content in a database with a PHP form?
How to get dates which are between last monday till current day?
versioning each field vs history date field?
MySQL on duplicate key on a non-unique field
Is it possible to have more than 5 read replicas in Amazon RDS?
MySQL structure for translations
Spring, Hibernate, MySQL - How Transactions work - Conclusion/Questions**
MySQL street address fuzzy search
NHibernate / MySQL string concatenation
How to efficiently determine changes between rows using SQL
Mysql where 1= 0 confusion
Shortest string within same path (branch)
Secure Remote mySQL Connection
MySQL unknown column error when using ALTER, don't understand behaviour
Authentication with old password no longer supported, use 4.1 style passwords
Laravel eager loading vs explicit join
Specifying the schema in Pandas to_sql

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!