#129 Too long inserts confuse MySQL

3.2.0
closed-works-for-me
MySQL (68)
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
     
  • Nobody/Anonymous

    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.

     
  • SourceForge Robot

    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).

     
  • SourceForge Robot

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

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks