장기기억장치

-- 진수 변환을 위한 핵심 함수 create or replace function to_base(p_dec in number, p_base in number) return varchar2 is l_str varchar2(255) default NULL; l_num number default p_dec; l_hex varchar2(16) default '0123456789ABCDEF'; begin if ( trunc(p_dec) p_dec OR p_dec

# Linux version : 5.15.0-3.60.5.1.el9uek.aarch64# mysql version : 9.1.0-commercial  # 10.0.2.10 cluster1# 10.0.2.20 cluster2# 10.0.2.30 cluster3# cluster1,cluster2,cluster3에 mysql이 설치 및 실행되어있다고 가정하고 진행[root@localhost ~]# vi /etc/hosts10.0.2.10 cluster110.0.2.20 cluster210.0.2.30 cluster3[root@localhost ~]# mysql -ivh mysql-router-commercial-9.1.0-1.1.el9.aarch64.rpm mysql-shell-commercial-9.1.0-..

-- 현재 performance_schema 저장?call sys.ps_setup_save(10);-- do before query profilingupdate performance_schema.setup_instrumentsset enabled = 'YES', timed = 'YES'where name like '%statement/%' or name like '%stage/%';--where name like 'stage/innodb/alter%'; /* when you want to profiling alter */update performance_schema.setup_consumersset enabled = 'YES'where name like '%events_statements_%' or n..

// 인자로 주어진 쿼리 다이제스트에 대해 Performance 스키마에서 수집된 정보의 통계 데이터를 얻고 싶은 쿼리 다이제스트 값을 입력한다.sys.ps_trace_statement_digest MySQL :: MySQL 8.4 Reference Manual :: 30.4.4.22 The ps_trace_statement_digest() Procedure30.4.4.22 The ps_trace_statement_digest() Procedure Traces all Performance Schema instrumentation for a specific statement digest. If you find a statement of interest within the Performance Schema ..

/*set pagesize 0;select * from print_table('select * from test.emp where rownum 0 ) loop for i in 1 .. l_colCnt loop if ( l_descTbl(i).col_type not in ( 113 ) ) then dbms_sql.column_value ( l_theCursor, i, l_columnValue ); pipe row( printTblScalar( l_descTbl(i).col_name, ..