MySQL数据库插入的数据限制 [英] Data Limit on MySQL DB Insert
问题描述
我想知道是否对要插入到MySQL数据库的数据大小有限制。
I was wondering if there was a limit to the size of data to be Inserted into a MySQL database?
我似乎成功插入记录,但是当某些textarea字段变大,似乎记录不会被Insert。有人可以让我知道是否有大小限制或者是否只有一个错误?
I seem to be successfully Inserting records but when certain textarea fields get large, it seems like the records won't Insert. Can someone let me know if there is a size limit or if there is just an error?
感谢。
Brett
推荐答案
这取决于磁盘和内存大小和网络限制:
It depends in the disk and memory size and network limitations mostly:
报价从我的sql网站:
Quote From my sql website:
http://dev.mysql.com/doc/refman/5.0/en/blob.html
BLOB或TEXT对象的最大大小由其类型
决定,但实际上可以在客户端和
服务器之间传输的最大值由可用内存量确定而
的大小是通信缓冲区。您可以通过更改max_allowed_packet变量的值来更改消息缓冲区大小,但必须对服务器和客户端程序执行$ b $ b
The maximum size of a BLOB or TEXT object is determined by its type, but the largest value you actually can transmit between the client and server is determined by the amount of available memory and the size of the communications buffers. You can change the message buffer size by changing the value of the max_allowed_packet variable, but you must do so for both the server and your client program
这篇关于MySQL数据库插入的数据限制的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!