> <snip> I can't find a my.cnf file anywhere on this
> FreeBSD 4.5 system!
>
> I know [also from your other reply :-] that I can set various options in
> my personal .my.cnf file... Does that include innodb file paths and the
> like, or is that only in the system-level file?
IMO it's best to have just one my.cnf.ini.
> % skip-innodb
> % is not commented out, do so. If other innodb vars are commented out,
> % uncomment them.
>
> I'll leave the rest of these checks until I find the file... Meanwhile,
> here are some selections from a 'show variables;' that make me wonder
> about our innodb status...
>
> Variable_name Value
>
> bdb_home /var/db/mysql/
> datadir /var/db/mysql/
> have_bdb YES
> have_innodb DISABLED
> have_isam YES
> innodb_additional_mem_pool_size 1048576
> innodb_buffer_pool_size 8388608
> innodb_data_file_path
> innodb_data_home_dir
> innodb_file_io_threads 4
> innodb_force_recovery 0
> innodb_thread_concurrency 8
> innodb_flush_log_at_trx_commit 16777216
> innodb_fast_shutdown ON
> innodb_flush_method
> innodb_lock_wait_timeout 50
> innodb_log_arch_dir
> innodb_log_archive OFF
> innodb_log_buffer_size 1048576
> innodb_log_file_size 5242880
> innodb_log_files_in_group 2
> innodb_log_group_home_dir
> innodb_mirrored_log_groups 1
> transaction_isolation READ-COMMITTED
> tmp_table_size 33554432
> tmpdir /var/tmp/
> version 3.23.52
See the manual about how to set up InnoDB. You will have to create the
InnoDB directory yourself, then set
innodb_data_file_path = <filename>:<size>
innodb_data_home_dir = <path.
innodb_log_group_home_dir = <path>
innodb_log_arch_dir = <path
in my.cnf/ini.
PB
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
