'Query' Tag

• Does Size or Type Matter?

  July 27, 2010

  MySQL seems to be happy to convert types for you. Developers are rushed to complete their project and if the function works they just move on. But what is the costs of mixing your types? Does it matter if your are running across a million rows or more? Lets find out. Here is what the [...]

  posted in Tips & Tricks, Tunning by mark

• Single Query Profiling

  February 26, 2010

  Every wounder what was taking MySQL so long to run your query.  You can ask it. mysql > set profiling=1; mysql> SELECT * FROM country WHERE city like ‘okla’  order by name; mysql> SHOW PROFILES; You should now see a table with a single row, with the number 1 to the left of your query. [...]

  posted in Commentary by mark