LinuxQuestions.org
Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
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.

Notices


Reply
  Search this Thread
Old 11-27-2006, 12:48 PM   #1
joemacbusiness
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, 07:51 AM   #2
trickykid
LQ Guru
 
Registered: Jan 2001
Posts: 24,149

Rep: Reputation: 235Reputation: 235Reputation: 235
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.
 
  


Reply


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 11:11 PM
limit file size ust Linux - General 2 02-24-2005 08:33 AM
redhat 9.0 file limit size.. johnyy Linux - Software 2 09-16-2003 05:38 PM
MySQL size limit Robert0380 Linux - General 2 09-05-2003 04:36 AM
File size limit petway56 Linux - General 4 05-08-2003 12:19 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - General

All times are GMT -5. The time now is 11:31 PM.

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