[Tickets #7363] Re: Avoid bitwise operations in the SQL Share driver

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/7363
------------------------------------------------------------------------------
  Ticket             | 7363
  Updated By         | ibon.igartua at ehu.es
  Summary            | Avoid bitwise operations in the SQL Share driver
  Queue              | Horde Framework Packages
  Version            | FRAMEWORK_3
  Type               | Enhancement
  State              | Assigned
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             | Horde Developers
------------------------------------------------------------------------------


ibon.igartua at ehu.es (2010-01-25 07:11) wrote:

> ibon: that's really interesting. Have you observed similar things  
> with other tables, or is this specific to the share tables? Do you  
> have a sense of what about innodb is giving better performance here?

  Sorry for the delay replying. We only changed to InnoDB the _shares  
tables. I believe the performance improved a lit due to the way MySQL  
caches the table data always in main memory.

  At the moment we are still experiencing serious performance problems  
at peak ours. We use to have more than 1K active sessions  
simultaneously (active in the last 5 mins) with 25k rows in *_shares  
tables (kronolith, mnemo, nag and turba).

  We have a "big" server dedicated for the horde MySQL 5 server: 2  
quad core with 32 Gb RAM. We are at the moment setting up a second  
server and trying to configure them as multi-master. One for writing  
and both balanced for reading. We hope it'll improve the performance.

  By the way ... is this last patch published here reliable?