{"id":6026,"date":"2008-02-13T10:47:00","date_gmt":"2008-02-13T01:47:00","guid":{"rendered":"http:\/\/www.synapsoft.co.kr\/blog\/6026"},"modified":"2008-02-13T10:47:00","modified_gmt":"2008-02-13T01:47:00","slug":"%ec%9d%b8%ed%8a%b8%eb%9d%bc%ec%9b%90%ec%9d%84-%ed%86%b5%ed%95%b4%ec%84%9c-%eb%b3%b8-mysql-%ed%8a%9c%eb%8b%9d","status":"publish","type":"post","link":"https:\/\/www.synapsoft.co.kr\/blog\/6026\/","title":{"rendered":"\uc778\ud2b8\ub77c\uc6d0\uc744 \ud1b5\ud574\uc11c \ubcf8 MySQL \ud29c\ub2dd"},"content":{"rendered":"

\uc778\ud2b8\ub77c\uc6d0\uc744 \ud1b5\ud574\uc11c \ubcf8 MySQL \ud29c\ub2dd<\/strong><\/font>
<\/font>v1.0 2007\/12\/14 Copyleft by \uc804\uacbd\ud5cc@\uc0ac\uc774\ub0c5\uc18c\ud504\ud2b8<\/p>\n

\uc774 \ubb38\uc11c\ub294 \uc0ac\uc774\ub0c5\uc18c\ud504\ud2b8 \uc0ac\ub0b4 \uc778\ud2b8\ub77c\ub137(\uc778\ud2b8\ub77c\uc6d0)\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 MySQL\uc774 \uba54\ubaa8\ub9ac\ub97c \ub9ce\uc774 \uc0ac\uc6a9\ud558\uace0, \uc790\ub8cc\ub7c9\uc774 \ub298\uc5b4\ub098\uba74\uc11c \ub290\ub824\uc9c0\ub294 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud558\uc5ec, \uc8fc\uc694\ud55c \uba87\uba87 \ud30c\ub77c\ubbf8\ud130\uc640 \ucffc\ub9ac\ub97c \ud29c\ub2dd\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud558\uc5ec \uc870\uce58\ud558\uace0 \uadf8 \ub0b4\uc6a9\uc744 \uc138\ubbf8\ub098\ud55c \uc790\ub8cc\uc784.
<\/font>
\uc0ac\uc6a9\uc790\uc640 \uac1c\ubc1c\uc790<\/strong><\/font><\/p>\n

\uc0ac\uc6a9\uc790(User) <-> \uc18c\ud504\ud2b8\uc6e8\uc5b4 <-> \uac1c\ubc1c\uc790(Developer) <-> \uac1c\ubc1c\ud234 <-> \uc804\ubb38\uac00(Expert)<\/p>\n

\uac1c\ubc1c\ud234\uc774\ub780?<\/p>\n

Function Library
Database Management System
Web Server
Eclipse IDE
Compiler\/Interpreter
Operating System
Hardware
Version Control System
Issue Tracking System
Memory Usage Program
…<\/p>\n

\ub2f9\uc2e0\uc740 \uac1c\ubc1c\ud234\uc758 \uc720\uc800\uc778\uac00\uc694?<\/p>\n

\ucee8\ud53c\uadf8\ub97c \ub9cc\uc9c8 \uc904 \uc54c\uba74 \uc218\ud37c\uc720\uc800\uc778 \uac83\ucc98\ub7fc,
\uac1c\ubc1c\ud234\uc758 \ucee8\ud53c\uadf8\ub97c \ub9cc\uc9c8\uc904 \uc54c\uace0 \ub85c\uadf8\ub97c \ubcfc \uc904\uc54c\uba74 \uc218\ud37c\uac1c\ubc1c\uc790.<\/p>\n

MySQL \ucee8\ud53c\uadf8(my.cnf) \ud29c\ub2dd<\/font><\/strong><\/p>\n

\ud29c\ub2dd\uc740 \ud574\ub3c4 \ud574\ub3c4 \ub05d\uc5c6\ub294 \uccad\uc18c\uc640 \uac19\uc740 \uac83\uc774\ub2e4.
\uccad\uc18c\ud560 \ub54c \ud070 \uac83\ubd80\ud130 \uce58\uc6b0\ub294 \uac83 \ucc98\ub7fc
\ud070 \uac12\uacfc \ub9ce\uc774 \uc0ac\uc6a9\ub418\ub294 \uac12\uc5d0 \uc8fc\ubaa9\ud55c\ub2e4.<\/p>\n

\uc11c\ubc84\ub2f9 \ud30c\ub77c\ubbf8\ud130<\/strong><\/font><\/p>\n

# InnoDB, unlike MyISAM, uses a buffer pool to cache both indexes and
# row data. The bigger you set this the less disk I\/O is needed to
# access data in tables. On a dedicated database server<\/font><\/strong> you may set this
# parameter up to 80% of the machine physical memory size<\/font><\/strong>. Do not set it
# too large, though, because competition of the physical memory may
# cause paging in the operating system.\u00a0 Note that on 32bit systems you
# might be limited to 2-3.5G of user level memory per process, so do not
# set it too high.
innodb_buffer_pool_size = 256M
#innodb_buffer_pool_size = 1G<\/strong><\/font><\/p>\n

# Query cache is used to cache SELECT results<\/font><\/strong> and later return them
# without actual executing the same query once again. Having the query
# cache enabled may result in significant speed improvements, if your
# have a lot of identical queries and rarely changing tables. See the
# “Qcache_lowmem_prunes” status variable to check if the current value
# is high enough for your load.
# Note: In case your tables change very often or if your queries are
# textually different every time, the query cache may result in a
# slowdown instead of a performance improvement.
query_cache_size = 32M
#query_cache_size = 128M<\/strong><\/font><\/p>\n

\uc811\uc18d\ub2f9 \ud30c\ub77c\ubbf8\ud130<\/font><\/strong><\/p>\n

# Sort buffer is used to perform sorts for some ORDER BY and GROUP BY
# queries. If sorted data does not fit into the sort buffer, a disk
# based merge sort is used instead – See the “Sort_merge_passes”
# status variable. Allocated per thread<\/font><\/strong> if sort is needed.
sort_buffer_size = 4M
#sort_buffer_size = 8M<\/font><\/strong><\/p>\n

# This buffer is used for the optimization of full JOINs<\/font><\/strong> (JOINs without
# indexes). Such JOINs are very bad for performance in most cases
# anyway, but setting this variable to a large value reduces the
# performance impact. See the “Select_full_join” status variable for a
# count of full JOINs. Allocated per thread if full join is found
join_buffer_size = 4M
#join_buffer_size = 8M<\/font><\/strong><\/p>\n

# How many threads we should keep in a cache for reuse. When a client
# disconnects, the client’s threads are put in the cache if there aren’t
# more than thread_cache_size threads from before.\u00a0 This greatly reduces
# the amount of <\/font>thread creations<\/font><\/strong> needed if you have a lot of new
# connections. (Normally this doesn’t give a notable performance
# improvement if you have a good thread implementation.)
thread_cache = 4<\/font><\/strong><\/p>\n

\ub85c\uadf8\uad00\ub828 \ud30c\ub77c\ubbf8\ud130<\/font><\/strong><\/p>\n

# Enable binary logging. This is required for acting as a MASTER in a
# replication configuration. You also need the binary log if you need
# the ability to do point in time recovery<\/font><\/strong> from your latest backup.
#log_bin<\/font><\/strong><\/p>\n

# Enable the full query log. Every query<\/font><\/strong> (even ones with incorrect
# syntax) that the server receives will be logged. This is useful for
# debugging, it is usually disabled in production use.
#log<\/font><\/strong><\/p>\n

# Log slow queries<\/font><\/strong>. Slow queries are queries which take more than the
# amount of time defined in “long_query_time” or which do not use
# indexes well, if log_long_format is enabled. It is normally good idea
# to have this turned on if you frequently add new queries to the
# system.
log_slow_queries<\/font><\/strong><\/p>\n

# All queries taking more than this amount of time (in seconds)<\/font><\/strong> will be
# trated as slow. Do not use “1” as a value here, as this will result in
# even very fast queries being logged from time to time (as MySQL
# currently measures time with second accuracy only).
long_query_time = 2<\/font><\/strong><\/p>\n

SQL \ucffc\ub9ac \ud29c\ub2dd<\/font><\/strong><\/p>\n

SQL\uc774\ub780? \ubcf8\ub798 \uc77c\ubc18 \uc0ac\ubb34\uc6d0\ub4e4\uc774 \uc4f8 \uc218 \uc788\ub3c4\ub85d \ub9cc\ub4e0 DB\uc5b8\uc5b4, \uac1c\ubc1c\uc790\uc6a9\uc73c\ub85c \ub9cc\ub4e4\uc5b4\uc9c4\uac8c \uc544\ub2d8.
\uac1c\ubc1c\uc790\ub77c\uba74 SQL\uc744 \uc4f8 \ub54c \uc548\ucabd\uc5d0\uc11c \uc5b4\ub5bb\uac8c \uc218\ud589\ub420 \uc9c0\ub3c4 \uba38\ub9ac\uc18d\uc5d0 \uadf8\ub9b4 \uc218 \uc788\uc5b4\uc57c \ud55c\ub2e4.<\/p>\n

1. \uc778\ub371\uc2a4\ub97c \ud0c0\ub3c4\ub85d<\/p>\n

\ubcc0\uacbd\uc804<\/p>\n

Select\u00a0 menuid,hid, seq, subject, left(excerpt,150)as excerpt,
\u00a0comment_cnt, attach_cnt, name, hit ,
DATE_FORMAT(regdate,’%Y-%m-%d’) >=
\u00a0date_add(DATE_FORMAT(now(),’%Y-%m-%d’), interval – 1 day) as isNew ,
DATE_FORMAT(regdate,’%Y-%m-%d’) REGDATE
From bbs
where subject<>”
and DATE_FORMAT(regdate,’%Y-%m-%d’) >
\u00a0date_add(DATE_FORMAT(now(),’%Y-%m-%d’), interval – 3 day)
<\/font><\/strong>and menuid not in(select seq from menu where root in(201))
order by seq desc\u00a0 limit 0,50;\u00a0 <\/div>\n

\ubcc0\uacbd\ud6c4<\/p>\n

Expression \ud615\ud0dc\ub85c \ub41c where \uc808\uc758 \uacbd\uc6b0, regdate\uc5d0 \uc0c9\uc778\uc774 \uac78\ub824\uc788\ub2e4\uace0 \ud574\ub3c4 \uc0ac\uc6a9\ub418\uc9c0 \ubabb\ud55c\ub2e4. Expression\uc744 \ubcc0\ud615\ud558\uc5ec regdate\uac00 \ud55c\ucabd\ud56d\uc5d0 \uc628\uc804\ud788 \ub098\uc62c \uc218 \uc788\ub3c4\ub85d \ud574\uc57c\ud55c\ub2e4.<\/p>\n

Select\u00a0 menuid,hid, seq, subject, left(excerpt,150) as excerpt,
comment_cnt, attach_cnt, name, hit,
datediff( curdate(), regdate) < 2 as isNew,
DATE_FORMAT(regdate,’%Y-%m-%d’) REGDATE
From bbs
where
regdate<\/font><\/strong> > date_sub(curdate(),interval 4 day)
and menuid not in (select seq from menu where root = 201)
and menuid not in (select seq from menu where Template = ‘album’)
order by seq desc <\/div>\n

2. \ud544\ub4dc\ucd94\uac00<\/p>\n

SELECT nid,hid, (select hname from customer where hid= a.hid) hname<\/font><\/strong>,
note,reg_date,reg_id,reg_name FROM cust_note a
where hid in (select hid from customer where cid=’146871′)
order by reg_date desc limit 0,10; <\/div>\n

\uc704 \ucffc\ub9ac\ub294 \ub9e4\uc6b0 \uc798 \ub9cc\ub4e4\uc5b4\uc9c0\uae34 \ud588\uc9c0\ub9cc, \uc0ac\uc6a9\ube48\ub3c4\uac00 \ub9e4\uc6b0 \ub192\uc740 \uacbd\uc6b0\ub77c\uba74 cust_note \ud14c\uc774\ube14\uc5d0 hname\uc744 \ub123\ub3c4\ub85d \ud558\uc5ec \uc870\uc778\uc744 \uc5c6\uc560\uace0 \ub354 \ube60\ub974\uac8c \ub9cc\ub4e4 \uc218 \uc788\ub2e4. \uc774\ub7f0 \uacfc\uc815\uc744 \uc815\uaddc\ud654\uc758 \uc5ed\uacfc\uc815 denomalization\uc774\ub77c\uace0 \ud55c\ub2e4.<\/p>\n

3. \ucffc\ub9ac \ubd84\ub9ac<\/p>\n

# Query_time: 3\u00a0 Lock_time: 0\u00a0 Rows_sent: 20\u00a0 Rows_examined:<\/font><\/strong> 14225<\/font><\/strong>
select a.nid, a.hid, b.hname, b.cid, b.cname, b.cpos2, b.phone, b.mobile,
\u00a0b.email, a.reg_id, a.reg_name, a.note, a.reg_date,
\u00a0DATE_FORMAT(a.reg_date,’%w’) reg_week
from cust_note a, customer b
where b.DEL_FLAG=’0′
\u00a0 and a.hid = b.hid
<\/font><\/strong>order by a.reg_date desc limit 0, 20;<\/div>\n

\ucffc\ub9ac\uac00 \uac04\ub2e8\ud574 \ubcf4\uc774\ub354\ub77c\ub3c4 \uc870\uc778\uc740 \ub9e4\uc6b0 \ucee4\ub2e4\ub780 \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uace0, \uba54\ubaa8\ub9ac\uc640 \uc2dc\uac04\uc744 \ub9ce\uc774 \uc18c\ubaa8\ud55c\ub2e4. cust_note\uc5d0\uc11c 20\uac1c\ub9cc \uac00\uc838\uc624\ub294 \ucffc\ub9ac\uc640 customer\uc5d0\uc11c \uae30\ubcf8\uc815\ubcf4\ub97c \uac00\uc838\uc624\ub294 \ucffc\ub9ac 2\uac1c\ub85c \ubd84\ub9ac\ud558\uc5ec \uad6c\ud604\ud558\uba74 \ub9e4\uc6b0 \ud6a8\uc728\uc801\uc774\ub2e4.<\/p>\n

4. limit\uc758 \uc720\ud639<\/p>\n

select seq, Subject, Excerpt, name, comment_cnt,
\u00a0DATE_FORMAT(regdate,’%Y-%m-%d %H:%i’) regdate
from bbs
where menuid=6 and seq<11641
order by seq desc limit 0,1<\/font><\/strong>;<\/div>\n

\ucd5c\ub300\uac12\uc774\ub098 \ucd5c\uc18c\uac12\uc744 \uac00\uc838\uc624\uae30 \uc704\ud574 limit 1\uc744 \uc0ac\uc6a9\ud558\uae30\ubcf4\ub2e4\ub294 max\ub098 min\uc744 \ud65c\uc6a9\ud55c\ub2e4.
\uc704\uc758 \ucffc\ub9ac\uc758 \uacbd\uc6b0 max(seq)\ub97c \uad6c\ud558\ub294 query\ub97c \uba3c\uc800 \uc2e4\ud589\ud558\uace0, \ud574\ub2f9 max_seq\uc5d0 \ub300\ud558\uc5ec\u00a0 bbs\uac12\uc744 \uac00\uc838\uc624\ub3c4\ub85d \ud55c\ub2e4.<\/p>\n

\uae30\ud0c0 \uace0\ub824\uc0ac\ud56d
<\/strong><\/font>
1. \ubaa8\ub4e0 \uac78 DB\uc5d0 \uc62c\ub9ac\uc9c0 \ub9d0\uc790<\/p>\n

DBMS\ub294 \uc815\ud615\ud654\ub41c \uc790\ub8cc\uc758 \uc785\ucd9c\ub825, \uc18c\ud305 \ub4f1\uc744 \uc798 \ud560 \uc218 \uc788\ub294 \ub3c4\uad6c\uc77c \ubfd0\uc774\ub2e4.
\ud30c\uc77c\uc2dc\uc2a4\ud15c\uc774\ub098 Berkeley DB, \uac80\uc0c9\uc5d4\uc9c4 \uac19\uc740 \ub2e4\ub978 \uad6c\uc870\uac00 \ub354 \uc720\uc6a9\ud55c \uacbd\uc6b0\uac00 \ub9ce\ub2e4.<\/p><\/blockquote>\n

2. \ub85c\uadf8\ub97c \uc911\uc694\uc2dc \ud558\uc790<\/p>\n

\uc911\uc694\ud558\ub2e4\uace0 \uc0dd\uac01\ud55c \uac83\uacfc \uc2e4\uc81c\ub85c \uc911\uc694\ud55c \uac83\uc740 \ub2e4\ub97c \uc218 \uc788\ub2e4.
\ubb38\uc81c\ub294 \ud56d\uc0c1 \uc758\uc678\uc758 \uacf3\uc5d0\uc11c \uc0dd\uae34\ub2e4.
\ub85c\uadf8\ub97c \ubd10\uc57c\ub9cc \ubb38\uc81c\ub97c \uc815\ud655\ud788 \uc54c \uc218 \uc788\ub2e4.
\uc6b0\ub9ac\uac00 \ub9cc\ub4dc\ub294 \uc18c\ud504\ud2b8\uc6e8\uc5b4\ub294 \ub85c\uadf8\ub97c \uc798 \uae30\ub85d\ud574\uc57c \ud55c\ub2e4.
\ub85c\uadf8\uac00 \ub108\ubb34 \uc313\uc5ec\uc11c Disk\uac00 Full \ub418\uc9c0 \uc54a\ub3c4\ub85d \uc798 \uad00\ub9ac\ud574\uc57c \ud55c\ub2e4.<\/p><\/blockquote>\n<\/span>","protected":false},"excerpt":{"rendered":"

\uc778\ud2b8\ub77c\uc6d0\uc744 \ud1b5\ud574\uc11c \ubcf8 MySQL \ud29c\ub2ddv1.0 2007\/12\/14 Copyleft by \uc804\uacbd\ud5cc@\uc0ac\uc774\ub0c5\uc18c\ud504\ud2b8 \uc774 \ubb38\uc11c\ub294 \uc0ac\uc774\ub0c5\uc18c\ud504\ud2b8 \uc0ac\ub0b4 \uc778\ud2b8\ub77c\ub137(\uc778\ud2b8\ub77c\uc6d0)\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 MySQL\uc774 \uba54\ubaa8\ub9ac\ub97c \ub9ce\uc774 \uc0ac\uc6a9\ud558\uace0, \uc790\ub8cc\ub7c9\uc774 \ub298\uc5b4\ub098\uba74\uc11c \ub290\ub824\uc9c0\ub294 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud558\uc5ec, \uc8fc\uc694\ud55c \uba87\uba87 \ud30c\ub77c\ubbf8\ud130\uc640 \ucffc\ub9ac\ub97c \ud29c\ub2dd\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud558\uc5ec \uc870\uce58\ud558\uace0 \uadf8 \ub0b4\uc6a9\uc744 \uc138\ubbf8\ub098\ud55c \uc790\ub8cc\uc784.\uc0ac\uc6a9\uc790\uc640 \uac1c\ubc1c\uc790 \uc0ac\uc6a9\uc790(User) \uc18c\ud504\ud2b8\uc6e8\uc5b4 \uac1c\ubc1c\uc790(Developer) \uac1c\ubc1c\ud234 \uc804\ubb38\uac00(Expert) \uac1c\ubc1c\ud234\uc774\ub780? Function LibraryDatabase Management SystemWeb ServerEclipse IDECompiler\/InterpreterOperating SystemHardwareVersion Control SystemIssue Tracking SystemMemory Usage […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[20],"tags":[],"class_list":["post-6026","post","type-post","status-publish","format-standard","hentry","category-20"],"yoast_head":"\n\uc778\ud2b8\ub77c\uc6d0\uc744 \ud1b5\ud574\uc11c \ubcf8 MySQL \ud29c\ub2dd - Synapsoft<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.synapsoft.co.kr\/blog\/6026\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\uc778\ud2b8\ub77c\uc6d0\uc744 \ud1b5\ud574\uc11c \ubcf8 MySQL \ud29c\ub2dd - Synapsoft\" \/>\n<meta property=\"og:description\" content=\"\uc778\ud2b8\ub77c\uc6d0\uc744 \ud1b5\ud574\uc11c \ubcf8 MySQL \ud29c\ub2ddv1.0 2007\/12\/14 Copyleft by \uc804\uacbd\ud5cc@\uc0ac\uc774\ub0c5\uc18c\ud504\ud2b8 \uc774 \ubb38\uc11c\ub294 \uc0ac\uc774\ub0c5\uc18c\ud504\ud2b8 \uc0ac\ub0b4 \uc778\ud2b8\ub77c\ub137(\uc778\ud2b8\ub77c\uc6d0)\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 MySQL\uc774 \uba54\ubaa8\ub9ac\ub97c \ub9ce\uc774 \uc0ac\uc6a9\ud558\uace0, \uc790\ub8cc\ub7c9\uc774 \ub298\uc5b4\ub098\uba74\uc11c \ub290\ub824\uc9c0\ub294 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud558\uc5ec, \uc8fc\uc694\ud55c \uba87\uba87 \ud30c\ub77c\ubbf8\ud130\uc640 \ucffc\ub9ac\ub97c \ud29c\ub2dd\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud558\uc5ec \uc870\uce58\ud558\uace0 \uadf8 \ub0b4\uc6a9\uc744 \uc138\ubbf8\ub098\ud55c \uc790\ub8cc\uc784.\uc0ac\uc6a9\uc790\uc640 \uac1c\ubc1c\uc790 \uc0ac\uc6a9\uc790(User) \uc18c\ud504\ud2b8\uc6e8\uc5b4 \uac1c\ubc1c\uc790(Developer) \uac1c\ubc1c\ud234 \uc804\ubb38\uac00(Expert) \uac1c\ubc1c\ud234\uc774\ub780? Function LibraryDatabase Management SystemWeb ServerEclipse IDECompiler\/InterpreterOperating SystemHardwareVersion Control SystemIssue Tracking SystemMemory Usage […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.synapsoft.co.kr\/blog\/6026\/\" \/>\n<meta property=\"og:site_name\" content=\"Synapsoft\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/synapsoft\" \/>\n<meta property=\"article:published_time\" content=\"2008-02-13T01:47:00+00:00\" \/>\n<meta name=\"author\" content=\"synap\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\uae00\uc4f4\uc774\" \/>\n\t<meta name=\"twitter:data1\" content=\"synap\" \/>\n\t<meta name=\"twitter:label2\" content=\"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04\" \/>\n\t<meta name=\"twitter:data2\" content=\"4\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.synapsoft.co.kr\/blog\/6026\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.synapsoft.co.kr\/blog\/6026\/\"},\"author\":{\"name\":\"synap\",\"@id\":\"https:\/\/www.synapsoft.co.kr\/#\/schema\/person\/36ad8881b3b7b47a32258f5afe3a6391\"},\"headline\":\"\uc778\ud2b8\ub77c\uc6d0\uc744 \ud1b5\ud574\uc11c \ubcf8 MySQL \ud29c\ub2dd\",\"datePublished\":\"2008-02-13T01:47:00+00:00\",\"dateModified\":\"2008-02-13T01:47:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.synapsoft.co.kr\/blog\/6026\/\"},\"wordCount\":886,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.synapsoft.co.kr\/#organization\"},\"articleSection\":[\"\uae30\ud0c0\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.synapsoft.co.kr\/blog\/6026\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.synapsoft.co.kr\/blog\/6026\/\",\"url\":\"https:\/\/www.synapsoft.co.kr\/blog\/6026\/\",\"name\":\"\uc778\ud2b8\ub77c\uc6d0\uc744 \ud1b5\ud574\uc11c \ubcf8 MySQL \ud29c\ub2dd - Synapsoft\",\"isPartOf\":{\"@id\":\"https:\/\/www.synapsoft.co.kr\/#website\"},\"datePublished\":\"2008-02-13T01:47:00+00:00\",\"dateModified\":\"2008-02-13T01:47:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.synapsoft.co.kr\/blog\/6026\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.synapsoft.co.kr\/blog\/6026\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.synapsoft.co.kr\/blog\/6026\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.synapsoft.co.kr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\uae30\ud0c0\",\"item\":\"https:\/\/www.synapsoft.co.kr\/blog\/category\/%ea%b8%b0%ed%83%80\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"\uc778\ud2b8\ub77c\uc6d0\uc744 \ud1b5\ud574\uc11c \ubcf8 MySQL \ud29c\ub2dd\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.synapsoft.co.kr\/#website\",\"url\":\"https:\/\/www.synapsoft.co.kr\/\",\"name\":\"\uc0ac\uc774\ub0c5\uc18c\ud504\ud2b8\",\"description\":\"\ub3c4\ud050\uba3c\ud2b8 AI \uc804\ubb38 \uae30\uc5c5\",\"publisher\":{\"@id\":\"https:\/\/www.synapsoft.co.kr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.synapsoft.co.kr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.synapsoft.co.kr\/#organization\",\"name\":\"Synapsoft\",\"url\":\"https:\/\/www.synapsoft.co.kr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.synapsoft.co.kr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.synapsoft.co.kr\/wp-content\/uploads\/2019\/03\/favicon.png\",\"contentUrl\":\"https:\/\/www.synapsoft.co.kr\/wp-content\/uploads\/2019\/03\/favicon.png\",\"width\":512,\"height\":512,\"caption\":\"Synapsoft\"},\"image\":{\"@id\":\"https:\/\/www.synapsoft.co.kr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/synapsoft\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.synapsoft.co.kr\/#\/schema\/person\/36ad8881b3b7b47a32258f5afe3a6391\",\"name\":\"synap\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.synapsoft.co.kr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d51ab49a2d49cf5ea7fdff0c0a2390d07161fba4648f13dacf2f0dbe94def4de?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d51ab49a2d49cf5ea7fdff0c0a2390d07161fba4648f13dacf2f0dbe94def4de?s=96&d=mm&r=g\",\"caption\":\"synap\"},\"url\":\"https:\/\/www.synapsoft.co.kr\/blog\/author\/synap\/\"}]}<\/script>\n","yoast_head_json":{"title":"\uc778\ud2b8\ub77c\uc6d0\uc744 \ud1b5\ud574\uc11c \ubcf8 MySQL \ud29c\ub2dd - Synapsoft","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.synapsoft.co.kr\/blog\/6026\/","og_locale":"ko_KR","og_type":"article","og_title":"\uc778\ud2b8\ub77c\uc6d0\uc744 \ud1b5\ud574\uc11c \ubcf8 MySQL \ud29c\ub2dd - Synapsoft","og_description":"\uc778\ud2b8\ub77c\uc6d0\uc744 \ud1b5\ud574\uc11c \ubcf8 MySQL \ud29c\ub2ddv1.0 2007\/12\/14 Copyleft by \uc804\uacbd\ud5cc@\uc0ac\uc774\ub0c5\uc18c\ud504\ud2b8 \uc774 \ubb38\uc11c\ub294 \uc0ac\uc774\ub0c5\uc18c\ud504\ud2b8 \uc0ac\ub0b4 \uc778\ud2b8\ub77c\ub137(\uc778\ud2b8\ub77c\uc6d0)\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 MySQL\uc774 \uba54\ubaa8\ub9ac\ub97c \ub9ce\uc774 \uc0ac\uc6a9\ud558\uace0, \uc790\ub8cc\ub7c9\uc774 \ub298\uc5b4\ub098\uba74\uc11c \ub290\ub824\uc9c0\ub294 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud558\uc5ec, \uc8fc\uc694\ud55c \uba87\uba87 \ud30c\ub77c\ubbf8\ud130\uc640 \ucffc\ub9ac\ub97c \ud29c\ub2dd\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud558\uc5ec \uc870\uce58\ud558\uace0 \uadf8 \ub0b4\uc6a9\uc744 \uc138\ubbf8\ub098\ud55c \uc790\ub8cc\uc784.\uc0ac\uc6a9\uc790\uc640 \uac1c\ubc1c\uc790 \uc0ac\uc6a9\uc790(User) \uc18c\ud504\ud2b8\uc6e8\uc5b4 \uac1c\ubc1c\uc790(Developer) \uac1c\ubc1c\ud234 \uc804\ubb38\uac00(Expert) \uac1c\ubc1c\ud234\uc774\ub780? Function LibraryDatabase Management SystemWeb ServerEclipse IDECompiler\/InterpreterOperating SystemHardwareVersion Control SystemIssue Tracking SystemMemory Usage […]","og_url":"https:\/\/www.synapsoft.co.kr\/blog\/6026\/","og_site_name":"Synapsoft","article_publisher":"https:\/\/www.facebook.com\/synapsoft","article_published_time":"2008-02-13T01:47:00+00:00","author":"synap","twitter_card":"summary_large_image","twitter_misc":{"\uae00\uc4f4\uc774":"synap","\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04":"4\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.synapsoft.co.kr\/blog\/6026\/#article","isPartOf":{"@id":"https:\/\/www.synapsoft.co.kr\/blog\/6026\/"},"author":{"name":"synap","@id":"https:\/\/www.synapsoft.co.kr\/#\/schema\/person\/36ad8881b3b7b47a32258f5afe3a6391"},"headline":"\uc778\ud2b8\ub77c\uc6d0\uc744 \ud1b5\ud574\uc11c \ubcf8 MySQL \ud29c\ub2dd","datePublished":"2008-02-13T01:47:00+00:00","dateModified":"2008-02-13T01:47:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.synapsoft.co.kr\/blog\/6026\/"},"wordCount":886,"commentCount":0,"publisher":{"@id":"https:\/\/www.synapsoft.co.kr\/#organization"},"articleSection":["\uae30\ud0c0"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.synapsoft.co.kr\/blog\/6026\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.synapsoft.co.kr\/blog\/6026\/","url":"https:\/\/www.synapsoft.co.kr\/blog\/6026\/","name":"\uc778\ud2b8\ub77c\uc6d0\uc744 \ud1b5\ud574\uc11c \ubcf8 MySQL \ud29c\ub2dd - Synapsoft","isPartOf":{"@id":"https:\/\/www.synapsoft.co.kr\/#website"},"datePublished":"2008-02-13T01:47:00+00:00","dateModified":"2008-02-13T01:47:00+00:00","breadcrumb":{"@id":"https:\/\/www.synapsoft.co.kr\/blog\/6026\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.synapsoft.co.kr\/blog\/6026\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.synapsoft.co.kr\/blog\/6026\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.synapsoft.co.kr\/"},{"@type":"ListItem","position":2,"name":"\uae30\ud0c0","item":"https:\/\/www.synapsoft.co.kr\/blog\/category\/%ea%b8%b0%ed%83%80\/"},{"@type":"ListItem","position":3,"name":"\uc778\ud2b8\ub77c\uc6d0\uc744 \ud1b5\ud574\uc11c \ubcf8 MySQL \ud29c\ub2dd"}]},{"@type":"WebSite","@id":"https:\/\/www.synapsoft.co.kr\/#website","url":"https:\/\/www.synapsoft.co.kr\/","name":"\uc0ac\uc774\ub0c5\uc18c\ud504\ud2b8","description":"\ub3c4\ud050\uba3c\ud2b8 AI \uc804\ubb38 \uae30\uc5c5","publisher":{"@id":"https:\/\/www.synapsoft.co.kr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.synapsoft.co.kr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/www.synapsoft.co.kr\/#organization","name":"Synapsoft","url":"https:\/\/www.synapsoft.co.kr\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.synapsoft.co.kr\/#\/schema\/logo\/image\/","url":"https:\/\/www.synapsoft.co.kr\/wp-content\/uploads\/2019\/03\/favicon.png","contentUrl":"https:\/\/www.synapsoft.co.kr\/wp-content\/uploads\/2019\/03\/favicon.png","width":512,"height":512,"caption":"Synapsoft"},"image":{"@id":"https:\/\/www.synapsoft.co.kr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/synapsoft"]},{"@type":"Person","@id":"https:\/\/www.synapsoft.co.kr\/#\/schema\/person\/36ad8881b3b7b47a32258f5afe3a6391","name":"synap","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.synapsoft.co.kr\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d51ab49a2d49cf5ea7fdff0c0a2390d07161fba4648f13dacf2f0dbe94def4de?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d51ab49a2d49cf5ea7fdff0c0a2390d07161fba4648f13dacf2f0dbe94def4de?s=96&d=mm&r=g","caption":"synap"},"url":"https:\/\/www.synapsoft.co.kr\/blog\/author\/synap\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.synapsoft.co.kr\/wp-json\/wp\/v2\/posts\/6026","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.synapsoft.co.kr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.synapsoft.co.kr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.synapsoft.co.kr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.synapsoft.co.kr\/wp-json\/wp\/v2\/comments?post=6026"}],"version-history":[{"count":0,"href":"https:\/\/www.synapsoft.co.kr\/wp-json\/wp\/v2\/posts\/6026\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.synapsoft.co.kr\/wp-json\/wp\/v2\/media?parent=6026"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.synapsoft.co.kr\/wp-json\/wp\/v2\/categories?post=6026"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.synapsoft.co.kr\/wp-json\/wp\/v2\/tags?post=6026"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}