4 messages in com.mysql.lists.gui-toolsRe: Limiting memory consumption of My...
FromSent OnAttachments
Patrick Questembert08 Nov 2004 12:44 
Adam Majer09 Nov 2004 14:24 
Patrick Questembert09 Nov 2004 14:31 
Adam Majer09 Nov 2004 14:56 
Subject:Re: Limiting memory consumption of MySQL Administrator on Windows
From:Adam Majer (sdf2@zombino.com)
Date:11/09/2004 02:56:05 PM
List:com.mysql.lists.gui-tools

Patrick Questembert wrote:

Thanks, I have been hearing the same thing from the MySQL team who is working to resolve that bug. I have to say I am a little surprised that the author(s) of MySQL Administrator did not anticipate that the database might be bigger than available physical memory ... I'd say that the surprise would be if the database was smaller!

I think they just went about it the "easy" way. Sometimes it is the most obvious things that you don't think about :)

I'll try the command-line approach but will mysqldump work fine while MySQL apps are running (in the sense that what it creates will be a consistent snapshot of my database) or do I need to stop all apps?

I don't think there is a difference between command line or MySQL Admin approach. Personally, I never bother to stop anything to do a backup.

Regarding the restore procedure: the nice thing about MySQL Administrator is that it allows you to select which tables to restore. Using mysql on the backup file would not be selective - of course one is supposed to have primary keys on all tables so that it will not cause harm to (try to) restore the whole thing, but still, it is somehow disquieting to run thousands of statements attempting to re-insert rows with existing keys.

On the command line, you can backup and then restore each table separately (one backup file per table). I never bother to do that since if I need to do a restore, I would probably need to do it for the entire database anyway.

- Adam