Hello.
Searching in the archives says you could get worse performance, because of extending during transactions: http://lists.mysql.com/mysql/180037 http://lists.mysql.com/mysql/170946 Eric Persson <[EMAIL PROTECTED]> wrote: > Hi, > > I've been running a innodbdatabase for a while, and it works nice, > however, I've noticed that it have grown beyound the specifications in > the my.cnf file. I did define autoextend so its not very strange, > however, I was wondering, how far can it grow, and is it a bad idea to > just let it grow? > > the my.cnf looks like: > [mysqld] > datadir=/usr/local/mysql/data/ > socket=/tmp/mysql.sock > set-variable = max_connections=200 > set-variable = thread_cache_size=20 > innodb_data_home_dir = > innodb_data_file_path = /usr/local/mysql/data/ibdata1:2000M:autoextend > set-variable = innodb_buffer_pool_size=200M > set-variable = innodb_additional_mem_pool_size=20M > innodb_log_group_home_dir = /usr/local/mysql/data/innodb/ > innodb_log_arch_dir = /usr/local/mysql/data/innodb/ > set-variable = innodb_log_files_in_group=2 > set-variable = innodb_log_file_size=50M > set-variable = innodb_log_buffer_size=8M > innodb_flush_log_at_trx_commit=0 > set-variable = innodb_lock_wait_timeout=50 > set-variable = long_query_time=15 > #log-long-format > log-slow-queries = /var/log/mysqld.slow.log > > > [mysql.server] > user=mysql > basedir=/usr/local/mysql > > > [safe_mysqld] > err-log=/var/log/mysqld.log > pid-file=/usr/local/mysql/data/db.bcmanga.se.pid > > The ibdata1 is now around 7gb and it keeps growing.. > > How big can it be? Is it innodb dependent or os dependent? I'm currently > running Fedora Core release 3 (Heidelberg) on a dual xeon 3ghz with 3gb > ram. > > Can I just define some more ibdata files and it will re-arrange the data > by itself, or do I need to export and them import it? Or whats the best > practice here? > > Thanks in advance, > Eric > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
