Hi there,
I've encountered a problem trying to insert large strings into a MySQL
database. I'm running mysql Ver 11.15 Distrib 3.23.39, for dec-osf4.0f
The details follow.
Round 1:
When I tried to insert very long text strings into a LONGTEXT column of a
MyISAM table I was getting errors that killed the connection. I attempted
to increase the max_allowed_packet variable to 200MB but mysqladmin tells
me that max_allowed_packet = 67107840.
Round 2:
I tried again to load the sequences but then failed with a ~34MB string.
I then learned that this variable is capped at 16MB in version 3.23.
Round 3:
Unable to get around this without upgrading to MySQL 4.0, I tried to
insert the sequence by breaking it into smaller (1MB) substrings then
concatenating them in the database like so:
UPDATE table
SET string = CONCAT(string, next_substring)
WHERE ID = id;
I thought this might work because the packet size of the SQL statement is
only about 1MB. However, this failed too with Error code 139, right after
the insert that would have made the concatenated sequence > 16 MB.
Does this mean that the size of existing string in the database is
included in the calculation of the packet size? Or is there some other
parameter (limiting row size, for example) that is being violated?
Thank you for your help.
Regards,
Craig Cummings, Ph.D.
Relman Laboratory
Stanford University School of Medicine
Department of Microbiology and Immunology
e-mail: [EMAIL PROTECTED]
phone: 650-498-5998
fax: 650-852-3291
---------------------------------------------------------------------
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
