MySQL Forums
Forum List  »  InnoDB

innodb_file_per_table not working
Posted by: howa chen
Date: June 03, 2008 08:45PM

Hi,

Just observed a strange result...

my.cnf
=====
[mysqld]
datadir=/home/project/data/mysql
socket=/var/lib/mysql/mysql.sock
old_passwords=0

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
log-error=/home/project/log/mysql/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[innodb]
innodb_buffer_pool_size=128M
innodb_additional_mem_pool_size=10M
innodb_log_file_size=32M
innodb_log_buffer_size=8M
innodb_file_per_table
innodb_flush_log_at_trx_commit=0

mysql> show variables like '%inno%';
+---------------------------------+------------------------+
| Variable_name | Value |
+---------------------------------+------------------------+
| have_innodb | YES |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 8388608 |
| innodb_checksums | ON |
| innodb_commit_concurrency | 0 |
| innodb_concurrency_tickets | 500 |
| innodb_data_file_path | ibdata1: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 | 1 |
| 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 | 1048576 |
| innodb_log_file_size | 5242880 |
| 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 | 8 |
| innodb_thread_sleep_delay | 10000 |
+---------------------------------+------------------------+

Using MySQL 5.0.22, the table is always using the shared ibdata1 file

(restart server many times, alter type=innodb many times, removed the
log and data file many tiems...)

Any idea?

Howard.

Options: ReplyQuote


Subject
Views
Written By
Posted
innodb_file_per_table not working
4739
June 03, 2008 08:45PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.