On Thursday 25 June 2009 15:23:31 Tom Sommer wrote: > Okay, I added 12GB more RAM. Made my mysql tmp directory a tmpfs. Stole > some settings from Jason's my.cnf. Upgraded to latest MySQL version. > > Let's see how things run tonight, I'm not too optimistic though. > > Btw, these are the Index'es on my File table. Do they look right? > > mysql> show index from File; > > +-------+------------+----------+--------------+-------------+-----------+- >------------+----------+--------+------+------------+---------+ > > | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation > | Cardinality | Sub_part | Packed | Null | Index_type | Comment | > > +-------+------------+----------+--------------+-------------+-----------+- >------------+----------+--------+------+------------+---------+ > > | File | 0 | PRIMARY | 1 | FileId | A > | 246647341 | NULL | NULL | | BTREE | | > | > | File | 1 | JobId | 1 | JobId | A > | 7460 | NULL | NULL | | BTREE | | > | > | File | 1 | JobId_2 | 1 | JobId | A > | 7460 | NULL | NULL | | BTREE | | > | > | File | 1 | JobId_2 | 2 | PathId | A > | 17617667 | NULL | NULL | | BTREE | | > | > | File | 1 | JobId_2 | 3 | FilenameId | A > | 246647341 | NULL | NULL | | BTREE | | > > +-------+------------+----------+--------------+-------------+-----------+-
They seem right, even if it's hard to tell from the line wrapped output :) > > Is there some major gains to running 64 bit on the Bacula/MySQL server? No idea. Maybe if you want to put more than 4GB of cache in mysql ? ------------------------------------------------------------------------------ _______________________________________________ Bacula-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel
