What if the number of handles occupied by MySQL Server is too large?

This article mainly explains "what to do if the number of handles occupied by MySQL Server is too large". The content of the explanation in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "what if the number of handles occupied by MySQL Server is too large?"

1. Environment

OS:Win 2003 Server (X86)

DB:MySQL 5.1.30-community-log

two。 problem

The number of handles occupied by MySQL Server is too large, the process consumption handle is faster than the release speed, and some other applications cannot apply for the handle, resulting in unavailability.

2.1.Handle

> handle.exe-s-p mysqld.exe

01

Handle type summary:

02

Desktop: 1

03

Directory: 2

04

Event: 301663

05

File: 125

06

IoCompletion: 17

07

Key: 8

08

KeyedEvent: 1

09

Mutant: 24

ten

Port: 2

eleven

Semaphore: 10

twelve

Thread: 207

thirteen

WindowStation: 2

fourteen

Total handles: 302062

2.2.MySQL related parameters

one

Query_cache_size 84M

two

Innodb_buffer_pool_size 250M

three

Innodb_thread_concurrency 18

3. The solution that comes up with

3.1. Close QueryCache

3.2. Close innodb_thread_concurrency

3.3.OS is replaced by Win X64 or non-Win version

Thank you for reading, the above is the content of "what to do if the number of handles occupied by MySQL Server is too large". After the study of this article, I believe you have a deeper understanding of how to do if the number of handles occupied by MySQL Server is too large, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!