Home > General > MySQL Gotchas

MySQL Gotchas

Installation
-On a FC1 box, you will need to download the server and client rpms. You will also want to download mysqlcc, the Enterprise Manager equivalent.
-The RPMs set the mysql data dir to be /var/lib/mysql

Configuration
-MySQL supports several different table implementations, and the default, on MySQL 4.1, is the “old” non-transactional table type. Not so much as useful for our purposes.
-MySQL’s main table types are
–MyISAM – default, non-transactional
–InnoDB – transactional
–DBD – Berkley DB
-You need to put a my.cnf file in /etc . There are samples that ship with the RPMs in /usr/share/mysql.
–Take one of the examples and add “default-table-type=InnoDB” below the [mysqld] entry

Categories: General Tags:
  1. No comments yet.