… MySQL 5.1.32. Its a pretty high traffic site, but I’ve never seen the DB server go above 20% CPU usage… it freezes up it’s top state shows “ucond” and cpu usage is 0% or very low so somehow its still doing… = 16M thread_stack = 128K thread_cache_size = 64 query_cache_limit = 0 #query_cache_size = 64M query_cache_size = 0 query…
Page: Tools
May 30, 2008 By 31 Comments
… is a great tool to see details on CPU usage – how are different CPUs are being used, how…advanced MySQL tuning when the load is CPU bound – it will tell you where exactly inside MySQL or Kernel CPU… catch of it being unavailable on Linux which limits it practical use dramatically. fincore fincore is …
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… uncompression happening in parallel, improving buffer pool usage (currently you may need to both store… cores becomes increasingly important as their number per CPU just keeps doubling. It is also rather… “Gotches” while many of them come from MySQL limits at the time when Innodb was first …
Post: Opening Tables scalability
November 21, 2006 By 27 Comments
… test case for general MySQL problem. During warmup process I noticed I get very low CPU usage and disk Usage and IOWait about 25… physical IO or network operation if you care about scalability. MySQL has same problem with key buffer but that was fixed… a number to worry about) and also worry about possible limited performance while table cache is being warmed up in addition…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… – MySQL does not handle complex queries well, being able to use only one CPU … documented (sometimes) limitations. I’m saying about Prepared Statements in MySQL 4.1 which …MySQL I have created more than hundred of such little projects suggested by MySQL customers and myself based on long MySQL usage…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…for example we’re limited by space and how much data we can comfortably put in MySQL Instance without … mistakes you can make. One application can become CPU bound even with 5% of total data set …not want your runaway logs or extreme temporary space usage to stop the database, but they usually can …
Comment: Choosing innodb_buffer_pool_size
November 25, 2010 By 39 Comments
… Mysql server is heavily loaded, now 300 qps average. It uses %50 Cpu in average and just 700MB …? And is there any good practice to lower cpu usage through buffering or caching? innodb_buffer_pool_size … query_cache_used = 19 M Current query_cache_limit = 1 M Current Query cache Memory fill ratio = …
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
… parallel way, thus utilizing multiple CPU cores if needed. In previous … also had a number of other limitations (e.g. could not be … at the upcoming Percona Live MySQL Conference and Expo (register now!). Specifically… around it: Percona XtraBackup: install, usage, tricks tutorial, Tuesday 10th April …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… can be used to ballance between wasting CPU time running spin locks and doing unneeded …MySQL thread id 8079, query id 728899 localhost root Sending data select sql_calc_found_rows * from b limit… This section shows Buffer pool activity and memory usage. You can see total memory allocated by Innodb…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…just prefix compression. The downside in gzip is increased usage of CPU time. PZ: We will see how it …delete, if the page data size drops below this limit, merging it to a neighbor is tried */ #define …load is CPU bound and you’re scaling out you can get better performance by using couple of MySQL …
