…the most performance from your MySQL server via our Percona MySQL Consulting, Percona MySQL Support, and Percona MySQL Remote DBA services. With our MySQL Server … view of your MySQL server needs. Chances are custom MySQL server development should be one pillar of your strategy, and Percona MySQL …
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
… Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on standard EC2 servers with EBS… inserted per minute (click on the image for a bigger view): We can deduce a few things from this. The overall… workload is not very revealing. To understand the sustained write performance of an RDS instance, we need a multi-threaded long…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 55 Comments
… output of iostat.) I would characterize this as very good performance. Sub-millisecond latencies to disk, pretty much consistently, for reads… all aggregated together in each line. I can switch the view of the same data to look at it disk-by… a quarter of a second sometimes. This is causing acute performance problems for the database, manifested as epic stalls and server…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 38 Comments
… may carry new features or slight performance improvements, however these days it is rarely important to MySQL users. If it is to… MYSQL, upgrade MySQL, 10x start/stop MySQL, upgrade MySQL, downgrade MySQL, upgrade MySQL, install a security fix for something, 20x start/stop MySQL, upgrade MySQL, … . Restarting and changing MySQL…
Post: Logging MySQL queries from the client instead of the server
February 2, 2011 By 2 Comments
… your MySQL server. Queries are logged with timing information, and in the case of Percona Server, a great deal of additional performance…. Sometimes it’s valuable to be able to see both views of query execution time. Why would you want to see… mk-query-digest’s built-in ability to decode the MySQL wire protocol, it is certainly the easiest and best solution…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
….168.70.2 -j REJECT and perform an insert, this first insert will take longer: percona1 mysql> insert into percona values (0…-f7c4916d8330, } joined { 7e6d285b-d56d-11e1-0800-2491595e99bb, } left { } partitioned { }) to view: view(view_id(TRANS,7e6d285b-d56d-11e1-0800-2491595e99bb,2) memb { 86928728…
Post: Using Flexviews - part one, introduction to materialized views
March 23, 2011 By 3 Comments
… conceptually so too is the output of a SQL statement. MySQL even includes a SQL statement that makes this perfectly clear…. Views are not generally considered to be a performance optimization because: The contents of the result set are computed each time the view…, unless you stop all database write activity. Materialized views can be used to enhance performance by acting as a cache. Further, the…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…rows are the worst case for performance. Optimal mathematical performance requires operations on reduced sets. Keep… working directly with relational algebra. Materialized views techniques applied to distributed computation I… speaks SQL, but right now only MySQL storage nodes are supported. Amdahl’s …
Comment: MySQL Partitioning - can save you or kill you
May 31, 2012 By 45 Comments
…-and-mysql However, after reading Peter’s article on the performance issue of mysql view (http://www.mysqlperformanceblog.com/2007/08/12/mysql-view-as-performance-troublemaker), I ran a little test to compare query performance…
Post: Computing 95 percentile in MySQL
November 28, 2008 By 5 Comments
… one second, this means only 1 percent of queries/page views are allowed to take more than that. For larger systems… to get the data if MySQL only provides you the avg: mysql> select count(*),avg(wtime) from performance_log_081128 where page_type… concerned about simply by running following order-by queries: mysql> select wtime from performance_log_081128 where page_type=’search’ order by…
