mysql超过1W条查询不显示_mysql,php_mysql 被写入1W数据后无法select*from table,但是加入limit参数后可以查询，mysql,php - phpStudy...

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/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.

相关阅读:

正则表达式如何批量替换

seajs里一个文件有多个模块的时候如何加载某一个模块？

如何更改vc++2010解决方案资源管理器的前景和背景色?

chrome中有类似的功能吗?

"" and None的结果为什么是"" 而不是None？

正确书写EJS的方式？代码补全？编辑器插件？

在引用工程里面不能设置断点

这种网页字体是用的什么字体。如何实现的？

微信这个效果是怎么实现的

关于dd命令翻录CD镜像和用其他无损音频编码器翻录的音乐音质之间的区别

rsync的安全性问题

js 自执行函数可否代替onload事件？

flexbox与list-style冲突？

angular添加class问题

vertical-align: top; 处理图片与div之间空隙的问题？

如何实现搜索应用程序菜单栏中的选项

请问这个需求如何用`jmeter`实现？

如何提高memcache缓存命中率？

nodejs 怎么获取post请求的json数据

爬虫抓取数据页一直返回HTTP code 417