You'll also probably want to give the following a read over as they contain some good information. You'll also want to keep an eye on things like your buffer sizes, table cache, query cache and innodb_buffer_pool_size (if you're using innodb tables) as all of these memory allocations can have an affect on query performance which can cause MySQL to eat up CPU. This will show you any queries that are currently running or in the queue to run, what the query is and what it's doing (this command will truncate the query if it's too long, you can use SHOW FULL PROCESSLIST to see the full query text). Some other things you can check would be to run the following query while the CPU load is high: SHOW PROCESSLIST Thirdly I'd say you want to turn on the MySQL Slow Query Log to keep an eye on any queries that are taking a long time, and use that to make sure you don't have any queries locking up key tables for too long. This is also a major security thing to check. Secondly I'd say you want to double check your MySQL users, just to make sure it's not possible for anyone to be connecting from a remote server. I've searched high and low for a solution and I always come up empty handed.First I'd say you probably want to turn off persistent connections as they almost always do more harm than good. Infuriating to say the least, and I think a lot of people have this issue. It will run fine for a few minutes (regardless of what I'm doing in the program) and once again continue spiking until I close the program again. I have to close Ableton and reopen, as once it starts, it wont stop. Even if I stop it, wait for all delay and reverb tails to cancel, and run just one audio clip with no effects, it will instantly spike (even if I don't trigger any clips at all!). The thing is, after it has spiked once, it will ALWAYS spike and cause slowdowns. If I hit the stop button CPU usage goes down after a few seconds. I can stop all clips while the session is still playing, and the spike will not go down like I feel it should (it should go down if clips stop and effects are off, right?). I can run through the same parts and not go above 35% usage, but sooner or later it will always spike into 120%+ and cause stuttering. They don't always seem dependent on what's happening in live. I also encounter a lot of CPU spikes, pretty much always 5 minutes into using Ableton.
0 kommentar(er)
