…major rewrite of High Performance MySQL book – the most famous book about MySQL Performance on the market… which…s announcement so we would appreciate hearing your comments on it and what is the most … will be looking for reviewers. Let us know if you’re interested in reviewing one or more chapters…
Post: Working on "High Performance MySQL, Second Edition", how you can help?
August 31, 2007 By 20 Comments
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
…Note: Review was done as part of our consulting practice, but is … at a given incoming data rate, enabling much higher query performance. Beside iiBench we run benchmarks of SELECT queries again one… show the same performance gain, as to update we need to read data, and in this case – read previous comment. – The version…
Post: How Percona strives to remain neutral and independent
March 21, 2011 By Leave a Comment
… in part, but not perform the full and balanced disclosure that Percona would perform, then that is acceptable … see the results of our review. If the prospect knows that we are reviewing the proposal and you … If you have any questions or comments, I invite you to use the comment form, or if it’s …
Post: SQL Injection Questions Followup
July 26, 2012 By 2 Comments
…: http://pragprog.com/book/bksqla/sql-antipatterns Jonathan C. also commented: Q: My preferred variable parameter format: bug_id IN (?” . str… should be included in the review process, but it’s not her responsibility alone. Brian P. commented: Q: If you’re writing… makes coding and testing for security very challenging. Whereas with performance, your site is working well if you’ve optimized the…
Post: Percona Toolkit Webinar followup Q&A
December 19, 2012 By 1 Comment
… Today, I appreciate your time and nice comments. As promised, here are answers to questions …-digest –review S=/tmp/mysql_sandbox5527.sock,u=msandbox,p=msandbox,D=percona,t=reviews –report-…plugins as all nagios plugin doesn’t output performance data? The Percona Monitoring Plugins include cacti …
Post: Visualization tools for pt-query-digest tables
August 31, 2012 By 6 Comments
… samples of each query into query_review table and historical values for review trend analysis into query_review_history table. But it could… to figure out what to optimize and how to track performance over time. Anemometer relies on the Percona Toolkit to do… and displaying samples; * displaying table status and CREATE statements; * reviewing and commenting on queries. Despite its lack of ability to save predefined…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… Maatkit to merge the changes after all, also you can review binary logs to see which updates were applied to different… got to pick either long recovery time or further degraded performance. In the large databases I run in production relaying on… usually would prefer to lose one user comment a year instead of paying extra performance costs. It is worth to note DRBD…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…can have slow query log enabled and review it occasionally, but doing it offline … | hosting2.wp_terms | 335 | 2 | 4 | | hosting2.wp_comments | 12 | 1 | 3 | | hosting2.wp_options | 6586 | 200 | … under Other_commands a few MySQL performance counters broken down by users (full joins,…
Post: Percona XtraDB Cluster Feature 1: High Availability
January 17, 2012 By 20 Comments
… is High Availability. But before jumping to HA, let’s review general architecture of the Percona XtraDB Cluster. 1. The Cluster… any point of time you can shutdown any Node to perform maintenance or make configuration changes. Or Node may crash or… has to perform SST. You can monitor current state of Node by using SHOW STATUS LIKE ‘wsrep_local_state_comment‘, when it…
Post: PROCEDURE ANALYSE
March 23, 2009 By 9 Comments
… task during schema review is to find the optimal data type for the…queries while really MySQL has a native feature to perform this task – PROCEDURE ANALYSE Here is sample run … | NO | MUL | 0 | | | changed | int(11) | NO | MUL | 0 | | | comment | int(11) | NO | | 0 | | | promote | int(11) | NO | MUL …
