…running GROUP BY and some other kinds of queries MySQL needs to create temporary tables, which can be created in memory, using…MySQL 5.0…when you do not need GROUP BY results sorted – it can significantly improve performance in some cases. First I run the query…0.00 sec) So how long does it take: mysql…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…used to ballance between wasting CPU time running spin…use 1, locked 0 MySQL thread id 8079, query id 728899 localhost root Sending data select sql_calc_found_rows * from b limit 5…when last checkpoint was performed. Innodb uses… were not accessed long time, flush list…1000 corresponds to 100% hit rate….
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…running, 0 zombie, 0 stopped CPU states: cpu user nice system irq softirq iowait idle total 15.0% 0.0% 9.5% 0.0% 0.3% 6.5% 68.4% cpu00 22.1% 0.0…mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow-queries…
