3. import pymysql
    4. db = pymysql.connect("0.0.0.0","root","123456","x")
    5. cursor = db.cursor()
    6. cursor.execute('select count(*) from TIJJ_DEFAULTINFO')
    7. cursor.fetchall()
    8. # ((94,),)
    11. from DBUtils.PooledDB import PooledDB
    12. import pymysql
    13. c_mysql = '0.0.0.0,root,123456,x'
    14. [c1, c2, c3, c4] = c_mysql.split(',')
    15. pool2 = PooledDB(creator=pymysql, maxconnections=16, mincached=5, blocking=True, host=c1, user=c2, passwd=c3, db=c4, port=3306)
    16. print('池子目前有', len(pool2._idle_cache))
    18. db1 = pool2.connection()
    19. cursor1 = db1.cursor()
    20. cursor1.execute('show tables;')
    21. print('池子目前有', len(pool2._idle_cache))
    23. db2 = pool2.connection()
    24. cursor2 = db2.cursor()
    25. cursor2.execute('show tables;')
    26. print('池子目前有', len(pool2._idle_cache))
    28. # 池子目前有 5
    29. # 池子目前有 4
    30. # 池子目前有 3
    33. from DBUtils.PersistentDB import PersistentDB
    34. import pymysql
    35. c_mysql = '0.0.0.0,root,123456,x'
    36. [c1, c2, c3, c4] = c_mysql.split(',')
    37. pool2 = PersistentDB(creator=pymysql, threadlocal=None, host=c1, user=c2, passwd=c3, db=c4, port=3306)
    39. db1 = pool2.connection()
    40. cursor1 = db1.cursor()
    41. cursor1.execute('show tables;')
    42. print('End')
    44. db2 = pool2.connection()
    45. cursor2 = db2.cursor()
    46. cursor2.execute('show tables;')
    47. print('End')
    49. # End
    50. # End