Skip to content

Helpful hints for users to speed up INSERT queries in MySQL #9

@henno

Description

@henno

When starting, the program should:

  1. check the 'max_allowed_packet' value set on the MySQL server. If this value is less than 16777217 (default is 16777216 or 16MB), it should show a yellow warning message that "The MySQL max_allowed_packet value is {} MB. If you have more than 1.6GB of RAM, this is not optimal because it should be between 1% of your total RAM and 1GB".
  2. check the 'innodb_buffer_pool_size' value set on the MySQL server. If this value is less than 134217729 (default is 134217728 which is 128MB), it should show a yellow warning message that "The MySQL max_allowed_packet value is {} MB which is not optimal because it should be 50-75% of total RAM in case of a dedicated MySQL server".

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions