On Mon, 1 May 2006 12:04:10 +0200 Christoph Haas <[EMAIL PROTECTED]> wrote:
> Evening, > > I'm using MySQL (4.1) as an index storage with the default MyISAM table > format. Unfortunately the partition holding the MySQL databases ran full > and the database became corrupt. So I wanted to restore the mysqldump of > the index from the day before. > > Now it's 12 hours after I started to restore the 2.4 GB dump file and MySQL > still seems to be doing the "/*!40000 ALTER TABLE `File` ENABLE KEYS */" > part of the dump. The disk is trashing like fury while the database is > creating the indices. > > What I wonder about: > - is > 12 hours a common restore time for a 2.4 dump file? > - is a 2.4 dump file/database size common when backup up ~1 million files > that sum up to ~50 GB? (file and job retention are 1 month while I run > one full backup per week and an incremental daily) > - is InnoDB perhaps suited better than MyISAM? > - are there MySQL server parameters I could tune? > - are there better ways to restore the database than "mysql < dumpfile"? > - is PostgreSQL (7.4.7) perhaps better suited? This is far from a direct answer to your question, but you got me thinking, so I ran some quick tests. Our primary Bacula server has a 375M catalog. This is PostgreSQL 8.1 on FreeBSD. Just for kicks, I grabbed a dump of the catalog and timed restoring it to the PostgreSQL 8.1 installation on my local computer. It took 2m43s. My desktop machine is FreeBSD 6.0, on a 3.2Ghz Intel with HT enabled, 1G RAM and a single SATA 150 disk. The restore was done in (more or less) the same manner you did: psql -U pgsql template1 < bacula.dumpfile Obviously, this is far from apples to apples. I don't know exactly what this says about your problem or how to solve it. I doubt it's even saying "use PostgreSQL instead of MySQL". But it gives you some data to compare yours to. -- Bill Moran Collaborative Fusion Inc. **************************************************************** IMPORTANT: This message contains confidential information and is intended only for the individual named. If the reader of this message is not an intended recipient (or the individual responsible for the delivery of this message to an intended recipient), please be advised that any re-use, dissemination, distribution or copying of this message is prohibited. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. **************************************************************** ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
