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 del
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 t
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):
> http://www.mysql.com/
> 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 "gr
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 specif
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
; Sent: Monday, 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
Life 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 p
10 matches
Mail list logo
