본문 바로가기
728x90

mysql10

ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction 오류가 발생하는 경우 아래 내용 확인 후 처리 1단계 : 현재 설정 확인 mysql> select @@innodb_lock_wait_timeout; +----------------------------+ | @@innodb_lock_wait_timeout | +----------------------------+ | 50 | +----------------------------+ 2단계: 적절하게 타임아웃 변경 mysql> SET innodb_lock_wait_timeout=2000; 3단계: 확인 mysql> select @@innodb_lock_wait_timeout;.. 2021. 9. 28.
pgsql join update sample pgsql join update sample postgresql join update sample update stock_day_chart set std_prc = b.std_prc , close_per = b.close_per , high_per = b.high_per, fvrt_yn = b.fvrt_yn from stock_day_chart_backup b where (stock_day_chart.stock_cd = b.stock_cd and stock_day_chart.stock_date = b.stock_date) and b.std_prc is not null 2021. 8. 12.
mysql join update sample mysql join update sample update stock_day_chart a inner join stock_day_chart_backup b on (a.stock_cd = b.stock_cd and a.stock_date = b.stock_date) set a.std_prc = b.std_prc , a.close_per = b.close_per , a.high_per = b.high_per, a.fvrt_yn = b.fvrt_yn where b.std_prc is not null 2021. 8. 12.
mysql 테이블의 현재 사용량을 조회하여 확인 mysql 테이블의 현재 사용량을 조회하여 확인 SELECT engine, count(*) AS table_count, concat(round(sum(table_rows)/1000000,2),'M') AS table_rows, concat(round(sum(data_length)/(1024*1024*1024),2),'G') AS total_data, concat(round(sum(index_length)/(1024*1024*1024),2),'G') AS total_index, concat(round(sum(data_length+index_length)/(1024*1024*1024),2),'G') AS total_size, round(sum(index_length)/sum(data_length),2) AS.. 2020. 6. 13.
728x90

티스토리툴바