… in the case above there were a lot of free CPU and IO capacity. Take a look at another sample: | Threads… | | Threads_running | 24 | | Threads_running | 29 | In this case the load is higher and a lot more uniform – there are cases… helpful to see if client is loading the server well – if it does the number of threads_running will be appropriately high.
Post: Internals of InnoDB mutexes
September 7, 2006 By 4 Comments
… we can’t run spin very long as it eats CPU resources and after some loops it is reasonable to give CPU resource to concurrent threads. 2. Wait on condition variable using … dramatically – so you can test it if you have multi-CPU boxes and high-concurrency load on InnoDB.
Post: Living with backups
November 6, 2008 By 28 Comments
… copying physical files, so the price may actually be rather high. And the more effectively the server resources are utilized, the… danger may for example come from an unexpected spike in load or traffic, or even from quite expected spikes that you… be more sphisticated or include things like processlist information, CPU load avergages, I/O load, etc. In this case tar is actually launched…
Comment: Bug fix of InnoDB scalability problem
February 12, 2007 By 13 Comments
…NIN-15] CLONE -Slow front page load times and high CPU usage… Potential temporary solution in moving to MySQL 5.0…. has several performance enhancing benefits for innodb with dual core cpu‘s. My hope is that the improved performance with this…
Comment: Estimating Replication Capacity
January 16, 2012 By 4 Comments
I’m trying to estimate the slave load using the UserStats method. But it doesn’t reflect the … 5 minutes while the slave is working. I see really high CPU utilization in htop for mysql, so it’s really working…
Post: Effect of adaptive_flushing
December 4, 2009 By 5 Comments
… bad for performance because during those short periods of very high page write activity, the system and/or innodb can become… impact query response time, and so on. And what about CPU, load average, and so on? Actually, those did not change enough…
Comment: When to use Hardware upgrade instead of Software Optimization
December 7, 2008 By 5 Comments
…. We’d have 4 or 5 boxes, for example, with CPU loading under 20% and healthy looking memory, but we couldn’t… out it was cheaper for us to invest in some high end storage (a Netapp SAN) and replace 4 CABs with…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… power management: processor : 7 vendor_id : GenuineIntel cpu family : 6 model : 15 model name : Intel(… both the queries which cause the greatest load on the server (in aggregate) and which… monitoring, alerting, backups, caching, reverse proxies, and high availability solutions, all of which we can…
Post: Using LoadAvg for Performance Optimization
December 4, 2006 By 5 Comments
… does not really tell you if it is CPU bound load or IO bound load. For example if you have LoadAvg of 10… 2 disks Load of 4 can be light if it is CPU bound – because the system can execute much more CPU bound tasks in parallel or High if it is Disk Bound LoadAvg. Low Load…
Post: Predicting Performance improvements from memory increase
August 7, 2008 By 6 Comments
… improve performance order of magnitude by converting very IO bound load to CPU bound, it is well possible to see limited gains… start by looking at the type of load we’re dealing with. If it is CPU bound and there is little IO… IO bound (high IO system utilization, low CPU usage) one should think about how much CPU capacity is available. If your CPU is 25…
