Maison > développement back-end > tutoriel php > mysql 被写入1W数据后无法select*from table,但是加入limit参数后可以查询

mysql 被写入1W数据后无法select*from table,但是加入limit参数后可以查询

WBOY
Libérer: 2016-06-06 20:34:23
original
1206 Les gens l'ont consulté

数据库表结构 innodb

SELECT 查询错误提示

<code>ERROR 2013 (HY000): Lost connection to MySQL server during query
</code>
Copier après la connexion
Copier après la connexion

我觉得可能是 SELECT 执行时间过长,所以报错.

mysql 日志

<code>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.
</code>
Copier après la connexion
Copier après la connexion

回复内容:

数据库表结构 innodb

SELECT 查询错误提示

<code>ERROR 2013 (HY000): Lost connection to MySQL server during query
</code>
Copier après la connexion
Copier après la connexion

我觉得可能是 SELECT 执行时间过长,所以报错.

mysql 日志

<code>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.
</code>
Copier après la connexion
Copier après la connexion

把表repair一下

Étiquettes associées:
source:php.cn
Déclaration de ce site Web
Le contenu de cet article est volontairement contribué par les internautes et les droits d'auteur appartiennent à l'auteur original. Ce site n'assume aucune responsabilité légale correspondante. Si vous trouvez un contenu suspecté de plagiat ou de contrefaçon, veuillez contacter admin@php.cn
Tutoriels populaires
Plus>
Derniers téléchargements
Plus>
effets Web
Code source du site Web
Matériel du site Web
Modèle frontal