For us,
even InnoDB was way to slow. It took hours to insert attributes.
We switched to PostgreSQL three years ago. Since then, no more performance
problems.
Also, creating the tree for restores was magnitudes faster with PostgreSQL.
It heavily depends on the number of files and attributes in the db, so for us
PostgreSQL was the right choice.
Try it out.
Robert
> Am 22.12.2014 um 17:20 schrieb Phil Stracchino <phils AT caerllewys DOT net>:
>
> On 12/22/14 11:01, Josh Fisher wrote:
>> MyISAM "can" be quick at inserting records at the end of a table, but
>> has both table locking and a single key buffer lock causing contention,
>> so is much, much slower at inserts that are not at the end of a table.
>> MyISAM also does not have a change buffer. In short, MyISAM is a poor
>> choice for an INSERT heavy application like Bacula. Use should use
>> InnoDB instead.
>
> It is probably more accurate to say that MyISAM is a poor choice,
> period. It is a legacy storage engine that, honestly, should no longer
> be used in production. Even in a 100% read scenario, the best possible
> use case for it, it still underperforms compared to InnoDB.
>
>
> --
> Phil Stracchino
> Babylon Communications
> phils AT caerllewys DOT net
> phil AT co.ordinate DOT org
> Landline: 603.293.8485
>
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming! The Go Parallel Website,
> sponsored by Intel and developed in partnership with Slashdot Media, is your
> hub for all things parallel software development, from weekly thought
> leadership blogs to news, videos, case studies, tutorials and more. Take a
> look and join the conversation now. http://goparallel.sourceforge.net
> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
------------------------------------------------------------------------------
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
