InnoDB: How do I know how much free space there is left on a raw device?

2005-04-22 Thread Jarle Aase
Hi list, Just a simple question. How do I know how much free space there is left on a device assigned to InnoDB? Jarle -- Jarle Aase email: [EMAIL PROTECTED] Author of freeware. http://www.jgaa.com news:alt.comp.jgaa War FTP

Re: data export

2005-04-11 Thread Jarle Aase
ame into outfile '/tmp/whatever'; Jarle -- Jarle Aase email: [EMAIL PROTECTED] Author of freeware. http://www.jgaa.com news:alt.comp.jgaa War FTP Daemon: http://www.warftp.org War FTP Daemon FAQ: http://www.warftp.or

Problem: Slow "LOAD FILE" performance with innodb

2005-03-17 Thread Jarle Aase
utoextend set-variable = innodb_buffer_pool_size=512M set-variable = innodb_additional_mem_pool_size=120M set-variable = innodb_log_file_size=1G set-variable = innodb_log_buffer_size=16M innodb_flush_log_at_trx_commit=0 innodb_flush_method = O_DSYNC Jarle -- Jarle Aase email

Q: Suggested reading

2005-03-15 Thread Jarle Aase
ore such databases, and what hardware and opertating system to reccommend. I'm greatful for any relevant information :) Jarle -- Jarle Aase email: [EMAIL PROTECTED] Author of freeware. http://www.jgaa.com news:alt.comp.jgaa W