DATA traveler

show create procedure 프로시저명\G

MySQL DB의 Replication을 활용하다 보면,MASTER에만 쿼리를 수행하고 싶을 때가 있다. 세션단위로 파라미터 조정만 해주면 간단히 할 수 있다. --해당 파라미터 확인mysql> SHOW VARIABLES LIKE 'sql_log_bin';+---------------+-------+| Variable_name | Value |+---------------+-------+| sql_log_bin | ON |+---------------+-------+ -- 옵션 끄기mysql> SET SESSION sql_log_bin=OFF; mysql> SHOW VARIABLES LIKE 'sql_log_bin';+---------------+-------+| Variable_name | Value ..

mysql> SHOW INDEX FROM dbname.tablename

mysql> SELECT r.trx_id waiting_trx_id, r.trx_mysql_thread_id waiting_thread, r.trx_query waiting_query, b.trx_id blocking_trx_id, b.trx_mysql_thread_id blocking_thread, b.trx_query blocking_query FROM information_schema.innodb_lock_waits w INNER JOIN information_schema.innodb_trx b ON b.trx_id = w.blocking_trx_id INNER JOIN information_schema.innodb_trx r ON r.trx_id = w.requesting_trx_id; waiti..