Re: [Bacula-users] MySQL slowness when initializing new disk volume
2014-04-19 23:17:34
On 18/04/14 23:49, Lloyd Brown wrote:
Are the tables in MyISAM or InnoDB format?
At the moment, MyISAM. I'd wondered if I could safely convert to
InnoDB, since that's generally going to have better locking
characteristics, etc.
It's easy enough to change, but....
How large are the tables? In particular how many entries do you have
in the file table?
MySQL is good, but it doesn't scale to large tables very well (even
with Inno) so at some point there's a lot of benefit (reduced ram
use) in switching to Postgres.
|
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech _______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
|
|