… are running, but it also shows me load average, …/run/mysqld/mysqld.pid –log-error=/var/log/mysqld.log mysql…to be possible to improve a lot, and a simple mental calculation can then tell me how…times, etc), the EXPLAIN plan, and the desired modifications to the query or the table. We explain how to…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…how to use this info to improve MySQL Performance. To…time. In the very start of printout Innodb will print: ===================================== 060717 3:07:56 INNODB MONITOR OUTPUT ===================================== Per second averages calculated…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…to 300MB each. In total raw data is about 55GB. Average…log…time to find how to execute command from command line using included sqlline utility, and I did not understand how to…to be fair, let’s calculate…to 100GB, which is significant economy of space. I am open to run any other queries if you want to…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… on how to do…to be periodically printed into MySQL error log. You can later disable logging by simply dropping the table. The problem I faced many times…averages calculated from the last 33 seconds ———- SEMAPHORES ———- … snip … Keep in mind the file will only be refreshed when you run…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
…reading if you want to understand how InnoDB works. …to test different settings in a short period of time, I used 30-minute runs, which may not be long enough to…. This value is calculated from the output …in innodb_log_file corresponds to changed pages … to 3000MB during the run. The 15-minute average…
Post: Comparing Percona XtraDB Cluster with Semi-Sync replication Cross-WAN
June 14, 2012 By 7 Comments
… wanted me to do a test comparing PXC against semi-synchronous replication to see how they…running wsrep_slave_threads=16 and all other required wsrep settings. Also note that I disabled log…inserted about 10 rows, and calculated an average time for each INSERT to autocommit. Environment Results (ms) …
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…times per hour) from 24900 NOTPM to 17700 NOTPM (dips of around 30%). Next, the second run…average” method. This method requires setting innodb_flush_neighbor_pages=0 , to… calculation of how…to increasing log_size we added option innodb_log_block_size which allows to change IO block size for logs…
Post: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
…reflex, estimate, keep_average). Why do we…run fast with a broken foot, right ?) And actually it does not work, as MySQL is not able to…to increase innodb_log_file_size, but that: 1) only delays the problem until later; 2) increases recovery time…makes calculating how many pages we need to flush …
