HowTo install MySQL on AIX 5.3

• Tweet

• Tweet

ThisTutorial will show you how to install MySQL on AIX 5.3

Prerequisites

Tools:

• gunzip
• tar, GNU tar is known to work

Make sure that:

• /usr fileystem exists, is mounted and has at least 100MB free space

Download

Get pre compiled binary from SUNET:
http://ftp.sunet.se/pub/unix/databases/relational/mysql/Downloads/MySQL-5.0/mysql-standard-5.0.27-aix5.2-powerpc-64bit.tar.gz
Installation

Create user and group mysql. Gunzip and take a look at INSTALL-BINARY:
shell> wget http://url/to/mysql-version.tar.gzshell> cd /usr/localshell> groupadd mysqlshell> useradd -g mysql mysqlshell> gunzip < /path/to/mysql-version.tar.gz | tar -xvf

Link the library to mysql for simplicity:
shell> ln -s /full/path/to/mysql-version mysql

Create mysql database:
shell> cd mysqlshell> scripts/mysql_install_db –user=mysql

Correct owner and permissions:
shell> pwd/usr/local/mysqlshell> chown -R root .shell> chown -R mysql datashell> chgrp -R mysql .

Config

Create /etc/my.cnf, get the PATH:s right, i.e:
[mysqld]datadir=/usr/local/mysql/datasocket=/tmp/mysql.sock[mysql.server]user=mysqlbasedir=/usr/local/mysql/lib[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/usr/local/mysql/data/axdlab.pid

Old passwords

To activate support for
old_passwords=1
InnoDB

InnoDB variables, goes under the [mysqld] section:
default-table-type = INNODBinnodb_file_per_tableinnodb_data_file_path = ibdata1:10M:autoextendset-variable = innodb_buffer_pool_size=32Mset-variable = innodb_additional_mem_pool_size=4Mset-variable = innodb_log_file_size=8Mset-variable = innodb_log_buffer_size=8Minnodb_flush_log_at_trx_c ommit=1

Trim the values to fit your installation. See examples under support-files/.
Start

Start server:
shell> bin/mysqld_safe –user=mysql &

Passwords

Set password for the mysql root user:
shell> ./bin/mysqladmin -u root password ‘newpassword’shell> ./bin/mysqladmin -u root -h localhost password ‘newpassword’

Start at boot

Use support-files/mysql.server
Errors

If you get the following error at mysqld startup:
Error:070627 21:36:12 InnoDB: Error: cannot allocate 209731584 bytes ofInnoDB: memory with malloc! Total allocated memoryInnoDB: by InnoDB 29352528 bytes. Operating system errno: 12InnoDB: Check if you should increase the swap file orInnoDB: ulimits of your operating system.[...]

Add this to /etc/security/limits:
mysql: data = -1

And in bin/mysqld_safe something like:
export LDR_CNTRL=’MAXDATA=0×80000000′

Then erase data/ib_logfile* and start mysqld.
Misc

Show version info and such:
# bin/mysql -u root -pEnter password:Welcome to the MySQL monitor. Commands end with ; or g.[...]mysql> show variables like ‘%version%’; +————————-+——————————————+| Variable_name | Value |+————————-+——————————————+| protocol_version | 10 || version | 5.0.27-standard || version_comment | MySQL Community Edition – Standard (GPL) || version_compile_machine | powerpc || version_compile_os | ibm-aix5.2.0.0 |+————————-+——————————————+5 rows in set (0.00 sec)mysql>

Benchmarks is located under sql-bench:
shell> cd sql-bench ; perl run-all-tests

And is done, see you in the next tutorial

{loadposition user9}

Related Articles By Tags :

{loadposition user1}

Related posts:

1. MySQL recover root Password