No Image

USE Method: Linux Performance Checklist

2016-04-05 KENNETH 0

출처 : http://www.brendangregg.com/USEmethod/use-linux.html   USE Method: Linux Performance Checklist The USE Method provides a strategy for performing a complete check of system health, identifying common bottlenecks and errors. For each system resource, metrics for utilization, saturation and errors are identified and checked. Any issues discovered are then investigated using further strategies. This is an example USE-based metric list for Linux operating systems (eg, Ubuntu, CentOS, Fedora). This is primarily intended for system administrators of the physical systems, who are using command line tools. Some of these metrics can be found in remote monitoring tools. Physical Resources component type metric CPU utilization system-wide: vmstat 1, ”us” + ”sy” + ”st”; sar -u, sum fields except ”%idle” and ”%iowait”; dstat -c, sum fields except ”idl” and ”wai”; per-cpu: mpstat -P ALL 1, sum fields except ”%idle” and ”%iowait”; sar -P ALL, same as [ more… ]

No Image

Submit a Talk and Register Now for nginx.conf 2016!

2016-04-05 KENNETH 0

Submit a Talk and Register Now for nginx.conf 2016! We’re excited to announce that registration and the Call for Proposals are now open for nginx.conf 2016. We’re looking forward to seeing you in Austin, TX this September 7-9. Register now to save $400! Early bird pricing is available until May 19. Share your story about how you’re using NGINX and NGINX Plus to help you achieve performance, security, and scale for your web applications. Whether you’re deploying your app in the cloud, on bare metal, or a combination, we want to hear how you’re using NGINX across any type of application and in any sort of environment. We’d love to see talks on any of the topics below: Architecting, Developing, & Deploying Code Scaling and Securing Applications NGINX-specific and NGINX Plus-Specific Case Studies & Best Practices Submit your ideas to [ more… ]

No Image

RHSA-2016:0591-1: Moderate: nss, nss-util, and nspr security, bug fix, and enhancement update

2016-04-05 KENNETH 0

RHSA-2016:0591-1: Moderate: nss, nss-util, and nspr security, bug fix, and enhancement update Red Hat Enterprise Linux: An update for nss, nss-util, and nspr is now available for Red Hat Enterprise Linux 6. Red Hat Product Security has rated this update as having a security impact of Moderate. A Common Vulnerability Scoring System (CVSS) base score, which gives a detailed severity rating, is available for each vulnerability from the CVE link(s) in the References section. CVE-2016-1978, CVE-2016-1979 Source: RHSA-2016:0591-1: Moderate: nss, nss-util, and nspr security, bug fix, and enhancement update

No Image

mysql error : No data – zero rows fetched, selected, or processed

2016-04-05 KENNETH 0

프로시저를 생성해놓고 호출시에.. No data – zero rows fetched, selected, or processed 에러가 발생하는 경우가 있음. DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1; 구문을 프로시저에 추가해주면 된다고함… (이것은 내가 테스트 해본것은 아님.. 귀찮기도 하고.. ) 실사용은 아래 내용을 참고할 것 PS. mysql-5.6 으로 업데이트 하는 방법도 있다고함 (역시 내가 테스트 해본것은 아님.. 귀찮기도 했고.. ) 참고 : https://jirak.net/wp/mysql-fetch-cursor-%eb%ac%b8-%ec%82%ac%ec%9a%a9%eb%b0%a9%eb%b2%95/

No Image

MySQL Fetch Cursor 문 사용방법

2016-04-05 KENNETH 1

출처 : http://bizadmin.tistory.com/entry/MySQL-Fetch-Cursor-%EB%AC%B8-%EC%82%AC%EC%9A%A9%EB%B0%A9%EB%B2%95 작성자 : 불가사리 bluemount 아래 내용은 ”http://bizadmin.tistory.com/”에서 발췌한 내용입니다.   Mysql에서 커서(Fetch Cursor)를 사용할 때 아래와 같은 경고메세지를 얻는 경우가 있다. 1329: No data – zero rows fetched, selected, or processed 무슨 이유인지 커서가 다 돌지를 않고 중간에 멈춘거 같은 것을 보고 역시  Mysql 은 믿을 수가 없어 그런 느낌을 갖기도 했지만 역시 믿을 수 없는 건 나의 실력이었다. Mysql 의 커서(Cursor)를 충분히 분석하고 기능을 알아보려 한다. 커서는 기본적으로 커서(Cursor)를 돌면 어떤 데이타를 처리하는 것이 목적이다. 간단한 예제 수준만 알아서 해결이 안되는 경우 아래의 내용을 검토해 보자. 1. Fetch Cursor 기본 구조  : 아주 기초적 구조다. 이해가 안되면 외어라. CREATE PROCEDURE curdemo() BEGIN DECLARE done INT DEFAULT FALSE; DECLARE vRowCount INT DEFAULT 0 ; DECLARE vUserID varchar(20);   — 커서로 만들 데이타 값들 DECLARE cur1 CURSOR FOR SELECT Userid FROM Member;   — 커서가 마지막에 도착할 때의 상태값 DECLARE CONTINUE HANDLER [ more… ]