walt wrote:
> Derrell Durrett wrote:
>
> > I'm running server version: 3.22.32, on SunOS 5.6 Generic_105181-17.
> > The code is perl 5.6.1, using DBI and DBD::mysql as the interface. We
> > have code that prepares a group of statement handles for use in doing
> > various queries and inserts in a loop that is executed anywhere from
> > 1-30000 times per use of this program. Another program drives this one,
> > calling it about 150 times.
> >
> > Last week (after I filled the local hard disk on the server), we began
> > to suffer disconnects from the database in these queries and inserts.
> > There is no obvious pattern to the disconnections, and they appear at
> > arbitrary times during the connections, but at approximately the same
> > time for each set of data (some of the shorter datasets are inserted
> > completely).
> >
> > The admin for this db is certain the problem is in the code. However
> > I can't understand this since that code is unchanged.
> >
> > What should I look for, what should he look for, or what additional
> > information do I need to supply in order to pursue resolving this issue?
>
> Derrell,
> There are a few things I'd check.
> 1. Is anything else touching this/these table/tables while the application is
> running.
No.
> 2. In your perl code, are you running ->finish on each query?
No. If I understand the docs correctly, finish is only useful when all data has
been read from/written to the statement handle. As the program exits almost
immediately when done with the batch of inserts/queries for a given dataset, this
seems appears unnecessary. Is my understanding flawed?
> 3. Is/are the table/tables you're touching innodb or myisam (could be log issue);
No.
> 4. What error message does perl give you from the db?
"No Database Selected" is the most common one, though it occaisionally returns "Lost
connection to MySQL server during query".
> 5. What is the load avg on the db and application server when query/update fails?
Don't know. Not likely very high. The host is a Sun Ultra 2.
> 6. If the query or update fails, what happens if the perl app sleeps for a few
> seconds and trys again?
Haven't tried this, as it would result in unacceptably long-running programs.
Derrell
--
Derrell Durrett Xilinx, Inc. Productivity Engineering
Longmont, Colorado
720.652.3843
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
