On 11/13/13 10:59, Charles Douglass wrote:
> Thanks for the reply.
> 
> I know nothing about MySQL optimization.  I downloaded the
> "mysqltuner.pl" script and I will run it after the next full backup to
> see if it has any recommendations.

The mysqltuner script is a pretty decent basic tool.  The thing you need
to keep in mind regarding the "mysql-large", "mysql-huge" sample
configurations that are STILL widely distributed in MySQL packages (and
still widely used by the unsuspecting) is that most of those sample
configurations were originally written back when a "large" server was
one that might have as much as a whole 32MB of RAM.  These days, that is
less than the compiled-in default size of some individual MySQL
*buffers*.  So the unwary install the "suggested" configurations, and
can't understand why MySQL is performing like a geriatric tortoise.


-- 
  Phil Stracchino, CDK#2     DoD#299792458     ICBM: 43.5607, -71.355
  alaric AT caerllewys DOT net   alaric AT metrocast DOT net   phil AT 
co.ordinate DOT org
  Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
                 It's not the years, it's the mileage.

------------------------------------------------------------------------------
DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
Free app hosting. Or install the open source package on any LAMP server.
Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users