… data select sql_calc_found_rows…logs_at_trx_commit=2 log writes are done to OS cache, and being sequential writes these logs…hit ratio which measures buffer pool efficiency. 1000/1000 corresponds to 100% hit rate. It is hard to tell what buffer pool hit…, state: waiting for server activity Number of…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…1 compression ratio(compared … the EC2 console hit CTRL…servers.txt” and run the following commands: $ cat servers…log-error=/var/log/mysqld-innodb.log…cache skip-name-resolve sort-buffer-size=512K sql-mode=STRICT_TRANS_TABLES symbolic-links table-definition-cache=16384 table-open-cache=128 thread-cache…
Post: On Good Instrumentation
May 31, 2010 By 1 Comment
…to execute SQL query …lower layers logs is …server:port request was issued to which key was requested, and on response I’d like to know if it was hit…server memcache01 has very high miss ratio. Checking what is going on with memcache01 shows it just was restarted (and hence has almost empty cache…
