…or loading among multiple nodes as …’; mysql> use ontime1; Database changed mysql> show …a helpful utility (included in the …time, the second exec time, the third parse time). $ echo “select count(*) from ontime_fact;” | ./run_query…-update-need-lock=0 innodb…throughput over response time, get a good…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…including testing innodb_old_blocks_time=1000 on MySQL 5.5.30 and testing multiple buffer pools on MySQL 5.5.30. Finally, MySQL…time=0; mysql> set global innodb_old_blocks_time=0; Query OK, 0 rows affected (0.00 sec) mysql…_GET: 6731790 * NUMBER_PAGES_GET…0 | 8 | 8 | | 7 | System lock | 0.000031 | 0….
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…lock var 0 waiters flag 0 wait is ending –Thread 1147709792 has waited at ./../include…time object will be free already. OS Waits are relatively slow, and if you get…mysql tables in use 1, locked 1 LOCK WAIT 3 lock struct(s), heap size 320 MySQL thread id 30898, query… if it is multiple statement …
Post: On Good Instrumentation
May 31, 2010 By 1 Comment
…queries is going to be more helpful. The Glue Our applications involve multiple layers and typically higher layer can only report response time…time for given kind of request. I see response time is coming from MySQL. I check the number of MySQL Queries…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…locks where conflicts will be frequent. And now even laptops are getting multi cores so we can forget about spinlocks wasting CPU time…MySQL use of Databases just as directories it can be the problem – if transaction spawns multiple databases you need multiple…
