Download your favorite Linux distribution at LQ ISO.
Go Back > Forums > Linux Forums > Linux - General
User Name
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.


  Search this Thread
Old 11-27-2006, 11:48 AM   #1
LQ Newbie
Registered: Nov 2006
Location: USA
Posts: 1

Rep: Reputation: 0
File size limit on RedHat 3.4.5-2 with MySql

Hi Folks,

We are having a "database full" problem on a RedHat Linux Server. The DB is MySql: Ver 14.12 Distrib 5.0.19.
with about 16 million records.
I am thinking this is an OS issue since the docs I have read indicate it:
================= snip ===============
FROM: mysql site:

1.4.4. How Large MySQL Tables Can Be

MySQL 3.22 had a 4GB (4 gigabyte) limit on table size.
With the MyISAM storage engine in MySQL 3.23, the maximum
table size was increased to 65536 terabytes (2567 1 bytes).
With this larger allowed table size, the maximum effective
table size for MySQL databases is **usually determined by
operating system constraints** on file sizes, not by MySQL internal limits.

We have plenty of filesystem space available (over 50GB)
but our DB keeps filling up. I know this to be true since
we can delete a couple hundred K of old records and then add new records.
So my Queation is: How do I increase the file size limit on Redhat?
Thanks for the help, JoeMacB
Old 11-28-2006, 06:51 AM   #2
LQ Guru
Registered: Jan 2001
Posts: 24,149

Rep: Reputation: 245Reputation: 245Reputation: 245
Are you using filesystem space with MyISAM or InnoDB space? What's the total size of your DB currently when it fills up? If it's 2GB or so, could be the limitation by the kernel and filesystem, in which a quick recompile could clear up.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
File Size limit? compu73rg33k Linux - Software 1 02-27-2005 10:11 PM
limit file size ust Linux - General 2 02-24-2005 07:33 AM
redhat 9.0 file limit size.. johnyy Linux - Software 2 09-16-2003 04:38 PM
MySQL size limit Robert0380 Linux - General 2 09-05-2003 03:36 AM
File size limit petway56 Linux - General 4 05-07-2003 11:19 PM > Forums > Linux Forums > Linux - General

All times are GMT -5. The time now is 09:54 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration