<?php

$link=mysqli_connect("127.0.0.1","root","") or die(mysqli_connect_error());

mysqli_select_db($link,"test") or die(mysqli_error($link));


for($i=0;$i<65000;$i++)
{
        mysqli_query($link,"drop table if exists `opt`") or die(mysqli_error($link));
        mysqli_query($link,"CREATE TABLE `opt` (`a` int,`col000` smallint,`col001` int,`col002` mediumtext,`col003` mediumint,unique key(col002(255))) ENGINE=MyISAM DEFAULT CHARSET=latin1")or die(mysqli_error($link));
        
        for($j=1;$j<200;$j++)
        {
                $sql="INSERT INTO `opt` SET `a` = ".(10*$j*$i).", `col000` = 1, `col001` = 1, `col002` = 0x".($j*100024).", `col003` = 211111";
                //print $sql . "\n";
                mysqli_query($link,$sql)or die(mysqli_error($link));
        }
        mysqli_query($link,"delete from `opt` order by a limit 30 ")or die(mysqli_error($link));
        print "i=$i\n";
        
        $rs=mysqli_query($link,"optimize table `opt` extended");
        if($rs!==FALSE)
        {
                while($row=mysqli_fetch_array($rs))
                {
                        if($row['Msg_text'] != 'OK')
                        {
                                print_r($row);       
                        }
                }       
                mysqli_free_result($rs);
        }
        else
        {
                print mysqli_error($link) . " " . mysqli_errno($link)."\n";
        }
        
        $rs=mysqli_query($link,"check table `opt` extended");
        if($rs!==FALSE)
        {
                while($row=mysqli_fetch_array($rs))
                {
                       if($row['Msg_text'] != 'OK')
                        {
                                print_r($row);       
                        }
                }       
                mysqli_free_result($rs);
        }
        else
        {
                print mysqli_error($link) . " " . mysqli_errno($link)."\n";
        }
}

mysqli_close($link);

?>