Re: Lost connection to MySQL server during query

[Peter Brawley]

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