Bacula-users

Re: [Bacula-users] bacula max_rows limit 4294967295 on File table

2008-06-04 10:45:39
Subject: Re: [Bacula-users] bacula max_rows limit 4294967295 on File table
From: Frank Sweetser <fs AT WPI DOT EDU>
To: Brian Hanna <bdhanna AT cmrr.umn DOT edu>
Date: Wed, 04 Jun 2008 10:45:20 -0400
Brian Hanna wrote:
> No, that's not quite it. Yes, auto_increment is limited by the field 
> size, but even with a bigint(20), max_rows is still stuck at 4294967295. 
> Even on tables in a 64-bit mysql installation.
> 
> This has something to do with mysql's myisam default data row pointer 
> size myisam_data_pointer_size, I think [1].
> 
> To correct this, I'd have to increase the data pointer size, restart the 
> database, and dump and reload the table?

 From what I've found, no, you should be able to modify the existing table in 
place

http://wiki.bacula.org/doku.php?id=faq#why_does_mysql_say_my_file_table_is_full

-- 
Frank Sweetser fs at wpi.edu  |  For every problem, there is a solution that
WPI Senior Network Engineer   |  is simple, elegant, and wrong. - HL Mencken
     GPG fingerprint = 6174 1257 129E 0D21 D8D4  E8A3 8E39 29E3 E2E8 8CEC

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users

<Prev in Thread] Current Thread [Next in Thread>