question

dclaar avatar image
dclaar Suspended asked dclaar Suspended posted

Setting up an external database

Just so folks know, In the Installation documentation, appendix 17, it talks about updating my.cnf, specifically the [mysql] section. But--at least in linux--it should be the [mysqld] section.

iTestinstallation - licensingdocumentation
10 |950

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
dclaar avatar image
dclaar Suspended answered dclaar Suspended posted

The instructions for setting up an external database say to convert the entire database server to uft8. This is not a good idea if you're running other databases on the server. In fact--when bugzilla went to utf8--their documentation said that changing the database to utf8 without running a conversion program would cause loss of data! We need a way to set just the fanfare tables to utf8.

 

The instructions also don't indicate what type of table type should be used: MyISAM or innodb. MyISAM only does table locks, so that might be an issue? Has anyone reseached this?

 

The cleanup script seems a bit ugly, building up command lines to delete records one at a time. I'm guessing that this will be quite slow on the amount of data fanfare generates. Has anyone benchmarked this?

10 |950

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.