OK, got another piece of information.

I was running with the same 'default' mysql configuration, but
with a different data set.

when the mysql database table reached 7,285,902 records mysql
dropped the connection.
When I tried to reconnect, the mysql library core dumped.

Interesting note is that in two different labs, and two
different systems, mysql was configured exactly the same way, and
both dropped the connection at exactly 7,285,902 records.
The size in bytes for the two instances were drastically different.
In one case, the mysql db file was 9,9 gigbytes, in the other case
the file was 2.4 gigbytes.

I believe that the number 7,285,902 is significant here.

Does anyone have any idea what the significance is?

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 < [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> 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/[EMAIL PROTECTED]



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to