Re: [Bacula-devel] Original size of the backup file

Wed, 11 Oct 2017 06:06:51 -0700

Hello Wanderlei,

Unfortunately perl or php will not help Bacula with such functionality.  The Bacula SQL databases are already very large on many computers these days so anything that would increase the size of the catalog is probably not going to be implemented.

Since I am just back from vacation, I see that there are a lot of high priority tasks waiting for me and unfortunately, a lot of my time during the rest of this week and next week is already taken.  After that, I will work full-time on resolving bugs with Bacula version 9.

If someone were to implement this code in C++, we could add it to bvfs.c in the cats directory.  In fact, all the code already exists in Bacula it just needs someone to collect it together and put it into bvfs.c

Best regards,

Kern



On 10/11/2017 01:26 PM, Wanderlei Huttel wrote:
Hello Kern

It looks that the old code from bacula-gui it was written in pearl.

I guess baculum have some function in php to decode LStat.

But the main problem, if you only include these functions in MySQL or PostgreSQL, is the queries needs to read and decode the field LStat and this generate a lot of processing if you have a lot of files. 

If the original file size are saved in the File table as number, probably the queries will be executed more fast.
Would be interesting include in the Job table too, because it easier and practical to get the total of bytes that were backed up x JobBytes (that are saved compressed).

Today there's no way to get this information from Bacula quickly.


Best regards 

Wanderlei Hüttel

2017-10-11 8:07 GMT-03:00 Kern Sibbald <k...@sibbald.com>:

I do not know much about the bacula-gui code, but I imagine this was something written in php. 

Does it still exist in the bacula-gui code? 

Does it exist in the baculum code?

If it was in C++ like the Bacula core code please let me know.

Best regards,

Kern


On 10/09/2017 07:46 PM, Wanderlei Huttel wrote:
Hello Kern 

In the old bacula-gui-5.2.10 version there was the code.


Atenciosamente 

Wanderlei Hüttel

2017-10-09 14:29 GMT-03:00 Kern Sibbald <k...@sibbald.com>:

Hello Wanderlei,


On 10/09/2017 07:21 PM, Wanderlei Huttel wrote:
I would like to suggest to include a column in table "File" to identify the original size of files.
Or another suggestion is to include in the Job table the sum of all files backed up.

This would be increase the speed of SQL queries to get information about original file size.

I know that we have the information of file size in the column "LStat" but the queries are very slow and the function used to decode LSTAT is not by default in the Bacula community.

Would be interesting incorporate the function "base64_decode_lstat" by default in Bacula community.

 Where have you seen this function?  is it in bvfs.c?  In general if it is something in the Enterprise Edition, it should be included in the Community version unless it is a big differentiator, and base64_decode_lstat() is not such a differentiator.

Best regards,
Kern

I'm suggesting these because today is not possible to know the real size of files backed up. 

I've tried to implement by myself and only send a patch, but I couldn't.



Best regards

Wanderlei Hüttel


 
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot


_______________________________________________
Bacula-devel mailing list
Bacula-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-devel









------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-devel mailing list
Bacula-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-devel

Reply via email to