MySQL cannot select*from table after it has been written to 1W data, but can query after adding the limit parameter

database table Structure InnoDB

SELECT Query Error prompt

ERROR 2013 (HY000): Lost connection to MySQL server during query

I think it may be that the SELECT execution time is too long, so error.

MySQL Log

150414 03:11:26 Mysqld_safe starting mysqld daemon with databases from/var/lib/mysql150414 3:11:27 innodb:initializing Buffer pool, size = 8.0m150414 3:11:27 innodb:completed initialization of buffer poolinnodb:the first specified data File./ibdata1 didn't exist:innodb:a new database to is created!150414 3:11:27 innodb:setting file./ibdata1 size to Ten Mbinnodb:database physically writes the file full:wait ... 150414 3:11:27 innodb:log file./ib_logfile0 did not exist:new-be createdinnodb:setting Log file./ib_logfile0 siz E to 5 Mbinnodb:database physically writes the file full:wait ... 150414 3:11:27 innodb:log file./ib_logfile1 did not exist:new-be createdinnodb:setting Log file./ib_logfile1 siz E to 5 Mbinnodb:database physically writes the file full:wait ... Innodb:doublewrite Buffer not found:creating newinnodb:doublewrite buffer createdinnodb:creating foreign key constrain T system tablesinnodb:foreign key constraint system tables created150414 3:11:27 innodb:started; Log sequence number 0 0150414 3:11:27 [note] Event scheduler:loaded 0 events150414 3:11:27 [note]/usr/libexec/mysqld: Ready for connections.

Reply content:

database table Structure InnoDB

SELECT Query Error prompt

ERROR 2013 (HY000): Lost connection to MySQL server during query

I think it may be that the SELECT execution time is too long, so error.

MySQL Log

150414 03:11:26 Mysqld_safe starting mysqld daemon with databases from/var/lib/mysql150414 3:11:27 innodb:initializing Buffer pool, size = 8.0m150414 3:11:27 innodb:completed initialization of buffer poolinnodb:the first specified data File./ibdata1 didn't exist:innodb:a new database to is created!150414 3:11:27 innodb:setting file./ibdata1 size to Ten Mbinnodb:database physically writes the file full:wait ... 150414 3:11:27 innodb:log file./ib_logfile0 did not exist:new-be createdinnodb:setting Log file./ib_logfile0 siz E to 5 Mbinnodb:database physically writes the file full:wait ... 150414 3:11:27 innodb:log file./ib_logfile1 did not exist:new-be createdinnodb:setting Log file./ib_logfile1 siz E to 5 Mbinnodb:database physically writes the file full:wait ... Innodb:doublewrite Buffer not found:creating newinnodb:doublewrite buffer createdinnodb:creating foreign key constrain T system tablesinnodb:foreign key constraint system tables created150414 3:11:27 innodb:started; Log sequence number 0 0150414 3:11:27 [note] Event scheduler:loaded 0 events150414 3:11:27 [note]/usr/libexec/mysqld: Ready for connections.

Repair the watch, please.

