투덜이 개발자

mysql 로그 추적 MariaDB [(none)]> MariaDB [(none)]> show variables where Variable_name in ('version','log','general_log'); +---------------+-----------------+ | Variable_name | Value | +---------------+-----------------+ | general_log | OFF | | version | 10.1.43-MariaDB | +---------------+-----------------+ 2 rows in set (0.00 sec) MariaDB [(none)]> show variables like 'general%'; +-----------------..

sudo make sudo make install [postgres@gmedia postgresql-13.2]$ mkdir -p /home/postgres/pgsql/data [postgres@gmedia postgresql-13.2]$ /home/postgres/pgsql/bin/initdb -E utf-8 -D /home/postgres/pgsql/data The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with locale "en_US.UTF-8". The d..

mysqldump Unknown table 'COLUMN_STATISTICS' in information_schema (1109) 와 같은 에러 발생하여 --column-statistics=0 추가함 mysqldump --column-statistics=0 --host= --user= --password=

[Mysql] 테이블 용량 확인 SELECT concat(table_schema,'.',table_name), convert(concat(round(data_length/(1024*1024*1024),2),'G'), char) DATA, convert(concat(round(index_length/(1024*1024*1024),2),'G'), char) idx, convert(concat(round((data_length+index_length)/(1024*1024*1024),2),'G'), char) as total_size, round(index_length/data_length,2) idxfrac FROM information_schema.TABLES WHERE TABLE_SCHEMA = '데이터베..

vi /etc/mysql/mariadb.conf.d/50-server.cnf --> 설정파일 #bind-address = 127.0.0.1 -- > 주석처리 mysql 재시작 $ service mysql restart $ netstat -antp | grep mysql --> 확인 방화벽 포트 허용 $ sudo ufw allow out 3306/tcp $ sudo ufw allow in 3306/tcp

ERROR 2006 (HY000) at line 1837: MySQL server has gone away 원인 max_allowed_packet 이 16MB (기본값)로 되어 있음 vi /etc/mysql/mariadb.conf.d/50-server.cnf max_allowed_packet = 1024M 로 수정 하고 mysql 재시작 $ service mysql restart --> MariaDB 재시작은 ubuntu 기준 확인 show variables like 'max_allowed_packet';