======= test1.php ======= 
<?php

mysql_connect("10.205.22.253", "root", "yessir");
mysql_select_db("test");

function create_new_sequence($option) {

        if ($option=="option1") {

                mysql_query("INSERT INTO option1 VALUES (NULL);");
                return mysql_insert_id();
        } else {

                mysql_query("UPDATE option2 SET id=@id:=id+1");
                $result = mysql_query("SELECT @id as id;");
                return mysql_result($result,0,'id');

        }
}


foreach(array("option1", "option2") as $option) {

        foreach(array("usetransactions", "ignoretransactions") as $transactions) {

                $time = time();

                for($i=0;$i<10000;$i++) {

                        if ($transactions=="usetransactions") mysql_query("START TRANSACTION");
                        $sequence = create_new_sequence($option);
                        mysql_query("INSERT INTO log_table (id, payload) VALUES ($sequence, REPEAT('a', 1024))");
                        if ($transactions=="usetransactions") mysql_query("COMMIT");

                }


                $finish_time = time();
                print "$option $transactions execution took " . ($finish_time - $time) . " seconds\n";
        }

}

?>
======= test2.php ======= 
<?php

$option = $argv[1];

if (!$option) { die("Please select an option"); } 

mysql_connect("10.205.22.253", "root", "yessir");
mysql_select_db("test");

function create_new_sequence($option) {

        if ($option=="option1") {

                mysql_query("INSERT INTO option1 VALUES (NULL);");
                return mysql_insert_id();
        } else {

                mysql_query("UPDATE option2 SET id=@id:=id+1");
                $result = mysql_query("SELECT @id as id;");
                return mysql_result($result,0,'id');

        }
}



$time = time();

for($i=0;$i<10000;$i++) {

        mysql_query("START TRANSACTION");
        $sequence = create_new_sequence($option);
        mysql_query("INSERT INTO log_table (id, payload) VALUES ($sequence, REPEAT('a', 1024))");
        mysql_query("COMMIT");

}

$finish_time = time();
print "THREAD: $option execution took " . ($finish_time - $time) . " seconds\n";

======= worker.sh ======= 
#!/bin/sh
php test2.php $1 >> results.txt &

======= Command Line execution of test2 ======= 
for i in `seq 1 4`; do ./worker.sh option1; done;
for i in `seq 1 4`; do ./worker.sh option2; done;
for i in `seq 1 8`; do ./worker.sh option1; done;
for i in `seq 1 8`; do ./worker.sh option2; done;

======= Schema ======= 

 CREATE TABLE `log_table` (
  `id` int(11) NOT NULL,
  `payload` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;

CREATE TABLE `option1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;

CREATE TABLE `option2` (
  `id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;