[prev in list] [next in list] [prev in thread] [next in thread] 

List:       bacula-users
Subject:    Re: [Bacula-users] MySQL "hangs", jobs hang. Well not really, but
From:       Jari Fredriksson <jarif () iki ! fi>
Date:       2014-03-28 16:46:29
Message-ID: 5335A765.9000203 () iki ! fi
[Download RAW message or body]


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

28.03.2014 16:42, Phil Stracchino kirjoitti:
> On 03/28/14 10:16, Jari Fredriksson wrote:
> > Appeared that the bacula script created the tables as MyISAM. I
> > converted to InnoDB, tweaked some MySQL parameters, and not this
> > seems to be OK again.
>
> > Seems there is really a difference between MyISAM and InnoDB.
>
> There is an ENORMOUS difference between MyISAM and InnoDB.  I would go
> so far as to say that MyISAM should never be used in production any
> more, and I wish Oracle would officially deprecate it except for grant
> tables.  (And they're *working on* grant tables in InnoDB.  Maybe in
> MySQL 6.)
>
> Data point:
> At my company I did some simulated-OLTP benchmarking between identical
> servers with identical data sets and test loads, one with MyISAM
> tables and tuned optimally for MyISAM, the other likewise with InnoDB.
>  With a 100% read load, which is the best possible use case for
> MyISAM, the InnoDB server outperformed MyISAM by 60%.  By the time the
> workload reached 25% write, InnoDB was outperforming MyISAM by 400%.
>
> It should always be remembered that once of the principal design goals
> of the MyISAM storage engine was to deliver *acceptable* performance
> on a small server shared with other applications, at a time when a
> "large" server was one that might have a full 32MB of RAM.  That is
> now smaller than the current default size of some individual MySQL
> *buffers*.
>
>

The Bacula database creation script should be updated to use InnoDB, is
not currently so.

- -- 
jarif.bit
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iEYEARECAAYFAlM1p2UACgkQKL4IzOyjSrYgIgCfYPOFBlQaa1F858zJ/oLRjoGw
rkcAoIgFqs4LkpicnAdx5hQTUqsbYpyq
=aS8R
-----END PGP SIGNATURE-----


------------------------------------------------------------------------------
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
[prev in list] [next in list] [prev in thread] [next in thread]