Hi,
I got this error using mysqlhotcopy:
DBD::mysql::db do failed: Can't find file: './Tecnowind/tqgrppia.frm' (errno:
24) at /usr/local/mysql/bin/mysqlhotcopy line 375.
Issuing rollback() for database handle being DESTROY'd without explicit
disconnect().
and perror 24 says:
Error code 24: Too many open files
Ok, the point is that the database has 865 tables:
# ls -al /home3/Oasi/files/Tecnowind/*.MYI | wc -l
865
The mysqlhotcopy script at line 375 try to lock all tables at once.
$dbh->do("LOCK TABLES $hc_locks");
I got this error with 3.23.34a and 3.23.36 mysql versions.
Could someone give me a solution ?
I think that some parameter should be tuned (open tables limit ???)
Thanks in advance
PS:
Yesterday, I have completed an installation with 120 concurrent users, with
OASI, our ERP based on mysql (OF COURSE) and it runs very very well !
The hardware is a bi-processor XEON 733 MHZ with 2GB of RAM and 60 gb
HD (SCSI).
There are 4 databases that shares some common tables !
marcello
---------------------------------------------------------------------
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
