Thanks for the info guys. I decided to start over from scratch with the server
(running Suse Server 11 BTW).
Batch insert was NOT on before (it is now) and I used the InnoDB specs below.
The restore process is 1000 times faster now. THANK YOU!
Version browser is still a bit slow if picking
On 10/11/11 11:09, Brian Debelius wrote:
> Hi,
>
> I have a 5GB database. The server has 6GB RAM. These are the settings
> I am using right now.
>
> default-storage-engine=innodb
> default-table-type=innodb
> query_cache_limit=16M
> query_cache_size=256M
> innodb_log_file_size=384M
> innodb_buf
Hi,
I have a 5GB database. The server has 6GB RAM. These are the settings
I am using right now.
default-storage-engine=innodb
default-table-type=innodb
query_cache_limit=16M
query_cache_size=256M
innodb_log_file_size=384M
innodb_buffer_pool_size=3G
innodb_log_buffer_size=2M
innodb_flush_log_
On 10/11/11 08:04, Jarrod Holder wrote:
> I've also tried the running the DB under MySQL with MyISAM and InnoDB
> tables. Both had the same slow performance here. With MySQL, I also
> tried using the my-large.cnf and my-huge.cnf files. Neither helped.
Ignore the packaged out-of-the-box MySQL co
Jarrod Holder wrote:
> Bacula version 5.0.3
>
> In BAT, when trying to restore a directory (roughly 31,000 files in 560 sub
> folders) The "Filling Database Table" takes an extremely long time to
> complete (about an hour or so).
>
> I've been looking around for a way to speed this up. Foun
Am 11.10.2011 14:04, schrieb Jarrod Holder:
> Bacula version 5.0.3
>
> In BAT, when trying to restore a directory (roughly 31,000 files in 560 sub
> folders) The "Filling Database Table" takes an extremely long time to
> complete (about an hour or so).
>
> I've been looking around for a way
Bacula version 5.0.3
In BAT, when trying to restore a directory (roughly 31,000 files in 560 sub
folders) The "Filling Database Table" takes an extremely long time to complete
(about an hour or so).
I've been looking around for a way to speed this up. Found a post on here that
referred to
