… the database is cold, but uses less CPU time when the database is hot. I … be good for raw performance, but there are limitations which MyISAM imposes that are difficult to work …datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…on Dell PowerEdge R720 box and varied cpu combinations with taskset. The following chart… some data updates into the mix, limitations of read-only transactions become obvious….0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… place a limit on amount of queries system can ran, for example if we have query which requires 1 CPU second and… to get CPU consumption per query ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc… 0 The #14 and #15 here is kernel and user CPU usage of MySQL process in 1/100 of the second. (This is…
Post: MySQL Wish for 2013 - Better Memory Accounting
December 31, 2012 By 6 Comments
… performance bottlenecks as well as where CPU resources are spent. (Performance Schema does not accounts CPU usage directly but it is something…, MySQL as a Service vendors will especially appreciate as currently they are on complete mercy of their users not being able to limit memory usage by individual MySQL users or even track how much these users are using. Now as MySQL 5…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… management: processor : 7 vendor_id : GenuineIntel cpu family : 6 model : 15 model name : …mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql… query log output. The stock MySQL server’s limitation of one-second granularity makes…
Post: Google's user_statistics V2 port and changes
September 12, 2008 By 9 Comments
… to fresh releases of MySQL. Features includes: New statistics per user (Cpu_time, Bytes_received, Bytes_… in set (0.00 sec) mysql> select * from information_schema.table_STATISTICS limit 10; +————–+—————–+———–+————–+————————+ | TABLE_SCHEMA | TABLE…
Post: The Optimization That (Often) Isn't: Index Merge Intersection
December 14, 2012 By 6 Comments
…(user_type) WHERE user_type=2 AND user_id > 2938575 AND parent_id=0 AND status=1 ORDER BY user_id LIMIT 1; mysql> EXPLAIN SELECT user_id FROM users USE INDEX(user_type) WHERE user_type=2 AND user_id > 2938575 AND… rows examined” graph had dropped several orders of magnitude and CPU utilization on the machine had dropped by about 2/3…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
… users having huge spike in MySQL usage Personally I would see a few more things implemented. A few examples to mention: per-user CPU… a few MySQL performance counters broken down by users (full joins, table scans, disk temp tables, etc.) limiting command availability to SUPER users only or restricting regular users to see…
Post: How Innodb Contention may manifest itself
July 28, 2011 By 1 Comment
… Server and MySQL 5.5, there are still workloads in which case mutex (or rw-lock) contention is a performance limiting factor… happens user CPU will be very high, and the context switches will be somewhere reasonable. In others you would see the CPU usage… Percona Server or newer MySQL version or doing application/architecture changes. Reducing number of competing threads (such as limiting number of Apache…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… processing accumulated backlog. The Theme of this Users Conference was surely Storage Engines both looking… 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 …
