#!/usr/bin/php
<?php

$lHost     = '127.0.0.1';
$lUser     = 'root';
$lPassword = 'secret';
$lPort     = '3306';

$lPort     = '3319';
$lPassword = '';

$lNoSchemas = 5000;
$lNoTables  = 200;

$rc = 0;

$mysqli = new mysqli($lHost, $lUser, $lPassword, null, $lPort, null);

if ( mysqli_connect_error() ) {
	$rc = 1;
	fprintf(STDERR, "ERROR: Connect failed: (%d) %s\n", mysqli_connect_errno(), mysqli_connect_error());
	exit($rc);
}
$mysqli->query('SET NAMES utf8');
$mysqli->query('SET GLOBAL sync_frm = off');

for ( $s = 0 ; $s < 1 ; $s++ ) {

	$sql = sprintf('CREATE SCHEMA `schema_%05d`', $s);
	// print $sql . "\n";
 	if ( $mysqli->query($sql) ) {
		printf('*');
		for ( $t = 0 ; $t < 1000 ; $t++ ) {
			$sql = sprintf('CREATE TABLE `schema_%05d`.`table_%04d` (`id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, `data` VARCHAR(64) DEFAULT NULL, `ts` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP)', $s, $t);
			// print $sql . "\n";
			if ( $mysqli->query($sql) ) {
				printf('.');
			}
			else {
				fprintf(STDERR, "\nERROR %d: %s\n", $mysqli->errno, $mysqli->error);
			}
		}
	}
	else {
		fprintf(STDERR, "\nERROR %d: %s\n", $mysqli->errno, $mysqli->error);
	}
}

$mysqli->query('SET GLOBAL sync_frm = on');

$mysqli->close();
exit($rc);

?>