there any way to specifiy the autoextend option
(...::autoextend) when using Innodb with raw devices
for the Shared Tablespace ?
sorry, no. We think of the partition as a chunk of storage. It does not
extend.
Thanks in advance for your help,
Mariella
Regards,
Heikki
--
MySQL General
autoextend option
(...::autoextend) when using Innodb with raw devices
for the Shared Tablespace ?
Thanks in advance for your help,
Mariella
Need a vacation? Get great deals
to amazing places on Yahoo! Travel
com/doc/refman/5.0/en/adding-and-removing.html
Yeah I've been reading that. It says that if we have an autoextend
file ( which we do ), then it's current size ( around 500MB now )
will be the limit for all subsequent autoextend files. I'd like to
be able to set a limit of 1
Tha
tml
Yeah I've been reading that. It says that if we have an autoextend
file ( which we do ), then it's current size ( around 500MB now )
will be the limit for all subsequent autoextend files. I'd like to be
able to set a limit of 1
That's not how I read it. How did you draw
reading that. It says that if we have an autoextend
file ( which we do ), then it's current size ( around 500MB now )
will be the limit for all subsequent autoextend files. I'd like to
be able to set a limit of 1
That's not how I read it. How did you draw this conclusion?
or
ant several data files (mainly because performance)
you need to add them in the my.cnf following the instructions in:
14.2.7. Adding and Removing InnoDB Data and Log Files
http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html
Yeah I've been reading that. It says that if we have an autoext
Daniel, innodb data files keep growing as needed, it even be of 20Gb
or more. If you want several data files (mainly because performance)
you need to add them in the my.cnf following the instructions in:
14.2.7. Adding and Removing InnoDB Data and Log Files
http://dev.mysql.com/doc/refman/5.0/en/
Hi all.
I'm about to import a LOT of data ( 20 GB ) into some InnoDB tables. At
the moment, I have:
innodb_data_file_path = ibdata1:10M:autoextend
in my /etc/mysql/my.cnf
The ibdata1 file is 499MB at the moment. What happens when this goes
past 2GB? Do I automatically get allocated another,
Tom Brown wrote:
hmm i'm not entirely sure i fancy adding another data file on the fly -
Can you give me a brief run down about how you would go about this?
My collegue the sysadmin usually takes care of keeping the databases
happy. But AFAIK it's a matter of modifying the setting in the .cnf fi
The short answer: no.
http://dev.mysql.com/doc/refman/4.1/en/innodb-configuration.html states:
" The autoextend attribute and those following can be used only for the last
data file in the innodb_data_file_path line. autoextend is available
starting from MySQL 3.23.50 and 4.0.2. "
From: "Tom Brown" <[EMAIL PROTECTED]>
(...)
> starting at say 1GB and then 'extending' to 25GB. So is it possible for
> all datafiles, rather than just the last one, be 'autoextending'
The short answer: no.
http://dev.mysql.com/doc/refman/4.1/en/innodb-c
Hi
I need to have a single db that will have in excess of 100gb of data in
it - For this i will need to create more that 1 datafile as the max file
size of linux would be exceeded in this scenerio.
On Oracle you can say that a datafile is x mb in size and it can
autoextend to be x mb - Is
At 16:29 +0300 8/17/03, Dmitry Kosoy wrote:
Hi,
Is there any possibility to check existing of autoextend option
for InnoDB ?
I mean by any sql command and not by searching in my.ini file ?
If you mean you want to find out the setting of the innodb_data_file_path
variable, you can use this
Hi,
Is there any possibility to check existing of autoextend option
for InnoDB ?
I mean by any sql command and not by searching in my.ini file ?
Regards,
Dmitry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
t;
Regards,
Heikki
....
Subject: RE: AUTOEXTEND
From: Subhakar Burri
Date: Tue, 8 Jul 2003 10:10:26 -0700
Hi, sorry to keep this thread going ...
I'm sending you the output of my results ... I don't see the autoextend
string in my
output. I'm using 3.23.5
Hi, sorry to keep this thread going ...
I'm sending you the output of my results ... I don't see the autoextend string in my
output. I'm using 3.23.56
I have the following entry in my .cnf file:
innodb_data_file_path=innodb_data01:5M;innodb_data02:5M:autoextend:max:10M
And t
: "Subhakar Burri" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, July 08, 2003 1:22 AM
Subject: RE: AUTOEXTEND
Hi,
I tried SHOW VARIABLES LIKE '%innodb%';
but I couldn't find any variables that show i
; -Original Message-
> From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 07, 2003 2:24 PM
> To: [EMAIL PROTECTED]
> Subject: Re: AUTOEXTEND
>
>
> Subhakar,
>
> - Original Message -
> From: ""Subhakar Burri"" <[EMAIL
s_priv table in mysql database, but
of no use. Any idea where MYSQL stores the status information inside the database?
Thankx in advance,
SB
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
Sent: Monday, July 07, 2003 2:24 PM
To: [EMAIL PROTECTED]
Subject: Re: AUTOEX
Subhakar,
- Original Message -
From: ""Subhakar Burri"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Monday, July 07, 2003 11:52 PM
Subject: AUTOEXTEND
> Sorry to post the same question again .. last time when I sent I =
> received a
Sorry to post the same question again .. last time when I sent I received a couple of
mails with some error messages .. so, not sure if my question was posted ...
Here we go again ..
Hi,
I have a couple of questions, and really appreciate your help ...
How can I find out if a data file is set
Hi,
I have a couple of questions, and really appreciate your help ...
How can I find out if a data file is set to auto-extend without looking in my.cnf
file? ie.. is there any variable that stores this information inside a database that I
can query?
I need the table_name & table_type of all th
>What version of MySQL do you use? autoextend is supported since
>3.23.50 and 4.0.2
Ahaa, I am using 3.23.49 (came with rh7.3).
Close but no cigar :)
--
&ers
-
Anders Nygård
--
s an syntax error if I removed 'autoextend' it works
adnaxsds> but I really want the autoextend capability.
What version of MySQL do you use? autoextend is supported since
3.23.50 and 4.0.2
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This em
Hello.
In an attempt to use innoDB tables I added this to my 'my.cnf':
innodb_data_home_dir =
innodb_data_file_path = /var/mysql/admin/ibdata1:100M:autoextend
mysqld claimed this was an syntax error if I removed 'autoextend' it works
but I really want the autoextend capa
At 13:33 -0300 10/16/02, Silmara wrote:
>- Original Message -
>From: Paul DuBois <[EMAIL PROTECTED]>
>To: Silmara <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
>Sent: Wednesday, October 16, 2002 12:16 PM
>Subject: Re: Autoextend
>
>
>> At 12:08
- Original Message -
From: Peter Brawley <[EMAIL PROTECTED]>
To: Silmara <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, October 16, 2002 12:18 PM
Subject: Re: Autoextend
> 1. "inoodb" should be "innodb".
Ok. I typed wrong in the e-
- Original Message -
From: Paul DuBois <[EMAIL PROTECTED]>
To: Silmara <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, October 16, 2002 12:16 PM
Subject: Re: Autoextend
> At 12:08 -0300 10/16/02, Silmara wrote:
> >How can I create a autoextend dat
Silmara,
Wednesday, October 16, 2002, 6:08:18 PM, you wrote:
S> I tried using the following configuration:
S> inoodb_data_file_path=date_d1:100M:autoextend
^
innodb_data_file_path
S> But the MySQL don't started.
S> What's wrong?
What error did you get? Check error logs.
--
At 12:08 -0300 10/16/02, Silmara wrote:
>How can I create a autoextend database?
>
>I tried using the following configuration:
>
>inoodb_data_file_path=date_d1:100M:autoextend
I assume you mean innodb_... and not innnodb_... ?
>
>But the MySQL don't started.
>
1. "inoodb" should be "innodb".
2. Does the directory named in innodb_data_home_dir exist?
3. Does the file date_d1 already exist?
PB
-
- Original Message -
From: "Silmara" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, Oc
How can I create a autoextend database?
I tried using the following configuration:
inoodb_data_file_path=date_d1:100M:autoextend
But the MySQL don't started.
What's wrong?
-
Before posting, please chec
message:
..
Subject: InnoDB autoextend question
From: Duane Winner
Date: Mon, 9 Sep 2002 10:30:21 -0700
Hello all,
I'm hoping someone can confirm this for me.
We're using InnoDB, but when I set it up originally, I just specified the
size of the data file:
innodb_data_file_path
Hello all,
I'm hoping someone can confirm this for me.
We're using InnoDB, but when I set it up originally, I just specified the
size of the data file:
innodb_data_file_path = ibdata1:1000M
Being new to it and all at the time, I wasn't aware of the autoextend
capability. Bu
Anthony,
Monday, June 17, 2002, 5:13:23 PM, you wrote:
ARJB> I am trying to play with innodb tables in 4.0.1-alpha-max on
ARJB> Solaris 2.7, but I am having a problem with setting up an
ARJB> autoextend tablespace... as soon as I put :autoextend at the
ARJB> end of my innodb_da
Nico,
Friday, June 14, 2002, 1:05:13 PM, you wrote:
NS> Hi, I just installed mysql-max 3.23.51, hoping to use innodb autoextend feature,
but mysql dies when run with the following row in my.cnf:
NS> innodb_data_file_path = ibdata1:512M:autoextend;ibdata2:256M:autoextend;
NS> compl
Hi, I just installed mysql-max 3.23.51, hoping to use innodb autoextend feature, but
mysql dies when run with the following row in my.cnf:
innodb_data_file_path = ibdata1:512M:autoextend;ibdata2:256M:autoextend;
complaining of an unrecognized option.
Thanks,
Nico
s the error output from mysqld:
> "InnoDB: syntax error in innodb_data_file_path
> 020523 16:34:24 Can't init databases"
>
> When I remove ":autoextend" from my.cnf then the database comes up and the
> new datafile is added but it's not autoextensible. I
0523 16:34:24 Can't init databases"
When I remove ":autoextend" from my.cnf then the database comes up and the
new datafile is added but it's not autoextensible. Is there a documentation
error on the autoextend syntax?
AtDhVaAnNkCsE,
Steve Orr
--
JW,
Wednesday, April 24, 2002, 11:49:17 PM, you wrote:
J> At various places on the MySQL web site there's mention of 3.23.50 and 3.23.51, and
the new autoextend feature.
J> However, the most recent on the download page is 3.23.49a.
J> Was .50/.51 not released because of bugs or
On Wed, Apr 24, 2002 at 03:49:17PM -0500, JW wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hey,
>
> At various places on the MySQL web site there's mention of 3.23.50
> and 3.23.51, and the new autoextend feature.
>
> However, the most recent
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hey,
At various places on the MySQL web site there's mention of 3.23.50 and 3.23.51, and
the new autoextend feature.
However, the most recent on the download page is 3.23.49a.
Was .50/.51 not released because of bugs or some
42 matches
Mail list logo
