Programing 2016.12.02 14:15 Posted by 애플자라

눈이 침침해서 글자크기 변경방법 찾음


Window > Preferences > General > Colors and Fonts > Basic > Text Font



[Jenkins]Email Extension Plugin 모니터링

Programing 2016.11.25 10:06 Posted by 애플자라

Email Extension Plugin
 - This plugin is a replacement for Jenkins's email publisher




[SKT] 부가통화 상세 안내(band데이터요금)

Board 2016.11.22 10:11 Posted by 애플자라

부가통화 상세 안내(band데이터요금)

1. 부가통화란?
- 부가통화는 1599 등 전국 대표번호, 050 등 안심번호, 060/030 등 번호로 이용하는 것으로 band데이터 요금제의 집전화/이동전화 무제한에 포함되지 않으며, 각 요금제의 별도 제공량 내에서 이용하실 수 있습니다.
2. 각 요금제별 부가통화 및 영상통화 기본 제공량
ㅇ band 데이터 세이브/band 데이터 1.2G/band 데이터 2.2G/band 데이터 3.5G 요금제 ☞ 50분(부가통화 + 영상통화)
ㅇ band 데이터 6.5G/band 데이터 퍼펙트/T 시그니처 Classic/T 시그니처 Master(구 요금제 포함) ☞ 300분(부가통화 + 영상통화)
ㅇ 부가통화 이용 시 1초당 1초 차감, 영상통화 이용 시 1초당 1.66초 차감, 기본 제공량 초과 시 부가통화 1초당 1.98원, 영상통화 1초당 3.3원 부과(부가세 포함)
3. 부가통화 상세 국번
- 전국대표번호서비스(1644,1588,1566,1600,1688,1599,1544,1661,1877,1577 등), 050으로 시작하는 국번(050, 0505, 0506 등), 정보제공서비스(060), 주파수공용통신망서비스(0130), 1666, 011-200, 011-700, 지역번호+153, 지역번호+141, 지역번호+700 등(단, KT 114로 안내받은 전화로 바로 연결시 발생하는 정보이용료/통화료은 무료통화에서 차감되지 않고 유료 과금)
※ 유선통화 국번은 유선 일반전화 02/031/032/070 등이 해당

[Windows]윈도우 Tail

Tips 2016.11.15 14:03 Posted by 애플자라





[MYSQL]DB 튜닝(innodb / my.cnf)

Programing 2016.11.14 16:33 Posted by 애플자라

### DB셋팅 / 2016.11.14

# Set the SQL mode to strict


# The maximum amount of concurrent sessions the MySQL server will
# allow. One of these connections will be reserved for a user with
# SUPER privileges to allow the administrator to login even if the
# connection limit has been reached.


# Query cache is used to cache SELECT results 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.


# The number of open tables for all threads. Increasing this value
# increases the number of file descriptors that mysqld requires.
# Therefore you have to make sure to set the amount of open files
# allowed to at least 4096 in the variable "open-files-limit" in
# section [mysqld_safe]


# Maximum size for internal (in-memory) temporary tables. If a table
# grows larger than this value, it is automatically converted to disk
# based table This limitation is for a single table. There can be many
# of them.

# 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.  This greatly reduces
# the amount of thread creations 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.)


#*** MyISAM Specific options

# The maximum size of the temporary file MySQL is allowed to use while
# recreating the index (during REPAIR, ALTER TABLE or LOAD DATA INFILE.
# If the file-size would be bigger than this, the index will be created
# through the key cache (which is slower).


# If the temporary file used for fast index creation would be bigger
# than using the key cache by the amount specified here, then prefer the
# key cache method.  This is mainly used to force long character keys in
# large tables to use the slower key cache method to create the index.


# Size of the Key Buffer, used to cache index blocks for MyISAM tables.
# Do not set it larger than 30% of your available memory, as some memory
# is also required by the OS to cache rows. Even if you're not using
# MyISAM tables, you should still set it to 8-64M as it will also be
# used for internal temporary disk tables.


# Size of the buffer used for doing full table scans of MyISAM tables.
# Allocated per thread, if a full scan is needed.


# This buffer is allocated when MySQL needs to rebuild the index in
# REPAIR, OPTIMZE, ALTER table statements as well as in LOAD DATA INFILE
# into an empty table. It is allocated per thread so be careful with
# large settings.


# Additional memory pool that is used by InnoDB to store metadata
# information.  If InnoDB requires more memory for this purpose it will
# start to allocate it from the OS.  As this is fast enough on most
# recent operating systems, you normally do not need to change this
# value. SHOW INNODB STATUS will display the current amount used.


# If set to 1, InnoDB will flush (fsync) the transaction logs to the
# disk at each commit, which offers full ACID behavior. If you are
# willing to compromise this safety, and you are running small
# transactions, you may set this to 0 or 2 to reduce disk I/O to the
# logs. Value 0 means that the log is only written to the log file and
# the log file flushed to disk approximately once per second. Value 2
# means the log is written to the log file at each commit, but the log
# file is only flushed to disk approximately once per second.


