…know where exactly memory is allocated. This was not much of the problem in MySQL…how much memory they use). Memory Tables MEMORY tables can take memory. There are implicit MEMORY tables which are allocated for query…to remove (or still use for processing…
Post: How to Identify Bad Queries in MySQL
January 10, 2011 By 16 Comments
…queries) that are slow and provide a bad user experience by the parameters to the –outliers option. If a query is slower than X more than N times…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 3 Comments
…how it could be possible to recover, on some specific cases, a single table from a full backup in order to save time and make the recovery process…the rows from it. To accomplish this task we’ll use constraint_parser command. In order to use it the tool needs to know the…
Post: The two even more fundamental performance metrics
May 5, 2011 By 6 Comments
…the completion time minus the arrival time (a duration). We can also compute the average concurrency, throughput, response time, and utilization during the observation period: see the previous post for how to…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…how to distribute the computation of aggregation queries over time. I realised that I could apply these same mathematical concepts to distributed queries…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…a lot. How to get CPU consumption per query ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql…how much does it cost to run a query. With Cloud Computing being hot a lot of Directors would like to know the…
Post: How Percona strives to remain neutral and independent
March 21, 2011 By Leave a Comment
…the product. The more we know, the more valuable we can be to you and to our clients who might purchase the solution. Being a…a vendor wants us to evaluate their solution for a prospective client, we generally bill them for all of the time…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…time from the “base tables” (those tables on which the view was built) there must be a process to bring them up-to…the view to use it The SQL_API call flexviews.enable() is used to actually build the contents of the view, making it available for querying: mysql…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… don’t know how to read these, there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first… time we’re spending, and shortcut effort if it’s not useful, e.g. skipping analysis for a query the client’s developers are in the process…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…to know how many times the ad was clicked each day? If so, you can roll all those events up into a…query parallelization, so ETL jobs written to rely on SQL tend to get really bogged down. In contrast, moving the processing outside the…
