File Size Limit In HP-UX.

[Jamal Al-Hammadi]

Hi

I have MYSQL database file in HP-UX 11i Operating System, wich size is 2G.B.
I want to add more records to that file to become more than 2G.B. in size.
How can I do for this problem?

[Ken Penland_1]

the filesystem that the database file resides in needs to have been created with the option "largefiles" specified and the filesystem mounted with the largefiles option. 2 Gig is the limit unless you directly specify "largefiles"

[mirco_1]

hy,

do you activate the largefiles :

# fsadm

return largefiles?

if not then

# fsadm -F vxfs -o largefiles
DM

[D Block 2]

is this a raw device ? if not, have the option present in the /etc/fstab file for mounting.

[Devender Khatana]

Hi,

You can achive this by enabling largefile options online and enabling the options in /etc/fstab file so that everytime the file system is mounted the options is enabled by itself.

Make these changes
#fsadm -F vxfs -o largefiles /mount_point

Change entry in /etc/fstab for this file system . Please note that if the changes are not made to /etc/fstab and largefile option is enabled for the file system then it will not mount on next attempt by itself.

HTH,
Devender

[Jamal Al-Hammadi]

Hi

I have MYSQL database file in HP-UX 11i Operating System, wich size is 5G.B.
I want to add more records to that file to become more than 5G.B. in size.
What can I do for this problem?

[Alan Meyer_4]

In addition to setting the largefiles flag for the filesystem, you will ned to extend the logical volume to handle the size of the file that you wish to create. This can be done either through SAM or through lvextend & extendfs. To accomplish this with the filesystem mounted, you will need to have onlineJFS installed also.

[Jamal Al-Hammadi]

Hi

I have MYSQL database file in HP-UX 11i Operating System, wich size is 5G.B.
I want to add more records to that file to become unlimited size.
What can I do for this problem?

[Ranjith_5]

Hi,

See the following white paper from HP.

http://docs.hp.com/en/940/lgfiles4.pdf

Regards,
Syam

[Ranjith_5]

Hi jamal,

Go through the following thread.There is your answer.

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=90584

Regards,
Syam