Re: innodb file won't shrink
Alvaro, - Original Message - From: Alvaro Avello [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 1:13 AM Subject: Re: innodb file won't shrink -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 There 's any chance that in the future every InnoDB table files from a determinated database can be placed in the same directory of the mysql ( MyISAM ) database ? . My point is that if you want to take a binary backup of all databases in the mysql directory and you want to restore just one of the databases , you could just copy the directory to the correct place and thats all you have to do to restore a single database.. I guess I'm getting tired to wait for the dump to re-create all the indexes and stuff like that. it will not be straightforward. The undo logs used to purge old versions of rows and roll back uncommitted transaction will not be placed to those table files. But if you let the database to be silent and run purge to completion, then you will get clean tables you can restore later individually to the database. Thanks In advance Saludos / Regards , Alvaro Avello. Regards, Heikki walt wrote: |Heikki Tuuri wrote: | | |On September 15th, 2003 you will be able to put every InnoDB table into its |own file. That should alleviate this kind of problem. | | |Best regards, | |Heikki Tuuri |Innobase Oy |http://www.innodb.com |Transactions, foreign keys, and a hot backup tool for MySQL |Order MySQL technical support from https://order.mysql.com/ | | |That is great news! Will a single table be able to span several |datafiles? | |Thanks! |walt | -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) Comment: Using GnuPG with Netscape - http://enigmail.mozdev.org iD8DBQE/EysJR9NZaw5tbc0RAnMHAJ4/ZxbE5sRwAjW8cDAcXOr6cbsiowCeJU14 y/QT2dFY16n6L/OcJ0vCHyw= =PCGI -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: innodb file won't shrink
Walt, - Original Message - From: walt [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, July 14, 2003 11:56 PM Subject: Re: innodb file won't shrink Heikki Tuuri wrote: On September 15th, 2003 you will be able to put every InnoDB table into its own file. That should alleviate this kind of problem. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ That is great news! Will a single table be able to span several datafiles? sorry, no. The TODO list is already overloaded. Thanks! walt Regards, Heikki -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: innodb file won't shrink
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Sorry HeikkiCan you give me a few steps to obtain that...? Thanks a lot. Alvaro Avello. Heikki Tuuri wrote: |Alvaro, | |- Original Message - |From: Alvaro Avello [EMAIL PROTECTED] |To: Heikki Tuuri [EMAIL PROTECTED] |Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] |Sent: Tuesday, July 15, 2003 1:13 AM |Subject: Re: innodb file won't shrink | | |-BEGIN PGP SIGNED MESSAGE- |Hash: SHA1 | |There 's any chance that in the future every InnoDB table files from a |determinated database can be placed in the same directory of the mysql ( |MyISAM ) database ? . My point is that if you want to take a binary |backup of all databases in the mysql directory and you want to restore |just one of the databases , you could just copy the directory to the |correct place and thats all you have to do to restore a single |database.. I guess I'm getting tired to wait for the dump to |re-create all the indexes and stuff like that. | | |it will not be straightforward. The undo logs used to purge old versions of |rows and roll back uncommitted transaction will not be placed to those table |files. But if you let the database to be silent and run purge to completion, |then you will get clean tables you can restore later individually to the |database. | |Thanks In advance | |Saludos / Regards , | |Alvaro Avello. | | |Regards, | |Heikki | |walt wrote: | ||Heikki Tuuri wrote: || || ||On September 15th, 2003 you will be able to put every InnoDB table |into its ||own file. That should alleviate this kind of problem. || || ||Best regards, || ||Heikki Tuuri ||Innobase Oy ||http://www.innodb.com ||Transactions, foreign keys, and a hot backup tool for MySQL ||Order MySQL technical support from https://order.mysql.com/ || || ||That is great news! Will a single table be able to span several ||datafiles? || ||Thanks! ||walt || |-BEGIN PGP SIGNATURE- |Version: GnuPG v1.2.1 (GNU/Linux) |Comment: Using GnuPG with Netscape - http://enigmail.mozdev.org | |iD8DBQE/EysJR9NZaw5tbc0RAnMHAJ4/ZxbE5sRwAjW8cDAcXOr6cbsiowCeJU14 |y/QT2dFY16n6L/OcJ0vCHyw= |=PCGI |-END PGP SIGNATURE- | | | | | -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) Comment: Using GnuPG with Netscape - http://enigmail.mozdev.org iD8DBQE/FGZMR9NZaw5tbc0RAn6lAJ0filp6siUs+TBk7N2CP8Il6mgHvwCfV20j YBIWR33O86CMczdhleqvZKs= =iQu1 -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: innodb file won't shrink
Alvaro, - Original Message - From: Alvaro Avello [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 11:38 PM Subject: Re: innodb file won't shrink -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Sorry HeikkiCan you give me a few steps to obtain that...? sorry, I was talking about the September file per table storage model. Thanks a lot. Alvaro Avello. Regards, Heikki Heikki Tuuri wrote: |Alvaro, | |- Original Message - |From: Alvaro Avello [EMAIL PROTECTED] |To: Heikki Tuuri [EMAIL PROTECTED] |Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] |Sent: Tuesday, July 15, 2003 1:13 AM |Subject: Re: innodb file won't shrink | | |-BEGIN PGP SIGNED MESSAGE- |Hash: SHA1 | |There 's any chance that in the future every InnoDB table files from a |determinated database can be placed in the same directory of the mysql ( |MyISAM ) database ? . My point is that if you want to take a binary |backup of all databases in the mysql directory and you want to restore |just one of the databases , you could just copy the directory to the |correct place and thats all you have to do to restore a single |database.. I guess I'm getting tired to wait for the dump to |re-create all the indexes and stuff like that. | | |it will not be straightforward. The undo logs used to purge old versions of |rows and roll back uncommitted transaction will not be placed to those table |files. But if you let the database to be silent and run purge to completion, |then you will get clean tables you can restore later individually to the |database. | |Thanks In advance | |Saludos / Regards , | |Alvaro Avello. | | |Regards, | |Heikki | |walt wrote: | ||Heikki Tuuri wrote: || || ||On September 15th, 2003 you will be able to put every InnoDB table |into its ||own file. That should alleviate this kind of problem. || || ||Best regards, || ||Heikki Tuuri ||Innobase Oy ||http://www.innodb.com ||Transactions, foreign keys, and a hot backup tool for MySQL ||Order MySQL technical support from https://order.mysql.com/ || || ||That is great news! Will a single table be able to span several ||datafiles? || ||Thanks! ||walt || |-BEGIN PGP SIGNATURE- |Version: GnuPG v1.2.1 (GNU/Linux) |Comment: Using GnuPG with Netscape - http://enigmail.mozdev.org | |iD8DBQE/EysJR9NZaw5tbc0RAnMHAJ4/ZxbE5sRwAjW8cDAcXOr6cbsiowCeJU14 |y/QT2dFY16n6L/OcJ0vCHyw= |=PCGI |-END PGP SIGNATURE- | | | | | -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) Comment: Using GnuPG with Netscape - http://enigmail.mozdev.org iD8DBQE/FGZMR9NZaw5tbc0RAn6lAJ0filp6siUs+TBk7N2CP8Il6mgHvwCfV20j YBIWR33O86CMczdhleqvZKs= =iQu1 -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: innodb file won't shrink
Heikki Tuuri wrote: On September 15th, 2003 you will be able to put every InnoDB table into its own file. That should alleviate this kind of problem. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ That is great news! Will a single table be able to span several datafiles? Thanks! walt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: innodb file won't shrink
Steve, - Original Message - From: Steve [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday, July 10, 2003 11:24 PM Subject: Re: innodb file won't shrink I found the following thread: http://groups.google.com/groups?threadm=9dpadc%2412ag%241%40FreeBSD.csie.NCTU.edu.tw That was from 2001 and talks about the potential for INNODB tools... does anyone know if any work has been made on those? I just can't believe that there's no real way for me to make this file smaller when the space is no longer needed/used... the suggested - dump the database and then recreate it just won't since I have a 34+GB db and no more space on my drive? Anyone? Please! sorry, it is not possible to shrink the InnoDB tablespace without recreating it. You may try gzip or some other tool to compress the table dumps if they would not otherwise fit on your disk. On September 15th, 2003 you will be able to put every InnoDB table into its own file. That should alleviate this kind of problem. -Steve Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]