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 < [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]
