목록분류 전체보기 (24)
내블로그
selinux 설정변경(해제) 설정파일 : /etc/selinux/config SELINUX=enforcing => SELINUX=disabled 패키지 설치 yum -y update yum -y install net-tools rdate yum -y install httpd yum -y install php php-pear php-cgi php-common php-mbstring php-snmp php-gd php-xml php-mysql php-gettext php-bcmath yum -y install mariadb-server mariadb php.ini 설정 설정파일 : /etc/php.ini date.timezone = Asia/seoul 서비스 설정 systemctl enable httpd ..
#PHP $isMobile = 0; if (preg_match("/Android|BlackBerry|iPhone|iPad|iPod|Opera Mini|IEMobile/i", $_SERVER['HTTP_USER_AGENT'])) { $isMobile = 1; } #JavaScript var isMobile = { Android: function() { return navigator.userAgent.match(/Android/i); }, BlackBerry: function() { return navigator.userAgent.match(/BlackBerry/i); }, iOS: function() { return navigator.userAgent.match(/iPhone|iPad|iPod/i); },..
openssl x509 -noout -dates -in 인증서파일
use File::stat; $timestamp = stat(파일명)->mtime;
log-bin 파일이 무한전 늘어나는 문제로 필요없는 log-bin 파일은 정리해주도록 하자.PURGE MASTER LOGS BEFORE DATE_SUB(CURRENT_DATE, INTERVAL 30 DAY);
#!/usr/bin/perluse strict;use warnings;use Time::HiRes qw(ITIMER_REAL setitimer); $SIG{ALRM} = sub {};setitimer(ITIMER_REAL, 0.1, 3);while (1) { sleep ; print time()." : Main Loop\n";}
1. 기본 테이블 크기 확인 SELECT table_name, table_rows, round(data_length/(1024*1024),2) as 'DATA_SIZE(MB)', round(index_length/(1024*1024),2) as 'INDEX_SIZE(MB)'FROM information_schema.TABLESWHERE table_schema = '데이타베이스명'; 2. 파티셔닝된 테이블 파티션별 크기 확인SELECT table_name , partition_name , round(data_length/(1024*1024),2) as 'DATA_SIZE(MB)' , round(index_length/(1024*1024),2) as 'INDEX_SIZE(MB)'FROM INFORMATION..
1. CREATE TABLE CREATE TABLE `data_table` ( `idnr` BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT 'idnr', `send_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`idnr`, `send_time`),)COLLATE='utf8_general_ci'ENGINE=InnoDB DEFAULT CHARSET=utf8PARTITION BY RANGE (YEAR(`send_time`)*100+MONTH(`send_time`))( PARTITION p201611 VALUES LESS THAN (201611) ENGINE = InnoDB, PARTITION p201612 VAL..
1. 테이블 생성 CREATE TABLE `json` (`json` BLOB NULL)COLLATE='utf8_general_ci'ENGINE=InoDB; 2. 데이터 삽입(COLUMN_CREATE)INSERT INTO json VALUES (COLUMN_CREATE('age', 22, 'name', 'kim'));INSERT INTO json VALUES (COLUMN_CREATE('age', 11, 'name', 'heo'));INSERT INTO json VALUES (COLUMN_CREATE('color', 'blue', 'size', 'XL'));INSERT INTO json VALUES (COLUMN_CREATE('color', 'black', 'price', 500)); 3. 데이터 가져오기..