Tripp,
ibdata files never shrink. You can try this to free up space:
* Take a mysqldump of all tables that you may need,
* delete the ibdata files,
* Rebuild your tables by importing the dump.
Using innodb_file_per_table, will freed the disk space whenever you
run optimize table or
At 3:25 PM -0700 9/17/03, Hsiu-Hui Tseng wrote:
After specify the variablies for innodb in my.cnf file, I started mysql
server. Why I did not see the creating output? But I can see it in err file.
If there is an error file, that's where you'll see the output.
If you mean you want to see it on the
Hi Edward,
Thank you for the reply. I really appreciate the response,but I was thinking
into a different direction.
I was hoping that perhaps additionally to the normal backup procedure that
there is a shortcut or a trick which would quickly allow you to fix that
specific issue (f.e. recover
http://www.innodb.com/ibman.html#Backing_up
See the section on Forcing Recovery.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Nils Valentin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, 10 June, 2003 01:40
Subject: InnoDB question(s)
Hello.
On Fri 2002-12-06 at 11:46:16 -0500, [EMAIL PROTECTED] wrote:
From what I've been reading in the MySQL documentation, 3.23.43b
InnoDB features foreign key constraints, which is great! But from
the MySQL 4.1 wishlist items found here (scroll to the bottom):
This implies that I have to preguess how large each data file will be.
Correct. However, all InnoDB tables will share this space automatically.
(Corrolary: A single table will automatically span several InnoDB data
files if need be.)
Now, I understand with MyISAM tables that they just grow
David,
Wednesday, September 04, 2002, 9:34:55 AM, you wrote:
From the online manual I see:
DL --
DL innodb_data_file_path
DL Paths to individual data files and their sizes. The full directory path
DL to each data file is acquired by concatenating innodb_data_home_dir to
DL the paths specified
Science
757 S.Raymond
Pasadena, CA 91105
Tel: 626-584-5900
email: [EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 25, 2002 2:26 PM
To: Demirchyan Oganes-AOD098
Subject: Re: InnoDB question
Your message cannot be posted
, February 25, 2002 2:34 PM
To: '[EMAIL PROTECTED]'
Subject: RE: InnoDB question
Hello everyone,
I have this database, I'm using InnoDB type tables. I wanted
to know the
following:
How can I manipulate the tables, so that db supports multiple
users trying
to access the same table
On Mon, Feb 25, 2002 at 02:44:45PM -0800, Eric Mayers wrote:
Oganes,
It sounds like what you want is row-level-locking. This is a
feature of InnoDB tables. It allows users to write to a table while
other users are reading from the same table. Of course, they cannot
read and write the
10 matches
Mail list logo