1. \ub290\ub9b0 \ucffc\ub9ac \ud655\uc778<\/p>\n
my.cnf \uc5d0 \ub290\ub9b0\ucffc\ub9ac\uc5d0 \ub300\ud55c \ub85c\uadf8 \ub0a8\uae30\uae30<\/p>\n
[mysqld] \uc139\uc158\uc5d0 \uc544\ub798\uc758 \ub0b4\uc6a9\uc744 \ucd94\uac00<\/p>\n
log-slow-queries = \/var\/log\/mysql\/mysql-slow.log \/\/ slow \ucffc\ub9ac \ub85c\uadf8\ub97c \ub0a8\uae38 \uc704\uce58\r\nlong_query_time = 1 \/\/ \ub290\ub9b0 \ucffc\ub9ac\uc758 \uae30\uc900(\ucd08)\r\n<\/pre>\n2. \ub290\ub9b0 \ucffc\ub9ac\ub97c \ud655\uc778\ud558\uba74, \ud574\ub2f9 \ucffc\ub9ac\uc758 \ubd84\uc11d<\/p>\n
\ucffc\ub9ac \ud50c\ub79c\uc744 \ud655\uc778\ud574\uc11c index \ub97c \ud0c0\ub294\uc9c0, \uc544\ub2cc\uc9c0 \ud655\uc778<\/p>\n
desc select * from table;\r\nexplain select * from table;<\/pre>\n\ud574\ub2f9 \ud14c\uc774\ube14\uc758 index \uc815\ubcf4 \ud655\uc778<\/p>\n
SHOW INDEX FROM table;<\/pre>\n\ucffc\ub9ac\uc758 \uc870\uac74\uacfc \ud604\uc7ac \uc801\uc6a9\ub41c index \uac00 \uc801\uc808\ud55c\uc9c0 \ud310\ub2e8.<\/p>\n
3. index \uc218\uc815<\/p>\n
index \ucd94\uac00<\/p>\n
ALTER TABLE contents add index idx_column (column);<\/pre>\nindex \uc0ad\uc81c<\/p>\n
ALTER TABLE table_name DROP INDEX index_name (column_name);<\/pre>\n4. \ubcc4 \uc774\uc0c1\uc774 \uc5c6\ub2e4\uba74, index \ub2e8\ud3b8\ud654\uc77c \uac00\ub2a5\uc131\ub3c4 \uc788\uc73c\ubbc0\ub85c index \uc815\ub9ac<\/p>\n
cd mysql\/var\/\ub514\ube44\uba85
\nmyisamchk -R1 *
\noptions
\n-a : \ud769\uc5b4\uc9c4 \uc778\ub371\uc2a4\ub97c \ubaa8\uc544 \uc18d\ub3c4 \ud5a5\uc0c1
\n-S : \uc778\ub371\uc2a4\ud2b8\ub9ac \uc18c\ud305 \uac80\uc0c9 \uc18d\ub3c4 \ud5a5\uc0c1
\n-R : \uc778\ub371\uc2a4 \uae30\uc900 \ub808\ucf54\ub4dc \uc815\ub82c \uc18d\ub3c4 \ud5a5\uc0c1<\/p>\n5. mysql DB\ubcc4 \uc0ac\uc6a9\ub7c9\ub3c4 \uccb4\ud06c \ud574\ubcf4\uc790<\/p>\n
SELECT information_schema.tables.table_schema, \r\n Sum(data_length) \r\nFROM information_schema.tables \r\nGROUP BY information_schema.tables.table_schema <\/pre>\n","protected":false},"excerpt":{"rendered":"1. \ub290\ub9b0 \ucffc\ub9ac \ud655\uc778 my.cnf \uc5d0 \ub290\ub9b0\ucffc\ub9ac\uc5d0 \ub300\ud55c \ub85c\uadf8 \ub0a8\uae30\uae30 [mysqld] \uc139\uc158\uc5d0 \uc544\ub798\uc758 \ub0b4\uc6a9\uc744 \ucd94\uac00 log-slow-queries = \/var\/log\/mysql\/mysql-slow.log \/\/ slow \ucffc\ub9ac \ub85c\uadf8\ub97c \ub0a8\uae38 \uc704\uce58 long_query_time = 1 \/\/ \ub290\ub9b0 \ucffc\ub9ac\uc758 \uae30\uc900(\ucd08) 2. \ub290\ub9b0 \ucffc\ub9ac\ub97c \ud655\uc778\ud558\uba74, \ud574\ub2f9 \ucffc\ub9ac\uc758 \ubd84\uc11d \ucffc\ub9ac \ud50c\ub79c\uc744 … Continue reading