8000 Python3 slow query execution · Issue #475 · PyMySQL/PyMySQL · GitHub
[go: up one dir, main page]

Skip to content
Python3 slow query execution #475
Closed
Closed
@paulfantom

Description

@paulfantom

I am creating mysql plugin for grabbing "GLOBAL STATUS" data for netdata. It executes one query ("SHOW GLOBAL STATUS") every second which doesn't carry very much data. However I found that your implementation of cursor.execute(query) is sluggish. It takes about 2-3x more time than MySQLdb implementation. After some investigation I think that the main reason behind it is usage of socket.makefile() which has some well known performance issues (https://bugs.python.org/issue18329)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

      0