[rt-users] Bad query?

[Jon Hittner]

Thanks very much... I will try converting to INNODB tables.

Jon

On Thursday 19 September 2002 07:11 pm, Mark E. Dawson, Jr. wrote:
> >    There where a few other procs, all small select
> > statements and update
> > statements, and all in a "locked" state.  I don't
> > want to have to upgrade to
> > Oracle for a problem that only happens every few
> > weeks.
>
> You don't have to upgrade to Oracle.  As I stated
> before, you can do a dump of the DDL, append the
> table type of INNODB to the create statements, and
> thus be able to use tables with row-level locking.
> This way, you can stay on MySQL.
>
> Or, you could go a half-step up and use BDB tables
> within MySQL, which would give you page-level lock-
> ing, or something to that effect.
>
> Either way, you have options that will keep you on
> MySQL.  Personally, I've just finished demo-ing and
> testing RT with upper management, and everyone just
> loves the tool.  My plan is to migrate this to pro-
> duction, but to convert the tables to InnoDB, since
> we'll have 250+ employees creating, updating, and
> searching tickets all at once.
>
> __________________________________________________
> Do you Yahoo!?
> New DSL Internet Access from SBC & Yahoo!
> http://sbc.yahoo.com