數(shù)據(jù)庫(kù)表結(jié)構(gòu) innodb

SELECT 查詢錯(cuò)誤提示

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

我覺(jué)得可能是 SELECT 執(zhí)行時(shí)間過(guò)長(zhǎng),所以報(bào)錯(cuò).

mysql 日志

150414 03:11:26 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

150414 3:11:27 InnoDB: Initializing buffer pool, size = 8.0M

150414 3:11:27 InnoDB: Completed initialization of buffer pool

InnoDB: 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 MB

InnoDB: Database physically writes the file full: wait...

150414 3:11:27 InnoDB: Log file ./ib_logfile0 did not exist: new to be created

InnoDB: Setting log file ./ib_logfile0 size to 5 MB

InnoDB: Database physically writes the file full: wait...

150414 3:11:27 InnoDB: Log file ./ib_logfile1 did not exist: new to be created

InnoDB: Setting log file ./ib_logfile1 size to 5 MB

InnoDB: Database physically writes the file full: wait...

InnoDB: Doublewrite buffer not found: creating new

InnoDB: Doublewrite buffer created

InnoDB: Creating foreign key constraint system tables

InnoDB: Foreign key constraint system tables created

150414 3:11:27 InnoDB: Started; log sequence number 0 0

150414 3:11:27 [Note] Event Scheduler: Loaded 0 events

150414 3:11:27 [Note] /usr/libexec/mysqld: ready for connections.

總結(jié)

以上是生活随笔為你收集整理的mysql超过1W条查询不显示_mysql 被写入1W数据后无法select*from table,但是加入limit参数后可以查询...的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。