Tag DB
(compute-1-30.local was alias of tier2-06.local/tier2-06.uchicago.edu)

STATIC EXECUTABLES!
more performant

install new mysql (wget http://dev.mysql.com/get/Downloads/MySQL-4.1/mysql-standard-4.1.20-pc-linux-gnu-i686.tar.gz/from/ftp://mirror.mcs.anl.gov/pub/mysql/)

http://dev.mysql.com/get/Downloads/MySQL-4.1/mysql-standard-4.1.20-pc-linux-gnu-i686.tar.gz/from/ftp://mirror.services.wisc.edu/mirrors/mysql/

untar
[root@pplant local]# ln -s mysql-standard-4.1.20-pc-linux-gnu-i686 mysql
[root@pplant local]# cd mysql
[root@pplant mysql]# cd mysql-test/
[root@pplant mysql-test]# ls
include  install_test_db  install_test_db.ncf  lib  mysql-test-run  mysql-test-run.pl  r  README  std_data  t
[root@pplant mysql-test]# ./mysql-test-run
Logging: ./mysql-test-run 
Installing Test Databases
...

- follow install instructions

my.large 
(huge > 1GB)

data/my.cnf

port?
uncomment to use innodb
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /usr/local/mysql/data/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /usr/local/mysql/data/
#innodb_log_arch_dir = /usr/local/mysql/data/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 256M
#innodb_additional_mem_pool_size = 20M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 64M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50

setup 2 accounts:
reader and writer

create database tier2tagdb;
grant all on tier2tagdb.* to tagwriter@'%.local' identified by 'xxxxxx';
grant select on tier2tagdb.* to tagreader; 
flush privileges;
\s
show databases;
show variables;

./mysql -u tagwriter -h tier2-06.local -p tier2tagdb
./mysql -u tagreader -h tier2-06.local  tier2tagdb

show databases;
create table `test1` (`a1` varchar(16) ) engine=innodb;
insert into test1 set a1='pippo';
select * from test1;

FROM INSTALL.txt and mysql outputs:
     shell> groupadd mysql
     shell> useradd -g mysql mysql
     shell> cd /usr/local
     shell> gunzip < /PATH/TO/MYSQL-VERSION-OS.tar.gz | tar xvf -
     shell> ln -s FULL-PATH-TO-MYSQL-VERSION-OS mysql
     shell> cd mysql
     shell> scripts/mysql_install_db --user=mysql
     shell> chown -R root  .
     shell> chown -R mysql data
     shell> chgrp -R mysql .
     shell> bin/mysqld_safe --user=mysql &

Installing all prepared tables
Fill help tables

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h tier2-06 password 'new-password'
See the manual for more instructions.

You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench'
directory:
cd sql-bench ; perl run-all-tests