InnoDB

2002-04-12 Thread Rodrigo Gonzalez
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

Re: Turning off innodb

2002-04-12 Thread Rodrigo Gonzalez
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

Re: InnoDB

2002-04-12 Thread Rodrigo Gonzalez
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

Re: InnoDB

2002-04-12 Thread Rodrigo Gonzalez
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

Re: InnoDB

2002-04-05 Thread Rodrigo Gonzalez
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

Query

2001-06-29 Thread Rodrigo Gonzalez
I have this table definition: table_1 +--+-+--+-+-++ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-++ | id | int(15) | | PRI | NULL|

GROUPING

2001-05-30 Thread Rodrigo Gonzalez
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

2001-05-30 Thread Rodrigo Gonzalez
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

Re: My sql and system time

2001-05-29 Thread Rodrigo Gonzalez
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

Replication

2001-05-28 Thread Rodrigo Gonzalez
a cluster, could someone help me? Thanks, Rodrigo Gonzalez.