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
Howdy all,
I'm trying to clean up a development server so that we
can retask it. I tried dropping a very large but no
longer necessary database that uses INNODB tables
exclusively. Unfortunately the disk usage on the box
didn't change. We're using a completely default MySQL
5.0.15 install on the
Hi all,
A little question...
Can I upgrade directly a server with MySQL 3.23.x version which has some
MyISAM databases (no problem with it) and some InnoDB databases towards
MySQL 4.1.x? Or have I to do a dump and restore instead of re-use databases?
wdyt?
--
Cedric Gavage - [EMAIL
Hello.
MySQL AB recommends a gradual upgrade. See:
http://dev.mysql.com/doc/refman/4.1/en/upgrade.html
http://dev.mysql.com/doc/refman/5.0/en/upgrade.html
Cedric Gavage wrote:
Hi all,
A little question...
Can I upgrade directly a server with MySQL 3.23.x version which
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.
thanks
Hsiu-Hi
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
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
PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, 10 June, 2003 01:40
Subject: InnoDB question(s)
O.K MySQL List This one is on me,
a bit funny, a bit strange but with a serious background.
You are allowed to laugh ;-).
Assuming that somebody has the clever idea to rename the folder
O.K MySQL List This one is on me,
a bit funny, a bit strange but with a serious background.
You are allowed to laugh ;-).
Assuming that somebody has the clever idea to rename the folder for a InnoDB
database f.e. on the command line base (mv command for Linux). Now the mysqld
server startsup
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):
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/products/mysql-4.0/index.html
They mention hopes to support foreign key
I am new to InnoDb and was wondering what steps I would have to do to
restore a table. Lets assume I am backing up the data by backing up the
tablespaces.
Thanks in advance
(MySQL, query)
-
Before posting, please check:
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
Hi There,
(mysql, query)
From the online manual I see:
--
innodb_data_file_path
Paths to individual data files and their sizes. The full directory path
to each data file is acquired by concatenating innodb_data_home_dir to
the paths specified here. The file sizes are specified in megabytes,
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
When you have a table with both numeric and variable-length text data,
and you need to update the numeric part a lot, it made sense in MyISAM
to split the numeric from the textpart. (Because working on fixed-length
tables is so much faster.) Say...
Original:
Table 1: id1 int, id2 int,
:-(.
-Original Message-
From: Craig Vincent [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 16, 2002 6:28 PM
To: MySQL
Subject: MySQL/InnoDB question
I'm not new to MySQL but have only recently familiarized myself with
InnoDB.
One question I have so far been able to find an answer
I'm not new to MySQL but have only recently familiarized myself with InnoDB.
One question I have so far been able to find an answer on is the datafiles.
Let's assume I have 5 GB worth of information, this information changes
regularly. Performance wisewould I be better off using a single 5GB
Hi there
I am busy evaluating InnoDB to decide whether to use it in our live
environment, simultaneously (which proberly isn't the best thing) I am
making changes to my code (I am using Visual Basic), to stream line my
transactions and make full use of the transaction facility.
My question to
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
Dear,
I have just try to used innodb feature on linux 6.2 box. I have a little
confuse to startup but last i can do it. when I started, my server (64M
Ram and 3 gb disk space) go slower than without innodb feature. I would
like to ask someone who has experience use innodb.
-
23 matches
Mail list logo