문제를 잘 정의하는 것은 문제를 절반 해결한 것이다. - 2023.12 wiki:database:mariadb
http://rwiki.repia.com/
2026-04-17T12:33:10+00:00문제를 잘 정의하는 것은 문제를 절반 해결한 것이다. - 2023.12
http://rwiki.repia.com/
http://rwiki.repia.com/lib/tpl/mindthedark/images/favicon.icotext/html2023-01-13T18:44:10+00:00Anonymous (anonymous@undisclosed.example.com)wiki:database:mariadb:logging_my_cnf
http://rwiki.repia.com/doku.php?id=wiki:database:mariadb:logging_my_cnf&rev=1673603050&do=diff
SVN
* description : mariaDB log 파일 설정 관련 내용
* author : 도봉산핵주먹
* email : hylee@repia.com
* lastupdate : 2020-05-21
mariaDB
/etc/my.cnf 파일을 수정해야한다.
[mysqld]
# error log 위치
log-error=/data/search/REKMS/logs/db/error.log
log_warnings = 0
# log_error_verbosity = 1
# 1(errors only), 2(errors, warnings), 3(errors, warning, notes)
# general log 설정 및 위치
general_log=1
general_log_file=/data/search/REKMS/logs/db/mysql_history.log
# slow, long query 설정
slow-query-log = 1 …text/html2023-01-13T18:44:10+00:00Anonymous (anonymous@undisclosed.example.com)wiki:database:mariadb:mysql_note
http://rwiki.repia.com/doku.php?id=wiki:database:mariadb:mysql_note&rev=1673603050&do=diff
MySQL Note
* INSERT...SELECT Statementtext/html2023-01-13T18:44:10+00:00Anonymous (anonymous@undisclosed.example.com)wiki:database:mariadb:troubleshooting
http://rwiki.repia.com/doku.php?id=wiki:database:mariadb:troubleshooting&rev=1673603050&do=diff
Trouble Shooting
TimeZone error
JAVA에서 MySQL 혹은 MariaDB 서버에 연결시 다음과 같은 에러가 발생 할 수 있다.
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException:
Failed to obtain JDBC Connection; nested exception is java.sql.SQLException:
Cannot create PoolableConnectionFactory (The server time zone value xxxxx is unrecognized or represents more than one time zone.
You must configure either the server or JDBC driver (via the serverTimezone configuration property)
to use a more specifc …