… can be done in a parallel way, thus utilizing multiple CPU cores if needed. In previous versions, compression was only possible…:30 – 16:20 @ Ballroom D Extending Xtrabackup – A Point-In-Time System, Wednesday 11th April 16:30 – 17:20 @ Ballroom F Backing…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… *************************** USER:user TOTAL_CONNECTIONS: 1 CONCURRENT_CONNECTIONS: 0 CONNECTED_TIME: 800 BUSY_TIME: 775 CPU_TIME: 49 BYTES_RECEIVED: 21847267 BYTES_SENT: 336986112 BINLOG… ratio between Wait Time and CPU time is very helpful to see how “wait free your system is”. If it system is already have low…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
… by server backend. CPU Time This is the CPU time needed to generate request (you can split it to user and system if you want) and when there come various wait times… thread the following simple formula applies wall_time=cpu_time+sum(wait_time)+lost_time The lost time is the time which was lost for some reason…
Post: How Innodb Contention may manifest itself
July 28, 2011 By 1 Comment
… see the CPU usage being low with a lot of CPU being idle, increased compared to normal workload portion of system CPU and high…. First situation often corresponds to Innodb spending a lot of CPU time running “loops” as part of spinlock implementation. In many cases… how much context switches you can get from the system, as unlike CPU usage it is not obvious what to consider a…
Post: What time 18446744073709550.000 means
May 17, 2009 By 25 Comments
… only 2-core AMD Opteron systems appeared and I noticed sysbench getting crazy showing query execution time 18446744073709550.000 or like this… started on one CPU and during execution it was switched to another CPU (where generator delayed to first CPU) and time between two measurements… exact time between two points in application. So designing profiling in your application be aware of. I wonder how realtime sensor systems…
Post: On Good Instrumentation
May 31, 2010 By 1 Comment
… not very helpful. If you look at the system from bird eye view – system needs to process transactions and you want it… understand how much time was spent waiting on the database, memcache, other external services, as well as how much CPU time it consumed… bad response time for certain kind of request you can quickly understand where does it come from ? Is it wasted CPU time Slow…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…_sync_spin_loops can be used to ballance between wasting CPU time running spin locks and doing unneeded context switches. The next… also stores lock information, adaptive hash indexes and some other system structures. Pending reads and writes are pending requests on buffer… of Innodb main thread which controls scheduling of number of system operations – flushing dirty pages, checkpointing, purging, flusing logs, doing insert…
Post: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
… MyISAM scalability question. This time working on the customer system we figured out that box with 1 CPU Core is able to handle… mysqld find_key_block As you see 40% of effective CPU time is spent in pthread_mutex_lock / pthread_mutex_unlock. We… from 4 threads – which is quite unexpected for CPU bound load on system with 4 Cores. Here is comparison of MyISAM Innodb…
Page: Tools
May 30, 2008 By 31 Comments
… tuning when the load is CPU bound – it will tell you where exactly inside MySQL or Kernel CPU time is spent. iohist iohist is a little tool to show histogram for IO response time. The main use… example. sysbench sysbench is a tool to check performance of system and MySQL. Helpful to check different hardware and OS characteristic…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… in seconds. Ratio is MySQL 6.0 time divided by MySQL 5.1 time so if it is less than 1 MySQL… course this is much more powerful system but still you can get an idea – This system has geomean of 7.7 sec… 2 CPUs and being able to use only half of system CPU resources for query processing was not too bad, however with…
