MySQL and handle

1. Environment

OS: Win 2003 Server (X86)
DB: MySQL 5.1.30-community-log

2. Problem

The number of handles occupied by the MySQL Server is too large, and the consumption process of the handle is faster than the release speed. 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
10
Port: 2
11
Semaphore: 10
12
Thread: 207
13
WindowStation: 2
14
Total hand: 302062
2.2.MySQL Parameters

1
Query_cache_size 84 M
2
Innodb_buffer_pool_size: 250 M
3
Innodb_thread_concurrency 18
3. Solutions

3. 1. Disable QueryCache

3. 2. Disable innodb_thread_concurrency

3.3. OS replaced by Win X64 or non-Win Edition

 

4. Extended reading

Http://bugs.mysql.com/bug.php? Id = 45252



This article is from HowardX. D. Hua, author of The Open Source Chinese community.