mysql 被寫入1W資料後無法select*from table,但是加入limit參數後可以查詢

資料庫表結構 innodb

SELECT 查詢錯誤提示

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

我覺得可能是 SELECT 執行時間過長,所以報錯.

mysql 日誌

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 did not exist:InnoDB: a new database to be created!150414  3:11:27  InnoDB: Setting file ./ibdata1 size to 10 MBInnoDB: Database physically writes the file full: wait...150414  3:11:27  InnoDB: Log file ./ib_logfile0 did not exist: new to be createdInnoDB: Setting log file ./ib_logfile0 size to 5 MBInnoDB: Database physically writes the file full: wait...150414  3:11:27  InnoDB: Log file ./ib_logfile1 did not exist: new to be createdInnoDB: Setting log file ./ib_logfile1 size to 5 MBInnoDB: Database physically writes the file full: wait...InnoDB: Doublewrite buffer not found: creating newInnoDB: Doublewrite buffer createdInnoDB: Creating foreign key constraint 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.

回複內容：

資料庫表結構 innodb

SELECT 查詢錯誤提示

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

我覺得可能是 SELECT 執行時間過長,所以報錯.

mysql 日誌

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 did not exist:InnoDB: a new database to be created!150414  3:11:27  InnoDB: Setting file ./ibdata1 size to 10 MBInnoDB: Database physically writes the file full: wait...150414  3:11:27  InnoDB: Log file ./ib_logfile0 did not exist: new to be createdInnoDB: Setting log file ./ib_logfile0 size to 5 MBInnoDB: Database physically writes the file full: wait...150414  3:11:27  InnoDB: Log file ./ib_logfile1 did not exist: new to be createdInnoDB: Setting log file ./ib_logfile1 size to 5 MBInnoDB: Database physically writes the file full: wait...InnoDB: Doublewrite buffer not found: creating newInnoDB: Doublewrite buffer createdInnoDB: Creating foreign key constraint 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一下

