… in a parallel way, thus utilizing multiple CPU cores if needed. In previous versions, compression … the topics at the upcoming Percona Live MySQL Conference and Expo (register now!). Specifically, there …:20 @ Ballroom D Extending Xtrabackup – A Point-In-Time System, Wednesday 11th April 16:30 – 17:…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… The #14 and #15 here is kernel and user CPU usage of MySQL process in 1/100 of the second. (This is… *************************** USER:user TOTAL_CONNECTIONS: 1 CONCURRENT_CONNECTIONS: 0 CONNECTED_TIME: 800 BUSY_TIME: 775 CPU_TIME: 49 BYTES_RECEIVED: 21847267 BYTES_SENT: 336986112 BINLOG… query. We can also get “BUSY TIME” here, subtracting CPU time from it we get “Wait Time” which is in this case 775-49…
Post: Three ways that the poor man's profiler can hurt MySQL
December 2, 2011 By 19 Comments
… profiler has become a key tool in helping us analyze MySQL when customers are having trouble. We have our own implementation… slow-running server that was using tons of CPU time and lots of system CPU, and exhibiting the classic signs of InnoDB kernel… they can be. Of course, I’m really waiting for MySQL 5.6 and the improved Performance Schema that will be…
Post: How Innodb Contention may manifest itself
July 28, 2011 By 1 Comment
…. First situation often corresponds to Innodb spending a lot of CPU time running “loops” as part of spinlock implementation. In many cases… the more CPU cores you have available the less CPU utilization you can have. Sometimes though you may be wasting time with context… to buy a little bit more time while you’re upgrading to Percona Server or newer MySQL version or doing application/architecture…
Post: Apache PHP MySQL and Runaway Scripts
May 20, 2008 By 20 Comments
…() calls – so it takes a lot of time but does not really use any CPU time: Script which is same as previous one… script terminated after certain amount of seconds: Unlike set_time_limit() which specifies cpu time, pcntl_alarm() specifies number of wall clock seconds… 2 simple scripts which run for 1000 seconds (spending this time on MySQL time) one is doing single query another 1000 queries 1…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… simple. We tested 10G and 100G data sets which was CPU bound and IO bound box on the Dell 2950 box…. Times are given in seconds. Ratio is MySQL 6.0 time divided by MySQL 5.1 time so if it is less than 1 MySQL 6… set cut-off time to 3 hours to give MySQL more time to complete the queries: Query MySQL 5.0.23 MySQL 6.0.4Ratio…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…: mysql> SHOW USER_STATISTICS LIKE ‘hosting2′\G *************************** 1. row *************************** User: hosting2 Total_connections: 84 Concurrent_connections: 0 Connected_time: 20 Busy_time: 1… spike in MySQL usage Personally I would see a few more things implemented. A few examples to mention: per-user CPU time usage, some queries may be CPU bound rather than reading lots of rows support…
Post: Where does HandlerSocket really save you time?
March 16, 2011 By Leave a Comment
…_guess_on_hash 1807311.8690JOIN::optimize() 1771201.8317row_search_for_mysql 1711851.7703lex_one_token(void*,void*) 1626831.6824alloc_root 1318231… 11968414.7394btr_search_guess_on_hash 582027.1678row_search_for_mysql 469465.7815mutex_delay 386174.7558my_pthread_fastmutex_lock 377074.6437buf…_sel_store_mysql_rec 193472.3826btr_cur_search_to_nth_level 167012.0568row_sel_convert_mysql_key_to_innobase – Most CPU time is spent…
Post: Should MySQL and Web Server share the same box ?
October 16, 2006 By 9 Comments
… you may decide ether to grow system in MySQL+Apache pairs or split MySQL And Web Server and place them on different boxes. Generally using separate boxes for MySQL and Web Servers is rather good practice. It is more… on database server is often better use of their free CPU time. Second thing you may feel bad about it is Web…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…. Now, Valgrind does not need much introduction, especially to the MySQL server developers. The Valgrind Memcheck tool, which is synonymous with… a selected MTR testcase under Helgrind. (For the time being, running the whole MySQL testsuite is not very practical due to 100x… that if other CPU cores will read this same variable, they will get an old value for quite some time after the…
