본문 바로가기

전체 글

 (198)
[HANA] Trouble shooting - Version GC Issue GC Blocker 찾기 GC를 blocking하고 있는 Statement와 connection을 찾아야 함 Statement Library MVCC Blocker Connection MVCC Blocker Statement MVCC Blocker Transaction Connection ID, Statement 확인 필요 (Example) MVCC Blocker Statemen Type = GLOBAL - Global version garbage collection blocker = TABLE - The specific table의 garbage collecton blocker TABLE의 GC blocker에 의한 Timestamp가 Global timestamp보다 낮음 수행 후 바로 TABLE t..
[HANA] Trouble shooting - MVCC Issue MVCC Problem Identification Transactions blocking garbage collection은 다음으로부터 발생 가능 Long-running or unclosed cursor Long-running trancation with isolation mode 'serializable' or 'repeatable read' Hanging threads MVCC 관련 문제가 있는지 확인 위해 active version 수를 확인 해야 함 select * from m_mvcc_tables where name in ('NUM_VERSIONS','MAX_VERSIONS_PER_RECORD','TABLE_ID_OF_MAX_NUM_VERSIONS'); -> NUM_VERSIONS and MA..
[Linux] sar 사용예 1. CPU 사용률 (오늘) sar [root@zetawiki ~]# sar Linux 2.6.32.59-0.7-xen (jmnote) 10/24/12 _x86_64_ 00:00:01 CPU %user %nice %system %iowait %steal %idle 00:10:01 all 20.63 0.00 11.65 2.17 0.08 65.46 00:20:01 all 9.32 0.00 4.34 1.99 0.05 84.30 00:30:01 all 11.32 0.00 6.61 1.17 0.13 80.77 ... (생략) Average: all 10.28 0.00 6.03 2.03 0.12 81.53 → 00시부터 현재까지 10분마다 CPU 사용률 측정한 기록을 보여준다.[1] 2. CPU 사용률 (날짜별) ..
[HANA] Workload Management (internal) 보호되어 있는 글입니다.
[HANA] HANA DB Trace Trace Structure Trace entries ([_] 공백으로 구분) []{}[/] :
[Python] File I/O Printing to the Screen The simplest way to produce output is using the print statement where you can pass zero or more expressions separated by commas. This function converts the expressions you pass into a string and writes the result to standard output as follows Reading Keyboard Input Python provides two built-in functions to read a line of text from standard input, which by default comes fro..
[HANA] 유용한 Python 프로그램 http://sapbasisinfo.com/blog/2018/03/12/useful-python-scripts-for-hana/ All python scripts can be found in exe/python_support directory. These scripts can affect the system therefore it’s better to check with ‘-help’ switch before executing the scripts. systemOverview.py You can get system information with this script like Instance, Services, Memory, Disk, Memory etc. python systemOverview.py Ex..
[HANA] HANA DB Startup DB Startup overview HDB daemon startup overview Runlevel 1-2 Runlevel 3-5 Indexserver Startup Overview Core/CPU Information Collection Persistency Initialization Row Store Log Replay DTX (Distributed Transaction) Consistency Check / How it work? DTX Consistency Check : 분산 트랜잭션을 위한 트랜잭션의 정합성 체크 Terminology LSN (Log Sequence Number) Log 위치를 가리킴 DTX Consistency에서 LSN은 Log Position 대신 사용 Master & Sl..

티스토리툴바