http://stackoverflow.com/questions/2919558/mysql-servers-thread-stack-parameter-what-is-it-how-big-should-it-be
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html

You will need to set it in the my.cnf or my.ini or .my.cnf file under the [mysqld] stanza and restart the mysqld process/server.

thread_stack=196608

When i want to key in the asset entry, mysql giving an error code like below,What that's mean ?

DATABASE ERROR : could not get all assets
error code : 1436
error message : Thread stack overrun: 12912 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack.
sql that failed was : SELECT *, 0_get_asset_value(a.asset_id, YEAR(now())) as current_value FROM 0_asset_types at INNER JOIN 0_assets a ON at.asset_type_id = a.asset_type_id WHERE !a.inactive

Thanks for your supports