MySQL™: The World’s Most Popular Open Source Database 158 4.0: Dynamic Setting of Variables • Change options on the fly (per thread and globally) – No need to restart server to change cache sizes – Possible to set larger buffers for specific commands • SET GLOBAL SORT_BUFFER=1*1024*1024 – This will set the sort buffer (used by ORDER BY queries) for all new connections • SET SESSION SORT_BUFFER=32*1024*1024 – Will set the same buffer but only for the current connection • SELECT @@GLOBAL.SORT_BUFFER – Returns the default size of the variable Copyright 2003 MySQL AB