Hi
Christoph Haas schrieb:
What I wonder about:
- is a 2.4 dump file/database size common when backup up ~1 million files
that sum up to ~50 GB? (file and job retention are 1 month while I run
one full backup per week and an incremental daily)
My Dumpfile is about 2 GB (1,5 million files about 450 GB, 14 day
retention).
- is InnoDB perhaps suited better than MyISAM?
I prefer innodb.
Stores data in tablespaces, that can be limited in size and thus can not
eat up all free space if autoextend is not configured.
Supports transactions, row-locking and caches data records (not just
indexes as MyISAM-Tables). Although Bacula doesnt utilize that features.
- are there MySQL server parameters I could tune?
You could fine tune some parameters normally in /etc/my.cnf
Most times the default my.cnf is optimized for systems with little
memory (up to 64 MB).
To improve performance you can increase various buffer sizes.
Depending on the used storage engine (myisam, innodb) there are
different parameters. A good point to look at would be the example
my.cnf files or the documentation of mysql.
Regards
Helmut
-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
