<?php

$db="test"; #warning this database will be dropped!
$link = mysqli_connect("127.0.0.1","root","",$db,3306) or die("cant connect");


$rs=mysqli_query($link,"show processlist");
$cnt=0;
while(1)
{
	$cnt++;
	print "iteration $cnt\n";
	$str=make_str(0,10);
	$rs=mysqli_query($link,"drop table if exists `t$str`");
	$rs=mysqli_query($link,"create table if not exists `t$str`(value varchar(20),fulltext index(value))engine=innodb");
	$rs=mysqli_query($link,"create table if not exists `t$str`(value varchar(10))engine=innodb");
	$rs=mysqli_query($link,"select @@session.innodb_ft_user_stopword_table");if($rs) mysqli_free_result($rs);
	$rs=mysqli_query($link,"select @@global.innodb_ft_user_stopword_table");if($rs) mysqli_free_result($rs);
	$rs=mysqli_query($link,"set global innodb_ft_user_stopword_table='$db/t$str'");
	$rs=mysqli_query($link,"set session innodb_ft_user_stopword_table='$db/t$str'");
	$rs=mysqli_query($link,"insert into `t$str` values('$str')");
	$rs=mysqli_query($link,"optimize table `t$str`");
	if($cnt % 100 == 0)
	{
		$rs=mysqli_query($link,"drop database if exists `$db`");
		$rs=mysqli_query($link,"create database if not exists `$db`");
	}
}
mysqli_close($link);
exit;

function make_str($min,$max)
{
	$str="";
	$len=mt_rand($min,$max);
	for($i=0;$i<$len;$i++)
	{
		$str.=chr(mt_rand(ord('a'),ord('z')));
	}
	
	return $str;
}
?>