Is just a tunning problem?....Well, no problem, I continue testing.... Regards.
----- Original Message ----- From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: "Rodrigo Gonzalez" <[EMAIL PROTECTED]> Cc: "MySQL List" <[EMAIL PROTECTED]> Sent: Friday, April 12, 2002 4:38 PM Subject: Re: InnoDB > Rodrigo, > > ----- Original Message ----- > From: "Rodrigo Gonzalez" <[EMAIL PROTECTED]> > To: "Heikki Tuuri" <[EMAIL PROTECTED]> > Cc: "MySQL List" <[EMAIL PROTECTED]> > Sent: Friday, April 12, 2002 10:27 PM > Subject: Re: InnoDB > > > > 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? > > I am sorry, but MySQL AB and Innobase Oy developers can help in tuning only > if you have bought a technical support contract. > > > Regards, > > > > Rodrigo Gonzalez. > > 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: "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
