×

Welcome to TagMyCode

Please login or create account to add a snippet.
 

Mysql Profiler

0
0
 
0
Language: SQL
Posted by: Roman Ignatov
Added: Nov 30, 2016 11:07 AM
Views: 2200
Tags: mysql sysadmin
  1. -- session example
  2. SET profiling=1;
  3. SELECT COUNT(*) FROM comment;
  4. SELECT COUNT(*) FROM message;
  5. SHOW profiles;
  6.  
  7. SHOW profile FOR query 1; -- from previous list
  8.  
  9. --  Кол-во запрсов можно увеличить с помощью параметра
  10. -- profiling_history_size, но не более чем до 100.
  11.  
  12. SET profiling=1;
  13. SET profiling_history_size=100;

Write a comment

To post comments, please log in or register.