Re: Lost connection to MySQL server during query

[Christopher Popplewell]

Yes, the mysql service is running when I attempted the command.

Overall, I really think that something crashed at some point which created some inconsistency in the DB ebcause nothing has been changed that I know of that would cause these issues out of the blue - outside of a DoS-type attack.

Here is my.cnf. Looks a bit thin to me:
---------------------------------------
[mysqld]
innodb_file_per_table=1
default-storage-engine=MyISAM
performance-schema=0
max_allowed_packet=268435456
open_files_limit=10000
#socket=/var/lib/mysql/mysql.sock
---------------------------------------