Re: innodb select

2006-01-13 Thread Gleb Paharenko
Hello. > Does this have anything to do with the variable: > > | tx_isolation| REPEATABLE-READ| It seems it is. If you use InnoDB only due to speed issues, change the transaction isolating level to READ UNCOMMITED. See: http://dev.mysql.com/doc/refman/5.0/e

Re: InnoDB select slow too

2001-11-30 Thread Chris Withers
Heikki Tuuri wrote: > > Chris, > > what is your my.cnf or my.ini like? Do you have a big enough > innodb_buffer_pool_size? set-variable = innodb_buffer_pool_size=300M big enough? Chris database, sql, query, table (just to keep the stoopid list software from whinging..) -

Re: InnoDB select slow too

2001-11-30 Thread Heikki Tuuri
Chris, what is your my.cnf or my.ini like? Do you have a big enough innodb_buffer_pool_size? Regards, Heikki http://www.innodb.com -- Order commercial MySQL/InnoDB support at https://order.mysql.com/ [EMAIL PROTECTED] wrote: > > Your message cannot be posted because it appears to be either s

Re: InnoDB select slow too

2001-11-30 Thread Chris Withers
[EMAIL PROTECTED] wrote: > > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > database,sql,query,table > > If you just reply to this message, and incl