Category Archives: Database

Query & DB Technic.

High CPU usage query & Adding Index

CASE: Specific query is consuming up CPU resource cause CPU Spike(100% usage) when the DB hit count is increased. Type: MSSQL 2012 In such a case, mostly the query is known, so it can be solved by creating index for this query. But in emergency status, when Application Designer is absent and when the instant response is needed by DBA… Read More »

977 total views, no views today

log truncate interruption – open transaction

http://yoonsy.tistory.com/26 Case: DB Type: MS SQL 2012 DB Recovery Model: Full One day, Growing DB log size is pressing the Disk space, it almost full. See the status of db files, the log file size has been increased very big though the transaction log backup task has been taking regularly. Once to handle this situation, just trying… Read More »

1,243 total views, no views today

[MSSQL] Desizing the Transaction log

for further steps http://www.dbguide.net/db.db?cmd=view&boardUid=13957&boardConfigUid=9&boardIdx=74&boardStep=1 To desize the transaction log of statistical  database which is just for the log-likely data and of which the transaction log grows very fast, set the recovery option for that database as “SIMPLE” and truncate the log. Due to the queries to desize the logs are slightly different by the version… Read More »

4,909 total views, 11 views today

[MSSQL] CPU Usage Analysis / Queries

When usage of CPU increased in Database Server, use this query to check which is the most exhausting one.

Use below to check the detail with SPID:

1,358 total views, 2 views today

1,358 total views, 2 views today

Data Mining with Weka (5.2: Pitfalls and pratfalls)

게시일: 2013. 10. 6. Data Mining with Weka: online course from the University of Waikato Class 5 – Lesson 2: Pitfalls and pratfalls http://weka.waikato.ac.nz/ Slides (PDF): http://goo.gl/5DW24X https://twitter.com/WekaMOOC http://wekamooc.blogspot.co.nz/ Department of Computer Science University of Waikato New Zealand http://cs.waikato.ac.nz/ 카테고리 교육 라이선스 크리에이티브 커먼즈 저작자 표시 라이선스(재사용 허용)     1,359 total views, 1 views today

1,359 total views, 1 views today

[SQL ] The Curse and Blessings of Dynamic SQL

cite from: http://www.sommarskog.se/dynamic_sql.html An SQL text by Erland Sommarskog, SQL Server MVP. Latest revision: 2011-06-23. An earlier version of this article is also available in German. Translations provided by SQL Server MVP Frank Kalis. Introduction If you follow the various newsgroups on Microsoft SQL Server, you often see people asking why they can’t do: SELECT… Read More »

1,320 total views, 3 views today

[MySQL] Create Table with Auto Incremental

Example> use foodfavor; create table food (   pk1 MEDIUMINT NOT NULL AUTO_INCREMENT,   food_id char(50),   food_name CHAR(255) NOT NULL,   PRIMARY KEY (pk1) ); * reference: http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html MyISAM Or InnoDB MySQL engine?: http://linuxers.org/howto/myisam-or-innodb-mysql-engine   1,327 total views, 1 views today

1,327 total views, 1 views today

[MySQL-ORACLE] Oracle and MySQL Compared (types and so on)

cite from: http://docs.oracle.com/cd/E12151_01/doc.150/e12155/oracle_mysql_compared.htm Here’s the table for comparing types of ORACLE & MySQL below: 2.2.4 Migrating Multiple Databases SQL Developer supports the migration of multiple MySQL databases if they are on the same MySQL database server. 2.2.5 Schema Migration Considerations for MySQL Schema migration considerations for MySQL apply in the following areas” Databases Mapping MySQL Global and Database-Level… Read More »

1,835 total views, 1 views today

[MySQL] Create Database-Create User-Grant on

가장 기초이면서도 종종 쓰면서도 정리해두지 않으면 매번 찾아보아야 한다. 미리 정리해둔다. –Create Database— create database simple_board; –Create User & Grant & Check Grant (for Remote Access)———– CREATE USER board_u@localhost IDENTIFIED BY ‘12345’; GRANT ALL PRIVILEGES ON simple_board.* TO board_u@localhost; SHOW GRANTS FOR board_u@localhost; –Modify Grant Privilege of User for remote access ———————————— UPDATE mysql.user SET… Read More »

1,375 total views, no views today

Hadoop 2.2.0 (4) – 개발환경 구축하기: Plugin 설치

하둡 설치가 끝났으면 이제 개발 해봐야죠~ 썩은 무라도 잘라야 이때까지 고생한 보람이 있겠죠?(^^;;;) 일단 Eclipse Plugin 이 존재한다는 사실은 알고 있었기 때문에 바로 검색 들어갑니다. 구글냥에서 검색해보면 이미 많은 분들의 포스팅이 있지만 검색 첫단에 나온 github 사이트의 결과를 이용하기로 합니다. https://github.com/winghc/hadoop2x-eclipse-plugin (진짜.. 이런거 만들어 볼 능력이 되야 할텐데… 다음 생에?) 컴파일해도 되지만 시간을 많이 잡아먹은… Read More »

6,547 total views, 12 views today