# The size of the buffer InnoDB uses for buffering log data. As soon as
# it is full, InnoDB will have to flush it to disk. As it is flushed
# once per second anyway, it does not make sense to have it very large
# (even with long transactions).


# 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 you may set this
# parameter up to 80% of the machine physical memory size. Do not set it
# too large, though, because competition of the physical memory may
# cause paging in the operating system.  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.


# Size of each log file in a log group. You should set the combined size
# of log files to about 25%-100% of your buffer pool size to avoid
# unneeded buffer pool flush activity on log file overwrite. However,
# note that a larger logfile size will increase the time needed for the
# recovery process.


# Number of threads allowed inside the InnoDB kernel. The optimal value
# depends highly on the application, hardware as well as the OS
# scheduler properties. A too high value may lead to thread thrashing.

innodb_lock_wait_timeout = 1200


[MYSQL]DB 로그인(멀티인스턴스)

Database 2016.11.14 08:39 Posted by 애플자라



/data1/mysql1/bin/mysql -uroot -p --socket=/tmp/mysql1-3306.sock
/data2/mysql2/bin/mysql -uroot -p --socket=/tmp/mysql2-3307.sock
/data3/mysql3/bin/mysql -uroot -p --socket=/tmp/mysql3-3308.sock

'Database' 카테고리의 다른 글

[MYSQL]원격지 SELECT  (0) 2017.02.07
[MYSQL]지니안NAC 저장장치 정보 쿼리  (0) 2017.01.23
[MYSQL]DB 로그인(멀티인스턴스)  (0) 2016.11.14
[MYSQL]LINUX 시작서비스등록  (0) 2016.11.14
[MYSQL]사용자 계정생성  (0) 2016.11.11
[MYSQL]패스워드 변경  (0) 2016.11.11

[MYSQL]LINUX 시작서비스등록

Database 2016.11.14 08:36 Posted by 애플자라


cp mysql.server /etc/init.d/mysqld1

[Bluetooth]플랜트로닉스 mite15(익스플로러 500)

Board 2016.11.12 13:20 Posted by 애플자라



페어링 - 요기를 꾸욱 눌러주세요!!
그럼 플래시가 파랑, 빨강으로 변하더니

깜빡 깜빡거림


잽사게 핸드폰을 꺼내 블루투스를 활성화시키세요!!!

그럼 "plt_e500"을 선택하면 끝!

이렇게 하면 여러개의 기기에 블루투스가 연결가능하다고 하네요


출처 - http://blog.naver.com/applepiejin/220573301083




내꺼는 이거임





Linux 2016.11.11 23:25 Posted by 애플자라

-bash-4.1$ netstat -atnp
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name  
tcp        0      0       *                   LISTEN      -                  
tcp        0      0        *                   LISTEN      -                  
tcp        0      0     *                   LISTEN      -                  
tcp        0      0     *                   LISTEN      -                   
tcp        0      0 :::55138                    :::*                        LISTEN      -                  
tcp        0      0 :::3306                    :::*                        LISTEN      -                  
tcp        0      0 :::111                      :::*                        LISTEN      -                  
tcp        0      0 :::22                       :::*                        LISTEN      -                  
tcp        0      0 :::23                       :::*                        LISTEN      -                  
tcp        0      0 ::1:631                     :::*                        LISTEN      -


'Linux' 카테고리의 다른 글

리눅스 이더넷 맥 주소 확인  (0) 2017.02.24
[shell] Time format  (0) 2017.02.01
LISTEN Port확인  (0) 2016.11.11
[Linux]시스템 시간관리하기(hwclock)  (0) 2016.11.11
[Linux]rsync 복사  (0) 2016.11.01
강제 umount 방법 (umount : device is busy 발생시)  (0) 2016.08.05

[MYSQL]사용자 계정생성

Database 2016.11.11 19:39 Posted by 애플자라

[5.7 이전 버젼]
update mysql.user set password=password('새로운패스워드') where user='root';

[5.7 이후 버젼]
update user set authentication_string=password('새로운패스워드') where user='root';

(5.7 이후 버젼에는 password 필드가 존재하지 않는다.)
설정 후 MySQL 접속 후 명령을 실행하게 되면 다음과 같은 장애가 발생한다.

mysql> SELECT 1;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

위와 같은 오류가 발생하는 경우 다음과 같은 명령어를 실행한다.

mysql> SET PASSWORD = PASSWORD('새로운패스워드');
Query OK, 0 rows affected (0.01 sec)

mysql> SELECT 1;
| 1 |
| 1 |


'Database' 카테고리의 다른 글

[MYSQL]DB 로그인(멀티인스턴스)  (0) 2016.11.14
[MYSQL]LINUX 시작서비스등록  (0) 2016.11.14
[MYSQL]사용자 계정생성  (0) 2016.11.11
[MYSQL]패스워드 변경  (0) 2016.11.11
[MYSQL]multiple instances(mysqld_multi)  (0) 2016.11.08
[MYSQL]ROWNUM  (0) 2016.10.21