My Blog List

Wednesday, September 11, 2013

Install Openfire with Mssql

 
GO to openfire Website
 
Download openfire for Windows OS
 
 
Select Language
 
Select Your DB Server
 

setting Dabase


 
Setting Profile

 

setting Admin Account

Finally You can login 
asdf

Tuesday, September 10, 2013

Query time Count

you can fine result millisecond

DECLARE @start_time DATETIME, @end_time DATETIME
SET @start_time = CURRENT_TIMESTAMP;


[your Query here]


SET @end_time = CURRENT_TIMESTAMP
SELECT DATEDIFF(ms, @start_time, @end_time),DATEDIFF(ms, @start_time, @end_time)/1000;

Sunday, September 8, 2013

Oracle backup exp


exp system/oracle file=/backup/export/test05.dmp owner=(scott, hr)

Tuesday, September 3, 2013

Oracle import dmp file

Step by Step


if not exist
1. create user {user_id} identified by {password}

2. GRANT CONNECT, DBA, RESOURCE TO {user_id};

$ imp {user_id}/{password} file={filename}.dmp ignore=y full=y

wow very Easy~

Sunday, September 1, 2013

Apache Benchmark


[root@dev bin]# pwd

/usr/bin

[root@dev bin]# ab -n 500 -c 20 http://{testURL}

설명 : ab n Request개수(500) c 동시접속자 URL (API)

 

== 결과값 ==

 

This is ApacheBench, Version 2.3 <$Revision: 655654 $>

Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/

Licensed to The Apache Software Foundation, http://www.apache.org/

 

Benchmarking 203.233.82.229 (be patient)
Completed 100 requests
Completed 200 requests
Completed 300 requests
Completed 400 requests
Completed 500 requests
Finished 500 requests

Server Software:        Apache/2.2.21
Server Hostname:        203.233.82.229
Server Port:            80

Document Path:          //account/view/terms
Document Length:        4593 bytes

 
Concurrency Level:      20 (동시 접속자)
Time taken for tests:   0.513 seconds (총 소요시간)
Complete requests:      500
Failed requests:        0
Write errors:           0
Total transferred:      2511500 bytes
HTML transferred:       2296500 bytes
Requests per second:    975.44 [#/sec] (mean)
Time per request:       20.504 [ms] (mean)
Time per request:       1.025 [ms] (mean, across all concurrent requests)
Transfer rate:          4784.80 [Kbytes/sec] received

 
Connection Times (ms)
              min  mean[+/-sd] median   max
Connect:        5    6   0.8      6       9
Processing:     8   14   8.3     11     124
Waiting:        7   14   8.3     11     123
Total:         13   20   8.6     17     131

 
Percentage of the requests served within a certain time (ms)
  50%     17
  66%     19
  75%     21
  80%     22
  90%     30
  95%     34
  98%     45
  99%     55
100%    131 (longest request)