Database (103) 썸네일형 리스트형 [MariaDB] IP/Port 이용한 접속 및 DB생성 IP/Port를 이용한 접속 - mysql -h [IP] -p [Port] -u [유저] -p C:\DevCenter\MariaDB\mariadb-10.5.1-winx64\bin>mysql -h 172.16.2.6 -P 8087 -u root -p Enter password: ****** Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 46 Server version: 10.0.38-MariaDB-0ubuntu0.16.04.1 Ubuntu 16.04 Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' .. [HANA] 1977584 - Technical Consistency Checks for SAP HANA Databases - https://launchpad.support.sap.com/#/notes/1977584%20%E2%80%93%20Technical%20Consistency%20Checks%20for%20SAP%0A%09%09%09%09%09%09%09%09%09HANA%20Databases https://launchpad.support.sap.com/#/notes/1977584%20%E2%80%93%20Technical%20Consistency%20Checks%20for%20SAP%0A%09%09%09%09%09%09%09%09%09HANA%20Databases launchpad.support.sap.com Symptom You are interested in an pro-active SAP HANA consist.. [HANA] 2100009 - FAQ: SAP HANA Savepoints Symptom You face issues or have questions related to savepoints in SAP HANA environments. Environment SAP HANA Cause 1. What are savepoints in SAP HANA environments? 2. When is a savepoint triggered? 3. Where can I find more information related to savepoints? 4. Which indications exist for problems related to savepoints? 5. Are savepoints online operations? 6. How can typical savepoint issues be.. [HANA] 2180165 - FAQ: SAP HANA Expensive Statements Trace * 2180165 - FAQ: SAP HANA Expensive Statements Trace https://launchpad.support.sap.com/#/notes/2180165 https://launchpad.support.sap.com/#/notes/2180165 launchpad.support.sap.com 3. Criteria can be used to record a database request Indicator Validity Parameter Unit Details Runtime general global.ini -> [expensive_statement] -> threshold_duration us SQL statements exceeding the configured runtime.. [Postgresql] 외부에서 접속하기 1. 포트 확인 root@django:/home/ivan# netstat -ntlp | grep 5432 tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN 1481/postgres - DB에서 사용하는 포트 = 5432 - 127.0.0.1:5432 -> 내부에서만 사용 가능 2. Config 변경 - postgresql.conf 파일 변경 root@django:/etc/postgresql/10/main# ls -al postgresql.conf -rw-r--r-- 1 postgres postgres 23045 Nov 12 23:13 postgresql.conf root@django:/etc/postgresql/10/main# vi postgresql.conf #-----------.. [HANA] hdbsql options SAP HANA HDBSQL Options Set information for the database and for database objects by using SAP HANA HDBSQL commands. In addition to SAP HANA HDBSQL commands, you can also enter an SQL statement or a database procedure. The statement or procedure must be enclosed in quotation marks. Configuration Options Use the following options to modify the operation of SAP HANA HDBSQL commands. Database Sessi.. [HANA] Database trace설정 (savepoint) 설정 방법 HANA Studio -> Administator -> Trace Configuration -> Database Trace Component = savepoint 선택 Trace Level = 'INFO' -> 'DEBUG'로 변경하여 ON Savepoint Trace 예시 == Trace 미설정 상태 [620581]{-1}[-1/-1] 2019-07-12 08:49:07.030953 i Savepoint SavepointImpl.cpp(02995) : Savepoint current savepoint version: 11954, restart redo log position: 0xa90f2a482, next savepoint version: 11955, last snapshot SP vers.. [HANA] Memory GC Trigger 관련 파라미터 https://launchpad.support.sap.com/#/notes/2169283 Memory Garbage collection Auto Trigger 시점 관련 Parameter global.ini -> [memorymanager] -> async_free_target Default = 95 % Trigger 되면 할당된 메모리를 global allocation limit의 특정 비율(aync_free_target) 만큼 줄임 global.ini -> [memorymanager] -> async_free_threshold Default = 100 % global allocation limit의 특정 비율(async_free_threshold) 만큼 도달하면 proactive Memory GC가 .. 이전 1 ··· 4 5 6 7 8 9 10 ··· 13 다음