Cpt Best

The server has 12 GB of RAM, 10 GB is allocated to MySQL (InnoDB) and I usually have 400-700 MB free. I got the the point I don't know what else to do, so I'm not doing anything: I'm just trying to get this working since I get some occasional mysql lockups every few days, in which I can see dozens of sleeping mysql processes (up to max_connections), and I think it's somewhat related, as it doesn't happen when apc is disabled.

I'm using IPB 3.1.2, LiteSpeed and APC (both latest), user online count tops at 1200 on busy periods but is usually between 600-800. Although there are vast performance improvements with APC enabled (load avg 1-3 instead of 3-10), I'm worried about cache fragmentation and full cache counts. No matter what settings I use, fragmentation builds up and I also get a whole bunch of cache full counts, which is what I want to disappear. Using cache size = 300 MB, stat = 0, file and user ttl = 0, I get this after a couple hours: Using bfarber's settings (file ttl=300 and user ttl=180), fragmentation still builds up, although much slower (takes almost a day). Cache full counts, however, shows really high numbers (10000+), reverts to 0, them builds up again to high numbers, reverts to 0, and so on, all in interval of minutes. Almost every webpage there is about APC fragmentation/cache full count says I should limit what is being cached using the filters options. That's ok for files, but analyzing the stats it seems user cache is getting too full and is causing the fragmentation. How do I limit what's going into the user cache? Thanks