On 04/19/2014 09:10 PM, Alan Brown wrote:
> 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.
>
>
At the moment:
> mysql> select count(*) from File;
> +-----------+
> | count(*) |
> +-----------+
> | 287794478 |
> +-----------+
> 1 row in set (0.00 sec)
Definitely more than I expected. Although, I have to say, RAM usage on
this host isn't really much of a concern. At the moment, the mysqld
process is only using just over 1GB of RAM, and this host has 128G.
Possibly I need to tune MySQL to keep more of the tables' contents in RAM.
Lloyd Brown
Systems Administrator
Fulton Supercomputing Lab
Brigham Young University
http://marylou.byu.edu
>
>
> ------------------------------------------------------------------------------
> 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
>
------------------------------------------------------------------------------
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
