MySQL中查询/查看表的大小限制是多少? [英] What is the size limit for a Query/View table in MySQL?

问题描述

我正在使用MySQL，目前在数据库中有3个表.我创建了一个视图表，其中包含3个表之间的关系.视图表应该是大约20万行数据，因为我也在Access中测试了相同的查询，并且工作正常，但是很遗憾，我不允许使用Access.

I am using MySQL and currently have 3 tables in a database. I created a view table with relationships between the 3 tables. The view table should be about 200 000 rows of data because i also tested the same query in Access and it works fine, but unfortunately i am not allowed to use Access.

当我在MySQL中构建视图时，我收到一条消息，指出该视图已成功构建.但是，当我尝试实际查看数据时，它给了我类似MySQL内存不足的信息.我不确定我可以做些什么来避免此消息.有人可以给点建议吗?

When i build the view in MySQL i get a message that says the view was build successfully. But when i try to actually view the data, it gives me something like, MySQL ran out of memory. I am not sure what i can do differently to avoid this message. Can someone please give some advice?

推荐答案

您可以使用

You can use the Quick option for running your query.

不要缓存每个查询结果，在接收到每一行时将其打印出来.这 如果输出被挂起，可能会降低服务器的速度.有了这个选项， mysql不使用历史记录文件.

Do not cache each query result, print each row as it is received. This may slow down the server if the output is suspended. With this option, mysql does not use the history file.

这篇关于MySQL中查询/查看表的大小限制是多少?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！