Hi,
After setting it in my.cnf, have you restarted the MySQL server? Can you check with “show global variables like ‘max_heap_table_size%’;”
If it’s still not worked then I would suggest to check error log after restart, you might be find something which causes this. Also provide mysql/PS version.