


PHP 一直报错.而且还不能正常访问.这是什么情况PHP Warning: mysqli::mysqli()(HY000/2003)
[23-Aug-2013 00:29:57] PHP Warning: mysqli::mysqli() [mysqli.mysqli]: (HY000/2003): Can't connect to MySQL server on '42.120.19.1' (10048) in D:\wwwroot\sms\common\DbManager.php on line 14
[23-Aug-2013 00:29:57] PHP Warning: mysqli::set_charset() [mysqli.set-charset]: Couldn't fetch mysqli in D:\wwwroot\sms\dao\PhoneDao.php on line 92
[23-Aug-2013 00:29:57] PHP Warning: PhoneDao::deleteUsedPhone() [phonedao.deleteusedphone]: Couldn't fetch mysqli in D:\wwwroot\sms\dao\PhoneDao.php on line 93
[23-Aug-2013 00:29:58] PHP Warning: mysqli::mysqli() [mysqli.mysqli]: (HY000/2003): Can't connect to MySQL server on '42.120.19.1' (10048) in D:\wwwroot\sms\common\DbManager.php on line 14
[23-Aug-2013 00:29:58] PHP Warning: mysqli::set_charset() [mysqli.set-charset]: Couldn't fetch mysqli in D:\wwwroot\sms\dao\SysParamDao.php on line 15
[23-Aug-2013 00:29:58] PHP Warning: SysParamDao::getSysParam() [sysparamdao.getsysparam]: Couldn't fetch mysqli in D:\wwwroot\sms\dao\SysParamDao.php on line 16
[23-Aug-2013 00:29:58] PHP Warning: mysqli::mysqli() [mysqli.mysqli]: (HY000/2003): Can't connect to MySQL server on '42.120.19.1' (10048) in D:\wwwroot\sms\common\DbManager.php on line 14
[23-Aug-2013 00:29:58] PHP Warning: mysqli::set_charset() [mysqli.set-charset]: Couldn't fetch mysqli in D:\wwwroot\sms\dao\SysParamDao.php on line 15
回复讨论(解决方案)
他不是已经告诉你“无法连接到MySQL服务器(42.120.19.1)”了吗?
检查mysql是否启动
检查你的账户是否已经授权
他不是已经告诉你“无法连接到MySQL服务器(42.120.19.1)”了吗?
检查mysql是否启动
检查你的账户是否已经授权
是授权的
他不是一直连接不上. 是并发的有点多,然后偶尔出现这样的情况.所以也不知道是不是并发引起的.或者其他什么原因引起的.但不是一开始就无法连接的
偶尔出现就不算是问题
你可以做错误处理:在出现连不上时,等待一会比如0.5秒再连
将你的mysql的并发数改大点,或者减少php的并发请求数。
将你的mysql的并发数改大点,或者减少php的并发请求数。
嗯.怎么查询并发数
SHOW STATUS WHERE variable_name like '%connection%';
这个?
如何修改呢?
偶尔出现就不算是问题
你可以做错误处理:在出现连不上时,等待一会比如0.5秒再连
如何等待?sleep(1); 吗?
是的,sleep 以秒为单位,usleep 以微秒为单位
设置最大并发数可以参考以下链接
http://hi.baidu.com/xiaoxvziboke/item/b8d1fc098b1a98e934990254
设置最大并发数 只能缓解当前的矛盾
如果访问量继续增大怎么办?继续修改?
如果没有权限修改怎么办?
如果增大并发数后,数据库变慢怎么办?
设置最大并发数 只能缓解当前的矛盾
如果访问量继续增大怎么办?继续修改?
如果没有权限修改怎么办?
如果增大并发数后,数据库变慢怎么办?
是用等待+增加并发权衡吧?
那这个等待,是有try catch 还是 if else
连接失败返回值是什么?
将你的mysql的并发数改大点,或者减少php的并发请求数。
我用
ab -n 1000 -c 100
来测了一下.到300并发的时候自动关闭连接.
并不是我出现这样的问题
$loop = 1; //重复连接的次数do { $db = @ new mysqli(参数略);}while($db->connect_error && $loop--);if($db->connect_error) echo $db->connect_error;
设置最大并发数 只能缓解当前的矛盾
如果访问量继续增大怎么办?继续修改?
如果没有权限修改怎么办?
如果增大并发数后,数据库变慢怎么办?
是用等待+增加并发权衡吧?
那这个等待,是有try catch 还是 if else
连接失败返回值是什么?
$loop = 1; //重复连接的次数do { $db = @ new mysqli(参数略);}while($db->connect_error && $loop--);if($db->connect_error) echo $db->connect_error;
设置最大并发数 只能缓解当前的矛盾
如果访问量继续增大怎么办?继续修改?
如果没有权限修改怎么办?
如果增大并发数后,数据库变慢怎么办?
是用等待+增加并发权衡吧?
那这个等待,是有try catch 还是 if else
连接失败返回值是什么?
你看是不是因为我使用了默认的wait-timeout 8小时
我是不是可以设置为30秒. 30秒没进一步操作,强制关闭此链接呢?
http://www.wbsz.com/html/25425.html
这里看过来

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics



Alipay PHP...

JWT is an open standard based on JSON, used to securely transmit information between parties, mainly for identity authentication and information exchange. 1. JWT consists of three parts: Header, Payload and Signature. 2. The working principle of JWT includes three steps: generating JWT, verifying JWT and parsing Payload. 3. When using JWT for authentication in PHP, JWT can be generated and verified, and user role and permission information can be included in advanced usage. 4. Common errors include signature verification failure, token expiration, and payload oversized. Debugging skills include using debugging tools and logging. 5. Performance optimization and best practices include using appropriate signature algorithms, setting validity periods reasonably,

The application of SOLID principle in PHP development includes: 1. Single responsibility principle (SRP): Each class is responsible for only one function. 2. Open and close principle (OCP): Changes are achieved through extension rather than modification. 3. Lisch's Substitution Principle (LSP): Subclasses can replace base classes without affecting program accuracy. 4. Interface isolation principle (ISP): Use fine-grained interfaces to avoid dependencies and unused methods. 5. Dependency inversion principle (DIP): High and low-level modules rely on abstraction and are implemented through dependency injection.

How to automatically set the permissions of unixsocket after the system restarts. Every time the system restarts, we need to execute the following command to modify the permissions of unixsocket: sudo...

How to debug CLI mode in PHPStorm? When developing with PHPStorm, sometimes we need to debug PHP in command line interface (CLI) mode...

Article discusses late static binding (LSB) in PHP, introduced in PHP 5.3, allowing runtime resolution of static method calls for more flexible inheritance.Main issue: LSB vs. traditional polymorphism; LSB's practical applications and potential perfo

Sending JSON data using PHP's cURL library In PHP development, it is often necessary to interact with external APIs. One of the common ways is to use cURL library to send POST�...

Article discusses essential security features in frameworks to protect against vulnerabilities, including input validation, authentication, and regular updates.
