…done in a parallel way, thus utilizing multiple CPU cores if needed. In previous versions, compression … utilities, which also had a number of other limitations (e.g. could not be used with …users. The new features in Percona XtraBackup will be part of the topics at the upcoming Percona Live MySQL…
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: 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: 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 …
Post: InnoDB compression woes
May 20, 2011 By 14 Comments
…read-only workload in 16 parallel threads with limiting dataset to 3,000,000 rows per table…-requests=0 –rand-type=uniform –max-time=1800 –mysql-user=root –report-interval=10 run this will … workload is clear read-only CPU bound, let’s check CPU stats: regular tables: —–cpu—— us sy id …
Post: Multiple MySQL instances on Fusion-io ioDrive
October 7, 2011 By 6 Comments
It is known that MySQL due internal limitations is not able to utilize all CPU and IO resources available on modern hardware. Idea is to run multiple instances of MySQL… Transaction each 10 seconds. That is, for each set of user sessions, we take 270 throughput measurements. Based on this, we…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
… users use these boxes you also likely to have more bugs on all levels starting from Hardware and going down to MySQL… throughput. If single user CPU bound query takes 30 seconds you unlikely will be able to solve the problem by CPU upgrade. For… if there are problems. Over time application still will be limited by MySQL server so the alternative would be either spend $5000…
