앨리스래빗팀 기술블로그

show create table [ 테이블명 ];

https://stackoverflow.com/questions/4932503/how-to-kill-mysql-connections How to kill MySQL connections I'm building a website with MySQL. I'm using TOAD for MySQL and suddenly I can't connect to the database as I'm getting an error: "Too many connections" Is there any way in Toad for MySQL to v... stackoverflow.com SHOW PROCESSLIST; KILL 192;

show variables like 'max_connections'; t2.micro: 66 t2.small: 150 m3.medium: 296 t2.medium: 312 M3.large: 609 t2.large: 648 M4.large: 648 M3.xlarge: 1237 R3.large: 1258 M4.xlarge: 1320 M2.xlarge: 1412 M3.2xlarge: 2492 R3.xlarge: 2540

SET SQL_SAFE_UPDATES = 0;

SELECT user_id, count(user_id) AS total, count(distinct device_token) AS token, IF( count(user_id) != count(distinct device_token), '불일치', '일치') AS duplicated FROM USER_DEVICE AS UD GROUP BY user_id ORDER BY total DESC;

(date_sub('$date', interval '12' month) 12달 (date_sub('$date', interval '1' day) 하루 Today WHERE t_date=CURDATE(); Tomarrow WHERE t_date=CURDATE() + INTERVAL 1 DAY; Yesterday WHERE t_date=CURDATE() - INTERVAL 1 DAY;

DB CHARSET utf8mb4

ALTER TABLE NUTRIENT AUTO_INCREMENT = 원하는 숫자;

파라미터 변경 ngram_token = 2 innodb_ft_min_token_size = 2 ft_min_word_len = 2 적용확인 show variables like 'ft_min%'; show variables like 'innodb_ft_min%'; 검색 인덱스 추가 ALTER TABLE MANUAL ADD FULLTEXT(칼럼명); 조회 쿼리 SELECT 칼럼, MATCH (칼럼) AGAINST ('키워드*' IN BOOLEAN MODE) AS score FROM 테이블 ORDER BY score desc; SELECT manual_title, ( ((LENGTH(manual_title) - LENGTH((REPLACE(manual_title, '관리', '')))) / LENGTH('관리..

1. 파라미터 그룹 복제 ( 기본 파라미터 그룹은 수정이 불가하다 ) 2. time_zone 파라미터 항목 수정 3. 인스턴스 재부팅 ( 재부팅 전에는 새로운 파라미터 그룹이 적용되지 않는다 )