PDO 長連接 PDO::ATTR_PERSISTENT 測試及了解

$PDO = new PDO( PDO_DSN, MYSQL_USERNAME, MYSQL_PASSWORD, array(
    PDO::ATTR_PERSISTENT => false
) );
$PDO->exec("set names utf8");

$sql = " SELECT * FROM UserLog  ";
$pre = $PDO->prepare($sql);
$pre->execute();

1

2

3

4

5

6

7

8

$PDO = new PDO( PDO_DSN, MYSQL_USERNAME, MYSQL_PASSWORD, array(

PDO::ATTR_PERSISTENT => false

) );

$PDO->exec("set names utf8");

$sql = " SELECT * FROM UserLog ";

$pre = $PDO->prepare($sql);

$pre->execute();

"2016-04-26 09:34:55","MJAPP_SoundU[MJAPP_SoundU] @ localhost []",86,0,"Connect","MJAPP_SoundU@localhost on MJAPP_SoundU2"
"2016-04-26 09:34:55","MJAPP_SoundU[MJAPP_SoundU] @ localhost []",86,0,"Query","set names utf8"
"2016-04-26 09:34:55","MJAPP_SoundU[MJAPP_SoundU] @ localhost []",86,0,"Query","SET GLOBAL time_zone='+8:00'"
"2016-04-26 09:34:55","MJAPP_SoundU[MJAPP_SoundU] @ localhost []",86,0,"Query","SELECT * FROM UserLog"
"2016-04-26 09:34:56","MJAPP_SoundU[MJAPP_SoundU] @ localhost []",86,0,"Quit",""

1

2

3

4

5

"2016-04-26 09:34:55","MJAPP_SoundU[MJAPP_SoundU] @ localhost []",86,0,"Connect","MJAPP_SoundU@localhost on MJAPP_SoundU2"

"2016-04-26 09:34:55","MJAPP_SoundU[MJAPP_SoundU] @ localhost []",86,0,"Query","set names utf8"

"2016-04-26 09:34:55","MJAPP_SoundU[MJAPP_SoundU] @ localhost []",86,0,"Query","SET GLOBAL time_zone='+8:00'"

"2016-04-26 09:34:55","MJAPP_SoundU[MJAPP_SoundU] @ localhost []",86,0,"Query","SELECT * FROM UserLog"

"2016-04-26 09:34:56","MJAPP_SoundU[MJAPP_SoundU] @ localhost []",86,0,"Quit",""

$PDO = new PDO( PDO_DSN, MYSQL_USERNAME, MYSQL_PASSWORD, array(
    PDO::ATTR_PERSISTENT => true
) );
$PDO->exec("set names utf8");

$sql = " SELECT * FROM UserLog  ";
$pre = $PDO->prepare($sql);
$pre->execute();

1

2

3

4

5

6

7

8

$PDO = new PDO( PDO_DSN, MYSQL_USERNAME, MYSQL_PASSWORD, array(

PDO::ATTR_PERSISTENT => true

) );

$PDO->exec("set names utf8");

$sql = " SELECT * FROM UserLog ";

$pre = $PDO->prepare($sql);

$pre->execute();

"2016-04-26 09:38:38","MJAPP_SoundU[MJAPP_SoundU] @ localhost []",87,0,"Connect","MJAPP_SoundU@localhost on MJAPP_SoundU2"
"2016-04-26 09:38:38","MJAPP_SoundU[MJAPP_SoundU] @ localhost []",87,0,"Query","set names utf8"
"2016-04-26 09:38:38","MJAPP_SoundU[MJAPP_SoundU] @ localhost []",87,0,"Query","SELECT * FROM UserLog"

1

2

3

"2016-04-26 09:38:38","MJAPP_SoundU[MJAPP_SoundU] @ localhost []",87,0,"Connect","MJAPP_SoundU@localhost on MJAPP_SoundU2"

"2016-04-26 09:38:38","MJAPP_SoundU[MJAPP_SoundU] @ localhost []",87,0,"Query","set names utf8"

"2016-04-26 09:38:38","MJAPP_SoundU[MJAPP_SoundU] @ localhost []",87,0,"Query","SELECT * FROM UserLog"

$PDO = new PDO( PDO_DSN, MYSQL_USERNAME, MYSQL_PASSWORD, array(
    PDO::ATTR_PERSISTENT => false
) );
$PDO->exec("set names utf8");

$sql = " SELECT * FROM UserLog LIMIT 1 ";
$pre = $PDO->prepare($sql);
$pre->execute();
$sql = " SELECT * FROM UserLog LIMIT 1 ";
$pre = $PDO->prepare($sql);
$pre->execute();
$sql = " SELECT * FROM UserLog LIMIT 1 ";
$pre = $PDO->prepare($sql);
$pre->execute();

1

2

3

4

5

6

7

8

9

10

11

12

13

14

$PDO = new PDO( PDO_DSN, MYSQL_USERNAME, MYSQL_PASSWORD, array(

PDO::ATTR_PERSISTENT => false

) );

$PDO->exec("set names utf8");

