…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
November 6, 2011 By 4 Comments
… | +——————————+————+ . . . | 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
November 24, 2008 By 17 Comments
…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!
April 20, 2008 By 17 Comments
…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
November 6, 2006 By 12 Comments
…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
October 2, 2009 By 50 Comments
…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…
