On Thu, 16 Aug 2007, Drew Bentley wrote: > You'll either need to add more InnoDB by adding more to your > /etc/my.cnf file or convert the tables to use MyISAM. Usually depends > on what MySQL will use as default or if someone else created the > InnoDB space but you can easily add more by editing the > innodb_data_file_path in the my.cnf
Here's what I have: innodb_additional_mem_pool_size = 16M innodb_buffer_pool_size = 2G innodb_data_file_path = ibdata1:26000M;ibdata2:2000M:autoextend (As I understand it, this should grow the tablespace as needed) innodb_data_home_dir = /var/lib/mysql innodb_file_io_threads = 4 innodb_thread_concurrency = 16 innodb_flush_log_at_trx_commit = 2 innodb_log_buffer_size = 8M innodb_log_file_size = 512M innodb_log_files_in_group = 2 innodb_log_group_home_dir = /var/lib/mysql/log innodb_max_dirty_pages_pct = 90 innodb_lock_wait_timeout = 120 # ls -l /var/lib/mysql total 55755736 drwx------ 2 mysql mysql 4096 Jan 3 2007 bacula -rw-rw---- 1 mysql mysql 27262976000 Aug 16 16:35 ibdata1 -rw-rw---- 1 mysql mysql 29775060992 Aug 16 16:35 ibdata2 drwxr-xr-x 2 root root 4096 Dec 15 2006 log drwx------ 2 mysql mysql 16384 Jun 1 2006 lost+found drwx------ 2 mysql mysql 4096 Jul 9 2006 mysql lrwxrwxrwx 1 root root 26 Dec 19 2006 mysql.sock -> /var/run/mysqld/mysql.sock drwxr-xr-x 3 mysql mysql 4096 Jun 29 2006 new drwx------ 2 mysql mysql 4096 Jun 29 2006 test > > A typical my.cnf file for the InnoDB stuff looks like this: > > # Uncomment the following if you are using Innobase tables > innodb_data_file_path = ibdata1:15000M; > innodb_data_home_dir = /var/lib/mysql/ > innodb_log_group_home_dir = /var/lib/mysql/ > innodb_log_arch_dir = /var/lib/mysql/ > set-variable = innodb_mirrored_log_groups=1 > set-variable = innodb_log_files_in_group=4 > set-variable = innodb_log_file_size=128M > set-variable = innodb_log_buffer_size=8M > innodb_flush_log_at_trx_commit=0 > innodb_log_archive=0 > set-variable = innodb_buffer_pool_size=512M > set-variable = innodb_additional_mem_pool_size=8M > set-variable = innodb_file_io_threads=4 > set-variable = innodb_lock_wait_timeout=50 > > If you wanted to add space, simply edit this line: > > innodb_data_file_path = ibdata1:15000M; > > And make it look like this: > > innodb_data_file_path = ibdata1:15000M; ibdata2:15000M; > > That would add 15000 more MB to my existing space. Add what you need. > > -Drew > ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
