… report it takes 15 seconds to finish of the process. but normally in PARADOX(the same kind of data) it takes only 3 seconds. can… instead of 1G the result is same. only difference i could find is when i make query_cache = 0 then the process is increased to 20 seconds instead of 15…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… people assume their application is difficult or somehow different, and that we need all kinds of schema diagrams and code listings, but the… often use tools to gather a lot of the data for us and speed the process, when possible, but the core commands I… ‘du’ on the data files, or simply skip this step. This information can help me determine what kinds of things I ought to…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…of internal Innodb performance counters, statistics, information about transaction processing and all kinds of other things. In MySQL 5 number of… the last 44 seconds Make sure data is sampled for at least 20-30… level so these are different. We can also see different types of IO submited by Innodb …
Post: Intro to OLAP
July 12, 2010 By 10 Comments
…post) Identifying the differences between a data warehouse, and a data mart. Introduction to MDX queries and the kind of SQL …processing. OLAP analysis, which is really just another name for multidimensional analysis, consists of displaying summary aggregations of the data broken down into different…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… fit”. Depending on data access distribution gains will be different ranging from …Of course this depends on all kinds of things, but the only rule of…of different operations for different levels of concurrency, specifically around mutexes and contention? How does this fit into the development process…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…of backups for you, what follows are some of the internals of our implementation. What kind of…data is not encrypted before transfer Monitoring Monitoring is the most important piece to tie all of these process…
Post: The two even more fundamental performance metrics
May 5, 2011 By 6 Comments
… the distribution of service times? You need this for all kinds of queueing … to process and send back the response, with a “long tail” of…different from each other due to the random differences in completion times, caused by differences… very simple set of data, we can learn a lot of complex and …
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
…kind of peak speed possible at all. Furthermore this type of caching is rather helpful for some of applications, which tend to access same data…of the process is rather simple – to get result from the cache and ship it back, so large overhead of…
Post: Looking at Redis
August 27, 2009 By 27 Comments
…of strings with support of various set operations. I kind of miss support for something like associative array/hash/map in the data…allow for using server by different applications, different versions, testing or …data since the start of the process. Slave can get the data (which is basically set of…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…CPU usage of MySQL process in 1/100 of the second…different memory amount having same workload. You will often see increasing amount of…get great amount of related data from mk-query-digest…kind of hardware will take you to reach appropriate performance, what kind of hardware provides better balance of…
