From: lmfitzg
To: [EMAIL PROTECTED]
Subject: [50 character or so descriptive subject here (for reference)]
>Description:
<precise description of the problem (multiple lines)>
>How-To-Repeat:
<code/input/activities to reproduce the problem (multiple lines)>
>Fix:
<how to correct or work around the problem, if known (multiple lines)>
>Submitter-Id: <submitter ID>
>Originator:
>Organization:
<organization of PR author (multiple lines)>
>MySQL support: [none | licence | email support | extended email support
]
>Synopsis: <synopsis of the problem (one line)>
>Severity: <[ non-critical | serious | critical ] (one line)>
>Priority: <[ low | medium | high ] (one line)>
>Category: mysql
>Class: <[ sw-bug | doc-bug | change-request | support ] (one line)>
>Release: mysql-3.22.26a (Source distribution)
>Server: ./mysqladmin Ver 7.11 Distrib 3.22.26a, for sun-solaris2.8 on
sparc
TCX Datakonsult AB, by Monty
Server version 3.22.26a
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 1 day 20 hours 24 min 25 sec
Threads: 4 Questions: 725 Slow queries: 0 Opens: 677 Flush tables:
1 Open tables: 63
>Environment:
<machine, os, target, libraries (multiple lines)>
System: SunOS sherwin 5.8 Generic_108528-03 sun4u sparc SUNW,Ultra-60
Architecture: sun4
Some paths: /usr/bin/perl /usr/ccs/bin/make /usr/local/bin/gmake
/usr/local/bin/gcc /usr/ucb/cc
GCC: Reading specs from
/usr/local/lib/gcc-lib/sparc-sun-solaris2.8/2.95.2/specs
gcc version 2.95.2 19991024 (release)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS=''
LDFLAGS=''
Configure command: ./configure --prefix=/usr/local/mysql
Perl: This is perl, version 5.005_03 built for sun4-solaris
I am trying to load two tables from space-delimited files.
Both are quite large.
Neither ever seems to finish. I have allowed them to run for days.
The file sizes of the table files increase for a while and stop,
but the mysql cursor never returns, 'mysqlamysqladmin processlist'
says the process is still running, top says the process mysql is still
taking up an entire CPU, but nothing is happening. When this
happens I can't do anything else in the database.
I have tried LOAD DATA INFILE from the mysql prompt,
and mysqlimport from the command line (which launches LOAD
DATA INFILE), both with the same results.
file size
file 1: 342580425 FAILS
file 2: 233952880 FAILS
file 3: 156121911 WORKS
I am running Sun Solaris 8, which allows file sizes over 2gig. Is there
a file size limit for mysql? Is there some setting I need to
allow import of large files? Is there some different/better way
to import data than what I have tried?
The only way I have found to stop the process is to kill the server.
Lisa
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
