bz_lock_tables - how much, how often?

Kevin Benton kevin.benton at amd.com
Wed Jan 3 16:18:03 UTC 2007


David Miller wrote:
> Fergus Sullivan wrote on 12/21/06 3:27 AM:
>> i've noticed mysql.pm (2.22) includes the following code:
>
>> my bugzilla instance is a mixture of myisam an innodb.
>
> Bugzilla 2.22 was not written with InnoDB in mind.  Your tables should 
> all be myISAM or you're probably asking for trouble.
>
> That said, there's been some debate about switching things to InnoDB, 
> and if that happens it'll probably be for 3.2 or so.
>
Hi Fergus,

Any time Bugzilla asks MySQL for a lock, MySQL automatically clears the 
lock as soon as one of two things happen: 1) the connection is 
terminated, or 2) Bugzilla releases the lock.

Kevin

-- 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bugzilla.org/pipermail/developers/attachments/20070103/fb420155/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: AMDLogo.png
Type: image/png
Size: 1784 bytes
Desc: not available
URL: <http://lists.bugzilla.org/pipermail/developers/attachments/20070103/fb420155/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: kevin.benton.vcf
Type: text/x-vcard
Size: 915 bytes
Desc: not available
URL: <http://lists.bugzilla.org/pipermail/developers/attachments/20070103/fb420155/attachment.vcf>


More information about the developers mailing list