May 25, 2012

Post: How to convert MySQL's SHOW PROFILES into a real profile

to demonstrate: mysql> SET profiling=1; mysql> pager cat > /dev/null mysql…| +———————-+———-+——-+——-+————–+ | removing tmp table | 0.095135 | 55.10 | 3 | 0.0317116667 | | Copying to tmp table | 0….0.00 | 1 | 0.0000020000 | | logging slow query | 0.000001 | 0.00 | 1…

Post: Improved InnoDB fast index creation

… | +——————————+————+ . . . | copy to tmp table | 184.694432 | . . . +——————————+————+ 18 rows in set (0.00 sec) mysql> SET expand_fast_index_creation=ON; Query… The constant “copying to tmp table” part will not be affected by a slow tmpdir, but …

Post: How Percona does a MySQL Performance Audit

slow query logs in the stock MySQL server are extremely limited, and for serious analysis it’s basically mandatory to

Post: Updated msl (microslow) patch, installation walk-through!

tmp_table, tmp_table_on_disk, filesort, filesort_on_disk] It allows you to filter queries logged by execution plan. For example to log only queries doing full table

Comment: Database problems in MySQL/PHP Applications

query-time=5 log-slow-queries=/apps/log/slow-query interactive_timeout=300 wait_timeout=300 thread_cache = 40 max_connections=500 query

Post: Analyzing air traffic performance with InfoBright and MonetDB

mysql -S /tmp/mysql-ib.sock -e “LOAD DATA INFILE ‘/data/d1/AirData_ontime/${YEAR}_$i.txt.tr’ INTO TABLE… -lsql –database=ontime -t -s “COPY 700000 records INTO ontime … of rows, the slowness here is similar to Q0. -Q8: …to use bash and pass query as parameter, otherwise I was not able to edit query