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: Fr

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]

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 li

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 wh

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

InnoDB

2002-04-05 Thread Rodrigo Gonzalez
d a lot more space for this table type, but I could not find how to calculate this space... Regards, Rodrigo Gonzalez. sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) h

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| auto_inc

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: "Rodr

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: 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,

Replication

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