$sql = " SELECT * FROM UserLog LIMIT 1 ";

$pre = $PDO->prepare($sql);

$pre->execute();

$sql = " SELECT * FROM UserLog LIMIT 1 ";

$pre = $PDO->prepare($sql);

$pre->execute();

$sql = " SELECT * FROM UserLog LIMIT 1 ";

$pre = $PDO->prepare($sql);

$pre->execute();

"2016-04-26 10:57:16","MJAPP_SoundU[MJAPP_SoundU] @ localhost []",123,0,"Connect","MJAPP_SoundU@localhost on MJAPP_SoundU2"
"2016-04-26 10:57:16","MJAPP_SoundU[MJAPP_SoundU] @ localhost []",123,0,"Query","set names utf8"
"2016-04-26 10:57:16","MJAPP_SoundU[MJAPP_SoundU] @ localhost []",123,0,"Query","SELECT * FROM UserLog LIMIT 1"
"2016-04-26 10:57:16","MJAPP_SoundU[MJAPP_SoundU] @ localhost []",123,0,"Query","SELECT * FROM UserLog LIMIT 1"
"2016-04-26 10:57:16","MJAPP_SoundU[MJAPP_SoundU] @ localhost []",123,0,"Query","SELECT * FROM UserLog LIMIT 1"
"2016-04-26 10:57:16","MJAPP_SoundU[MJAPP_SoundU] @ localhost []",123,0,"Quit",""

1

2

3

4

5

6

"2016-04-26 10:57:16","MJAPP_SoundU[MJAPP_SoundU] @ localhost []",123,0,"Connect","MJAPP_SoundU@localhost on MJAPP_SoundU2"

"2016-04-26 10:57:16","MJAPP_SoundU[MJAPP_SoundU] @ localhost []",123,0,"Query","set names utf8"

"2016-04-26 10:57:16","MJAPP_SoundU[MJAPP_SoundU] @ localhost []",123,0,"Query","SELECT * FROM UserLog LIMIT 1"

"2016-04-26 10:57:16","MJAPP_SoundU[MJAPP_SoundU] @ localhost []",123,0,"Quit",""

$PDO = new PDO( PDO_DSN, MYSQL_USERNAME, MYSQL_PASSWORD, array(
    PDO::ATTR_PERSISTENT => true
) );
$PDO->exec("set names utf8");

$sql = " SELECT * FROM UserLog LIMIT 1 ";
$pre = $PDO->prepare($sql);
$pre->execute();
$sql = " SELECT * FROM UserLog LIMIT 1 ";
$pre = $PDO->prepare($sql);
$pre->execute();
$sql = " SELECT * FROM UserLog LIMIT 1 ";
$pre = $PDO->prepare($sql);
$pre->execute();

1

2

3

4

5

6

7

8

9

10

11

12

13

14

$PDO = new PDO( PDO_DSN, MYSQL_USERNAME, MYSQL_PASSWORD, array(

PDO::ATTR_PERSISTENT => true

) );

$PDO->exec("set names utf8");

$sql = " SELECT * FROM UserLog LIMIT 1 ";

$pre = $PDO->prepare($sql);

$pre->execute();

$sql = " SELECT * FROM UserLog LIMIT 1 ";

$pre = $PDO->prepare($sql);

$pre->execute();

$sql = " SELECT * FROM UserLog LIMIT 1 ";

$pre = $PDO->prepare($sql);

$pre->execute();

"2016-04-26 10:58:28","MJAPP_SoundU[MJAPP_SoundU] @ localhost []",66,0,"Query","set names utf8"
"2016-04-26 10:58:28","MJAPP_SoundU[MJAPP_SoundU] @ localhost []",66,0,"Query","SELECT * FROM UserLog LIMIT 1"
"2016-04-26 10:58:28","MJAPP_SoundU[MJAPP_SoundU] @ localhost []",66,0,"Query","SELECT * FROM UserLog LIMIT 1"
"2016-04-26 10:58:28","MJAPP_SoundU[MJAPP_SoundU] @ localhost []",66,0,"Query","SELECT * FROM UserLog LIMIT 1"

1

2

3

4

"2016-04-26 10:58:28","MJAPP_SoundU[MJAPP_SoundU] @ localhost []",66,0,"Query","set names utf8"

"2016-04-26 10:58:28","MJAPP_SoundU[MJAPP_SoundU] @ localhost []",66,0,"Query","SELECT * FROM UserLog LIMIT 1"

PDO 長連接 PDO::ATTR_PERSISTENT 測試及了解

PHP PDO MySQL 長連結設定及影響

Related Post

One thought on “PDO 長連接 PDO::ATTR_PERSISTENT 測試及了解”

發佈留言

PDO 長連接 PDO::ATTR_PERSISTENT 測試及了解

PHP PDO MySQL 長連結設定及影響

Related Post

MySQL - 錯誤代碼及解決思路

MySQL 5.7 - 忘記 root 密碼

CodeIgniter 3 - PHPMailer

One thought on “PDO 長連接 PDO::ATTR_PERSISTENT 測試及了解”

發佈留言