Mysql的longblob字段插入数据问题解决_MySQL
bitsCN.com
在使用mysql的过程中，有个问题就是mysql的优化，mysql中longblob字段在5.5版本中默认的为1M。
想改变这个问题，需要注意几点：
com.mysql.jdbc.PacketTooBigException: Packet for query is too large (2054817 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.
原因：myslq默认配置最小的需要更改 ：在mysql.ini中配置参数（max_allowed_packet=1024M） ；
但是在[client]和[mysql]部分添加始终没有效果，貌似是客户端读取的参数。所以需要注意这点。bitsCN.com
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1359
52
The page is blank after PHP is connected to MySQL. What is the reason for the invalid die() function?
Apr 01, 2025 pm 03:03 PM
The page is blank after PHP connects to MySQL, and the reason why die() function fails. When learning the connection between PHP and MySQL database, you often encounter some confusing things...
PHP PDO connection to MySQL database: How does the charset=utf8 setting affect the database character set?
Apr 01, 2025 am 11:39 AM
PHP...
How to efficiently integrate Node.js or Python services under LAMP architecture?
Apr 01, 2025 pm 02:48 PM
Many website developers face the problem of integrating Node.js or Python services under the LAMP architecture: the existing LAMP (Linux Apache MySQL PHP) architecture website needs...
How to share the same page on the PC and mobile side and handle cache issues?
Apr 01, 2025 pm 01:57 PM
How to share the same page on the PC and mobile side and handle cache issues? In the nginx php mysql environment built using the Baota background, how to make the PC side and...
Is Debian Strings compatible with multiple browsers
Apr 02, 2025 am 08:30 AM
"DebianStrings" is not a standard term, and its specific meaning is still unclear. This article cannot directly comment on its browser compatibility. However, if "DebianStrings" refers to a web application running on a Debian system, its browser compatibility depends on the technical architecture of the application itself. Most modern web applications are committed to cross-browser compatibility. This relies on following web standards and using well-compatible front-end technologies (such as HTML, CSS, JavaScript) and back-end technologies (such as PHP, Python, Node.js, etc.). To ensure that the application is compatible with multiple browsers, developers often need to conduct cross-browser testing and use responsiveness
Docker builds LNMP environment: Is a single Dockerfile or Docker Compose better?
Apr 01, 2025 pm 02:09 PM
Dockerfile Best Practice for Building LNMP Environment Learning During Docker, many developers try to build their own LNMP (Linux, Nginx, MySQL, PHP)...
Comparison of Redis queues and MySQL stability: Why is Redis prone to data loss?
Apr 01, 2025 pm 02:24 PM
Comparison of Redis queues and MySQL stability: Why is Redis prone to data loss? In the development environment, using PHP7.2 and ThinkPHP frameworks, we often face the choice of cooperation...
When using Django and MySQL to process hundreds of thousands to one or two million pieces of data, what kind of cache solution should a 4-core 8G memory server choose?
Apr 01, 2025 pm 11:36 PM
Using Django and MySQL to process large data volumes When using Django and MySQL databases, if your data volume reaches hundreds of thousands to one or two million...
