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 > ------------------------------------------------------------------------- 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
