Question

我能把我最多的东西储存在我的SQL的一栏中? 我看不到《我的后勤手册》中提到的情况。

Answer 1

这里谈论的是@JorgeLondoño。

2. 设定服务器的最大允许包装尺寸:

mysql> set global max_allowed_packet=1024*1024*1024;

• 取消并再次开放我的客户,从而确定客户的最大包装规模,以便:

$ mysql --max-allowed-packet=$((1024*1024*1024))

a. 设立一个有色人听记的测试表,填写时间最长的线人文件如下:

mysql> create table test.jtest ( j json );

mysql> insert into test.jtest 
  set j = concat( [ , repeat( "word", , 100000000),  "word"] );
Query OK, 1 row affected (1 min 49.67 sec)

mysql> select length(j) from test.jtest;
+-----------+
| length(j) |
+-----------+
| 800000008 |
+-----------+

This shows that I was able to create a single JSON document with 100 million elements, and MySQL stores this in approximately 800MB.

我没有尝试一份较长的文件。我假定在1 GB中达到最高点,这是你可以确定的最大值。

Answer 2

JSON栏中储存的JSON文件数量限于<代码>的数值。 (尽管服务器在内部对一名初等人物的记忆进行操纵,但这种数值可能更大;该限额在服务器储存时适用。)

Command-Line Format --max_allowed_packet=#
System Variable Name    max_allowed_packet
Variable Scope  Global, Session
Dynamic Variable    Yes
Permitted Values    Type    integer
Default 4194304
Min Value   1024
Max Value   1073741824

Answer 3

Max allowed size for json data type field in MySql is 1GB. If json is less than 8k in size then it will be store as part of the row itself, just like other data types. On other hand json larger than 8k will be moved to seperate space as a document and individual SQL row will have pointer to that document.

我建议处理错误,如果你认为上载的json可能比1GB OR要好得多,如果你在将json储存到银行之前能够检查其大小。

信息源链接here

友情链接