MySQL – force not to use cache for testing speed of query

by

Try using the SQL_NO_CACHE (MySQL 5.7) option in your query.
(MySQL 5.6 users click HERE )

eg.

SELECT SQL_NO_CACHE * FROM TABLE

This will stop MySQL caching the results, however be aware that other OS and disk caches may also impact performance. These are harder to get around.

More Related Contents:

  1. INSERT INTO SELECT statement with more columns which is not in another table
  2. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  3. Why does MYSQL higher LIMIT offset slow the query down?
  4. How to split the name string in mysql?
  5. Normalization in MYSQL
  6. MySQL load NULL values from CSV data
  7. Is there a REAL performance difference between INT and VARCHAR primary keys?
  8. JOIN queries vs multiple queries
  9. Calculate difference between two datetimes in MySQL
  10. MySQL select statement with CASE or IF ELSEIF? Not sure how to get the result
  11. Is there a Profiler equivalent for MySql? [closed]
  12. Cast int to varchar
  13. LOAD DATA LOCAL INFILE gives the error The used command is not allowed with this MySQL version
  14. Import SQL file into mysql
  15. How to export data from SQL Server 2005 to MySQL [closed]
  16. MySQL SELECT last few days?
  17. “where 1=1” statement [duplicate]
  18. How do you debug MySQL stored procedures?
  19. Schrödingers MySQL table: exists, yet it does not
  20. MySQL Calculate Percentage
  21. ld: library not found for -lzstd while bundle install for mysql2 gem Ruby on macOS Big Sur 11.4 Apple M1
  22. mysql select sum group by date
  23. How to insert selected columns from a CSV file to a MySQL database using LOAD DATA INFILE
  24. My SQL Dynamic query execute and get ouput into a variable in stored procedure
  25. Postgres LEFT JOIN with WHERE condition
  26. MySQL – Using COUNT(*) in the WHERE clause
  27. MySQL Integer vs DateTime index
  28. Unserialize through query at database level itself
  29. Detecting utf8 broken characters in MySQL
  30. django cannot connect mysql in docker-compose

Leave a Comment