본문 바로가기
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_.. 2021. 9. 28.
🥰 pgsql join update sample pgsql join update samplepostgresql join update sampleupdate stock_day_chartset std_prc = b.std_prc , close_per = b.close_per , high_per = b.high_per, fvrt_yn = b.fvrt_ynfrom stock_day_chart_backup bwhere (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 sampleupdate stock_day_chart ainner 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_ynwhere 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(i.. 2020. 6. 13.
728x90

티스토리툴바