php PDO Á´½Ó mysql ×î¼òµ¥ ʵÀý
define("DB_SERVER","127.0.0.1");
define("DB_PORT",3306);
define("DB_CATALOG","uab");
define("DB_USERID","root");
define("DB_PASSWORD","");
$dsn="mysql:host=".DB_SERVER.";port=".DB_PORT.";dbname=".DB_CATALOG;
self::$__PDO=new PDO($dsn, DB_USERID, DB_PASSWORD);
//support long connection
self::$__PDO=new PDO($dsn, DB_USERID, DB_PASSWORD, array(PDO::ATTR_PERSISTENT => true));
Ïà¹ØÎĵµ£º
<?php
//±äÁ¿¶¨Ò壬»ÍÖÔ²»¡Ê±µÄ½Ç¶È´óС
define("ANGLELENGTH",3);
/**
* »æÖÆÍ¼Æ¬
* @param $title 3DͼµÄ±êÌâ
......
Ms sql 2000
drivername=com.microsoft.jdbc.sqlserver.SQLServerDriver
url=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=books
username=sa
password=sa
MySQL
drivername=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost/books
username=root
password=root
Oracle
drivername=orac ......
1.ʵÏÖTAB¼ü²¹È«
SHELL>vi /etc/my.cnf
[mysql]
#no-auto-rehash
auto-rehash
SHELL>reboot mysqld
note: 1.ÒªÏÈuseµ½Ä³¸öÊý¾Ý¿âÏ£»2.Òª²¹È«µÄ¹Ø¼ü×ÖÐèÒª´óд¡£
2.promptÈòÙ×÷¸ü¼ÓÇå³þ
mysql>prompt \u@\h(\d) \r:\m:\s (ÁÙʱ)
[mysql] £¨³¤¾Ã£©
prompt=\\u@\\h
3.pagerÈÃä ......
½ñÌ쿪¶àÒ»¸öÓ¦ÓÃÔÚ APP SERVER ÉÏ£¬±¨¸æÒ»¸ö´íÎó:
ERROR 1040 (00000): Too many connections
Õâµ¹ÊÇ´ÓÀ´Ã»Åöµ½¹ý£¬²»¹ýÔÚ console Ï¿ÉÒÔÓà root µÇ¼ £¨console ÏÂÓÃÆäËûÓû§Ò²²»¿ÉµÇ¼£¬Too many connections£©
mysql -uroot -p
mysql > show processlist;
...
ÕâÀïÁÐÁË100¸öÁ´½Ó£¡£¡ÆäÖÐÖ»ÓÐ2¸öÁ´½ÓÊÇQ ......