By chance, is it at all possible to exceed the 4.2GB file size barrier on Solaris 8 with MySQL 3.23.47? I've got one built with both GCC and another one with the Solaris Workshop 6 compiler.. Neither can exceed that magical number for some reason.. Both were built with large-files enabled.. In fact, when using the Solaris Workshop compiler, I forced each and every compiler line to have :
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 That didn't appear to make any difference.. I've also enabled largefiles as part of mounting my UFS file system -- I ran across that somewhere on the net.. Is there something I'm missing? I'm also doing similar tests on AIX and HP-UX 11i concurrently.. Those didn't even get as far as Solaris (2.1gb for them), but I didn't have large file support enabled for the respective volume managers.. If you've got any ideas, I'm happy to try it out! Here's what I get when I try to add one more record : % ./bin/mysql capacity Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.47 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> insert into test_capacity ( id, name, description, create_time, update_time, bit_flags ) values (59708440, 'Record #59708440', 'Description for Record #59708440', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 59708440); ERROR 1114: The table 'test_capacity' is full mysql> show table status; +---------------+--------+------------+----------+----------------+--------- ----+-----------------+--------------+-----------+----------------+--------- ------------+---------------------+------------+----------------+---------+ | Name | Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Create_options | Comment | +---------------+--------+------------+----------+----------------+--------- ----+-----------------+--------------+-----------+----------------+--------- ------------+---------------------+------------+----------------+---------+ | test_capacity | MyISAM | Dynamic | 59708440 | 71 | 4294967272 | 4294967295 | 489195520 | 0 | NULL | 2002-02-06 17:53:01 | 2002-02-07 08:30:52 | NULL | | | +---------------+--------+------------+----------+----------------+--------- ----+-----------------+--------------+-----------+----------------+--------- ------------+---------------------+------------+----------------+---------+ 1 row in set (0.00 sec) mysql> describe test_capacity; +-------------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+---------------+------+-----+---------+-------+ | id | int(11) | | PRI | 0 | | | name | varchar(65) | YES | | NULL | | | description | varchar(255) | YES | | NULL | | | create_time | timestamp(14) | YES | | NULL | | | update_time | timestamp(14) | YES | | NULL | | | bit_flags | int(11) | YES | | NULL | | +-------------+---------------+------+-----+---------+-------+ 6 rows in set (0.00 sec) mysql> Bye --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
