On 01/30/13 16:16, John Drescher wrote:
>> On Wed, Jan 30, 2013 at 3:46 PM, John Drescher <dresche...@gmail.com> wrote:
>>> Also check for database activity. If you did not tune your DB server
>>> and you have millions of files the DB inserts could take a long time.
>>
>> Hmmm, there is about 900,000 files on that filesystem.
>>
>> Just a default MySQL install. In what way should I tune it?
>> Specific to Bacula?
>
> Look for a mysql optimization guide to tune your my.conf (not really
> bacula specific). Many distributions ship with a default mysql setup
> that is tuned for a server with 64MB of ram (or something ridiculously
> small compared to your system).
+1. Almost without exception, the first thing you should do on any
brand-new MySQL installation is toss the distribution's provided default
MySQL configuration in the trash and write a new one from scratch. They
are uniformly worthless, and most actually *introduce* security weaknesses.
(The *second* thing you should do, if it hasn't already been done, is
run the mysql_secure_installation script.)
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
It's not the years, it's the mileage.
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_jan
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
