… tested 10G and 100G data sets which was CPU bound and IO bound box on the Dell…1 hour so query taking over 1 hour has NA. Times are given in seconds. Ratio is MySQL 6.0 time divided by MySQL 5.1…give MySQL more time to complete the queries: Query MySQL 5.0.23 MySQL 6.0.4Ratio Query13784.453737.540.99…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…. How to get CPU consumption per query ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 (mysqld) S 1 19018 19018 0 -1… 3.08 1.96 469.31 0.99 # Bytes sent 8.77G 11 55.41M 5.15k 3.88k 258.55k 1.46k # Merge…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
…take a position when you are sure that the looping statements have been executed) and slave is restarted on mysql 1…1] http://dev.mysql.com/doc/refman/5.1/en/replication-implementation-details.html [2] http://dev.mysql.com/doc/refman/5.1…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… for new connections as in MySQL. This is very helpful for…query-digest can be pretty CPU and memory consuming, so ideally…% yes, 95% no # Filesort on 0% yes, 99% no # Full scan 4% yes, 95%…# 8 0x4C16888631FD8EDB 0.1160 1.4% 5 0.0232 1.00 0.00 …is taking up the longest sum of run time, query ranked #1….
Post: How number of columns affects performance ?
September 28, 2009 By 10 Comments
… type possible (CHAR(0) could be taking less space), table with 1 tinyint column and char(99) column and table with 100 tinyint…+0) from t99v1; +———–+ | max(t1+0) | +———–+ | 0 | +———–+ 1 row in set (3.26 sec) mysql [localhost] {msandbox} (test) > explain select max(t1… memory full table scan. P.S Tests were done on MySQL 5.4.2 on Intel(R) Xeon(R) CPU E5405 @ 2.00GHz CPU.
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…mysql_system#” \G *************************** 1. row *************************** USER: #mysql_system# TOTAL_CONNECTIONS: 1 CONCURRENT_CONNECTIONS: 0 CONNECTED_TIME: 446 BUSY_TIME: 74 CPU…take the difference in these counters every 5…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
…99% cases”. Note We’re specific to the user interaction – people are used to Search taking… now HTML takes 0.5 seconds to …search’ and wtime>1; +———-+—————–+——————+——————+——————+——————+ | count(*) | avg(wtime) | cpu_ratio | mysql…
Post: Scaling: Consider both Size and Load
July 13, 2010 By 5 Comments
…able to handle 1.000.000 of accounts …MySQL (and systems in general) do not scale perfectly with numbers of CPUs and number of concurrent requests. Reduced efficiency of CPU…5 “shards” on it. 5 shards surely come with 5x more data which you need to carefully take… may look at 99% response time, some …
Post: Air traffic queries in LucidDB
October 26, 2009 By 20 Comments
…DESC; LucidDB: 2.338 seconds InfoBright: 0.99 sec MonetDB: 0.27 sec – Q5: … 28.82s, 3.68s, 1.10s 3y, 35.37s, 5.44s, 1.69s 4y, 41.66s, 7… external data (there is even access to MySQL via JDBC driver) just in SQL queries… single query execution takes 100% of user time in single CPU, which may signal …
