Home Web Front-end JS Tutorial CI框架出现mysql数据库连接资源无法释放的解决方法_php实例

CI框架出现mysql数据库连接资源无法释放的解决方法_php实例

Jun 07, 2016 pm 05:07 PM
ci framework mysql database Solution

本文实例分析了CI框架出现mysql数据库连接资源无法释放的解决方法。分享给大家供大家参考,具体如下:

使用ci框架提供的类查询数据:

$this->load->database();
$query = $this->db->query($sql);

Copy after login

程序运行一段时间之后,报错,告知数据库too many connections

很明显MySQL数据库连接资源超过了 max_connections 设定值。立马在每个查询之后,添加资源释放脚本:

$this->db->close();

Copy after login
Copy after login

仍然无法释放资源,怎么办呢?查看手册之后,知道了,只要把pconnect设置为false就可以了,设置大致如下:

$db['default']['pconnect'] = FALSE;

Copy after login

设置 过之后,无需调用

$this->db->close();

Copy after login
Copy after login

即可自动关闭连接。

更多关于CodeIgniter相关内容感兴趣的读者可查看本站专题:《codeigniter入门教程》、《CI(CodeIgniter)框架进阶教程》、《php优秀开发框架总结》、《ThinkPHP入门教程》、《ThinkPHP常用方法总结》、《Zend FrameWork框架入门教程》、《php面向对象程序设计入门教程》、《php+mysql数据库操作入门教程》及《php常见数据库操作技巧汇总》

希望本文所述对大家基于CodeIgniter框架的PHP程序设计有所帮助。

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Printer operation cannot be completed error 0x0000709 Solution Printer operation cannot be completed error 0x0000709 Solution Apr 20, 2024 pm 10:10 PM

In daily office and study, printers are indispensable tools. However, encountering printer errors is a very common situation. Recently, some users have encountered error code 0x0000709 when using the printer, and the system prompts that the operation cannot be completed. We have prepared four solutions to this problem, let’s take a look. Method 1: NT6 Printer Sharing Repair Tool The NT6 Printer Sharing Repair Tool is an excellent printer repair tool that can easily solve the problem of printer sharing link failure caused by updating patches, such as the recent problem when connecting Win10 and Win11 to share a printer. Errors reported, printer error codes 0x0000011b, 0x00000709 and other issues. This tool provides

Deepseek official website entrance access guide Solve the common problems that cannot be logged in Deepseek official website entrance access guide Solve the common problems that cannot be logged in Feb 19, 2025 pm 04:30 PM

Deepseek is a platform that provides anonymous deep network access. To access its official website, please use the official portal link provided. If you encounter problems during login, it may be due to the following reasons: the browser is outdated, the credentials are incorrect, the connection is blocked, maintenance or the account is disabled. Frequently Asked Questions include: Deepseek's security and legality, and how to connect with the support team.

How to solve the problem of Pokemon Crystal, Diamond, Bright Pearl and Duck blocking the road? How to solve the problem of Pokemon Crystal, Diamond, Bright Pearl and Duck blocking the road? Apr 01, 2024 pm 02:33 PM

In the game Pokémon Crystal, Diamond, and Bright Pearl, players are blocked by a reachable duck on Route 210. Many players are still not sure what is going on. Let’s take a look at the reachable duck of Crystal, Diamond, and Bright Pearl. Here is a solution, I hope it helps everyone. What should I do if Pokémon Diamond, Bright Pearl, and Duck block the way? 1. Go to the gate of Nohara Wetland Observation Deck and see Team Galaxy’s men sneaking around. They said they were going to the lake, so we followed them. 2. Run into Ada on the road, talk to him and fight. 3. After the battle is won. We continue to track Team Galaxy's men until we catch up to him near the 7-star restaurant, and then we can fight him. 4. After winning the battle, go up and you will meet Zhulan, and then you will get the secret medicine. 5. According to the instructions, let us go to the road blocking the road.

How to solve the problem of busy servers for deepseek How to solve the problem of busy servers for deepseek Mar 12, 2025 pm 01:39 PM

DeepSeek: How to deal with the popular AI that is congested with servers? As a hot AI in 2025, DeepSeek is free and open source and has a performance comparable to the official version of OpenAIo1, which shows its popularity. However, high concurrency also brings the problem of server busyness. This article will analyze the reasons and provide coping strategies. DeepSeek web version entrance: https://www.deepseek.com/DeepSeek server busy reason: High concurrent access: DeepSeek's free and powerful features attract a large number of users to use at the same time, resulting in excessive server load. Cyber ​​Attack: It is reported that DeepSeek has an impact on the US financial industry.

gate.io official login web version gate.io login URL 2025 gate.io official login web version gate.io login URL 2025 Feb 20, 2025 pm 02:09 PM

Gate.io Exchange provides users with an official login portal. Through the official website or mobile app, users can log in to their account. The login steps are easy, including entering the email or mobile phone number used when registering, as well as your password. In order to ensure the security of the account, it is recommended that users change their passwords regularly and properly keep their login information. In addition, the article also provides solutions to common login problems, including inability to log in and password loss.

How to adjust Sesame Open Exchange into Chinese How to adjust Sesame Open Exchange into Chinese Mar 04, 2025 pm 11:51 PM

How to adjust Sesame Open Exchange to Chinese? This tutorial covers detailed steps on computers and Android mobile phones, from preliminary preparation to operational processes, and then to solving common problems, helping you easily switch the Sesame Open Exchange interface to Chinese and quickly get started with the trading platform.

The ultimate solution to JavaScript:void defect The ultimate solution to JavaScript:void defect Apr 09, 2024 pm 01:15 PM

The void operator in JavaScript has unexpected behavior and bugs that interfere with type inference. Alternative solutions include: 1. Use undefined to clearly express intent; 2. Use null to indicate that the value does not exist; 3. Use the ternary operator to concisely specify the value for different situations.

Sesame Open Door Exchange App Official Download Sesame Open Door Exchange Official Download Sesame Open Door Exchange App Official Download Sesame Open Door Exchange Official Download Mar 04, 2025 pm 11:54 PM

The official download steps of the Sesame Open Exchange app cover the Android and iOS system download process, as well as common problems solutions, helping you download safely and quickly and enable convenient transactions of cryptocurrencies.

See all articles