sch Document
01779
검색 초기화
GitHub
sch Document
GitHub
sch Document
Ai
Ai
Index
Prompt
Prompt
각종 프롬프트 모음
Aws
Aws
AWS
Amplify
Amplify
Amplify
Athena
Athena
Athena
Cdk
Cdk
CDK
Example
Example
Example (JavaScript, TypeScript)
Cli
Cli
CLI
Cloudformation
Cloudformation
CloudFormation
Dms
Dms
DMS
Oracle
Oracle
Oracle DMS
Postgresql
Postgresql
PostgreSQL DMS
Elb
Elb
ELB
Glue
Glue
Glue
Iam
Iam
IAM
Rds
Rds
RDS
Aurora
Aurora
Aurora
Info
Info
Aurora 구성 및 특징
Mysql
Mysql
RDS MySQL
Create instance
Create instance
인스턴스 생성 방법
Log
Log
Log
Optimized writes
Optimized writes
Optimized Writes
Oracle
Oracle
RDS Oracle
Administering
Administering
RDS에서의 권한 관리
Create instance
Create instance
인스턴스 생성 방법
Datapump
Datapump
Datapump
Memory swap
Memory swap
Memory, Swap 문제
Quotas
Quotas
RDS Oracle의 자원 할당량
S3
S3
S3 관련 명령어
S3 INTEGRATION
Spatial
Spatial
Spatial
Temporary tablespace
Temporary tablespace
Temporary Tablespace
Timezone
Timezone
Timezone
Postgresql
Postgresql
RDS PostgreSQL
S3
S3
S3
Snapshot
Snapshot
Snapshot
Ssm
Ssm
Session Manager
Csharp
Csharp
C#
Array
Array
Array
Datatable
Datatable
DataTable
Datetime
Datetime
DateTime
Directory
Directory
Directory
Fileinfo
Fileinfo
FileInfo
Standard numeric format string
Standard numeric format string
Standard Numeric Format String
Stringreader
Stringreader
StringReader
Etc
Etc
etc
Btree
Btree
B Tree
Char varchar
Char varchar
CHAR와 VARCHAR의 차이
Cidr
Cidr
CIDR (Classless Inter-Domain Routing)
Cpu scheduling
Cpu scheduling
CPU Scheduling
Eol
Eol
End of Line
Hash
Hash
Hash
Ip class
Ip class
IP Class
Isolation level
Isolation level
Isolation Level (격리 수준)
Keepalive
Keepalive
Keepalive
Nkf
Nkf
nkf Network Kanji Filter (Shift JIS의 특수문자 처리)
Ora2pg
Ora2pg
ora2pg
Regular expression
Regular expression
Regular Expression
Rest api
Rest api
REST API
Snapshot
Snapshot
Snapshot
Tcp flag
Tcp flag
TCP Flag
Etcd
Etcd
ETCD
Excel
Excel
Excel
Flutter
Flutter
Flutter
Git
Git
git
gitmessage.txt
Haproxy
Haproxy
HAProxy
Js
Js
JavaScript
Linux
Linux
Linux
Centos base.repo
Centos base.repo
CentOS-Base.repo
Hugepage
Hugepage
HugePage
Inode
Inode
inode
Thp
Thp
Transparent HugePages
Mysql
Mysql
MySQL
Error
Parameter
Analyze
Analyze
Analyze
Cast
Cast
Cast
Cluster
Cluster
Cluster
Innodb
Innodb
InnoDB Cluster
Ndb
Ndb
NDB Cluster
Constraint
Constraint
Constraint
Data format
Data format
Data Format
Date format
Date format
Date Format
Double write buffer
Double write buffer
Double Write Buffer
Error
Error
ERROR 1045 (28000): Access denied for user 'user_name'@'host_name' (using password: NO)
Unknown table 'column_statistics' in information_schema (1109)
ERROR 1153 (08S01) at line 45: Got a packet bigger than 'max_allowed_packet' bytes
ERROR 1194 (HY000): Table 'table_name' is marked as crashed and should be repaired
ERROR 1227 (42000) at line 18: Access denied; you need (at least one of) the SUPER privilege(s) for this operation
Got fatal error 1236 from master when reading data from binary log: 'Client requested master to start replication from position > file size; the first event 'binary_log.000000' at 000000000, the last event read from '/directory_name/log/binary_log.000000' at 4, the last byte read from '/directory_name/log/binary_log.000000' at 4.'
Error Code: 1248. Every derived table must have its own alias
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
ERROR 1300 (HY000): Invalid utf8mb4 character string:
Error Code: 1337. Variable or condition declaration after cursor or handler declaration
ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)
ERROR 1486 (HY000): Constant, random or timezone-dependent expressions in (sub)partitioning function are not allowed
Error Code: 1493. VALUES LESS THAN value must be strictly increasing for each partition
Error Code: 1503. A PRIMARY KEY must include all columns in the table's partitioning function
Error Code: 1505. Partition management on a not partitioned table is not possible
Error Code: 1520. Reorganize of range partitions cannot change total ranges except for last partition where it can extend the range
ERROR 1563 (HY000): Partition constant is out of partition function domain
Error Code: 1786. Statement violates GTID consistency: CREATE TABLE ... SELECT.
1831 Duplicate index 'index_name' defined on the table 'schema_name.table_name'. This is deprecated and will be disallowed in a future release.
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket 'directory/mysql.sock' (2)
Error Code: 3100. Error on observer while running replication hook 'before_commit'.
ERROR 3948 (42000): Loading local data is disabled; this must be enabled on both the client and server sides
Column statistics
ERROR at line : Unknown command '\''
Event scheduler
Event scheduler
Event Scheduler
Explain
Explain
Explain
Function
Function
Function
Gtid
Gtid
GTID (Global Transaction Identifier)
Hugepage
Hugepage
Huge Page
Index
Index
Index
Insert into on duplicate key update
Insert into on duplicate key update
INSERT INTO ~ ON DUPLICATE KEY UPDATE
Install
Install
Install
Isolation level
Isolation level
Isolation Level
Load data
Load data
Load Data
Log
Log
Log
Binary
Binary
binary log
General
General
general log
Relay
Relay
relay log
Slow query
Slow query
slow query
Mysql
Mysql
mysql
Mysql shell
Mysql shell
mysql shell
Mysql shell dump
Mysql shell dump
mysql shell dump
Mysqlbinlog
Mysqlbinlog
mysqlbinlog
Mysqld
Mysqld
mysqld
Mysqldump
Mysqldump
mysqldump
Mysqldump pump dumper shell
Mysqldump pump dumper shell
mysqldump, mysqlpump, mydumper, mysqlshell dump의 차이
Parameter
Parameter
Parameter
binlog_row_image
group_concat_max_len
innodb_additional_mem_pool_size
innodb_autoextend_increment
innodb_buffer_pool_chunk_size
innodb_buffer_pool_instances
innodb_buffer_pool_size
Innodb data file path
innodb_doublewrite
innodb_doublewrite_batch_size
innodb_doublewrite_dir
innodb_doublewrite_files
innodb_doublewrite_pages
innodb_file_per_table
innodb_flush_log_at_timeout
innodb_flush_log_at_trx_commit
innodb_flush_method
innodb_flush_neighbors
innodb_flush_sync
innodb_io_capacity
innodb_io_capacity_max
innodb_page_size
innodb_read_io_threads
innodb_support_xa
innodb_use_sys_malloc
innodb_write_io_threads
local_infile
log_bin_trust_function_creators
lower_case_table_names
sync_binlog
Partition
Partition
Partition
Persist
Persist
Persist
Procedure
Procedure
Procedure
Process
Process
Process
Profiling
Profiling
Profiling
Replication
Replication
Duplication
Master replication
Master replication
Replication
Mha
Mha
Mysql High Availability
Semi sync replication
Semi sync replication
Semi-sync Replication
Router
Router
Router
Schema
Schema
Schema
Spatial
Spatial
Spatial
Sql mode
Sql mode
SQL Mode
Table
Table
Table
Tablespace
Tablespace
Tablespace
System
System
시스템 테이블스페이스
Time zone
Time zone
Time Zone
User
User
User
View
View
View
Oracle
Oracle
Oracle
Error
Parameter
favorite
favorite
상황별 자주 쓰는 SQL
Active duplication
Active duplication
Active Duplication
Analyze
Analyze
Analyze
Analyze와 DBMS_STATS의 차이
Automated maintence task
Automated maintence task
Automated Maintence Task
Automatic memory management
Automatic memory management
AMM (Automatic Memory Management)
Automatic shared memory management
Automatic shared memory management
ASMM (Automatic Shared Memory Management)
Block
Block
Block
Cbo rbo
Cbo rbo
CBO, RBO
Compare features
Compare features
Compare Features
Compression
Compression
Compression
Constraint
Constraint
Constraint
Datapump
Datapump
Datapump
Db link
Db link
DB Link
Dimension
Dimension
Dimension
Direct path load
Direct path load
Direct Path Load
Enqueue
Enqueue
Enqueue
Error
Error
00054
00059
00439
00900
00911
00932
00955
00959
00972
00988
00997
01008
01013
01017
01153
01418
01438
01476
01502
01549
01555
01652
01654
01658
01688
01779
01790
01795
01861
01922
01940
01950
02019
02082
02287
02429
02437
03214
04031
08180
10631
10636
12014
12162
12537
12545
12703
12719
12838
12899
14047
14086
14400
14451
14511
14701
19573
22835
22858
22868
22998
24344
28000
28040
29851
30036
30052
30926
32463
38029
38104
39809
60100
65096
LPX 00216
SP2 0591
SP2 0618
Expdpimpdp
Explain
Explain
Explain
Export csv
Export csv
Export csv
Flashback
Flashback
Flashback
Gathering
Gathering
Gathering (통계 수집)
Hint
Hint
Hint
Hugepage
Hugepage
HugePage
Identity
Identity
Identity
Index
Index
Index
Bitmap index
Bitmap index
Bitmap
Oracle text index
Oracle text index
Oracle Text
Oracle Text에 대한 자세한 설명
Oracle Text 인덱스와 % 의 성능 비교
Install oracle client
Install oracle client
Install Oracle Client
Latch
Latch
Latch
Cache Buffers Chains
Library Cache
Literal sql
Literal sql
Literal SQL
Lob
Lob
LOB (Large Objects)
Log
Log
Log
Archive
Archive
Archive
Supplemental
Supplemental
Supplemeltal Log
Trace
Trace
Trace
Merge into
Merge into
Merge Into
Nls parameter
Nls parameter
NLS Parameter
Parameter
Parameter
db_block_%
db_file_multiblock_read_count
db_writer_processes
dbwr_io_slaves
pool_size
sec_case_sensitive_logon
sec_case_sensitive_logon
session_cached_cursors
sort_area_size
Pfile spfile
Pfile spfile
PFILE, SPFILE
Parsing
Parsing
Parsing
Partition
Partition
Partition
Patch
Patch
Patch
Pct
Pct
PCT
Process
Process
Process
Query rewrite
Query rewrite
Query Rewrite
Regular expression
Regular expression
Regular Expression
Report
Report
Report
Ash
Ash
ash Report
Awr
Awr
awr Report
Statspack
Statspack
Statspack
Row level lock
Row level lock
Row Level Lock
Sequence
Sequence
Sequence
Session
Session
Session
Shrink
Shrink
Shrink
Sqlldr
Sqlldr
SQL Loader
Sqlplus
Sqlplus
SQL Plus
Synonym
Synonym
Synonym
Table
Table
Table
Temporary table
Temporary table
Temporary Table
Tablespace
Tablespace
Tablespace
BIGFILE과 SMALLFILE의 차이
테이블 스페이스 내부 데이터 크기를 확인하여 변경
Temporary Tablespace
UNDO Tablespace
Trigger
Trigger
Trigger
User
User
User
View
View
View
Materialized view
Materialized view
Materialized View
With
With
With
Postgresql
Postgresql
PostgreSQL
Parameter
Cluster
Cluster
PostgresSQL HA 구성 (Cluster)
Patroni
Patroni
Patroni
Pgbackrest
Pgbackrest
pgbackrest
Database
Database
Database
Extension
Extension
Extension
Dblink
Dblink
dblink
Oracle fdw
Oracle fdw
oracle_fdw
Install
Install
Install
Pg ctl
Pg ctl
pg_ctl
Pgbadger
Pgbadger
PGBADGER
Pgbench
Pgbench
pgbench
Psql
Psql
psql
Schema
Schema
Schema
Sequence
Sequence
Sequence
Serial
Serial
Serial
Server
Server
Server
Session
Session
Session
Timezone
Timezone
Timezone
User
User
User
User mapping
User mapping
User Mapping
Python
Python
python
Error
Breakpoint
Breakpoint
Breakpoint
Datetime
Datetime
Datetime
Error
Error
Consider using the --user option or check the permissions.
AttributeError
Indent
TypeError
Json
Json
Json
Time
Time
Time
Shell
Shell
Shell
Crontab
Crontab
crontab
Export
Export
export
Find
Find
find
Grep
Grep
grep
Head
Head
head
Iconv
Iconv
iconv
Iostat
Iostat
iostat
Sar
Sar
sar
Sleep
Sleep
sleep
Sudo
Sudo
sudo
Tail
Tail
tail
Timedatectl
Timedatectl
timedatectl
Top
Top
top
User
User
user
Vi
Vi
vi
Vnc
Vnc
VNC
Terraform
Terraform
Terraform
Module
Module
Terraform Module
Uipath
Uipath
UiPath (C#)
Vue
Vue
Vue
Error
Error
Error
Quasar
Quasar
Quasar
Windows
Windows
Windows
Ps
Ps
Power Shell
Rdp
Rdp
RDP (Remote Desktop Protocol)
Wsl
Wsl
WSL (Windows Subsystem for Linux)
01779
===
UPDATE 시 조인 되는 컬럼의 제약 조건이 유니크가 아님
서브 쿼리 방식이나 머지 방식으로 변경