Bug #7927 | max_allowed_packet = 1M | ||
---|---|---|---|
Submitted: | 15 Jan 2005 15:06 | Modified: | 17 Jan 2005 16:39 |
Reporter: | Olaf van der Spek (Basic Quality Contributor) | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Documentation | Severity: | S3 (Non-critical) |
Version: | MySQL 4.1.9-nt | OS: | Windows (Windows) |
Assigned to: | Sergei Golubchik | CPU Architecture: | Any |
[15 Jan 2005 15:06]
Olaf van der Spek
[15 Jan 2005 15:30]
MySQL Verification Team
Thank you for writting to us. The config files accompanying our releases are only an example, a starting point for each user. And there is lot of sense in having larger packet value for mysqldump, in case that data is to be dumped from some other server.
[15 Jan 2005 15:37]
Olaf van der Spek
> The config files accompanying our releases are only an example, a starting point for each user. It's not just an example, it's also the default. And what's the reason for not fixing/improving the default and/or examples? > And there is lot of sense in having larger packet value for mysqldump, in case that data is to be dumped from some other server. dumping from? What sense does it make that a server can't read it's own dump?
[16 Jan 2005 20:06]
Sergei Golubchik
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release. If necessary, you can access the source repository and build the latest available version, including the bugfix, yourself. More information about accessing the source trees is available at http://www.mysql.com/doc/en/Installing_source_tree.html Additional info: changed max_allowed_packet for mysqldump to be 1M too.
[16 Jan 2005 20:21]
Olaf van der Spek
Why did you decrease the value for mysqldump instead of increasing the value for mysqld?
[16 Jan 2005 21:02]
Sergei Golubchik
Sorry, not changed :) As mysqldump does not use max_allowed_packet to limit a statement length in a dump, the problem does not exist. (Manual was wrong in this regard - it's fixed now)
[16 Jan 2005 21:18]
Olaf van der Spek
So what is it used for in mysqldump?
[17 Jan 2005 16:39]
MySQL Verification Team
max_allowed_packet is used to limit maximum record size that can be read from the server. net_buffer_length is used to limit number of rows in multi-row inserts, as generated by mysqldump.