That's what I was referring to. Junior Cunha wrote: > Ryan, what you mean with Optimizing?? I already compiled MySQL with > InnoDB support. I was thinking in create some index... > > []s > > Jr > > > Ryan Novosielski wrote: >> I think it ought to run fine. Optimizing MySQL would likely help. I am >> running Bacula on a Sun Sparc UE450. The processors are 3x296MHz. >> >> Matt Cowger wrote: >>> I would argue that this machine is probably underpowered for what >>> you are doing with it. My guess is it has a single disk (or RAID1), >>> and not a ton of RAM, either, right? >>> >>> >>> Upgrade it....Dual 2GHz P4s, 2G RAM, 4 disks in a RAID 10 would do >>> you much better. >>> >>> --Matt >>> >>> >>> On Sep 21, 2006, at 8:15 AM, Junior Cunha wrote: >>> >>>> Hello >>>> >>>> I've bacula runnning under FC3 on a dual-processor machine (P3 >>>> 500Mhz). Around 16000 backups already been done (150 per day). Lately, >>>> i've been some performance problem. While the jobs are running, the >>>> load >>>> is up to 3 and the % user (sar -u) is 97%. In process list i see this: >>>> >>>> PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND >>>> 3988 mysql 16 0 28980 14m 3252 S 85.3 2.8 3889:58 mysqld >>>> 24128 root 15 0 207m 4048 252 S 95.7 0.9 12:56.97 >>>> bacula-dir >>>> 24129 root 15 0 114m 1920 1386 S 85.0 1.1 12:57.01 >>>> bacula-sd >>>> 24130 root 15 0 207m 3200 980 S 97.8 0.5 12:57.08 >>>> bacula-fd >>>> >>>> Looking on mysql's process list i have a lot of querys like this: >>>> >>>> SELECT count(*) FROM JobMedia WHERE MediaId=<some number> >>>> SELECT JobId FROM JobMedia WHERE MediaId=<some number> >>>> SELECT >>>> MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolEr >>>> rors,VolWrites,MaxVolBytes >>>> (...) (i can see just this) >>>> (...) >>>> >>>> I would like to know if is normal this highs levels of load and >>>> processor utilization? >>>> >>>> []s >>>> >>>> Jr >>>> >>>> >>>> >>>> >>>> >>>> ---------------------------------------------------------------------- >>>> --- >>>> Take Surveys. Earn Cash. Influence the Future of IT >>>> Join SourceForge.net's Techsay panel and you'll get the chance to >>>> share your >>>> opinions on IT & business topics through brief surveys -- and earn >>>> cash >>>> http://www.techsay.com/default.php? >>>> page=join.php&p=sourceforge&CID=DEVDEV >>>> _______________________________________________ >>>> Bacula-users mailing list >>>> Bacula-users@lists.sourceforge.net >>>> https://lists.sourceforge.net/lists/listinfo/bacula-users >>> >>> ------------------------------------------------------------------------- >>> >>> Take Surveys. Earn Cash. Influence the Future of IT >>> Join SourceForge.net's Techsay panel and you'll get the chance to >>> share your >>> opinions on IT & business topics through brief surveys -- and earn cash >>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV >>> >>> _______________________________________________ >>> Bacula-users mailing list >>> Bacula-users@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/bacula-users >> >
-- ---- _ _ _ _ ___ _ _ _ |Y#| | | |\/| | \ |\ | | |Ryan Novosielski - Systems Programmer III |$&| |__| | | |__/ | \| _| |[EMAIL PROTECTED] - 973/972.0922 (2-0922) \__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630 ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
