{"id":687,"date":"2015-04-13T21:44:13","date_gmt":"2015-04-14T06:44:13","guid":{"rendered":"http:\/\/blog.box.kr\/?p=687"},"modified":"2015-04-13T21:44:13","modified_gmt":"2015-04-14T06:44:13","slug":"%ed%8e%8cmariadb-%ec%84%a4%ec%a0%95-%ed%8c%8c%ec%9d%bc-my-cnf","status":"publish","type":"post","link":"https:\/\/blog.box.kr\/?p=687","title":{"rendered":"[\ud38c]MariaDB \uc124\uc815 \ud30c\uc77c my.cnf"},"content":{"rendered":"

http:\/\/www.programkr.com\/blog\/MUDM5ADMwYT2.html<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

# MariaDB database server configuration file.
\n#
\n# You can copy this file to one of:
\n# – “\/etc\/mysql\/my.cnf” to set global options,
\n# – “~\/.my.cnf” to set user-specific options.
\n#
\n# One can use all long options that the program supports.
\n# Run program with –help to get a list of available options and with
\n# –print-defaults to see which it would actually understand and use.
\n#
\n# For explanations see
\n# http:\/\/dev.mysql.com\/doc\/mysql\/en\/server-system-variables.html<\/p>\n

# This will be passed to all mysql clients
\n# It has been reported that passwords should be enclosed with ticks\/quotes
\n# escpecially if they contain “#” chars…
\n# Remember to edit \/etc\/mysql\/debian.cnf when changing the socket location.
\n[client]
\nport = 3306 #\ud074\ub77c\uc774\uc5b8\ud2b8 \uc5f0\uacb0 \ud1b5\uc2e0 \ud3ec\ud2b8
\nsocket = \/var\/run\/mysqld\/mysqld.sock #socket \ud30c\uc77c linux\/unix \uc2dc\uc2a4\ud15c \ud2b9\uc720\uc758, \uc0ac\uc6a9\uc790 \uc774 \ud658\uacbd \uc544\ub798\uc5d0\uc11c \ud074\ub77c\uc774\uc5b8\ud2b8 \uc5f0\uacb0 \ub3fc, \uc548 \ud1b5\ud574 tcp\/ip \ub124\ud2b8\uc6cc\ud06c \uc54a\uace0 \uc9c1\uc811 \uc0ac\uc6a9 socket \ud30c\uc77c \uc5f0\uacb0
\ndefault-character-set = utf8mb4 #\ud074\ub77c\uc774\uc5b8\ud2b8 \uae30\ubcf8 \uc5f0\uacb0 \ubb38\uc790 \uc9d1\ud569 \uc9d1\ud569, \ub9cc\uc57d \ucef4\ud30c\uc77c \uc124\uce58 \ub54c \uc774\ubbf8 \uc9c0\uc815\ub41c \uc54a\uc73c\uba74 \uc548 \uc368<\/p>\n

# Here is entries for some specific programs
\n# The following values assume you have at least 32M ram<\/p>\n

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
\n[mysqld_safe]
\nsocket = \/var\/run\/mysqld\/mysqld.sock
\nnice = 0<\/p>\n

[mysqld]
\n#
\n# * Basic Settings
\n#
\ncharacter-set-client-handshake = FALSE
\ncharacter-set-server = utf8mb4 #\uc11c\ubc84 \ubc0f \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uae30\ubcf8 \ubb38\uc790 \uc9d1\ud569
\ncollation-server = utf8mb4_unicode_ci #\ud074\ub77c\uc774\uc5b8\ud2b8 \ubcf4\uc815 \ubb38\uc790 \uc9d1\ud569
\ninit_connect = ‘SET NAMES utf8mb4’<\/p>\n

user = mysql
\npid-file = \/var\/run\/mysqld\/mysqld.pid #\uc11c\ubc84 \uc0ac\uc774\ub4dc \ud504\ub85c\uc138\uc2a4\uc758 pid \ud30c\uc77c\uc744 \ub9cc\uc57d \uc783\uc5b4\ubc84\ub9b0 \uc740 \ub2e4\uc2dc Mysql \ub2e4\uc2dc \ub9cc\ub4e4 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. \ub9cc\uc57d \ub2e4\uc2dc \uc54a\uc73c\uba74 \ud504\ub85c\uc138\uc2a4 \uc8fd\uc774\uae30 mysqld \ub54c\ubb38\uc5d0 \uc544\uc9c1 \uc0ac\uc6a9\ud560 \uc218 pkill mysql \ud6c4 \ub2e4\uc2dc Mysql \uc740 \uc131\uacf5
\nsocket = \/var\/run\/mysqld\/mysqld.sock #\uc11c\ubc84 \uc0ac\uc774\ub4dc \ud1b5\uc2e0 \ud30c\uc77c, \ub9cc\uc57d \uc783\uc5b4\ubc84\ub9b0 \uc740 \ub2e4\uc2dc Mysql \ub2e4\uc2dc \ub9cc\ub4e4 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. \ub9cc\uc57d \ub2e4\uc2dc \uc54a\uc73c\uba74 \ud504\ub85c\uc138\uc2a4 \uc8fd\uc774\uae30 mysqld \ub54c\ubb38\uc5d0 \uc544\uc9c1 \uc0ac\uc6a9\ud560 \uc218 pkill mysql \ud6c4 \ub2e4\uc2dc Mysql \uc740 \uc131\uacf5
\nport = 3306 #Mysql \uc11c\ube44\uc2a4 \uc0ac\uc774\ub4dc \ub4e3\ub294 \ud3ec\ud2b8
\nbasedir = \/usr #Mysql \uc18c\ud504\ud2b8\uc6e8\uc5b4 \ub514\ub809\ud130\ub9ac
\ndatadir = \/mnt\/data\/mysql #Mysql \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc800\uc7a5 \ubaa9\ub85d
\ntmpdir = \/tmp #\uc784\uc2dc \ud30c\uc77c\uc744 \uc800\uc7a5\ud560 Mysql \ub4f1 \ub300\ud615 \uc815\ub82c \ub514\uc2a4\ud06c \uae30\ubc18 \uac00\ubcbc\uc6b4 \uc784\uc2dc \ud14c\uc774\ube14
\nlc_messages_dir = \/usr\/share\/mysql
\nlc_messages = en_US
\nskip-external-locking #\uc678\ubd80 \uc7a0\uae08 \ubc29\uc9c0 \uc2dc\uacc4\ub97c \ud5c8\uc6a9 \uc678\ubd80 \ud30c\uc77c \uc9c1\uae09 \uc790\ubb3c\uc1e0. \uc7a0\uae08 \ud30c\uc77c \uc5f4\uae30 \uc74c\uc2dd\uc774\ub77c\ub3c4 \uc131\ub2a5 \uc545\uc601\ud5a5\uc744 \ubbf8\uce5c\ub2e4
\n#
\n# Instead of skip-networking the default is now to listen only on
\n# localhost which is more compatible and is not less secure.
\nbind-address = 112.124.37.33 #\uc11c\ubc84 \uc5ec \uac1c IP \ub54c \uc368 \ube44\uad50\uc801 \uc911\uc694\ud55c \uc624\uc9c1 \ubb36\uc5ec\uc788\uc2b5\ub2c8\ub2e4 IP \uc8fc\uc18c\ub97c \ud074\ub77c\uc774\uc5b8\ud2b8\ub97c \uc218\uc6a9\ud560 \uc218 \uc788\ub294 \uc5f0\uacb0 \uc694\uccad
\n#
\n# * Fine Tuning #\ubbf8\uc138 \uc870\uc815
\n#
\n# \ub3d9\uc2dc\uc131 \uc2a4\ub808\ub4dc \uc218, \uac74\uc758 \uc704\ud574 CPU \ud575\uc2ec \uacf1\ud558\uae30 2: CPU \uac1c\uc218’s*2 for thread_concurrency
\n#thread_concurrency = 8 #\uc18c\uc18d \uc911\uc810 \ucd5c\uc801\ud654 \ub9e4\uac1c \ubcc0\uc218 \uc774 \ub9e4\uac1c \ubcc0\uc218 \ub294 MariaDB \uae30\ubcf8 \uc124\uc815 \ud30c\uc77c \uc548\uc5d0 \uc544\uc9c1 \ub098\ud0c0\ub09c<\/p>\n

max_connections\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 5000 #\uc9c0\uc815\ud55c mysql \uc11c\ube44\uc2a4 \ud55c \ud5c8\uc6a9 \ucd5c\ub300 \uc5f0\uacb0 \ud504\ub85c\uc138\uc2a4 \uac1c\uc218
\n#connect_timeout\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 5
\nwait_timeout\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 600 #SQL \uad6c\ubb38 \ucd5c\ub300 \uc2e4\ud589 \uc2dc\uac04
\nmax_allowed_packet\u00a0\u00a0\u00a0\u00a0\u00a0 = 16M #\uc778\ud130\ub137 \uc124\uc815 \uc804\uc1a1 \uc911 \ud55c \ubc88 \uc218 \uc788\ub294 \ucd5c\ub300 \uba54\uc2dc\uc9c0 \uc804\uc1a1 \uc2dc\uc2a4\ud15c \uae30\ubcf8\uac12 1MB, \ucd5c\ub300 \uc218 1G
\nthread_cache_size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 256 #\uc124\uc815 threadcache \uc5f0\ubabb \uc18d\uc5d0 \uce90\uc2dc \uc5f0\uacb0 \uac1c\uccb4 \uc218 \ucd5c\ub300 \uac2f\uc218, \uae30\ubcf8\uac12 0, \uc774 \uac12 \ud45c\ud604 \ub2e4\uc2dc \uc774\uc6a9\ud560 \uc218 \uc788\ub294 \uce90\uc2dc \ub2e4\uc2dc \ub9cc\ub4dc\ub294 \uc911 \uc2a4\ub808\ub4dc \uc218\uac00 \uc800\uc7a5, \uacb0\ub2e8\uc744 \ub0b4\ub824\uc57c \ud560 \ub54c \uc5f0\uacb0 \ud574\uc81c \uc2dc, \ub9cc\uc57d \uce90\uc2dc \ub2e4\uc2dc \ub9cc\ub4dc\ub294 \uc911 \uadf8\ub9ac\uace0 \uacf5\uac04, \uadf8\ub7fc \ud074\ub77c\uc774\uc5b8\ud2b8 \uc788\ub294 \uc2a4\ub808\ub4dc \uaddc\ubaa8\ub85c \uac16\ub2e4 \uce90\uc2dc \ub2e4\uc2dc \ub9cc\ub4dc\ub294 \uc911, \ub9cc\uc57d \uc2a4\ub808\ub4dc \ub2e4\uc2dc \uc694\uccad\uc744 \ubc1b\uc558\ub2e4, \uadf8\ub7fc \uc694\uccad \uce90\uc2dc \uc5d0\uc11c \ub294 \uc77d\uae30, \uc9c0\uae08 \uce90\uc2dc \uc18d \ube48 \ub610\ub294 \uc0c8\ub85c\uc6b4 \uc694\uccad, \uadf8\ub7fc \uc2a4\ub808\ub4dc \uaddc\ubaa8\ub85c \ub2e4\uc2dc \uc0dd\uc131. \uc124\uc815 \ubc95\uce59 \uc704\ud574: 1G \uba54\ubaa8\ub9ac \uc124\uc815 \uc744 8,2G \uba54\ubaa8\ub9ac \uc124\uc815 \uc744 16,4G \uc774\uc0c1 \uc124\uc815 \uc744 64. \ub9cc\uc57d \ub9ce\uc740 \uc0c8\ub85c\uc6b4 \uc2a4\ub808\ub4dc \uc788\uc73c\uba74 \ub298 \uc774 \uac12 \uc2dc\uc2a4\ud15c \uc131\ub2a5\uc744 \uac1c\uc120\ud560 \uc218 \uc788\ub2e4. Connections \ubc0f Threads_created \uc0c1\ud0dc\uac00 \ube44\uad50\uc801 \ubcc0\uc218\ub97c \ud1b5\ud574 \uc774 \ubcc0\uc218 \ud6a8\uacfc\ub97c \ubcfc \uc218 \uc788\ub2e4
\nsort_buffer_size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 4M #\uc815\ub82c \ubc84\ud37c \uc4f8 \ucc98\ub9ac \ube44\uc2b7\ud55c orderby \ubc0f groupby \ub300\uae30\uc5f4 \uc77c\uc73c\ud0a8 \uc815\ub82c, \uc2dc\uc2a4\ud15c \uae30\ubcf8 \ud06c\uae30 2M \uc704\ud574 \uc774 \uc778\uc790 \ub300\uc751 \ubd84\ubc30 \uba54\ubaa8\ub9ac \uac83\uc740 \ubaa8\ub4e0 \uc5f0\uacb0 \uc804\uc6a9, \ub9cc\uc57d 100 \uac1c \uc5f0\uacb0, \uc2e4\uc81c \ubd84\ubc30 \uc815\ub82c \ubc84\ud37c \ud06c\uae30\ub97c \uc124\uc815\ud558\uc2ed\uc2dc\uc624 6*100; – 6M-8M, \ub354 \ud070 \uac83\uc774 \uc544\ub2c8\ub2e4, \uc774 connection \uae09 \ub9e4\uac1c \ubcc0\uc218, \ub108\ubb34 \ud070 \uc124\uc815 + \ub192\uc740 \ub3d9\uc2dc\uc131 \uc788\uc744 \ub2e4 \uc2dc\uc2a4\ud15c \uba54\ubaa8\ub9ac \uc790\uc6d0. \uc608: 500\uac1c \uc5f0\uacb0 \ub420 \uc18c\ubaa8 500*sort_buffer_size (8M) =4G \uba54\ubaa8\ub9ac \ucd08\uacfc 2KB \ub54c \ubcf4\uba74 \uc0ac\uc6a9 mmap () \uc544\ub2c8\ub77c malloc () \uc640 \uc9c4\ud589 \uba54\ubaa8\ub9ac \ud560\ub2f9 \uc904\uc5ec \ub2a5\ub960\uc744 \uc800\ud558\uc2dc\ud0a4\ub2e4. \uc18c\uc18d \uc911\uc810 \ucd5c\uc801\ud654 \ub9e4\uac1c \ubcc0\uc218.
\nbulk_insert_buffer_size = 16M #\ub300\ub7c9 \uc0b0\uc785 \ub370\uc774\ud130 \uce90\uc2dc \ud06c\uae30, \ud6a8\uacfc\uc801\uc73c\ub85c \uc0bd\uc785 \ud6a8\uc728\uc744 \ub192\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uae30\ubcf8\uac12\uc740 8M
\ntmp_table_size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 64M #\uba54\ubaa8\ub9ac \uc784\uc2dc \ud14c\uc774\ube14 \ud06c\uae30, \ub9cc\uc57d \ucd08\uacfc \uc774 \uac12, \uc784\uc2dc \ud14c\uc774\ube14 \ub514\uc2a4\ud06c\uc5d0 \uc4f0\uc778 \uac83\uc774\ub2e4
\nmax_heap_table_size\u00a0\u00a0\u00a0\u00a0 = 64M
\n#
\n# * MyISAM
\n#
\n# This replaces the startup script and checks MyISAM tables if needed
\n# the first time they are touched. On error, make copy and try a repair.
\nmyisam_recover\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = BACKUP #\uc790\ub3d9 \uac80\uc0ac\uc640 \uc218\ub9ac \uc548 \uc801\ub2f9\ud788 \ub2eb\ud78c MyISAM \uc2dc\uacc4
\nkey_buffer_size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 256M #\uc778\ub371\uc2a4 \ubc84\ud37c \ud06c\uae30\ub97c \uc9c0\uc815\ud569\ub2c8\ub2e4. \uadf8\uac83\uc740 \uacb0\uc815 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0c9\uc778 \ucc98\ub9ac \uc18d\ub3c4, \ud2b9\ud788 \uc0c9\uc778 \uc77d\uae30 \uc18d\ub3c4, \uba54\ubaa8\ub9ac \uc704\ud574 4G \ub54c \uc124\uc815 \uc744 256M \ub610\ub294 384M
\n#open-files-limit\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 2000 #\ubaa8\ub4e0 \ud504\ub85c\uc138\uc2a4 \ucd5c\ub300 \uc815\ub9d0 \uc5f4\ub9b0 \ud30c\uc77c \ud655\uc778 \ub124\uac00 \uc774\ubbf8 \ub2e4 \uac83\uc774\ub2e4 \uc2dc\uc2a4\ud15c \uc81c\ud55c \uc124\uc815 \ucda9\ubd84\ud55c \ub192\uc740 \uc5f4 \ub300\ub7c9\uc758 \uc2dc\uacc4 \ud544\uc694\ud55c \uc774 \uac12 \uc2e0\uc124 \ud070 \uac83\uc774\ub2e4
\ntable_open_cache\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 400 #\ub9e4\uac1c \ubcc0\uc218 \uc124\uc815 \uce90\uc2dc \uc218 \ud45c. \ubaa8\ub4e0 \uc5f0\uacb0 \ub4e4\uc5b4\uc640, \ub2e4 \uc801\uc5b4\ub3c4 \uc5f4 \ud55c \ud45c \uce90\uc2dc. \uadf8\ub798\uc11c table_cache \ud06c\uae30 \ubc0f \uad00\ub828 \ud55c\ub2e4 max_connections \uc124\uc815. \uc5d0 \ub300\ud574 200 \uac1c # \ubcd1\ub82c \uc2e4\ud589 \uc5f0\uacb0\ud560 \uc218 \uc788\ub3c4\ub85d \ud574\uc57c \uc2dc\uacc4 \uce90\uc2dc \ucd5c\uc18c\ud55c 200 \uacf1\ud558\uae30 N, \uc5ec\uae30 N\uc774 \uc751\uc6a9 \ud504\ub85c\uadf8\ub7a8\uc744 \uc2e4\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4 # \ud55c \uc870\uc778 \ub0b4\uc885 \ucd5c\ub300 \uac2f\uc218. \ub610 \uc544\uc9c1 \ub354 \uc784\uc2dc \ud14c\uc774\ube14 \ubc0f \ud30c\uc77c \uc704\ud574\uc11c \uc77c\ubd80 \ucd94\uac00 \ud30c\uc77c \uc124\uba85\uc790.
\n#\uc774 Mysql \ubc29\ubb38 \ub54c \ud55c \ud45c, \ub9cc\uc57d \uc774 \uc2dc\uacc4\ub294 \uc9c0\uae08 \uce90\uc2dc \ub2e4\uc2dc \ub9cc\ub4dc\ub294 \uc911 \uc774\ubbf8 \uc5f4\ub9ac\ub2e4, \uc740 \ubc14\ub85c \uc811\uadfc\ud560 \uc218 \uce90\uc2dc; \ub9cc\uc57d # \uc544\uc9c1 \uc758\ud574 \uce90\uc2dc, \ud558\uc9c0\ub9cc Mysql \uc2dc\uacc4 \ubc84\ud37c \uc911 \uadf8\ub9ac\uace0 \uacf5\uac04, \uadf8\ub7fc \uc774 \uc2dc\uacc4\ub294 \uadf8\ub0e5 \uc5f4\ub9ac\ub2e4 \uacb0\ucf54 \ub123\uace0 \uc2dc\uacc4 \ub2a6\ucd94\ub2e4 # \ub3c5\ud558\ub2e4 \uc601\uc5ed; \ub9cc\uc57d \uc2dc\uacc4 \uce90\uc2dc \uac00\ub4dd, \uc740 \uc5b4\ub5bb\uac8c \uc77c\uc815\ud55c \uaddc\uce59\uc5d0 \ud604\uc7ac \uc544\uc9c1 \uc4f8 \uc2dc\uacc4 \uc11d\ubc29\ud558\ub2e4., \ub610\ub294 \uc784\uc2dc \ud655\ub300 \uc2dc\uacc4 \uce90\uc2dc \uc628 \ub9e1\uae30\ub2e4, \uc2dc\uacc4 \uce90\uc2dc \uc0ac\uc6a9 \uac83\uc774 \ub354 \ube60\ub974\uac8c \uc811\uadfc\ud560 \uc218 \uc788\ub294 \ud45c \ub0b4\uc6a9\uc744. \uc5bc\uad74\uc774 \ubd89\uc5b4\uc9c0\ub2e4 tables \uc5b4\ub5bb\uac8c # \uce90\uc2dc \ube44\uc6b0\uae30 \ub0b4\uc6a9\uc744 \uc2e4\ud589. \uc77c\ubc18\uc801\uc73c\ub85c, \ubcfc \uc218 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2e4\ud589 \ud53c\ud06c \uc544\uc6cc \uc0c1\ud0dc \uac12 Open_tables \ud1b5\ud574 # \ubc0f Opened_tables , \ud310\ub2e8 \uac83\uc774 \ud544\uc694\ud568\uc744 table_cache \uac12 (\uc911 open_tables \uac83\uc740 # \uc804\uc5d0 \uc5f4 \ud14c\uc774\ube14 \ub420 \uc218\uac00,\u00a0 Opened_tables \uc740 \uc774\ubbf8 \uc5f4 \ud14c\uc774\ube14 \uc218\uac00). \uc989, \ub9cc\uc57d open_tables \uc811\uadfc table_cache \ub54c, \uadf8\ub9ac\uace0 Opened_tables \uc774 \uac12 \uc11c\uc11c\ud788 \uc99d\uac00\ud558\uace0, \uadf8\ub7fc \uace0\ub824\ud574\uc57c \uc99d\uac00 \uc774 # \uac12 \ud06c\uae30 \ub418\uc5c8\ub2e4. \uadf8\ub9ac\uace0 Table_locks_waited \ube44\uad50\uc801 \ub192\uc740 \ub54c \ub3c4 \ud544\uc694 table_cache \uc99d\uac00.
\nmyisam_sort_buffer_size = 1024M #MyISAM \uc2dc\uacc4 \ubcc0\ud654\uac00 \uc788\uc744 \ub54c \ub2e4\uc2dc \uc815\ub82c \ud544\uc694\ud55c \ubc84\ud37c
\nconcurrent_insert\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 2
\nread_buffer_size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 8M #\ud558\ub294 \ub370 MYISAM \uc2dc\uacc4 \uc804 \ud14c\uc774\ube14 \uc2a4\uce94 \ubc84\ud37c \ud06c\uae30, \ub9de\ucd94\ub2e4 \uc9c4\ud589 \uc21c\uc11c \uc2a4\uce94 \uccad\uc744 \ubd84\ubc30 \uac83\uc774\ub2e4 \ud55c \ud310\ub3c5 \ubc84\ud37c, MySql \uc5b4\ub5bb\uac8c \uadf8\uac83\uc744 \uc704\ud574 \ubd84\ubc30 \ud55c\ub3d9\uc548 \uba54\ubaa8\ub9ac \ubc84\ud37c. read_buffer_size \uc81c\uc5b4 \ubcc0\uc218 \uc774 \ubc84\ud37c \ud06c\uae30. \ub9cc\uc57d \uc2dc\uacc4\ub97c \ub9de\ucd94\ub2e4 \uc21c\uc11c \uc2a4\uce94 \uc694\uccad \ub9e4\uc6b0 \uc7a6\ub2e4, \uadf8\ub9ac\uace0 \ub2f9\uc2e0 \uc0dd\uac01 \uc790\uc8fc \uc2a4\uce94 \uc9c4\ud589\uc774 \ub108\ubb34 \ub290\ub9ac\ub2c8 \ud1b5\uacfc\ud560 \uc218 \uc99d\uac00 \uc774 \ubcc0\uc218 \uac12 \ubc0f \uba54\ubaa8\ub9ac \ubc84\ud37c \ud06c\uae30 \uadf8 \uc131\ub2a5 \ud5a5\uc0c1.
\nread_rnd_buffer_size\u00a0\u00a0\u00a0 = 8M #\ubb34\uc791\uc704 \uc77d\uae30 (\uc870\ud68c \uc870\uc791) \ubc84\ud37c \ud06c\uae30. \uc784\uc758 \uc21c\uc11c \ub418\ub294 \uac78\ub85c \ub530\ub77c \uc77d\uc744 \ub54c (\uc608\ub97c \ub4e4\uc5b4 \ub530\ub77c \uc815\ub82c \uc21c\uc11c) \uc744 \ubd84\ubc30 \ud55c \ubb34\uc791\uc704 \uc77d\ub2e4 \uce90\uc2dc \uad6c. \uc9c4\ud589 \uc815\ub82c \uac80\uc0c9 \ud560 \ub54c MySql \uc77c\ub2e8 \uc8fc\uc0ac \ud55c \ubc88 \uc774 \ubc84\ud37c \ud53c\ud558\ub824\uace0 \ub514\uc2a4\ud06c \uac80\uc0c9 \uac80\uc0c9 \uc18d\ub3c4\ub97c \ub192\uc774\ub2e4, \ud544\uc694\ud558\uba74 \ub300\ub7c9\uc758 \ub370\uc774\ud130 \uc815\ub82c \uc815\ub9d0 \uc801\ub2f9\ud788 \ub192\ub2e4 \uc774 \uac12. \ud558\uc9c0\ub9cc MySql \uac83\uc774\ub77c\ub294 \ubaa8\ub4e0 \uace0\uac1d \uc5f0\uacb0 \ubc1c\uae09 \uc774 \ubc84\ud37c \uacf5\uac04, \uadf8\ub798\uc11c \ubc18\ub4dc\uc2dc \uc801\ub2f9\ud788 \uc124\uc815 \uac00\ub2a5\ud55c \ud55c \uc774 \uac12 \ud53c\ud558\ub824\uace0 \uba54\ubaa8\ub9ac \uc500\uc500\uc774\ub294 \ub108\ubb34 \ud06c\ub2e4.
\n#
\n# * Query Cache Configuration
\n#
\n# Cache only tiny result sets, so we can fit more in the query cache.
\nquery_cache_limit\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 512K #\uc624\uc9c1 < \uc774 \uac12 \uacb0\uacfc \ube44\ub85c\uc18c \ub2e4\ub978 \ubc84\ud37c, \ubc30\uce58 \ud55c \ud070 \uacb0\uacfc \uac83\uc774\ub2e4. \ub2e4\ub978 \ubaa8\ub4e0 \uc870\ud68c \uacb0\uacfc \ubaa8\ub450 \ub36e\uc5b4\uc4f0\uae30
\nquery_cache_size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 256M #\uc9c0\uc815\ud55c mysql \uc870\ud68c \ubc84\ud37c \ud06c\uae30, \uc4f8 \ubc84\ud37c select \uacb0\uacfc \ubc0f \ub2e4\uc74c \uac19\uc740 \uc870\ud68c \ub54c \ub2e4\uc2dc \uc2e4\ud589 \ucffc\ub9ac \ub54c\ubb38\uc5d0 \uc9c1\uc811 \ubcf5\uadc0 \uacb0\uacfc Qcache_lowmem_prunes \ud06c\uae30\uc5d0 \ub530\ub77c \uc640 \ubcf4\uae30 \ud604\uc7ac \ubd80\ud558 \ub300\ud574 \ucda9\ubd84\ud55c \ub192\ub2e4, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uae30\ub85d \ud06c\uae30 \ub610\ub294 \uc5c5\ub370\uc774\ud2b8 \uc0dd\uc0b0\ub7c9 \ub610\ud55c \ube44\uad50\uc801 \ud070 \uc2dc\uc2a4\ud15c \uc774 \ubcc0\uc218 \ud560\ub2f9 \uc801\ud569\ud558\uc9c0 \uc54a\ub2e4 \ub108\ubb34 \ud06c\ub2e4. \uadf8\ub9ac\uace0 \ub192\uc740 \uad50\ubd80\ud558\ub2e4, \uc4f0\uae30 \uc591 \ud070 \uc2dc\uc2a4\ud15c, \uac74\uc758 \uadf8 \uc774 \uae30\ub2a5\uc744 \uae08\uc9c0 \ube60\uc9c0\ub2e4. \uc18c\uc18d \uc911\uc810 \ucd5c\uc801\ud654 \uc778\uc790 (\ud648 \ub77c\uc774\ube0c\ub7ec\ub9ac \ucca8\uc0ad \uace0\uce58\ub2e4 -MyISAM)
\n# for more write intensive setups, set to DEMAND or OFF
\n#query_cache_type = DEMAND #\ub9cc\uc57d \ubc00\uc9d1 \uae30\ub85d, query_cahce \uc774\ubbf8 \uc783\uc5b4\ubc84\ub9b0 \uc758\ubbf8, \uadf8\ub798\uc11c OFF \uc704\ud574 \ud544\uc694\ud55c \uc124\uc815
\n#
\n# * Logging and Replication
\n#
\n# Both location gets rotated by the cronjob.
\n# Be aware that this log type is a performance killer.
\n# As of 5.1 you can enable the log at runtime!
\n#general_log_file\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = \/var\/log\/mysql\/mysql.log
\n#general_log\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 1
\n#
\n# Error logging goes to syslog due to \/etc\/mysql\/conf.d\/mysqld_safe_syslog.cnf.
\n#
\n# we do want to know about network errors and such
\nlog_warnings = 2 #\uacbd\uace0 \uc778\uc1c4 \ucd9c\ub825 \uac83\uc774\ub2e4 \uae4c\uc9c0 \uc624\ub958 log \ud30c\uc77c. \ub2c8\uac00 MySQL \uc5b4\ub5a4 \ubb38\uc81c\uc5d0 \ub300\ud574, \ub108\ub294 \ub9c8\ub545\ud788 \uc5f4 \uacbd\uace0 log \ub610\ud55c \uc790\uc138\ud788 \uc2ec\uc0ac \uc624\ub958 \uae30\ub85d, \ucc3e\uc544\ub0b8 \uac00\ub2a5\ud55c \uc774\uc720.
\n#
\n# Enable the slow query log to see queries with especially long duration
\nslow_query_log=1 #\ucc9c\ucc9c\ud788 \uac80\uc0c9 \uae30\ub85d \uc2a4\uc704\uce58
\n#slow_query_log[={0|1}]
\nslow_query_log_file = \/var\/log\/mysql\/mariadb-slow.log #\ucc9c\ucc9c\ud788 \uc870\ud68c \ub85c\uadf8 \ud30c\uc77c
\nlong_query_time = 1 #\ucc9c\ucc9c\ud788 \uc870\ud68c \uc2dc\uac04
\n#log_slow_rate_limit = 1000
\nlog_slow_verbosity = query_plan<\/p>\n

#log-queries-not-using-indexes
\n#log_slow_admin_statements
\n#
\n# The following can be used as easy to replay backup logs or for replication.
\n# note: if you are setting up a replication slave, see README.Debian about
\n#\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 other settings you may need to change.
\n#server-id = 1 #\uc720\uc77c\ud55c \uc11c\ube44\uc2a4 \ud310\ubcc4\ud558\ub2e4 \ubc88\ud638, \uc218\uce58 \uc5d0 1\ubd80\ud130 2^32-1 \uc0ac\uc774, master \ubc0f slave \uc704\uc5d0 \ub2e4 \ud544\uc694 \uc5c6\ub2e4. \ub9cc\uc57d “\uc124\uc815 master-host” \uc758\ud574 \uc124\uc815 \uc54a\uc73c\uba74 \uae30\ubcf8\uac12\uc740 1, \ud558\uc9c0\ub9cc \ubb34\uc2dc \uc774 \uc635\uc158\uc744 MySQL \uc548 \ub85c\uc11c master \ubc1c\ud6a8
\n#report_host = master1
\n#auto_increment_increment = 2
\n#auto_increment_offset = 1
\nlog_bin = \/var\/log\/mysql\/mariadb-bin #\ubc14\uc774\ub108\ub9ac \uae30\ub85d \uae30\ub2a5 \uc5f4\uae30
\nlog_bin_index = \/var\/log\/mysql\/mariadb-bin.index
\n# not fab for performance, but safer
\n#sync_binlog = 1
\nexpire_logs_days = 10
\nmax_binlog_size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 100M
\n# slaves
\n#relay_log = \/var\/log\/mysql\/relay-bin
\n#relay_log_index = \/var\/log\/mysql\/relay-bin.index
\n#relay_log_info_file = \/var\/log\/mysql\/relay-bin.info
\n#log_slave_updates #\uc0ac\uc6a9 \uccb4\uc778 \uc11c\ubc84\uc5d0\uc11c \uad6c\uc870 \ubcf5\uc0ac \ubaa8\ub4dc (A-> B-> c), \ud544\uc694 \ub294 \uc11c\ubc84 B \uc704\uc5d0 \uc5f4 \uc774 \ud56d\ubaa9.\uc774 \uc635\uc158\uc744 \ucf1c \uc5d0\uc11c \uc2a4\ub808\ub4dc \uc704\uc5d0 \ub2e4\uc2dc \ubcf8 \uc5c5\ub370\uc774\ud2b8 \ub85c\uadf8, \uc798\ub77c\ub0b4\uace0 \ubd80\ud130 \uc11c\ubc84 \ubc14\uc774\ub108\ub9ac \ub85c\uadf8 \uae30\ub85d.
\n#read_only #\ub54c\ubb38\uc5d0 slave \uc77d\uae30 \uc804\uc6a9. \uc624\uc9c1 \uc0ac\uc6a9\uc790 \uac00\uc9c4 SUPER \uad8c\ud55c \ubc0f \uc704 slave \uc2a4\ub808\ub4dc \uc218 \uc788\ub294 \uc218\uc815 \ub370\uc774\ud130, \ub108 \uc774 \ud56d\ubaa9\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. \uac00\uc11c \ubcf4\uc99d\uc744 \uc751\uc6a9 \ud504\ub85c\uadf8\ub7a8 \uc758\uc678\uc758 \uc218\uc815 slave \uc544\ub2c8\ub77c master \uc704\uc758 \ub370\uc774\ud130.
\n#
\n# If applications support it, this stricter sql_mode prevents some
\n# mistakes like inserting invalid dates etc.
\n#sql_mode = NO_ENGINE_SUBSTITUTION,TRADITIONAL
\n#
\n# * InnoDB
\n#
\n# InnoDB is enabled by default with a 10MB datafile in \/var\/lib\/mysql\/.
\n# Read the manual for more InnoDB related options. There are many!
\ndefault_storage_engine = InnoDB #\uc0dd\uc131 \ud14c\uc774\ube14 \ub54c \uc0ac\uc6a9\ud560 \uae30\ubcf8 \uc800\uc7a5\uc18c \uc5d4\uc9c4
\n# you can’t just change log file size, requires special procedure
\n#innodb_log_file_size = 50M
\ninnodb_buffer_pool_size = 256M #\uadf8\uac8c Innodb \uc2dc\uacc4 \uc544\uc8fc \uc911\uc694\ud569\ub2c8\ub2e4. Innodb \ube44\ud574 MyISAM \uc2dc\uacc4 \ub300\ud574 \ub354\uc6b1 \ubbfc\uac10\ud55c \ubc84\ud37c. \uc218 MyISAM \uae30\ubcf8 key_buffer_size \uc124\uc815 \ub2e4\uc74c \uc2e4\ud589\ub420 \uc218 \uc788\ub2e4. \ud558\uc9c0\ub9cc Innodb \uae30\ubcf8 innodb_buffer_pool_size \uc124\uc815 \ub2e4\uc74c \uc624\ud788\ub824 \uadf8 \ub2ec\ud33d\uc774 \uac19\ub2e4. Innodb \ub54c\ubb38\uc5d0 \uadf8 \ub370\uc774\ud130 \ubc0f \uc0c9\uc778 \ub2e4 \uce90\uc2dc \uc77c\uc5b4\ub098\uc11c \uc5c6\uc2b5\ub2c8\ub2e4 \ubb3c\ub824\uc8fc\ub2e4 \uc6b4\uc601 \uccb4\uc81c \ub108\ubb34 \ub9ce\uc740 \uba54\ubaa8\ub9ac \uc788\uae30 \ub54c\ubb38\uc5d0 \ub9cc\uc57d \ub9cc \ud544\uc694 Innodb \ub9d0\ub85c \ud558\uba74 \ub3fc. \uadf8\uac83\uc740 \ub192\uc740 \ub2ec\ud55c\ub2e4 70-80% \uac00\uc6a9\uc131 \uba54\ubaa8\ub9ac \uc124\uc815. \uc77c\ubd80 \uc801\uc6a9 key_buffer \uaddc\uce59\uc744 \uc880 \ud55c \ub2c8\uac00 \ub370\uc774\ud130 \uc591 \ud06c\uc9c0 \uc54a\uc744 \ubfd0\ub9cc \uc544\ub2c8\ub77c, \ud3ed\uc99d, \uadf8\ub807\uac8c \ud560 \ud544\uc694\uac00 \uc5c6\ub2e4, \uadf8 innodb_buffer_pool_size \uc124\uc815\uc744 \ub108\ubb34 \ud06c\ub2e4. \uc124\uc815 \ub108\ubb34 \ud070 \ub9c8\ub77c, \uadf8\ub807\uc9c0 \uc54a\uc73c\uba74 \ub54c\ubb38\uc5d0 \ubb3c\ub9ac\uc801 \uba54\ubaa8\ub9ac \uacbd\uc7c1 \uc774\uc5b4\uc9c8 \uc6b4\uc601 \uc2dc\uc2a4\ud15c \u6362\u9875 \ud754\ub4e4\ub9ac\ub2e4. innodb_buffer_pool_size = 6G
\ninnodb_log_buffer_size = 8M #\uc774 \uc778\uc790 \ud655\uc815 \uc4f4 \ub85c\uadf8 \ud30c\uc77c\uc744 \uc0ac\uc6a9\ud560 \uba54\ubaa8\ub9ac \ud06c\uae30 \ub85c M \ub2e8\uc704\ub85c.\ubc84\ud37c \ub354 \ud070 \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\ub2e4. \uadf8\ub7ec\ub098 \uc758\uc678\uc758 \uace0\uc7a5\uc73c\ub85c \uc9c0\uc6cc\uc9c8 \uac83\uc785\ub2c8\ub2e4 \ub370\uc774\ud130 \ub54c\ubb38\uc5d0 \uae30\ubcf8\uc801\uc73c\ub85c \ucd08\ub2f9 \ub2e4 \uc0c8\ub85c \ud55c \ubc88 \ud544\uc694\uc5c6\uc5b4\uc694 \ub2e4\uc591\ud558\uae30 \uac12 \uc124\uc815 \ub108\ubb34 \ud070 (\uc2ec\uc9c0\uc5b4 \uae34 \ubb38\uc81c\uc5d0 \ub300\ud574 \uacbd\uc6b0) MySQL \uac1c\ubc1c\uc790 \uac74\uc758\ub97c \uc124\uc815 \uc744 1 \uff0d 8M \uc0ac\uc774\uc5d0
\ninnodb_file_per_table = 1
\ninnodb_open_files = 400
\ninnodb_io_capacity = 400
\ninnodb_flush_method = O_DIRECT #InnoDB \ub370 \uc0c8\ub85c \uace0\uce68 \uae30\ub85d \ubc29\ubc95\uc740 \uc2dc\uacc4 \uacf5\uac04 \ub298 \ub354\ube14 \uae30\ub85d \uacbd\uc2e0 \ubc29\ubc95\uc744 \uae30\ubcf8\uac12 ‘fdatasync “, \ub2e4\ub978 \ud558\ub098\ub294 “O_DSYNC”
\n#
\n# * Security Features
\n#
\n# Read the manual, too, if you want chroot!
\n# chroot = \/var\/lib\/mysql\/
\n#
\n# For generating SSL certificates I recommend the OpenSSL GUI “tinyca”.
\n#
\n# ssl-ca=\/etc\/mysql\/cacert.pem
\n# ssl-cert=\/etc\/mysql\/server-cert.pem
\n# ssl-key=\/etc\/mysql\/server-key.pem<\/p>\n

[mysqldump]
\nquick #\uadf8\ub9cc \ub294 \uba54\ubaa8\ub9ac \uc911 \uc804\uccb4 \uacb0\uacfc \ub514\uc2a4\ud06c \uce90\uc2dc. \uc4f0\uae30 \uc804\uc5d0 \uc5ec\uae30\uc11c \ub0b4\ubcf4\ub0b4\uae30 \ub9e4\uc6b0 \ud070 \ud45c \ub54c \uc774 \uc77c\uc744 \ud55c\ub2e4
\nquote-names
\nmax_allowed_packet = 16M #\uc778\ud130\ub137 \uc124\uc815 \uc804\uc1a1 \uc911 \ud55c \ubc88 \uc218 \uc788\ub294 \ucd5c\ub300 \uba54\uc2dc\uc9c0 \uc804\uc1a1 \uc2dc\uc2a4\ud15c \uae30\ubcf8\uac12 1MB, \ucd5c\ub300 \uc218 1G<\/p>\n

[mysql]
\n#no-auto-rehash # faster start of mysql but no tab completition
\ndefault-character-set = utf8mb4<\/p>\n

[isamchk]
\nkey_buffer = 16M<\/p>\n

#
\n# * IMPORTANT: Additional settings that can override those from this file!
\n#\u00a0\u00a0 The files must end with ‘.cnf’, otherwise they’ll be ignored.
\n#
\n!includedir \/etc\/mysql\/conf.d\/<\/p>\n","protected":false},"excerpt":{"rendered":"

http:\/\/www.programkr.com\/blog\/MUDM5ADMwYT2.html     # MariaDB database server configuration file. # # You can copy this file to one of: # – “\/etc\/mysql\/my.cnf” to set global options, # – “~\/.my.cnf” to set user-specific options. # # One can use all long options that the program supports. # Run program with –help to get a list of available options and with # –print-defaults to see which it would actually understand and use. # # For explanations see # http:\/\/dev.mysql.com\/doc\/mysql\/en\/server-system-variables.html # This will be passed to all mysql clients # It has been reported that passwords should be enclosed with ticks\/quotes # escpecially if they contain “#” chars… # Remember to edit \/etc\/mysql\/debian.cnf when changing the socket location. [client] port = 3306 #\ud074\ub77c\uc774\uc5b8\ud2b8 \uc5f0\uacb0 \ud1b5\uc2e0 \ud3ec\ud2b8 socket = \/var\/run\/mysqld\/mysqld.sock #socket \ud30c\uc77c linux\/unix \uc2dc\uc2a4\ud15c \ud2b9\uc720\uc758, \uc0ac\uc6a9\uc790 \uc774 \ud658\uacbd \uc544\ub798\uc5d0\uc11c \ud074\ub77c\uc774\uc5b8\ud2b8 \uc5f0\uacb0 \ub3fc, \uc548 \ud1b5\ud574 tcp\/ip \ub124\ud2b8\uc6cc\ud06c \uc54a\uace0 \uc9c1\uc811 \uc0ac\uc6a9 socket \ud30c\uc77c \uc5f0\uacb0 default-character-set = utf8mb4 #\ud074\ub77c\uc774\uc5b8\ud2b8 \uae30\ubcf8 \uc5f0\uacb0 \ubb38\uc790 \uc9d1\ud569 \uc9d1\ud569, \ub9cc\uc57d \ucef4\ud30c\uc77c \uc124\uce58 \ub54c \uc774\ubbf8 \uc9c0\uc815\ub41c \uc54a\uc73c\uba74 \uc548 \uc368 # Here is entries for some specific programs # The following values assume you have at least 32M ram # This was formally known as [safe_mysqld]. Both versions are currently parsed. [mysqld_safe] socket = […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"ngg_post_thumbnail":0,"spay_email":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[5],"tags":[],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5q9Zn-b5","jetpack-related-posts":[{"id":694,"url":"https:\/\/blog.box.kr\/?p=694","url_meta":{"origin":687,"position":0},"title":"* APM\uc124\uce58","date":"2015-04-15","format":false,"excerpt":"1. \uc124\uc815 \ubc29\ud654\ubcbd \ucf1c\uc838 80 \ud3ec\ud2b8, 3306 \ud3ec\ud2b8 vi \/etc\/sysconfig\/iptables -A INPUT -m state --state NEW -m tcp -p tcp --dport 80 -j ACCEPT -A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT \/etc\/init.d\/iptables restart #\ub9c8\uc9c0\ub9c9\uc73c\ub85c \ub2e4\uc2dc \ubc29\ud654\ubcbd \ub54c\ubb38\uc5d0 \uc124\uc815\uc774 \uc801\uc6a9\ub429\ub2c8\ub2e4 2. \ub2eb\uae30SELINUX vi \/etc\/selinux\/config\u2026","rel":"","context":"In "\uae30\uc220\uc790\ub8cc"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":801,"url":"https:\/\/blog.box.kr\/?p=801","url_meta":{"origin":687,"position":1},"title":"[scrap] MySQL Replication \uc124\uc815\uacfc \uba87 \uac00\uc9c0 \ud14c\uc2a4\ud2b8","date":"2015-05-18","format":false,"excerpt":"http:\/\/blog.hibrainapps.net\/130 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 MySQL\uc744 DB\ub85c \uc0ac\uc6a9\ud558\uba74\uc11c \uc11c\ubc84\uc758 \ubd80\ud558 \ubd84\uc0b0\uc744 \uc704\ud55c \ubc29\ubc95 \uc911 \ud558\ub098\ub85c Replication \uc744 \uc0ac\uc6a9\ud55c\ub2e4. Replication \uc740 Master \ud558\ub098\uc5d0 n\uac1c\uc758 Slave\ub85c \uc9c0\uc815\uc774 \uac00\ub2a5\ud558\ub2e4. Slave\ub294 \ub2e4\uc2dc Master \uc5ed\ud560\uc744 \ud560\uc218 \uc788\uc73c\uba70 \uc5ed\uc2dc \ub610 \ub2e4\ub978 n\uac1c\uc758 Slave\ub97c \uc9c0\uc815\ud560 \uc218 \uc788\ub2e4. \ubd80\ud558 \ubd84\uc0b0\uc758 \ud6a8\uacfc\ub294 inser,update \ub4f1 \ubcc0\uacbd\uacfc \uad00\ub828\ub41c \ubaa8\ub4e0 \uc791\uc5c5\uc740\u2026","rel":"","context":"In "DB\uad00\ub828"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":746,"url":"https:\/\/blog.box.kr\/?p=746","url_meta":{"origin":687,"position":2},"title":"How to find MySQL binary logs, error logs, temporary files?","date":"2015-05-08","format":false,"excerpt":"Have you ever spent a lot of time trying to locate where MySQL keeps some file? Here is a quick way to find all this information in one place. The obvious way is through examining database options in\u00a0my.cnf\u00a0or looking at the output of\u00a0SHOW GLOBAL VARIABLES. But not every path may\u2026","rel":"","context":"In "DB\uad00\ub828"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":803,"url":"https:\/\/blog.box.kr\/?p=803","url_meta":{"origin":687,"position":3},"title":"[scrap]mysqldump \uc635\uc158 \ubc0f \uc0ac\uc6a9\ubc95","date":"2015-05-18","format":false,"excerpt":"http:\/\/egloos.zum.com\/simonshin\/v\/2247509 \u00a0 1. mysqldump \uc635\uc158 \uc911 binary log \uc758 \ud3ec\uc9c0\uc158 \uc815\ubcf4 \uac19\uc774 dump \ud558\uae30 \/usr\/local\/mysql\/bin\/mysqldump -uroot -p --master-data=2\u00a0 > \/data\/\u2026\/backup.sql \uc774 \uba85\ub839\uc5b4 \uc911\uc5d0\uc11c \"--master-data=2\" \uc635\uc158\uc744 \uc8fc\uac8c \ub418\uba74 \ub364\ud504 \uc2dc\uc810\uc758 binary log\uc758 \ud3ec\uc9c0\uc158 \uc815\ubcf4\uac00 \uac19\uc774 Dump \ub418\uac8c \ub41c\ub2e4. Dump\ub41c \ud30c\uc77c\uc744 \uc5d0\ub514\ud130\ub85c \uc5f4\uc5b4\ubcf4\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \ub0b4\uc6a9\uc774 \ub098\uc628\ub2e4. 2. Table Lock \uac78\uae30 FLUSH\u2026","rel":"","context":"In "DB\uad00\ub828"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":807,"url":"https:\/\/blog.box.kr\/?p=807","url_meta":{"origin":687,"position":4},"title":"[scrap] mysql – dual master replication","date":"2015-05-18","format":false,"excerpt":"http:\/\/simonshin.egloos.com\/2247518 \/etc\/my.cnf \ud30c\uc77c \ub0b4\uc6a9 Below is what needs to be added to the configuration for Server A: server-id = 1 replicate-same-server-id = 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/\uc2ac\ub808\uc774\ube0c \uc11c\ubc84\uc5d0\uc11c \uc0ac\uc6a9\ub428. \uc77c\ubc18\uc801\uc73c\ub85c\ub294 \ub514\ud3f4\ud2b8 \uc124\uc815 \uac12\uc778 0\uc744 \uc0ac\uc6a9\ud558\ub294\ub370, \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/\uc774 \uac12\uc740 \uc21c\ud658 \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158(circular replication)\uc5d0 \uc758\ud55c \ubb34\ud55c \ub8e8\ud504\ub97c \ubc29\uc9c0\ud569\ub2c8\ub2e4. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/\uc774 \uac12\uc744 1\ub85c \uc124\uc815\ud55c\ub2e4\uba74, \uc2ac\ub808\uc774\ube0c\ub294 \uc790\uc2e0\uc758 \uc11c\ubc84\u2026","rel":"","context":"In "DB\uad00\ub828"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":673,"url":"https:\/\/blog.box.kr\/?p=673","url_meta":{"origin":687,"position":5},"title":"[Linux]Install MariaDB 10.0 on CentOS linux using YUM command","date":"2015-04-13","format":false,"excerpt":"Adding the MariaDB YUM Repository We highly recommended to use custom\u00a0MariaDB YUM\u00a0repository to install. Create a repo file under\/etc\/yum.repos.d\/MariaDB.repo, Copy and paste following line under MariaDB repository: Add repository on Centos 6.5 32-bit # vi \/etc\/yum.repos.d\/MariaDB.repo and paste following line: # MariaDB 10.0 CentOS repository list - created 2014-03-12 12:46\u2026","rel":"","context":"In "\uae30\uc220\uc790\ub8cc"","img":{"alt_text":"Connect to MariaDB 10.0","src":"https:\/\/i0.wp.com\/lintut.com\/wp-content\/uploads\/2014\/03\/639x352xScreenshot-from-2014-03-12-141810.png.pagespeed.ic.DHQ-h4Kmpx.png?resize=350%2C200","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/687"}],"collection":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=687"}],"version-history":[{"count":0,"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/687\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=687"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=687"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=687"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}