forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Bulk Insert — Bug?
- This topic is empty.
-
AuthorPosts
-
-
August 24, 2006 at 2:11 pm #22160
peterlaursen
Participant1) the 'bug'
Not reproducable! I get for instance this INSERT statement:
Code:insert into `tablename1` (`id`,`v`) values (1,'a'),(2,'b'),(3,'c');.. and that IS a BULK insert statement to my best understanding.
2) requests:
both are reasonable. I do not know how hard is is to copy to the editor.
-
August 25, 2006 at 12:17 am #22161
peterlaursen
ParticipantNow if you are sure that you do not get BULKs when you specify it, we will have to find the reason for difference!
-
August 25, 2006 at 12:50 pm #22162
FireStorm9
Memberpeterlaursen wrote on Aug 25 2006, 12:17 AM:@FireStorm9Now if you are sure that you do not get BULKs when you specify it, we will have to find the reason for difference!
I am sure. Please see the attached files for selection, result, and version information.
The connection is to a Linux server on my local lan, i.e. no ssh tunneling or anything special.
If there's anything I can do to to help I'd love to!
Thanks!!!
[attachment=506:attachment]
[attachment=509:attachment]
[attachment=510:attachment]
-
August 25, 2006 at 2:58 pm #22163
peterlaursen
Participanttools … preferences … General TAB.
What is the setting for 'Max packet Size' on your system?
If it is = (zero) or very low that woluld explain!
-
August 25, 2006 at 9:08 pm #22164
FireStorm9
Memberpeterlaursen wrote on Aug 25 2006, 02:58 PM:tools … preferences … General TAB.What is the setting for 'Max packet Size' on your system?
If it is = (zero) or very low that woluld explain!
I checked and it was indeed set to custom: 8.
I changed it to “server default” and got the same result (complete sql statements).
I restarted SQLYog just in case, but STILL got the same results.
Thanks!
-
August 25, 2006 at 9:21 pm #22165
peterlaursen
Participant“I changed it to “server default””
'server default' means that the server setting for max_allowed_packet is used.
What is the server 'max_allowed_packet' in your case?
(tool .. show .. variables will tell).
What happens if you set the BULK sixe yourself to – say – '200' ?
-
August 25, 2006 at 10:31 pm #22166
FireStorm9
Memberpeterlaursen wrote on Aug 25 2006, 09:21 PM:“I changed it to “server default””'server default' means that the server setting for max_allowed_packet is used.
What is the server 'max_allowed_packet' in your case?
(tool .. show .. variables will tell).
What happens if you set the BULK sixe yourself to – say – '200' ?
show variables like 'max_allowed_p%';
Code:Variable_name Value
—————— ——-
max_allowed_packet 1047552Set to custom: 512
Same result.
Thanks,
-
August 25, 2006 at 11:13 pm #22167
peterlaursen
ParticipantOKOKOKOK .. I give up then … let us return to this later next week!
-
August 26, 2006 at 1:10 pm #22168
FireStorm9
Memberpeterlaursen wrote on Aug 25 2006, 11:13 PM:OKOKOKOK .. I give up then … let us return to this later next week!Ahhh come on!!!! 🙂
Have a good weekend!
-
-
AuthorPosts
- You must be logged in to reply to this topic.