database performance - test setup

database performance: test setup: MySQL

MySQL has been bundled with most open-source operating system for many years so it is no surprise that the installation was remarkably easy:

yum install mysql mysql-server
chkconfig mysql on
/etc/init.d/mysql start
echo "GRANT ALL ON test.* TO test@'localhost' IDENTIFIED BY 'test';" | mysql -u root

This is all that is needed to access the database with the following JDBC url:
jdbc:mysql://localhost/test
The default connections will use isolation level 4: "Repeatable Read".