~ubuntu-branches/ubuntu/oneiric/pgpool2/oneiric

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
pdo-test README

-pdo-testÈÏ?

pdo-testÏphp PDO¥É¥é¥€¥ÐòÍøÍÑ€·€ÆpgpoolΥƥ¹¥Èò¹ÔŠ¥×¥í¥°¥é¥à
Ç€¹¡£

pdo-testÏab(Apache HTTP server benchmarking tool)ò»È€€¥Æ¥¹¥Èò¹Ô
€€€Þ€¹¡£

ŒÂºÝΌ¹ÔÎãϰʲŒÎÄÌêÇ€¹¡£

abc 10 -n 100 "http://localhost/pdo-test/pdotest.php"

PDO¥É¥é¥€¥ÐÈpgpoolÈÎÀܳÀßÄêÏdef.inc¥Õ¥¡¥€¥ëòÊÔœž€·€Þ€¹¡£
def.incÎÆâÍÆϰʲŒÎÄÌêÇ€¹¡£
<?php
	/* ¥Û¥¹¥ÈÌŸ€ÎÀßÄê*/
	define("HOSTNAME","localhost");
	/* DBÌŸ€ÎÀßÄê*/
	define("DBNAME","postgres");
	/* Àܳ¥æ¡Œ¥¶ÌŸ€ÎÀßÄê*/
	define("USER","postgres");
	/* Àܳport€ÎÀßÄê*/
	define("PORT","9999");
	/* ¥Ñ¥¹¥ï¡Œ¥É€ÎÀßÄê*/
	define("PASS","");
?>

ŒÂ¹Ô€¹€ë¥¯¥š¥êÏSQLList¥Ç¥£¥ì¥¯¥È¥êÆâÎ¥Õ¥¡¥€¥ë€«€é¥é¥ó¥À¥àË
ŒÂ¹ÔµìÞ€¹¡£

¥Õ¥¡¥€¥ëËÏ;(¥»¥ß¥³¥í¥ó)èÀÚêÇÊ£¿ôÎSQLòµ­œÒ€·€Æ€¯€Àµ€€¡£

Þ€¿¡¢ÆÃÄêÎ¥Õ¥¡¥€¥ëÎߌ¹Ԁ·€¿€€Ÿì¹çËÏ¡¢°Ê²ŒÎèŠËŒÂ¹Ô
€·€Þ€¹¡£

http://localhost/pdo-test/pdotest.php?query=¥Õ¥¡¥€¥ëÌŸ

PHP€¬œÐÎÏ€¹€ë¥š¥é¡ŒÏlog.txtËœÐÎϵìÞ€¹¡£
SQL¥ì¥Ù¥ëÎ¥š¥é¡ŒËÄ€€€ÆÏabΌ¹Էë²Ì€«€éʬ€«€ëèŠËÊÃÆÞ€¹¡£

°Ê²Œ€¬¥š¥é¡Œ€¬È¯Àž€·€¿Ÿì¹çÎabΌ¹Էë²ÌÇ€¹¡£
Non-2xx responses€¬ÉœŒšµì€¿Ÿì¹çËϲ¿€«€·€éDBË¥š¥é¡Œ€¬È¯Àž€·€¿
²ÄÇœÀ­€¬€¢€ëÎÇ¡¢log.txtÈDBÎ¥í¥°€ò³Îǧ€·€Æ€¯€Àµ€€¡£

oncurrency Level:      10
Time taken for tests:   7.721773 seconds
Complete requests:      100
Failed requests:        0
Write errors:           0
Non-2xx responses:      100
Total transferred:      25100 bytes
HTML transferred:       5300 bytes
Requests per second:    12.95 [#/sec] (mean)
Time per request:       772.177 [ms] (mean)
Time per request:       77.218 [ms] (mean, across all concurrent requests)
Transfer rate:          3.11 [Kbytes/sec] received