×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: SQL
Posted by: Jing Tai Piao
Added: Apr 16, 2013 2:51 AM
Views: 14
Tags: no tags
[mysql] Improve the performance of SQL when 'text' type in column.
Solution: add the following snippet at the end of my.ini/my.conf
  1. max_heap_table_size=128M
  2. tmp_table_size=128M