…, when compared to MySQL 5.6. Now let’s take a look at the status counters. MySQL Status Counters These status counters were captured when performing the benchmark on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL…
Post: Introducing the pmp-check-mysql-status Nagios Plugin
March 29, 2012 By Leave a Comment
… use for fairly arbitrary checks of status counters and variables. This is the pmp-check-mysql-status plugin, which can perform computations…: Compare a counter to a threshold Compare a counter to a variable or another counter Add, subtract, multiply, and divide counters or variables Transform…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… the graph above the labels mean as follows: MySQL 5.6 (2) is for MySQL 5.6 w/ buffer size 6M MariaDB… 5.5 is quite slow as compared to both MySQL 5.5 and MySQL 5.6. For MariaDB 5.5 the query… let’s take a look at the status counters. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer_size=6M…
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… buf_pool->stat are unprotected. These are buffer pool statistics counters: number of read, written, evicted, etc. pages. The more interesting… show the same issues, show similar issues (other InnoDB stat counters), show non-issues or my analysis errors (like the log…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
… is appealing to improve performance for MySQL Applications ? Make it Lockless Can we re-implement MySQL Query Cache so it is lockless… them to propagate sometime. For example if I’m maintaining counter I may not want changing that to have complete invalidation… make it cool again. The question is whenever anyone from “MySQL Market Players” – Oracle, MariaDB, Drizzle, Percona Server, will allocate resources…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
I am constantly referring to the amazing MySQL manual, especially the option and variable reference table. But just …
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 27 Comments
… terms of counters you can get from SHOW GLOBAL STATUS. I’ll start out by copying and pasting from the MySQL manual… anything meaningful based on a ratio of counters, because the process of dividing one counter by the other to get the ratio… all types of ratio-based and counter-based tuning techniques. Summary Major points in this article: Counter ratios are meaningless as a…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
… in this case ? First separate them into special counter table, having say “id” and “counter” columns. Using separate table for updates already…-time counters very efficiently pushing few updates back to MySQL server. If you rather use existing solutions you can use memcache + another mysql…
Post: The four fundamental performance metrics
April 27, 2011 By 15 Comments
… and aggregate metrics of activity on a system such as MySQL. In the best case, we want to know everything about… time. Now, if we add another counter, we can get the “weighted busy time.” This counter is similar to the busy time… just addition, subtraction, multiplication, and division of some constantly increasing counters! There’s more. We derived our four long-term average…
