her
> ; bacula-users
> Subject: Re: [Bacula-users]
> restore performance
>
> On Mon, Jan 14, 2013 at 09:01:32AM -0500, Novosielski, Ryan wrote:
>
>>> http://wiki.bacula.org/doku.php?id=faq#restore_takes_a_long_time_to_retrieve_sql_results_from_mysql_catalog
>&g
Sent: Tuesday, January 15, 2013 10:32 AM
To: Novosielski, Ryan
Cc: John Drescher ; bacula-users
Subject: Re: [Bacula-users] restore performance
On Mon, Jan 14, 2013 at 09:01:32AM -0500, Novosielski, Ryan wrote:
> > http://wiki.bacula.org/doku
On Mon, Jan 14, 2013 at 09:01:32AM -0500, Novosielski, Ryan wrote:
> > http://wiki.bacula.org/doku.php?id=faq#restore_takes_a_long_time_to_retrieve_sql_results_from_mysql_catalog
>
> Actually,
> >
> after re-reading that, I'm a little confused. I don't know
> whether it says to "drop all indexes
Le 2013-01-14 14:32, Uwe Schuerkamp a écrit :
> On Mon, Jan 14, 2013 at 08:24:07AM -0500, John Drescher wrote:
>> > I just ran into this. After a Google search, I turned up an
>> article that
>> > says the indices that used to make Bacula run faster now cause a
>> performance
>> > problem with re
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/14/2013 08:59 AM, Novosielski, Ryan wrote:
> On 01/14/2013 08:52 AM, Uwe Schuerkamp wrote:
>> On Mon, Jan 14, 2013 at 08:44:06AM -0500, John Drescher wrote:
>
>>> I did not mean file table indices (I am not sure about these -
>>> I use postgresq
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/14/2013 08:52 AM, Uwe Schuerkamp wrote:
> On Mon, Jan 14, 2013 at 08:44:06AM -0500, John Drescher wrote:
>
>> I did not mean file table indices (I am not sure about these - I
>> use postgresql with bacula). However I meant tuning the database
>
On Mon, Jan 14, 2013 at 08:44:06AM -0500, John Drescher wrote:
> I did not mean file table indices (I am not sure about these - I use
> postgresql with bacula). However I meant tuning the database
> parameters to allow mysql server to use more memory. I have had to do
> that for other mysql usage.
On Mon, Jan 14, 2013 at 8:32 AM, Uwe Schuerkamp
wrote:
> On Mon, Jan 14, 2013 at 08:24:07AM -0500, John Drescher wrote:
>> > I just ran into this. After a Google search, I turned up an article that
>> > says the indices that used to make Bacula run faster now cause a
>> > performance
>> > problem
On Mon, Jan 14, 2013 at 08:24:07AM -0500, John Drescher wrote:
> > I just ran into this. After a Google search, I turned up an article that
> > says the indices that used to make Bacula run faster now cause a performance
> > problem with recent versions of Bacula and recent versions of MySQL (it's
p before ;)
Cheers, Uwe
>
>
> >
> > From: Uwe Schuerkamp
> >To: Antony Mayi
> >Cc: "bacula-users@lists.sourceforge.net"
> >
> >Sent: Monday, 14 January 2013, 12:45
> >Subject: Re: [Bacula-users] restore performance
> >
> >On Mo
> I just ran into this. After a Google search, I turned up an article that
> says the indices that used to make Bacula run faster now cause a performance
> problem with recent versions of Bacula and recent versions of MySQL (it's on
> the Bacula wiki, the address for which I don't have handy). I re
:45
>Subject: Re: [Bacula-users] restore performance
>
>On Mon, Jan 14, 2013 at 11:38:04AM +, Antony Mayi wrote:
>> Hi guys,
>>
>> I seem to have major performance problem with the director/catalog when
>> trying restoration. Using MySQL, the catalog has about
handy). I removed all of the indices I
had on the file table and restores only take a few minutes now.
From: Antony Mayi [mailto:antonym...@yahoo.com]
Sent: Monday, January 14, 2013 06:38 AM
To: bacula-users@lists.sourceforge.net
Subject: [Bacula-users] restore performance
Hi guys,
I seem to
On Mon, Jan 14, 2013 at 11:38:04AM +, Antony Mayi wrote:
> Hi guys,
>
> I seem to have major performance problem with the director/catalog when
> trying restoration. Using MySQL, the catalog has about 200MB, mysql is using
> innodb with large enough buffer pool to keep all data in memory. th
Hi guys,
I seem to have major performance problem with the director/catalog when trying
restoration. Using MySQL, the catalog has about 200MB, mysql is using innodb
with large enough buffer pool to keep all data in memory. there is no iowait.
when I attempt to do a restore using bconsole I get:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Am 21.09.2011 14:58, schrieb Gavin McCullagh:
> Then a couple of months ago I noticed a new detail in the wiki about
> _removing_ bogus indexes. It turns out that by adding extra indexes you
> can slow down MySQL SELECT queries (I think someone said i
Le 21/09/2011 18:56, Marcio Merlone a écrit :
Em 21-09-2011 13:33, Alexandre Chapellon escreveu:
As Gavin pointed out, a 150GB database is
huuuge for only a dozen client.
Unless you have billions of files on
Em 21-09-2011 13:33, Alexandre Chapellon escreveu:
As Gavin pointed out, a 150GB database is huuuge for only a
dozen client.
Unless you have billions of files on each client there is no reason
your catalog is that large.
Are you sure you correctly applied job and file retention on your
Eric
As Gavin pointed out, a 150GB database is huuuge for only
a dozen client.
Unless you have billions of files on each client there is no
reason your catalog is that large.
Are you sure you correctly applied job and file retention on your
On Wed, 21 Sep 2011, Erik P. Olsen wrote:
> I forgot to mention that my problem is with building the file tree. So
> converting to postresql may be the best thing to do.
>
> Will the following scenario work?
>
> 1. Backup the catalogue
> 2. Remove mysql database
> 3. Build postresql database
>
On 21/09/11 15:56, Marcio Merlone wrote:
> Em 21-09-2011 10:29, Gavin McCullagh escreveu:
>> A 150GB database. That's pretty large. How many clients have you?
> About a dozen clients - some inactive but still with valid backup - File
> Retention = 6 months, Job Retention = 1 year. Most clients ha
Hi,
On Wed, 21 Sep 2011, Marcio Merlone wrote:
> Em 21-09-2011 10:29, Gavin McCullagh escreveu:
> >A 150GB database. That's pretty large. How many clients have you?
> About a dozen clients - some inactive but still with valid backup -
> File Retention = 6 months, Job Retention = 1 year. Most cl
Em 21-09-2011 10:29, Gavin McCullagh escreveu:
A 150GB database. That's pretty large. How many clients have you?
About a dozen clients - some inactive but still with valid backup - File
Retention = 6 months, Job Retention = 1 year. Most clients have few or
no changes, but my storage server ha
Hi,
On Wed, 21 Sep 2011, Marcio Merlone wrote:
> Em 21-09-2011 09:29, Gavin McCullagh escreveu:
> >On Wed, 21 Sep 2011, Erik P. Olsen wrote:
> >>I am running a very smooth bacula 5.0.3 on Fedora 14. Everything seems to
> >>be OK
> >>except restores which are incredibly slow. How can I debug it t
Em 21-09-2011 09:29, Gavin McCullagh escreveu:
On Wed, 21 Sep 2011, Erik P. Olsen wrote:
I am running a very smooth bacula 5.0.3 on Fedora 14. Everything seems to be OK
except restores which are incredibly slow. How can I debug it to see what's
wrong?
- building the file tree for selection
Hi,
On Wed, 21 Sep 2011, Gavin McCullagh wrote:
> On Wed, 21 Sep 2011, Erik P. Olsen wrote:
>
> > I am running a very smooth bacula 5.0.3 on Fedora 14. Everything seems to
> > be OK
> > except restores which are incredibly slow. How can I debug it to see what's
> > wrong?
>
> Start off by te
On Wed, 21 Sep 2011, Erik P. Olsen wrote:
> I am running a very smooth bacula 5.0.3 on Fedora 14. Everything seems to be
> OK
> except restores which are incredibly slow. How can I debug it to see what's
> wrong?
Start off by telling us what part of the restore process is slow:
- building th
I am running a very smooth bacula 5.0.3 on Fedora 14. Everything seems to be OK
except restores which are incredibly slow. How can I debug it to see what's
wrong?
--
Erik
--
All the data continuously generated in your
Hello,
On 3/30/2006 9:38 AM, Christoph Litauer wrote:
Hi,
I just searched the archives but didn't find hints. Sorry if this
question has been asked before.
I am using bacula-1.36.3 for the backup of about 12 linux clients. At
the moment I just use an external hardware raid as (File-)backup dev
Hi,
I just searched the archives but didn't find hints. Sorry if this
question has been asked before.
I am using bacula-1.36.3 for the backup of about 12 linux clients. At
the moment I just use an external hardware raid as (File-)backup device:
Device {
Name = FileStorage
Media Type = File
30 matches
Mail list logo
