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

[Yogeeraj_1]

hi,

http://www.docs.hp.com/hpux/onlinedocs/os/lgfiles4.pdf

contains all the information you need.

If you want your MYSQL database file to extend beyond 2GB, you must configure your file system to support Largefiles!

Large files is a technology that must be explicitly enabled. A system will not support large files just because it has been updated to a release of HP-UX that supports large files. The advantage of this is that if large
files are not needed, then they do not need to be enabled on the system and everything will continue to work as it has in the past.

do you need any further clarifications?

kind regards
yogeeraj

[Devender Khatana]

Hi,

There are two things which can be involved in this. First you need to look for free space for adding datafile and secondly you need to add that using your MYSQL database procedure.( which I am not aware of)

You can find out the free space in the file system using "bdf" command. If you have free space in the file system you can use MYSQL documentation to add data file.

But in any case it can not be of unlimited size. You can add another data file of say 5GB,10GB or even more.

If you do not have free space then either it can be allocated from unallocated space or if you do not have unallocated space then you need to add more storage space by adding hardware.

HTH,
Devender