…where memory could be allocated but it is a lot larger problems with MySQL 5.5 with addition of user variables, stored… how this memory allocation happens – does it grows slowly and …log ps aux | grep mysqld >> ps.log sleep 60 done Check for Table Cache Related Allocations There are cases when MySQL…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
… similar to using mysql binary logs for point-in-time…MySQL stored procedure API, called the SQL_API which is used to define the view. These stored… stored in the data dictionary: mysql> select * from flexviews.mview_table where… refreshable version does not take long to refresh: mysql> call flexviews….
Post: How InnoDB handles REDO logging
February 3, 2011 By 18 Comments
…logging whole pages (Value / Physical logging) where both the before and after image of a page is logged or by logging logical changes (Logical logging…log header stores information about the last checkpoint. The log is stored…
Post: MySQL Slow query log in the table
May 31, 2007 By Leave a Comment
…MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you had…does not store fractions of the second. Today I’ve got some time to play with table based slow query log…rather time and resource consuming. This is actually where being able to sort records by physical …
Post: Fighting MySQL Replication Lag
September 22, 2008 By 6 Comments
…fast updates which go after it in MySQL binary log can’t proceed. It is …1 WHERE body LIKE “%cheap rolex%”; This query will perform full table scan in MySQL 5….chopping for you. In general this trick does not only work well for full …SELECT query and the table to which store its result set and use in …
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…such as network IO or memory to store temporary table, but let us ignore them…take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 (… which are in 100us range are ones where no IO needed to happen so …well as as simple as how much does it cost to run a query. …
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… if you can analyze full query logs but if this is not …where you can analyze it without side load. Setting up 2 MySQL Servers side by side (for example with MySQL… Server versions and MySQL 5.6 you can also store innodb stats in …create a repeatable test case which does not use any sensitive data …
Post: Bug#12704861
November 20, 2011 By 1 Comment
… that is fixed in MySQL 5.1.60. I…log record for file extension in the current redo log format. What does…where crash recovery will itself crash. The last sentence (“there is no redo log record for file extension in the current redo log… allocated (nonfree=TRUE) before storing the BLOBs, or freed (…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…with what the lead consultant does. We want two sets of…where there’s a /var/lib/mysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql…/run/mysqld/mysqld.pid –log-error=/var/log/mysqld.log mysql 3172 3137 78 Nov19… that have a lot of stored procedures, which are more difficult…
Post: On Good Instrumentation
May 31, 2010 By 1 Comment
… be affected. In is important for response time summary stored in the logs which are easy to query so you can analyze… request you can quickly understand where does it come from ? Is it wasted CPU time Slow response from MySQL or Memcache. I also… calls stored together with attributed response time. For example I’d like to see number of mysql calls in addition to MySQL response…
