<?php


$db = mysqli_connect("localhost","root","") or die("can't connect!\n");
mysqli_query($db,"set global max_allowed_packet=1024*1024*1024") or die("error: ".mysqli_error($db) . " ( " . mysqli_errno($db) . ")\n");
mysqli_close($db);

$db = mysqli_connect("localhost","root","") or die("can't connect!\n");
mysqli_select_db($db,"test") or die ("can't change db to test!\n");
mysqli_query($db,"set session max_allowed_packet=1024*1024*1024") or die("error: ".mysqli_error($db) . " ( " . mysqli_errno($db) . ")\n");

$num_param=0;
        
        print "dropping procedure\n";
        mysqli_query($db,"drop procedure if exists `p1`") or die("error: ".mysqli_error($db) . " ( " . mysqli_errno($db) . ")\n");
        
        $sql="create procedure `p1`(";
        $param="";
        for($i=0;$i<$num_param;$i++)
        {
                $param.="OUT `aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa$i` INT";
                if($i<($num_param-1))
                       $param.= ", ";        
        
        }
        $sql.=$param;
        $sql.= ")\r\n";
        $sql.= "begin\r\n";
        for($f=0;$f<700000;$f++)
        {
                $sql.= "\tselect rand() into @a;\r\n";
        }
        
        
        $sql.= "end;";
        print "creating procedure of length: " . strlen($sql) . ")\n";
        if(FALSE===mysqli_query($db,$sql))
        {
              print "error: ".mysqli_error($db) . " ( " . mysqli_errno($db) . ")\n";
             // print $sql;
              exit();
        }

        
        $sql1="call `p1`(";
        for($i=0;$i<$num_param;$i++)
        {
                $sql1.= "@b$i";
                if($i<($num_param-1))
                        $sql1.= ", ";
        }
        $sql1.=")";
        print "calling procedure\n";
        if(FALSE===mysqli_query($db,$sql1))
        {
              print "error: ".mysqli_error($db) . " ( " . mysqli_errno($db) . ")\n";
              print $sql . "\r\n";
              print $sql1 . "\r\n";
        }

mysqli_close($db);


?>