MySQL has two ways to find tune execution of particular query. First is MySQL Hints, such as SQL_BIG_RESULT, STRAIGHT_JOIN, FORCE INDEX etc. You…_size=DEFAULT after executing the query. I noticed in production hints are used much more frequently than setting session variables for… it is not created dynamically some complex way) – adding extra MySQL calls with possibly their own error control is more complicated…
Post: Using GROUP BY WITH ROLLUP for Reporting Performance Optimization
September 17, 2007 By 14 Comments
… of sorting and add ORDER BY NULL so MySQL does not bother to sort results, though this has a little difference in… and I find it quite inconvenient whenever it is MySQL limitation or SQL Standard. This would be extremely useful feature and I… I forced FileSort execution method for GROUP BY by using SQL_BIG_RESULT hint I can see GROUP BY executing about same time as…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…while being employed by MySQL. These are great results, plus they …true This gives you some hints what you can try for…MySQL Settings are probably what is the most interesting: MySQL 5.0 Tuning in /etc/my.cnf (included in FDA) [mysqld] sql… 0M – query cache disabled. Not a big surprise though as this …
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…sql/filesort.cc patching file sql/log.cc patching file sql/log_event.cc patching file sql/my_time.c patching file sql/mysql…hints about installing MySQL on your platform. Also have a look at the files in the Docs directory. Thank you for choosing MySQL…results…
Comment: How to find wrong indexing with glance view
March 8, 2010 By 27 Comments
…2010. MySQL surprisingly supports declarative integrity constraints. But wait being MySQL …result in 1 row matching. So to circumvent that you need to help it out with optimizer hints…ORM like SQL Alchemy and want to avoid writing sql directly … did it would be a big deal – requiring system down time…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…After that load statement is: mysql -S /tmp/mysql-ib.sock -e “LOAD DATA… do that, so I generated big SQL file which contained load statements. … and MonetDB executes it immediately with result 117023290 rows Now some random …2009): James Birchall recommended to use hint COMMENT ‘lookup’ for fields in …
