From: Mark Kozikowski (mkozikowskilio.aacisd.com)
Date: Wed Jan 23 2008 - 07:44:52 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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
line:
set-variable=max_connections=300

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
put.

When I get a chance to access the system, I will get more status and
configuration information.

Thanks for helping.

Mark

Ananda Kumar wrote:
> HI Mark,
> What is the error your seeing the error log file, can u please let us know.
>
> regards
> anandkl
>
> 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
> 1.5K.
>
> 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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]