MySQL Forums
Forum List  »  Newbie

Re: Lost connection to MySQL server during query
Posted by: Peter Brawley
Date: November 14, 2017 09:47PM

Still need results of that database size query, the results of free -m when the server is busy, and error log entries when a crash occurs.

Some of the settings in Show Variables, some up to 16 exabytes, look way too high for a machine with 4GB RAM. Without data on database load size, server error reports and status data for longer uptime, it's just a guess that lowering those settings to something your RAM and disk could handle would help.

The server had been running for just 11 mins, so Show Status gives very little info. It does indicate that in those 11 minutes it opened 28k files, fielded 58k lock requests, and read 612k rows---all on just 3 connections.

Not related to the crash problem but these settings don't get along with one another ...

collation_connection utf8_general_ci
collation_database latin1_swedish_ci
collation_server latin1_swedish_ci

Options: ReplyQuote


Subject
Written By
Posted
Re: Lost connection to MySQL server during query
November 14, 2017 09:47PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.