반응형
MariaDB [(none)]> status
--------------
mysql Ver 15.1 Distrib 10.1.28-MariaDB, for Linux (x86_64) using readline 5.1
Connection id: 62
Current database:
Current user: otdev@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server: MariaDB
Server version: 10.1.28-MariaDB MariaDB Server
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 16 hours 20 min 0 sec
Threads: 20 Questions: 1698 Slow queries: 0 Opens: 46 Flush tables: 1 Open tables: 36 Queries per second avg: 0.028
--------------
/etc/my.cnf 를 수정하자
[mysqld]
collation-server = utf8_unicode_ci
character-set-server = utf8
skip-character-set-client-handshake
service mysql restart
MariaDB [(none)]> status
--------------
mysql Ver 15.1 Distrib 10.1.28-MariaDB, for Linux (x86_64) using readline 5.1
Connection id: 2
Current database:
Current user: otdev@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server: MariaDB
Server version: 10.1.28-MariaDB MariaDB Server
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 9 sec
Threads: 1 Questions: 4 Slow queries: 0 Opens: 17 Flush tables: 1 Open tabl es: 11 Queries per second avg: 0.444
--------------
반응형
'Develope > DataBase' 카테고리의 다른 글
| [SQL] 쿼리 튜닝 : select 문 안에 서브쿼리 (2) | 2017.12.01 |
|---|---|
| [Mybatis] result type이 HashMap일 때 Null 처리 (4) | 2017.11.14 |
| [Mybatis/MariaDB] foreach 구문을 이용해서 Insert 대량 삽입하기 (6) | 2017.11.10 |
| [Mysql] index 강제로 태우기 (4) | 2017.11.03 |
| [Mysql] Select할 때 String 을 Date로 표현하기, 포맷 변환 (2) | 2017.11.02 |