InnoDB
I install mysql-max 3.23.50 in my test box and start testing innodb tables I found two questionsfirst 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
Re: Turning off innodb
skip-innodb - Original Message - From: Scott Olson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 12, 2002 1:46 PM Subject: Turning off innodb Is it possible to turn off Innodb in MySQL 4.0 via the my.cnf file? Or command line params or something? I would like to be able to do this to since the device that MySQL is running on does not have the space available for the minimal 10Mb Innodb file. I realize I can probably do this be recompiling the source and not specificying the --with-innodb option. On Linux, RedHat 7.2 with the following RPMS. MySQL-Max-4.0.1-2 MySQL-4.0.1-2 MySQL-shared-4.0.1-2 MySQL-devel-4.0.1-2 MySQL-client-4.0.1-2 - 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
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? 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 questionsfirst 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
Re: InnoDB
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 questionsfirst 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
Re: InnoDB
How can I download this version? Regards - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 05, 2002 4:07 PM Subject: Re: InnoDB Hi! - Original Message - From: Rodrigo Gonzalez [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Friday, April 05, 2002 8:59 PM Subject: InnoDB First of all excuse my english...I hope someone can understand me I am thinking in converting from MyIsam to InnoDb tables. I have this table: du -sm table* 323 table.MYD 276 table.MYI 0 table.frm How much tablespace I need to convert it to InnoDb, I found that I need a lot more space for this table type, but I could not find how to calculate this space... The auto-extending data file of InnoDB-3.23.50 will solve your problem. No need to preallocate tablespace any more. I think the following formula usually gives a rough estimate of the needed size: 1.5 x size of the .MYD file + 5 x size of .MYI file. Regards, Rodrigo Gonzalez. sql,query 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 - 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
Query
I have this table definition: table_1 +--+-+--+-+-++ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-++ | id | int(15) | | PRI | NULL| auto_increment | | Contrato | int(11) | | MUL | 0 || | UserName | varchar(30) | | MUL | || +--+-+--+-+-++ table_2 +--+-+--+-+-++ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-++ | id | int(11) | | PRI | NULL| auto_increment | | Contrato | int(11) | | | 0 || | Nombre | varchar(50) | | | || | UserName | varchar(15) | | MUL | || +--+-+--+-+-++ table_3 +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | | +-+--+--+-+-++ | id | bigint(21) | | PRI | NULL| auto_increment | | UserName| varchar(32) | | MUL | | | | | Saldo | float|| | | | | +-+--+--+-+-++ I need to retrieve the column Saldo from table 3 for each Contrato (could in table 1 and table 2), so i executed this select... SELECT Contrato, Saldo FROM table_3, table_2, table_1 WHERE (table_1.UserName = table_3.UserName) OR (table_2.UserName = table_3.UserName) This select return an error that Contrato is ambiguous. I can not do 2 queries, so the only solution to this is an UNION, but MySQL does not support them yet.. Can someone help me?
GROUPING
Hi, I have to do a query but i don't know how to do this... I have this table id int start time stop time ... There are 2 to 4 rows for each id I have to select one row for each id where start is the max value between all rows with this id If you have an idea please let me know Thanks
Re: GROUPING
I did this, but there is a problem I have to select all fields from the record returned, not just id and start, i need the other fields from the record with max start do you understand? - Original Message - From: Ravi Raman [EMAIL PROTECTED] To: Rodrigo Gonzalez [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 12:37 PM Subject: RE: GROUPING hi. select id, max(start) from your_table group by id; HTH. -ravi. -Original Message- From: Rodrigo Gonzalez [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 10:57 AM To: [EMAIL PROTECTED] Subject: GROUPING Hi, I have to do a query but i don't know how to do this... I have this table id int start time stop time ... There are 2 to 4 rows for each id I have to select one row for each id where start is the max value between all rows with this id If you have an idea please let me know Thanks - 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
Re: My sql and system time
Field | Type | Null | Key | Default | Extra ---+--+--+-+-+--- hora | time | YES | | | insert into hora values (curtime()) - Original Message - From: VVM Ravikumar Sarma Chengalvala [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 10:07 AM Subject: My sql and system time Hi, Can some one let me know how can I insert current time into the MySQL table's time column. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
Replication
Hi, Excuse my english pleasei'll try to explain what i have to do. I have two server running MySQL, at this time one is a master and the other a slave. What I have to do is to make both master and slave together so if the master gows down the system still work with the slavelike a cluster, could someone help me? Thanks, Rodrigo Gonzalez.