[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 598
  • Last Modified:

MySQL error - MySql Server has gone away


I have a big union query (30 tables, each tabele has 1 milion records).
When I run the query for only 5 tabels it is ok, but when I try to run for all 30 table I get an error - MySql Server has gone away.

Thank you,
Qw M
Qw M
1 Solution
Guy Hengel [angelIII / a3]Billing EngineerCommented:
this usually means you need to assign the mysql server more memory:
increase key_buffer_size + read_buffer_size , restart your mysql server, and it should work better.
of course, if you can tune the query to perform faster can also help (indexes ...)

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now