I am using Jamf to manage 25K Macs and 13K iOS devices. Every time I try to update iOS apps or configuration profiles for a large number of devices my database gets overwhelmed. I have MySQL 5.6 running on Windows server 2008R2 with 16 cores and 32GB Ram. I have tried adjusting things like query_cache or thread concurrency without any success. Any help would be greatly appreciated.
innodb_buffer_pool_size = 25G -------------- ROW OPERATIONS -------------- 72 queries inside InnoDB, 0 queries in queue 71 read views open inside InnoDB Main thread id 2572, state: flushing log Number of rows inserted 269699, updated 352837, deleted 170748, read 2807450339 9.11 inserts/s, 8.43 updates/s, 6.83 deletes/s, 64676.96 reads/s