You are right, I didnot see this section so well....

BTW: I am really interested in InnoDB features, do you have an answer for
the second question about queries taking so long time?

Regards,

Rodrigo Gonzalez.

----- Original Message -----
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 12, 2002 3:51 PM
Subject: Re: InnoDB


> Rodrigo,
>
> from the manual:
>
> "
> If the disk becomes full you may want to add another data file to another
> disk, for example. Then you have to look the size of ibdata1, round the
size
> downward to the closest multiple of 1024 * 1024 bytes (= 1 MB), and
specify
> the rounded size of ibdata1 explicitly in innodb_data_file_path. After
that
> you can add another data file:
>
> innodb_data_file_path = /ibdata/ibdata1:988M;/disk2/ibdata2:50M:autoextend
> "
>
> Best regards,
>
> Heikki Tuuri
> Innobase Oy
> ---
> Order technical MySQL/InnoDB support at https://order.mysql.com/
> See http://www.innodb.com for the online manual and latest news on InnoDB
>
>
> ----- Original Message -----
> From: ""Rodrigo Gonzalez"" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.mysql
> Sent: Friday, April 12, 2002 4:20 PM
> Subject: InnoDB
>
>
> > I install mysql-max 3.23.50 in my test box and start testing innodb
> > tables....
> >
> > I found two questions....first of all I used autoextend feature (it's
> really
> > great) but I cannot now add another file to the tablespace....
> >
> > The second question is if I am configuring something wrong, the same
query
> > which takes 80 seconds in MyIsam tables takes 640 in InnoDb tables....
> >
> >
> > Here is my InnoDB definition in my.cnf
> >
> > # Uncomment the following if you are using Innobase tables
> > innodb_data_file_path =
> > ibdata1:256M;ibdata2:256M;ibdata3:128M:autoextend:max:2000M
> > innodb_data_home_dir = /usr/local/mysql_50/data/
> > innodb_log_group_home_dir = /usr/local/mysql_50/data/
> > innodb_log_arch_dir = /usr/local/mysql_50/data/
> > set-variable = innodb_mirrored_log_groups=1
> > set-variable = innodb_log_files_in_group=3
> > set-variable = innodb_log_file_size=10M
> > set-variable = innodb_log_buffer_size=8M
> > innodb_flush_log_at_trx_commit=0
> > innodb_log_archive=0
> > set-variable = innodb_buffer_pool_size=64M
> > set-variable = innodb_additional_mem_pool_size=4M
> > set-variable = innodb_file_io_threads=4
> > set-variable = innodb_lock_wait_timeout=50
> >
> > The test box is a PIII with 192MB
> >
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> >    http://www.mysql.com/manual.php   (the manual)
> >    http://lists.mysql.com/           (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to