… running MySQL in wild. I also wanted to share some troubleshooting techniques I use. Plot Memory Usage First I would like to see MySQL memory consumption plotted. I use “VSZ” columns from “ps” output on Linux. It helps me to understand how this memory… connections might have created and forgot to remove (or still use for processing). Of course you will see these tables going away if…
Post: How We Got Here
April 9, 2012 By 6 Comments
…MySQL conference that begins tomorrow. It seems appropriate to reflect on this process…how to operate it and develop against it. These are the people who are uniquely qualified to talk about how MySQL…
Post: Percona Live MySQL Conference & Expo Was A Great Event
April 17, 2012 By 2 Comments
…lot of people arrived with some uncertainty about how it would turn out, but the doubts …process of finalizing the plans for London and will announce that soon. Speaking of that, I want to…same as always: to help the MySQL ecosystem continue to thrive and prosper. I look forward to seeing you at …
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
…get any closer to reality. Benchmarks, like sysbench or tpcc-mysql, start N threads and try to push …distribution, with λ = M. That how it goes if to believe to the Poisson process. For example, if our target…% response times. What does it give to us? It allows to see: What is the response time we may…
Comment: High Rate insertion with MySQL and Innodb
March 29, 2012 By 16 Comments
…, it worked! 
I am using python and MySql 5.5, I have an XML file which I … child relationship and the engine type is InnoDB. The process is very slow, it first checks either parent record…_instances to 8, I don’t see any difference. I guess I am doing something wrong, could you please advise, how…
Post: How fast can MySQL Process Data
April 9, 2008 By 3 Comments
… data processing limitations of current systems. This raises valid question how fast can MySQL process (filter) data using it current architecture ? I decided to test… as you see as we add some math the row scan speed is significantly affected. I also decided to see how longer rows affect…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…see a pretty extensive list of suggestions for what to monitor in MySQL. Those are only suggestions; any given deployment might want to…to swap until it is unresponsive and has to be power cycled. In addition, other processes… restarted recently. It is surprising how often a server crashes, perhaps …
Post: How to Identify Bad Queries in MySQL
January 10, 2011 By 16 Comments
…process can be simplified to “can anything be improved for less than it costs not to…to-mean ratio, the Apdex score, and the explain sparkline to see whether the query is likely to be possible to…
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
…. The key is to use a logical approach and good tools. The process is straightforward: Determine …often really need to drill into a particular sample’s files and analyze it to see what’s …our MySQL video/screencast blog site. Another interesting topic is how to examine a system that appears to be …
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# cat… usage of MySQL process in 1/100 of the second. (This is pretty idle test system). So 347 and 5303 correspond to 3… ratio between Wait Time and CPU time is very helpful to see how “wait free your system is”. If it system is already…
