thanks much. exactly what I needed. -L -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 22, 2005 11:22 AM To: Crouch, Luke H. Cc: mysql@lists.mysql.com Subject: Re: extended insert limit?
"Crouch, Luke H." <[EMAIL PROTECTED]> wrote on 02/22/2005 12:18:51 PM: > what is the limit to the number of records that can be inserted via > an extended insert statement. I know mysqldump creates a new insert > statement every X records, but I forgot what that number is, and I'm > trying to duplicate the action. > > thanks, > -L The X you mention depends on the max_allowed_packet server setting. If adding another set of VALUES to an extended INSERT statement would cause the statement to exceed that value, mysqldump will end the current extended INSERT and start a new one. You will need to know the value of that variable for the server intended to execute the INSERT your are building in order to build INSERT statements that are as large as possible. Use SHOW VARIABLES LIKE 'max%' to see that value and several others. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
