Conversation:

Notices

1. maiyannah (maiyannah)'s status on Monday, 14-Nov-2016 13:57:35 EST maiyannah

   Remote profile options...

   • Abjectio
   @knuthollund If you're using the queue demons, I found that disabling the mysql cache entirely was a big performance boost, if you have it enabled, FWIW
   • maiyannah (maiyannah)'s status on Monday, 14-Nov-2016 15:24:56 EST maiyannah

     Remote profile options...

     • Abjectio
     @knuthollund Here is a good guide I used: http://status.hackerposse.com/url/12655 From it: query_cache_size: the query cache is a well known bottleneck that can be seen even when concurrency is moderate. The best option is to disable it from day 1 by setting query_cache_size = 0 (now the default on MySQL 5.6) and to use other ways to speed up read queries: good ind…