>>http://dev.mysql.com/doc/refman/5.0/en/server-parameters.html
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html
http://www.ibm.com/developerworks/library/l-tune-lamp-3.html
>>===MySql Variables===

==howto run mysql in 128M of RAM==
If you have only 128MB of memory and only a few tables, but you still do a lot of sorting, you can use something like this:
%%
# mysqld_safe --key_buffer_size=16M --sort_buffer_size=1M
%%
If there are very many simultaneous connections, swapping problems may occur unless mysqld has been configured to use very little memory for each connection. mysqld performs better if you have enough memory for all connections.

==show variables==
%%
> show variables
%%

%%
"back_log","50"
"basedir","/usr/local/"
"binlog_cache_size","32768"
"bulk_insert_buffer_size","8388608"

"character_set","latin1"
"character_sets","latin1 dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5"
"concurrent_insert","ON"
"connect_timeout","5"
"convert_character_set",""

"datadir","/home/mysql/"

"init_file",""

"language","/usr/local/share/mysql/english/"
"large_files_support","ON"
"license","GPL"

"local_infile","ON"
"log_warnings","1"
"log_error",""

"socket","/tmp/mysql.sock"

"table_type","MYISAM"
"timezone","BST"
"tmpdir","/tmp/"

"version","4.0.21"
%%
----
REFERRERS
{{backlinks}}