-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Peter, et al --
...and then Peter Brawley said... % % David, % % >From any client... % SHOW VARIABLES LIKE 'version'; % or % SELECT @@version; % will show the version. Ahhh... Thanks! Well, it looks like we're at 3.23.52. Not all is lost, but I wonder why the truncate worked... % % Search your my.cnf/ini for 'innodb'. If This is another one... 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? % 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 How does it look, Doc? Will I ever play the violin? % % PB Thanks & HAND mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health" http://www.justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE96pQ4Gb7uCXufRwARAsdwAJ0aiPa4zkQ/rHuB88TCOCDsfNb/agCgyyZk cClg0FJ5roYSnM03ZYVo1Yc= =Xdn6 -----END PGP SIGNATURE----- --------------------------------------------------------------------- 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
