'DB/MYSQL' 카테고리의 글 목록 (2 Page)

DB/MYSQL 26

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;

DB/MYSQL HEON.D 2022.10.20

[ MYSQL ] RDS max connections

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

DB/MYSQL HEON.D 2022.08.05

[ MYSQL ] Safe Mode 해제

SET SQL_SAFE_UPDATES = 0;

DB/MYSQL HEON.D 2022.08.04

[ MYSQL ] 중복 검증 쿼리

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;

DB/MYSQL HEON.D 2022.06.14

[ MYSQL ] 날짜 증가 후 조회

(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/MYSQL HEON.D 2022.05.27

[ MYSQL ] DB 커넥션 정보 utf8mb4 이모지

DB CHARSET utf8mb4

DB/MYSQL HEON.D 2022.05.20

[ MYSQL ] AutoIncrement 값 초기화

ALTER TABLE NUTRIENT AUTO_INCREMENT = 원하는 숫자;

DB/MYSQL HEON.D 2022.01.13

[ MYSQL ] FULLTEXT Search

파라미터 변경 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('관리..

DB/MYSQL HEON.D 2022.01.12