…,&new_index->lock. I profiled 5.6.11 in this IO bound scenario with the perf – see profile below: # Overhead Samples Command… second for MySQL 5.6.11. Conclusion: In CPU-bounds case MySQL performs quite well, though we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL still has performance issues…
Post: High-load problems? Investigate them with 'pt-query-digest'
April 23, 2013 By 2 Comments
…their database server, leading to degraded application performance, and sometimes even short moments of downtime…-query-digest –type rawlog –report-format profile, to get just the ranking of queries…regularly work with MySQL databases, getting familiar with Percona Toolkit for MySQL will let you do…
Post: Webinar: SQL Query Patterns, Optimized
May 20, 2013 By Leave a Comment
… MySQL 5.6 built-in methods to analyze them for optimal query efficiency. The discussion will cover optimizer reports, query profiling, and session status to measure performance. The query patterns will include: Exclusion Join…
Post: How to convert MySQL's SHOW PROFILES into a real profile
February 20, 2012 By 12 Comments
… profile the “nicer_but_slower_film_list” included with the Sakila sample database to demonstrate: mysql> SET profiling=1; mysql> pager cat > /dev/null mysql… that wasn’t captured in the profile. The above query is something I developed for High Performance MySQL Third Edition, by the way…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…=/var/db/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock consult…. The changes Percona’s performance audits typically suggest can be really significant, and can completely change the performance profile and workload of a…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
Recently I have had a chance to check out MySQL Performance on “Memory Appliance” by Violin Memory which can be used … which did not seems to give any significant performance benefit, may be even reducing performance few percents. I also tried running with… out other storage engines and other workloads or get some profiling results.
Post: MySQL Performance Engineer opening
May 13, 2008 By Leave a Comment
…we love to analyze performance of various MySQL features, benchmark, compare, analyze things and post our findings on MySQL Performance Blog. However recently we…one could profile applications – valgrind, oprofile, dtrace and similar tools One should know C/C++ to be able to understand performance …
Post: Read Buffers, mmap, malloc and MySQL Performance
September 12, 2007 By 8 Comments
… see from this post is – o_profile (often together with strace) are great tools for MySQL Performance analyses. Too many people end tuning… you could just grab one having allocation very quick. Also MySQL should get smarter in terms of which buffer size should…
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
… dumped by setuid processes (and MySQL Server is most commonly ran changing user from “root” to “mysql“). Before you embark on enabling…/sbin/mysqld[0x516a61] The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you… if you expect to do any MySQL profiling or dealing with crashes. It does not slow MySQL performance yet it is very helpful for…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual…Performance_schema_mutex_classes_lostblogpercona.commanual Performance_schema_mutex_instances_lostblogpercona.commanual Performance_schema_rwlock_classes_lostblogpercona.commanual Performance_schema_rwlock_instances_lostblogpercona.commanual Performance….commanual profiling_history_…
