Hello.


Looks like it is a bug. See:

  http://bugs.mysql.com/bug.php?id=7883





Duncan Hill <[EMAIL PROTECTED]> wrote:

> I recently changed /etc/my.cnf to set myisam_data_pointer_size to 6, as we're 

> starting to encounter quite a few tables that are larger than 4 GB.  However, 

> the create table statements used by the software application using the DB 

> don't seem to be creating tables with pointers > 4 bytes.

> 

> Recent creation (a month or two! after restarting the DB service)

> Creation time:       2005-09-07 16:35:06

> Datafile pointer (bytes):        4  Keyfile pointer (bytes):        4

> 

> Manually altering the table to a large max_rows and rebuilding the table 
> works 

> fine, and updates the pointer size to 5+.  Accessing files beyond 4 GB is not 

> an issue.

> 

> What's the point of setting the value (and restarted the mysql service) if it 

> doesn't actually do anything? :)  Or, what have I done wrong?

> 

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to