mysql设置最大连接时间_设置MySQL最大连接数

import mysql.connector

config = {

'user':'root',

'password':'root',

'host':'localhost',

'database':'test'}

l=[]

for x in range(1000):

print(x)

cnx = mysql.connector.connect(**config)

l.append(cnx)

for x in l:

cursor=x.cursor()

cursor.execute('show tables;')

for (owner) in cursor:

print(owner)

cursor.execute('select * from chepiao;')

for (name) in cursor:

print(name)

for x in l:

cnx.close()

D:\Shield\Py3>python mysqltest.py

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

Traceback (most recent call last):

File "mysqltest.py", line 16, in

cnx = mysql.connector.connect(**config)

File "C:\Python34\lib\site-packages\mysql\connector\__init__.py", line 179, i

connect

return MySQLConnection(*args, **kwargs)

File "C:\Python34\lib\site-packages\mysql\connector\connection.py", line 95,

n __init__

self.connect(**kwargs)

File "C:\Python34\lib\site-packages\mysql\connector\abstracts.py", line 715,

n connect

self._open_connection()

File "C:\Python34\lib\site-packages\mysql\connector\connection.py", line 207,

in _open_connection

self._do_handshake()

File "C:\Python34\lib\site-packages\mysql\connector\connection.py", line 101,

in _do_handshake

raise errors.get_exception(packet)

mysql.connector.errors.DatabaseError: 1040: Too many connections

以上错误是因为超过了MySQL最大的连接数，需要修改my.ini文件(Windows系统上)

# The maximum amount of concurrent sessions the MySQL server will

# allow. One of these connections will be reserved for a user with

# SUPER privileges to allow the administrator to login even if the

# connection limit has been reached.

max_connections=100

设置max_connections=1000，然后重启MySQL

"这个参数实际起作用的最大值(实际最大可连接数)为16384，即该参数最大值不能超过16384，即使超过也以16384为准； "