List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:April 26 2005 9:23am
Subject:Re: ibdata1 grows beyound borders..
View as plain text  
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 <eric@stripped> 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
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com



Thread
ibdata1 grows beyound borders..Eric Persson26 Apr
  • Re: ibdata1 grows beyound borders..Gleb Paharenko26 Apr
    • Re: ibdata1 grows beyound borders..Eric Persson26 Apr
      • Re: ibdata1 grows beyound borders..Gleb Paharenko26 Apr