Hi!
I'm having a strange problem. I use MySQL just to serve two hundred
small tables. They are very static, I update them once a week. And
small, about 40Mb of total disk space used. A few people use this
tables, always with MyODC from Access from a Windows platform.
Two weeks ago I needed to load a lot of data just to make some
statistics. A lot of data means 60 Million registers, 30 text files of
500 Mbytes each to import.
I started to import with mysqlimpor from another machine. Then I tried
first to FTP the file and then import with mysqlimport locally. Finally
I tried to FTP the file and import it from inside mysql with 'load data
infile...'.
With all this methods I had the same problem. I import one file, two
files, etc. But then the process just hangs (meaning that takes 10
times the usual time and no other querys can be done).
Sometimes I can´t even enter to mysql from command line. Sometimes I
can enter, and if I show the processes, they look like working. If I
kill them, and show the processes again, they look like 'Killed', but
are still there, with the Time counting and with the mysqld using 99%
of the processor (viewing with 'top').
Always, the only way to recover the server is a 'kill -9' to the
processes of the mysqld.
Could you please help me?
Installation data:
Server version: 3.23.39
Uname -a: SunOS 5.6 Generic_105181-16 sun4u sparc SUNW,Ultra-
5_10
Thank you very much!!
Facundo Batista
Gestión de Red
[EMAIL PROTECTED]
(54 11) 4324-9091
Cel: 15 5132 0132
-
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
