Buzilla 2.16.5 and InnoDB compatibility

[Joel Peshkin]

Patrick Campbell wrote:

>Hello,
>
>I apologize if this is seemingly self explanatory but I was unable to derive
>anything from google searches.
>
>We are currently running Bugzilla 2.16.5 and MySQL 3.23.58 with MyISAM.
>Interested in running InnoDB for increased overall performance, specifically
>with writes.
>
>It is unclear if we can simply enable InnoDB in MySQL and convert the table
>types or if this will cause critical failures with Bugzilla due to the
>differences in query syntaxes between MyISAM and InnoDB.
>
>Finally, is this something that should be necessary?  Our db has ~2500 bugs.
>
>  
>
No.  You cannot just switch to InnoDB.

There are many sites that dwarf yours.  Carefully examine the limits of 
your current performance before doing anything.  Very few performance 
issues scale with the number of bugs.  If you are interested in 
improving database performance, upgrade to MySQL 4.0 and consider 
upgrading to Bugzilla 2.18 and using a shadow database.