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

* Your Email Address
* Spam protection	Enter the letters below: . .. ..___..__..__. \ /\ / _/ [__][__] \/ \/ ./__.\| \|\| \|
Comment	>> 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?
Attachment
Watch this ticket