|
Home > Archive > MySQL ODBC Connector > April 2005 > Fw: modifying InnoDB storage
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Fw: modifying InnoDB storage
|
|
| Jigal van Hemert 2005-04-26, 7:23 am |
| Unfortunately no response from the list anymore :-(
Can we ever get rid of the autoexpanding ibdata file without completely
rebuilding the databases?
Regards, Jigal.
----- Original Message -----
From: "Jigal van Hemert" <jigal@spill.nl>
To: <mysql@lists.mysql.com>
Sent: Wednesday, April 20, 2005 12:31 PM
Subject: Re: modifying InnoDB storage
> From: "Gleb Paharenko"
>
> Hi Gleb,
>
> Thanks for your response.
>
>
> If it currently reads:
> innodb_data_file_pat
h =
>
/ibdata/ibdata1:2000M;/ibdata/ibdata2:2000M;/ibdata/ibdata3:2000M;/ibdata/ib
> data4:10M:autoextend
>
> Can you change this into:
> =
>
/ibdata/ibdata1:2000M;/ibdata/ibdata2:2000M;/ibdata/ibdata3:2000M;/ibdata/ib
> data4:2000M;/ibdata/ ibdata5:10M:autoexte
n
> or
> =
>
/ibdata/ibdata1:2000M;/ibdata/ibdata2:2000M;/ibdata/ibdata3:2000M;/ibdata/ib
> data5:2000M;/ibdata/ ibdata4:10M:autoexte
n
> ???
>
>
> Sorry, it's still 4.0.x that our sysadmin wants...
>
> Regards, Jigal.
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| Gleb Paharenko 2005-04-26, 11:24 am |
| Hello.
According to this:
"If your last data file was defined with the keyword autoextend, the
procedure to edit my.cnf must take into account the size to which the
last data file has grown. You have to look at the size of the data file, round the size downward to the closest multiple of 1024 * 1024 bytes (= 1MB), and specify the rounded size explicitly in innodb_data_file_pat
h. Then you can add another data file."
I think you can.
"Jigal van Hemert" <jigal@spill.nl> wrote:
> Unfortunately no response from the list anymore :-(
>
> Can we ever get rid of the autoexpanding ibdata file without completely
> rebuilding the databases?
>
> Regards, Jigal.
>
> ----- Original Message ---
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@ensita.net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
|
|
|
|
|