DB (mysql) ¼³Á¤ º¯°æ
DB¸¦ ¼¹ö¿¡ ¼³Ä¡ ÀÌÈÄ,
¼³Á¤À» °¡º±°Ô ÀÌ°ÅÀú°Å ¹Ù²ÜÀÏÀÌ ÀÖ´Ù
/etc/mysql/my.cnf ³ª
/etc/my.cnf ¿¡ º¸Åë ÀÖ´Ù.
ÇØ´ç ÆÄÀÏÀ» vi·Î ¿¾î¼ ÆíÁýÇؼ ÀúÀåÇѵÚ,
DB¸¦ Àç±âµ¿ ÇϸéµÈ´Ù.
$ vi /etc/my.cnf |
1. ÀÎÄÚµù : UTF8
°¡Àå ±âº»ÀûÀº ÀÎÄÚµù ¹æ½ÄÀ» utf8·Î ¹Ù²Ù´Â °ÍÀÌ´Ù
[mysql] default-character-set = utf8
[mysqld] character-set-client-handshake=FALSE init_connect="SET collation_connection = utf8_general_ci" init_connect="SET NAMES utf8" character-set-server = utf8 collation-server = utf8_general_ci
[client] default-character-set = utf8 |
DB Àç±âµ¿
$ service mysqld restart |
2. query ´ë¼Ò¹®ÀÚ ±¸ºÐ ¾ÈÇÔ
±×¸®°í º¸Åë ¸¹ÀÌ ÇÏ´Â°Ô query³¯·ÈÀ»¶§ ´ë¼Ò¹®ÀÚ¸¦ ±¸ºÐ ¾ÈÇϵµ·Ï ¼³Á¤ÇØ ÁÖ´Â °ÍÀÌ´Ù.
show variables like 'lower_case_table_names'; |
´ÙÀ½ Äõ¸®·Î È®ÀÎ Çغ¸¸é
0ÀÏ °æ¿ì, ´ë¼Ò¹®ÀÚ ±¸ºÐÇÏ°í
1ÀÏ °æ¿ì, ´ë¼Ò¹®ÀÚ ±¸ºÐÀ» ¾ÈÇÑ´Ù ±×·¡¼
[mysqld] ¿¡ Ãß°¡ ÇѵÚ, Àç±âµ¿ ÇØÁØ´Ù~
[mysql] default-character-set = utf8
[mysqld] character-set-client-handshake=FALSE init_connect="SET collation_connection = utf8_general_ci" init_connect="SET NAMES utf8" character-set-server = utf8 collation-server = utf8_general_ci lower_case_table_names=1
[client] default-character-set = utf8 |
3. DB max connection
SHOW VARIABLES LIKE '%wait_timeout%'; SHOW VARIABLES LIKE '%max_connection%'; // Á¢¼Ó¼ö |
4. DB Àç±âµ¿ ¾øÀÌ º¯¼ö°ª º¯°æÇϱâ
set global º¯°æ°ª; ex) setl global lower_case_table_names=1; |
Âü°í
http://wincloud.link/pages/viewpage.action?pageId=9469960
Ãâó: https://hyeonyeee.tistory.com/58 [hyeoneee's blog]
Ãâó: https://hyeonyeee.tistory.com/58 [hyeoneee's blog]