mysql的65535
时间: 2023-10-21 18:29:13 浏览: 30
MySQL的65535是指MySQL关系型数据库中单行的最大长度限制。根据引用[1]和引用的信息,最大行大小为65535字节,不包括BLOB字段。如果在插入或修改表的过程中,单行的大小超过了这个限制,就会报错"Row size too large",如引用所示。这个限制是为了确保查询的性能和效率。因为超过这个限制后,查询的IOPS(每秒输入/输出操作数)将会受到影响。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *3* [MYSQL单行长度不能超过 65535](https://blog.csdn.net/shushugood/article/details/80917671)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
- *2* [Mysql 报Row size too large 65535 的原因及解决方法](https://download.csdn.net/download/weixin_38585666/13700966)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]