I think I have found the solution to my problem with bvfs_cache. I added the .bvfs_update console command to my catalog backup and when I clear this cache, it’s slow again.
Le mar. 15 janv. 2019 à 10:09, Frédéric F. <cipher1...@gmail.com> a écrit : > > Thank you for your answer. > > So I will wait for the next release to update :) > > About the lag in the Baculum restore wizard, is everyone suffering > this issue ? Because it is very random. > > Best regards. > > Frédéric. > > Le sam. 12 janv. 2019 à 20:38, Marcin Haba <ganius...@gmail.com> a écrit : > > > > Hello Frédéric, > > > > Thanks for your feedback about using the Baculum. > > > > The apostrophe problem is a bug that will be fixed in next release. > > Thanks for reporting it. > > > > To the lag when you are going through the restore wizard it is caused > > by Bvfs cache that has to be built before showing restore browser > > content. The Baculum uses the Bvfs Bacula feature in restore wizard. I > > understand that for many files and paths this proces can take a while > > but I don't know if there is possible to optimize something here. > > > > Best regards. > > Marcin Haba (gani) > > > > On Fri, 11 Jan 2019 at 16:08, Frédéric F. <cipher1...@gmail.com> wrote: > > > > > > Hello, > > > > > > Thank you for your answer, I will try your fork next week. > > > I use CentOS for intructions. > > > > > > If anyone have an idea about my issues, I am interested. > > > > > > Le ven. 11 janv. 2019 à 12:27, Wanderlei Huttel > > > <wanderleihut...@gmail.com> a écrit : > > > > > > > > Are you using CentOS or Debian? > > > > > > > > Best regards > > > > > > > > Wanderlei Hüttel > > > > http://www.bacula.com.br > > > > > > > > > > > > Em sex, 11 de jan de 2019 às 09:24, Chris Wilkinson > > > > <winstonia...@gmail.com> escreveu: > > > >> > > > >> My Portuguese is not so good > > > >> > > > >> Regards > > > >> Chris Wilkinson > > > >> > > > >> On Fri, 11 Jan 2019, 11:22 am Wanderlei Huttel > > > >> <wanderleihut...@gmail.com wrote: > > > >>> > > > >>> Hello Chris > > > >>> > > > >>> Yes there is, but the instructions are in Portuguese. > > > >>> https://github.com/wanderleihuttel/bacula-utils/tree/master/tutorial > > > >>> > > > >>> > > > >>> Best regards > > > >>> > > > >>> Wanderlei Hüttel > > > >>> http://www.bacula.com.br > > > >>> > > > >>> > > > >>> Em sex, 11 de jan de 2019 às 09:16, Chris Wilkinson > > > >>> <winstonia...@gmail.com> escreveu: > > > >>>> > > > >>>> Very interesting. Is there a link for the installation instructions? > > > >>>> The docs folder appears to be old. > > > >>>> > > > >>>> Regards > > > >>>> Chris Wilkinson > > > >>>> > > > >>>> On Fri, 11 Jan 2019, 9:34 a.m. Wanderlei Huttel > > > >>>> <wanderleihut...@gmail.com wrote: > > > >>>>> > > > >>>>> Hello Frederic > > > >>>>> > > > >>>>> I have a fork o Webacula with a new visual and some improvements. > > > >>>>> https://github.com/wanderleihuttel/webacula > > > >>>>> > > > >>>>> You cant take a look in the screens here: > > > >>>>> https://github.com/wanderleihuttel/webacula/wiki > > > >>>>> > > > >>>>> Best regards > > > >>>>> > > > >>>>> Wanderlei Hüttel > > > >>>>> http://www.bacula.com.br > > > >>>>> > > > >>>>> > > > >>>>> Em qui, 10 de jan de 2019 às 20:48, Frédéric F. > > > >>>>> <cipher1...@gmail.com> escreveu: > > > >>>>>> > > > >>>>>> Hello everyone, > > > >>>>>> I use Bacula for 3 months and I am happy to use it. > > > >>>>>> However I have several problems with the GUI Baculum. > > > >>>>>> > > > >>>>>> In Baculum, I have problem to restore files with path contains ' > > > >>>>>> character like "D:\Data\l'information" > > > >>>>>> I can see in baculum the folder but when I select it, I can't > > > >>>>>> browse > > > >>>>>> into, the sub folder is empty. > > > >>>>>> I can restore upper folder but it's not a great job. > > > >>>>>> Any advice to browse in baculum with folders with special > > > >>>>>> character ? > > > >>>>>> I have a lot... > > > >>>>>> > > > >>>>>> Another problem with Baculum : > > > >>>>>> Randomly, I have some lag (about 20 minutes) when I select a "group > > > >>>>>> most recent backup" or one full backup in the list. > > > >>>>>> My postgresql DB is working at 100% on 1CPU/8 for about 20 minutes. > > > >>>>>> > > > >>>>>> I optimize my postgresql DB and with pg_stat_statements, I found > > > >>>>>> the > > > >>>>>> slow bacula query (sorry for presentation) : > > > >>>>>> > > > >>>>>> postgres=# SELECT * > > > >>>>>> FROM > > > >>>>>> pg_stat_statements > > > >>>>>> ORDER BY > > > >>>>>> total_time DESC; > > > >>>>>> userid | dbid | queryid | query | calls | total_time | > > > >>>>>> min_time | max_time | mean_time | stddev_time > > > >>>>>> | rows | shared_blks_hit | shared_blks_read | > > > >>>>>> shared_blks_dirtied > > > >>>>>> | shared_blks_written | local_blks_hit | local_blks_read | > > > >>>>>> local_blks_dirtied | local_blks_written | temp_blks_read | > > > >>>>>> temp_blks_written | blk_read_time | blk_write_time > > > >>>>>> > > > >>>>>> 10 | 16384 | 1980744281 | INSERT INTO PathVisibility (PathId, > > > >>>>>> JobId) SELECT a.PathId,$1 FROM ( SELECT DISTINCT h.PPathId AS > > > >>>>>> PathId > > > >>>>>> FROM PathHierarchy AS h JOIN P > > > >>>>>> athVisibility AS p ON (h.PathId=p.PathId) WHERE p.JobId=$2) AS a > > > >>>>>> LEFT > > > >>>>>> JOIN (SELECT PathId FROM PathVisibility WHERE JobId=$3) AS b ON > > > >>>>>> (a.PathId = b.PathId) WHERE b.Path > > > >>>>>> Id IS NULL | 60 | 1478982.747849 | 0.225819 | > > > >>>>>> 484839.953712 | 24649.71246415 | 105518.8118646 > > > >>>>>> 13 | 4074 | 205691266 | 165 | > > > >>>>>> 62 | 0 | 0 | 0 | > > > >>>>>> 0 | > > > >>>>>> 0 | 1011 | 1014 | 0 | > > > >>>>>> 0 > > > >>>>>> > > > >>>>>> I am not sure it is a DB problem rather a bacula optimization but > > > >>>>>> what ? > > > >>>>>> > > > >>>>>> According to my stats, I have : > > > >>>>>> - 5.31 TB of data saved, around 13M files > > > >>>>>> - Bacula DB 5,18 Go > > > >>>>>> - Fileset : 82 > > > >>>>>> > > > >>>>>> OS : CentOS 7.5.1804 > > > >>>>>> Postgresql : 10.6 > > > >>>>>> Bacula : 9.2.1-1-el7 > > > >>>>>> > > > >>>>>> Postgresql.conf tweaks : > > > >>>>>> > > > >>>>>> max_connections = 100 > > > >>>>>> shared_buffers = 2016MB > > > >>>>>> maintenance_work_mem = 512MB > > > >>>>>> effective_cache_size = 6GB > > > >>>>>> max_worker_processes = 8 > > > >>>>>> max_parallel_workers_per_gather = 2 > > > >>>>>> max_parallel_workers = 8 > > > >>>>>> > > > >>>>>> > > > >>>>>> Hardware > > > >>>>>> HP Proliant server (2017) > > > >>>>>> CPU Xeon 4/8 cores > > > >>>>>> Memory : 8 Go > > > >>>>>> HD in RAID 5 (no SSD) > > > >>>>>> > > > >>>>>> Off topic question : is there another web GUI to restore files > > > >>>>>> easily ? > > > >>>>>> > > > >>>>>> Thank you for your help > > > >>>>>> > > > >>>>>> PS : sorry for my approximate english. > > > >>>>>> > > > >>>>>> > > > >>>>>> _______________________________________________ > > > >>>>>> Bacula-users mailing list > > > >>>>>> Bacula-users@lists.sourceforge.net > > > >>>>>> https://lists.sourceforge.net/lists/listinfo/bacula-users > > > >>>>> > > > >>>>> _______________________________________________ > > > >>>>> Bacula-users mailing list > > > >>>>> Bacula-users@lists.sourceforge.net > > > >>>>> https://lists.sourceforge.net/lists/listinfo/bacula-users > > > > > > > > > _______________________________________________ > > > Bacula-users mailing list > > > Bacula-users@lists.sourceforge.net > > > https://lists.sourceforge.net/lists/listinfo/bacula-users > > > > > > > > -- > > "Greater love hath no man than this, that a man lay down his life for > > his friends." Jesus Christ > > > > "Większej miłości nikt nie ma nad tę, jak gdy kto życie swoje kładzie > > za przyjaciół swoich." Jezus Chrystus _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
