RE: dropping a database to reclaim space

2006-02-22 Thread Robert DiFalco
If I am testing for performance, I make sure to have one schema for each database server. When I want to tear down the data and restart (possibly with new settings). I first DROP the database I am working on. Then I shutdown the server and in the my_sql/data directory, I delete all the files

Re: dropping a database to reclaim space

2006-02-22 Thread sheeri kritzer
Luke, I believe the 'mysql' database (system) does NOT use InnoDB. The best thing to do would be to change your database to skip-innodb, check that the server is working, and then delete the innodb data and log files. -Sheeri On 2/21/06, Luke Vanderfluit [EMAIL PROTECTED] wrote: Hi. I have

Re: dropping a database to reclaim space

2006-02-22 Thread Heikki Tuuri
and that doesn't show reduced disk space either. I'm doing this on a solaris 9 box. Any input appreciated. Thanks. Kind regards. -- Luke Thread dropping a database to reclaim space - Luke Vanderfluit, February 22 2006 3:48am Re: dropping a database to reclaim space - sheeri kritzer, February 22 2006 6