앨리스래빗팀 기술블로그

[MYSQL] 인덱스 활용

개별변경ALTER TABLE PROJECT ADD INDEX idx_is_deleted (is_deleted);일괄변경SELECT CONCAT('ALTER TABLE ', TABLE_NAME, ' ADD INDEX idx_is_deleted (is_deleted);') FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = 'is_deleted' 검사SHOW INDEX FROM PROJECT;EXPLAIN SELECT * FROM PROJECT WHERE is_deleted = 0;

보호되어 있는 글입니다.

보호되어 있는 글입니다.

보호되어 있는 글입니다.

현재 트랜잭션 항목 확인SELECT * FROM information_schema.innodb_trx; 해당 트랜잭션 클로즈KILL

SELECT VERSION();MYSQL의 경우 예시8.0.34MariaDB의 경우 예시10.5.12-MariaDB

VALUES CURRENT SCHEMA;VARCHAR      -> 32,627LONG VARCHAR -> 16,320INTEGER      -> 10

웹팩 오류가 지속적으로 발생할 경우/Unode_modules/webpack-sources/lib/SizeOnlySource.js:16 return new Error( ^Error: Content and Map of this Source is not available (only size() is supported)https://github.com/webpack/webpack/issues/14840 Crash with `Error: Content and Map of this Source is not available (only size() is supported)` · Issue #14840 · webpack/webpacBug report I..

변경SET SCHEMA '스키마 라이브러리명'; 확인VALUES CURRENT SCHEMA;

Gmail 확인되지 않은 이미지 관련 정책https://stackoverflow.com/questions/51471607/email-thumbnail-url-changed-to-googleusercontent-com-in-gmail Email thumbnail URL changed to googleusercontent.com in gmailI have a system whenever user upload an image, it will send an email to the registered user's gmail. But in the email, i see something like this, the thumbnail is not viewable. I inspect on the el...stackove..