SW Engineering/DB-MySQL 썸네일형 리스트형 Slow Query Test Version 5.1.6 and above: 1. Enter the MySQL shell and run the following command:set global slow_query_log = 'ON'; 2. Enable any other desired options. Here are some common examples: Log details for queries expected to retrieve all rows instead of using an index: set global log_queries_not_using_indexes = 'ON' Set the path to the slow query log: set global slow_query_log_file ='/var/log/mysql/slo.. 더보기 기본 쿼리 정보 ( 필요시 추가 ) version 확인 select version(); 더보기 Stored Procedure의 Definer 변경하기 1. 기존 Procedure 확인하기 show procedure status; 2. difiner 변경하기 update mysql.proc set definer='username@%' where db = 'dbname'; 더보기 이전 1 다음