…t know how to read these, there’s a full explanation in our book, High Performance MySQL 2nd Edition …it’s basically mandatory to use a server that has the Percona patches for microsecond logging and …have a lot of stored procedures, which are more difficult to analyze because you have to pull out …
Post: How Percona Develops Open-Source Software
January 9, 2009 By 4 Comments
… it possible to learn a great deal about what your server is doing and how to optimize it. Customer demands. Customers come to us… so. How You Can Get Your Wishes To Come True If you have a particular need for some modification to the MySQL server, XtraDB… there were a built-in type in MySQL that could store date and time with microsecond precision? Lots of people have asked for…
Post: Introducing tcprstat, a TCP response time tool
August 31, 2010 By 12 Comments
…MySQL, this is the moral equivalent of a query’s response time. The statistics we chose to output by default are the count, median, average, min, max, and standard deviation of the response times, in microseconds…to tune this exchange, so if you have suggestions on how to…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…How much space InnoDB allocates for each blob outside of the page? HT: For each column that InnoDB needs to store… memory the kernel can decide (incorrectly) to swap out MySQL. There are two solutions here. Memlock… microseconds. And if you do not have, then the only way to get good performance is to …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…from SHOW INNODB STATUS output and how to use this info to improve MySQL Performance. To start with basics SHOW …_sleep_delay variable. Value is specified in microseconds. mysql tables in use 1, locked 0 is … not be equal to total size of buffer pool, because buffer pool also stores lock information, …
