We are running 2.6.15-gentoo Linux and downloaded the max binaries for 5.1.7. With the following my.cnf I thought we should have InnoDB. All of the InnoDB files got created but show variables like 'have%'; displays " have_innodb DISABLED". Exactly the same my.cnf {except the skip bdb is not commented out} has InnoDB enabled.
Any ideas on what we have to do to enable InnoDB. my.cnf # You can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /usr/local/var) or # ~/.my.cnf to set user-specific options. # # In this file, you can use all long options that a program supports. # If you want to know which options a program supports, run the program # with the "--help" option. # The following options will be passed to all MySQL clients [client] #password = your_password port = 3306 socket = /tmp/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket = /tmp/mysql.sock max_connections = 100 key_buffer = 256M max_allowed_packet = 1M table_cache = 256 sort_buffer_size = 256K read_buffer_size = 256K read_rnd_buffer_size = 256K thread_cache_size = 8 query_cache_size= 2M # Try number of CPU's*2 for thread_concurrency thread_concurrency = 4 # Replication Master Server (default) # binary logging is required for replication log-bin=mysql-bin # required unique id between 1 and 2^32 - 1 # defaults to 1 if master-host is not set # but will not function as a master if omitted server-id = 1 # Point the following paths to different dedicated disks #tmpdir = /tmp/ #log-update = /path-to-dedicated-directory/hostname skip-bdb # Uncomment the following if you are using InnoDB tables #innodb_data_home_dir = /usr/local/var/ innodb_data_file_path = ibd1:2000M;ibd2:2000M;ibd3:2000;ibd4:10M:autoextend #innodb_log_group_home_dir = /usr/local/var/ #innodb_log_arch_dir = /usr/local/var/ # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high innodb_buffer_pool_size = 512M innodb_additional_mem_pool_size = 20M # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 128M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 0 innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [myisamchk] key_buffer = 128M sort_buffer_size = 128M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout mysql> select version(); +--------------------+ | version() | +--------------------+ | 5.1.7-beta-max-log | +--------------------+ 1 row in set (1.73 sec) Linux zeus 2.6.15-gentoo-r1 #10 SMP PREEMPT Tue Mar 7 15:36:28 MST 2006 i686 Intel(R) Xeon(TM) CPU 3.80GHz GenuineIntel GNU/Linux mysql> show variables like 'have%'; +----------------------------+----------+ | Variable_name | Value | +----------------------------+----------+ | have_archive | YES | | have_bdb | DISABLED | | have_blackhole_engine | YES | | have_compress | YES | | have_crypt | YES | | have_csv | YES | | have_example_engine | NO | | have_federated_engine | YES | | have_geometry | YES | | have_innodb | DISABLED | | have_ndbcluster | DISABLED | | have_openssl | NO | | have_partitioning | YES | | have_query_cache | YES | | have_row_based_replication | YES | | have_rtree_keys | YES | | have_symlink | YES | +----------------------------+----------+ 17 rows in set (0.10 sec) mysql> show variables like 'inno%'; +---------------------------------+----------------------------------------- ------------+ | Variable_name | Value | +---------------------------------+----------------------------------------- ------------+ | innodb_additional_mem_pool_size | 20971520 | | innodb_autoextend_increment | 8 | | innodb_buffer_pool_awe_mem_mb | 0 | | innodb_buffer_pool_size | 536870912 | | innodb_checksums | ON | | innodb_commit_concurrency | 0 | | innodb_concurrency_tickets | 500 | | innodb_data_file_path | ibd1:2000M;ibd2:2000M;ibd3:2000;ibd4:10M:autoextend | | innodb_data_home_dir | | | innodb_doublewrite | ON | | innodb_fast_shutdown | 1 | | innodb_file_io_threads | 4 | | innodb_file_per_table | OFF | | innodb_flush_log_at_trx_commit | 0 | | innodb_flush_method | | | innodb_force_recovery | 0 | | innodb_lock_wait_timeout | 50 | | innodb_locks_unsafe_for_binlog | OFF | | innodb_log_arch_dir | | | innodb_log_archive | OFF | | innodb_log_buffer_size | 8388608 | | innodb_log_file_size | 134217728 | | innodb_log_files_in_group | 2 | | innodb_log_group_home_dir | | | innodb_max_dirty_pages_pct | 90 | | innodb_max_purge_lag | 0 | | innodb_mirrored_log_groups | 1 | | innodb_open_files | 300 | | innodb_support_xa | ON | | innodb_sync_spin_loops | 20 | | innodb_table_locks | ON | | innodb_thread_concurrency | 20 | | innodb_thread_sleep_delay | 10000 | +---------------------------------+----------------------------------------- ------------+ 33 rows in set (0.12 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]