Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Mark Kozikowski (mkozikowskilio.aacisd.com)
Date: Wed Jan 23 2008 - 07:44:52 CST
Thanks for the responses.
I am sorry I cannot give more detailed information now. The system is
being run through tests for other issues.
But I can say that we are using a my.cnf that contains only this one
There are a few processes making queries to the db, but my is the most
active, at approximately, 3.5 gigbytes per hour. This translates to
about 200 million rows into the table.
I do reduce the number of puts to the DB by combining multiple rows per
When I get a chance to access the system, I will get more status and
Thanks for helping.
Ananda Kumar wrote:
> HI Mark,
> What is the error your seeing the error log file, can u please let us know.
> On Jan 21, 2008 2:27 PM, Mark Kozikowski < mkozikowskilio.aacisd.com
> <mailto:mkozikowskilio.aacisd.com>> wrote:
> Hello all,
> I have been using MySQL for about 5 years now in a company project.
> I store a lot of data, very rapidly into the database.
> Presently, I am having a problem where the MySQL server appears to
> be denying a connection when I reach a database size of about
> 10 billion bytes.
> I am running a mostly default installation on Fedora core 4.
> We modified the blob size to 1 million for a special case. But for
> the failing operations, the blob size is only about 1.5K.
> I am storing about 3 millions records per hour, each averaging
> The DB is a single table with columns. 4 of which are integers.
> One is a blob.
> I am using RHFC 4 with ext3 file system.
> After running for about 2.5 hours, MySQL drops the connection and
> refuses to allow any others to the specified database.
> Are there any configurations I can adjust or look at that may enable
> me to extend my DB to more data storage?
> Mark Kozikowski
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=anandklgmail.com
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql