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. "
You could us
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-configuration.html states:
" The autoextend
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
? Moreover, why
doesn't the second file (innodb_data02)show up?
Please advise.
Thankx in advance,
SB
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 08, 2003 1:19 AM
To: [EMAIL PROTECTED]
Subject: Re: AUTOEXTEND
Subhakar,
Nils already answered the fi
: "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 couple of mails with some error messa
>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
-
Before pos
anders,
Friday, December 06, 2002, 1:14:04 PM, you wrote:
adnaxsds> In an attempt to use innoDB tables I added this to my 'my.cnf':
adnaxsds> innodb_data_home_dir =
adnaxsds> innodb_data_file_path = /var/mysql/admin/ibdata1:100M:autoextend
adnaxsds> mysqld claimed this was an syntax error if I r
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.
>
>What's wrong?
What does the err
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, October 16, 2002 8:08 AM
Subject: Autoextend
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> complaining of
18 matches
Mail list logo
