cancel
Showing results for 
Search instead for 
Did you mean: 

File Size Limit In HP-UX.

Jamal Al-Hammadi
Occasional Contributor

File Size Limit In HP-UX.

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?
11 REPLIES
Ken Penland_1
Trusted Contributor

Re: File Size Limit In HP-UX.

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
Valued Contributor

Re: File Size Limit In HP-UX.

hy,

do you activate the largefiles :

# fsadm

return largefiles?

if not then

# fsadm -F vxfs -o largefiles
DM
D Block 2
Respected Contributor

Re: File Size Limit In HP-UX.

is this a raw device ? if not, have the option present in the /etc/fstab file for mounting.
Golf is a Good Walk Spoiled, Mark Twain.
Devender Khatana
Honored Contributor

Re: File Size Limit In HP-UX.

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
Impossible itself mentions "I m possible"
Jamal Al-Hammadi
Occasional Contributor

Re: File Size Limit In HP-UX.

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
Respected Contributor

Re: File Size Limit In HP-UX.

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.
" I may not be certified, but I am certifiable... "
Jamal Al-Hammadi
Occasional Contributor

Re: File Size Limit In HP-UX.

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
Honored Contributor

Re: File Size Limit In HP-UX.

Hi,

See the following white paper from HP.

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

Regards,
Syam
Ranjith_5
Honored Contributor

Re: File Size Limit In HP-UX.

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
Honored Contributor

Re: File Size Limit In HP-UX.

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Devender Khatana
Honored Contributor

Re: File Size Limit In HP-UX.

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
Impossible itself mentions "I m possible"