Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-6404

max_allowed_packet

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Trivial
        • Resolution: Not a Bug
        • Affects Version/s: 10.0.7
        • Fix Version/s: N/A
        • Component/s: None
        • Environment:
          debian testing amd64, AMDFX8320, SSD, HDD, 16GRAM

          Description

          max_allowed_packet maximum size is 1GB, however I want to insert LARGEBLOBS - 4GB.

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                smooker Miroslav Tzonkov added a comment -

                workaround by temp table and max_allowed_packet / 2 sized packets
                kinda ugly

                Show
                smooker Miroslav Tzonkov added a comment - workaround by temp table and max_allowed_packet / 2 sized packets kinda ugly
                Hide
                Permalink
                axel Axel Schwenke added a comment -

                If you use the C API to access MySQL and if you use the prepared statement protocol, then you can send a BLOB in multiple pieces. The packet size limit applies to each piece you send, but the BLOB as a whole can be larger.

                This is done with the API function mysql_stmt_send_long_data() which is documented in the MySQL manual here. There is even an example how to use that function.

                You didn't say which connector you use to connect to MySQL. But if your connector is based on libmysqlclient (aka the C connector) then there is a certain chance that it exports this function as well.

                Show
                axel Axel Schwenke added a comment - If you use the C API to access MySQL and if you use the prepared statement protocol, then you can send a BLOB in multiple pieces. The packet size limit applies to each piece you send, but the BLOB as a whole can be larger. This is done with the API function mysql_stmt_send_long_data() which is documented in the MySQL manual here . There is even an example how to use that function. You didn't say which connector you use to connect to MySQL. But if your connector is based on libmysqlclient (aka the C connector) then there is a certain chance that it exports this function as well.
                Hide
                Permalink
                elenst Elena Stepanova added a comment -

                I'm closing this for now as not a bug. If you disagree or/and want to convert it to a feature request, please feel free to comment to-reopen.

                Show
                elenst Elena Stepanova added a comment - I'm closing this for now as not a bug. If you disagree or/and want to convert it to a feature request, please feel free to comment to-reopen.

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    smookie77 Miroslav Tzonkov
                  • Votes:
                    1 Vote for this issue
                    Watchers:
                    6 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved:

                      Time Tracking

                      Estimated:
                      Original Estimate - 1 day
                      1d
                      Remaining:
                      Remaining Estimate - 1 day
                      1d
                      Logged:
                      Time Spent - Not Specified
                      Not Specified