#129 Too long inserts confuse MySQL

3.2.0
closed-works-for-me
Jakub Vrána
MySQL (67)
5
2011-04-27
2011-03-02
Anonymous
No

Have a table with BLOBs, tiny ones - no more than 30Kb
Problem - Adminer does long INERTS with thousands of VALUES in single querry, buuut that makes MySQL server say "MySQL server has gone away"
For instance - PHPMyAdmin does shorter queries and doing alright

Statement - would be nice to have shorter INSERTS with fever VALUES or give opportunity to tune in a DUMP

Discussion

  • Ivan Bobrov
    Ivan Bobrov
    2011-03-07

    It is about export/import, couldn't mention it earlier...

     
  • Jakub Vrána
    Jakub Vrána
    2011-03-07

    What is your size of MySQL variable max_allowed_packet? Adminer assumes that it is at least 1 MB.

     
  • Jakub Vrána
    Jakub Vrána
    2011-03-07

    • status: open --> open
     
  • It is 1M

     
  • Jakub Vrána
    Jakub Vrána
    2011-03-07

    Strange. Can you please send me the table structure and an example of data that causes this error?

     
  • Jakub Vrána
    Jakub Vrána
    2011-03-07

    • status: open --> pending
     
  • Ivan Bobrov
    Ivan Bobrov
    2011-03-07

    can do, where to?

     
  • Ivan Bobrov
    Ivan Bobrov
    2011-03-07

    • status: pending --> open
     
  • Jakub Vrána
    Jakub Vrána
    2011-04-13

    • status: open --> pending-works-for-me
     
  • Jakub Vrána
    Jakub Vrána
    2011-04-13

    Please attach it to this bug.

     
  • This Tracker item was closed automatically by the system. It was
    previously set to a Pending status, and the original submitter
    did not respond within 14 days (the time period specified by
    the administrator of this Tracker).

     
    • status: pending-works-for-me --> closed-works-for-me