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
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.
------------------------------------------------------------------------------
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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
