HowTo install MySQL on AIX 5.3


Please shareShare on FacebookShare on Google+Tweet about this on TwitterShare on LinkedInShare on RedditDigg thisShare on StumbleUpon

AXS ThisTutorial will show you how to install MySQL on AIX 5.3



  • gunzip
  • tar, GNU tar is known to work

Make sure that:

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


Get pre compiled binary from SUNET:

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 .


Create /etc/my.cnf, get the PATH:s right, i.e:

Old passwords

To activate support for

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 server:
shell> bin/mysqld_safe –user=mysql &


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

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=0x80000000′

Then erase data/ib_logfile* and start mysqld.

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}